article thumbnail

The Pros and Cons of Wildcard Indexes on MongoDB

Percona

​​MongoDB is a schemaless database that is extremely flexible. MongoDB does not require any ALTER statement to modify the schema of a collection, like in a relational database. When you create a collection, you don’t have to specify a structure in advance, providing field names and data types.

article thumbnail

Fixing Misplaced Rows in a Partitioned Table

Percona

ALTER employees.salaries ENGINE=Innodb; One can also use pt-online schema change to recreate the table, which will not lock the table and have other benefits ( Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach ) as well. sec) But once the data is misplaced, it does not return any rows.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Building and Scaling Data Lineage at Netflix to Improve Data Infrastructure Reliability, and…

The Netflix TechBlog

Central engineering teams provide paved paths (secure, vetted and supported options) and guard rails to help reduce variance in choices available for tools and technologies to support the development of scalable technical architectures. Challenges We faced a diverse set of challenges spread across many layers in the system. come join us.

article thumbnail

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

We had specializations in hardware, operating systems, databases, graphics, etc. At one point we had two conflicting high availability products from different teams, who weren’t cooperating. It was the first database sizing guide Sun had ever produced. Jim also joined the database performance team.

Tuning 52
article thumbnail

Data Mining Problems in Retail

Highly Scalable

This approach can be expressed in more formal way by the following equation: where is the data available for analysis, is the space of a retailer’s actions and decisions, is an econometric model defined as a function of actions and data, and is the optimal strategy. This framework resembles the approach suggested in [JK98].

Retail 152