All About Data, Databases, Data Architecture, Data Analytics, SQL, NoSQL and Big Data
Database · Hardware · MySQL · Scalability
Here is some file IO performance numbers from DELL MD1120 SAS storage array. Last year I did the same test with HP P800 storage array and numbers were impressive. But[...]
Database · MySQL · NoSQL · Scalability
Its been a while anyone talked about Intel’s Hyper-Threading performance when it comes to databases. There were enough posts about disabling Hyper-Threading completely when it comes to MySQL/InnoDB workloads way[...]
During my previous post on how to improve derived tables performance, I patched the code to add indexes on internal derived table results, which made a huge difference in the[...]
Last week; I was working on one of the issue where the sub-query related to OLAP staging was running for about 2+ hours in the production server and finally nailed[...]
