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.

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.

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

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

Adrian Cockcroft

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52
article thumbnail

Data Mining Problems in Retail

Highly Scalable

To a certain extent, such a high diversity of recommendation techniques is attributed to several implementation challenges like a sparsity of customer ratings, computational scalability, and lack of information on new items and customers. Konstan, and John Riedl, 2001. Karypis, J. Konstan, J. Karypis, J. Guo, M.Fraser, 2009.

Retail 152