EmergencyEMERGENCY? Get 24/7 Help Now!

Query Planner Gotchas

 | June 29, 2011 |  Posted In: Tokutek, TokuView

Indexes can reduce the amount of data your query touches by orders of magnitude. This results in a proportional query speedup. So what happens when you define a nice set of indexes and you don’t get the performance pop you were expecting? Consider the following example:

Now we’d like to perform the following query: […]

Read More

Intel 320 SSD random write performance

 | June 23, 2011 |  Posted In: MySQL

While I like performance provided by PCI-E cards like FusionIO or Virident tachIOn, I am often asked about SATA drives alternatives, as price of PCI-E cards often is barrier, especially for startups. There is wide range of SATA drives on market, and it is hard to pick one, but Intel SSD are probably one of […]

Read More

FusionIO 320GB MLC random write performance

 | June 23, 2011 |  Posted In: MySQL

I was advised that new drivers and new firmware for FusionIO cards improve performance and stability and it is recommended to review results I’ve got about year ago. Using the same methodology and the same box as for Intel 320 SSD, I run random writes benchmarks for FusionIO 320GB MLC card (I do not have […]

Read More

Mike Vizard, CTO Edge

 | June 22, 2011 |  Posted In: Tokutek

The company has developed an index engine for MySQL based on Fractal Tree technology that allows MySQL performance to scale from gigabytes to terabytes.

Read More

Stuart Miniman, Wikibon

 | June 22, 2011 |  Posted In: Tokutek

The growth of data, especially in real-time Web 2.0 environments, can be a burden or an opportunity for new products and new revenue. MySQL users should consider TokuDB to increase agility, speed and scalability.

Read More

Upcoming webinar on Hibernate and Connector/J

 | June 22, 2011 |  Posted In: MySQL

On July 12th at 9 AM PST I will be giving a webinar about performance implications for Hibernate and Connector/J. If you cannot attend at this time, a recorded session will be available soon after the webinar. MySQL is not only about LAMP, and a lot of people use it from Java apps. For some […]

Read More

Understanding Indexing – SF MySQL Meetup

 | June 21, 2011 |  Posted In: Tokutek, TokuView

At this week’s SF MySQL Meetup, I will give a talk: “Understanding Indexing: Three rules on making indexes around queries to provide good performance.” The meetup is 7 pm tomorrow (Wednesday, 6/22), and will be held at CBS Interactive (235 2nd St., San Francisco). Thanks to hosts Erin O’Neill and Mike Tougeron for the invitation […]

Read More

Speeding Up TPCC Table Loads by 8x with TokuDB v5.0

 | June 17, 2011 |  Posted In: Tokutek, TokuView

Percona’s TPCC for MySQL toolset allows one to measure the query performance for an OLTP workload on various MySQL storage engines. The toolset includes a program to load the database tables, and a program to run queries and measure performance. We have found Percona’s TPCC toolset to be extremely useful for tuning our software. However, […]

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.