EmergencyEMERGENCY? Get 24/7 Help Now!

Which adaptive should we use?

 | September 15, 2009 |  Posted In: Benchmarks, Percona Software

As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from physical size of the buffer pool. And the another one is oldness of the block which is from the capacity of transaction log files. In the case of heavy updating workload, the modified ages of […]

Read More

SystemTap – DTrace for Linux ?

 | September 14, 2009 |  Posted In: Insight for DBAs

Since DTrace was released for Solaris I am missing it on Linux systems… It can’t be included in Linux by the same reason why ZFS can’t be – it’s licensing issue. Both ZFS and DTrace are under CDDL, which is incompatible with GPL. So you can see DTrace and ZFS on Solaris, FreeBSD, MacOS, but […]

Read More

Queries Active vs Transactions Active

 | September 14, 2009 |  Posted In: Insight for DBAs

What is wrong here (the part of SHOW INNODB STATUS): ————– ROW OPERATIONS ————– 8 queries inside InnoDB, 9 queries in queue 100 read views open inside InnoDB It is relationship between queries active – queries inside innodb+queries in the queue totalling 17 with “read views open inside InnoDB” which is a fancy way of […]

Read More

Cache Miss Rate as a function of Cache Size

 | September 12, 2009 |  Posted In: Tokutek, TokuView

I saw Mark Callaghan’s post, and his graph showing miss rate as a function of cache size for InnoDB running MySQL. He plots miss rate against cache size and compares it to two simple models: A linear model where the miss rate is (1-C/D)/50, and A inverse-proportional model where the miss rate is D/(1000C). He […]

Read More

3 ways MySQL uses indexes

 | September 12, 2009 |  Posted In: Insight for Developers

I often see people confuse different ways MySQL can use indexing, getting wrong ideas on what query performance they should expect. There are 3 main ways how MySQL can use the indexes for query execution, which are not mutually exclusive, in fact some queries will use indexes for all 3 purposes listed here.

Read More

Sponsoring OpenSQL Camp 2009

 | September 11, 2009 |  Posted In: Tokutek, TokuView

We’re supporting the OpenSQL Camp, which will be held in Portland on November 14. One of my objectives for the camp is to make progress on a universal storage engine API, to make it possible to use the same storage engines in MySQL, PostgreSQL, Ingres, or any other database. I’m also looking forward to hearing […]

Read More

Off to California!

 | September 10, 2009 |  Posted In: Events and Announcements

Today’s the day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week.

Our Montreal practice teach at Station-C went great – it was an opportunity to do a road test and iron out any kinks in the delivery.

What did I learn in the process?

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.