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