(Sean Hull) Query optimization is the often overlooked part of applications. Development schedules being what they are, getting the right results and getting the application working are the main priorities. So thoroughly testing, and benchmarking queries is often left as an afterthought.

(Ryan Thiessen) I have found that MySQL RANGE partitions on the primary key are a great way to achieve scale for insert-heavy InnoDB tables. I have used this to maintain an excellent and predictable insert rate, to avoid some of the well documented problems with insert performance as table sizes gr

(Shlomi Noach) Sometimes MySQL gets it wrong. It doesn’t use the right index.

(Ronald Bradford) Continuing on from CPU, we turn our attention to Memory. One of the first steps when addressing a MySQL performance tuning problem is to perform a system audit of the physical hardware resources, then identify any obvious bottlenecks in these resources.

(Leo Hsu and Regina Obe) Even though others have blogged about this in the past and its well-documented in the docs, its a frequently enough asked question, that we thought we’d post it here again with a couple of additional twists.

(Giuseppe Maxia) Encouraged by Baron Schwartz tip on result set comparison, here are a few more, on the same vein.

(Josh Berkus) Now, what the SE-Linux folks want is something quite different. It’s all based on “labels” which are to Linux security what ROLES are to SQL security. These labels composite types, which include a heirarchical element low to high security levels.

(Giuseppe Maxia) There has been much talking about MySQL performance related to logging. Since MySQL 5.1.21, when Bug #30414 was reported (Slowdown (related to logging) in 5.1.21 vs. 5.1.20) I have been monitoring the performance of the server, both on 5.0 and 5.1.

(Josh Berkus) In the postponed 8.4 feature which proposed to integrate SE Linux with PostgreSQL permissions, one part which had to be dropped was its row-level security ("RLS" from here on). In addition to performance overhead, one of the insurmountable obstacles to including it in 8.4 was that we h

(Shlomi Noach) A new utility in openark kit allows for online ALTER TABLE operation. That is, the modification of table structure without locking down the entire table for the duration of the operation. The oak-online-alter-table utility works under the following restrictions: –The table has at