June 18, 2013

Post: How to convert MySQL's SHOW PROFILES into a real profile

February 20, 2012 By 12 Comments

…database to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT * FROM… | 0.018478 | 10.70 | 3 | 0.0061593333 | | Sorting result | 0.011090 | 6.42 | 1 | 0.0110900000 | |…| starting | 0.000032 | 0.02 | 1 | 0.0000320000 | | freeing items | 0.000027 | 0.02 | 2 | 0.0000135000 |…

Filed Under: Insight for Developers, MySQL

Post: MySQL Configuration Wizard Updated

January 26, 2012 By 5 Comments

… once just to see what it would return and the results were pretty darn close to what we were using on… sanity/safety options to prevent common problems MySQL users run into because of too-permissive MySQL behaviors. These are the kinds of… in the comments. We hope this suite of free browser-based tools helps you become a more productive MySQL user and administrator!

Filed Under: Insight for DBAs, MySQL

Post: How Much memory do you use to run MySQL

November 2, 2012 By 8 Comments

We have seen number of issues with MySQL Server related to amount of memory you have in the … memory do we really use to run MySQL Server these days ? [poll id="2"] Feel free to select multiple sizes if you… when it will be frozen so we do not get results from multiple years mixed.

Filed Under: Insight for DBAs, MySQL, Polls

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… Criminal Records And Background Checks | 4.569097518920898 | | 70 | Montana Free Public Records, Criminal Records And Background Checks | 4.516233444213867 | … Always test how your application behaves as a result of a major MySQL version upgrade before rolling it into production!…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

…. I got some strange results, however, which showed MySQL 5.6.10 to be much slower than MySQL 5.5.30 even with only a single connection. I felt these results… * POOL_ID: 0 POOL_SIZE: 8192 * POOL_SIZE: 8191 FREE_BUFFERS: 1024 * FREE_BUFFERS: 1024 DATABASE_PAGES: 7163 * DATABASE_PAGES: 7162 OLD…

Filed Under: MySQL Tagged With: , , , , ,

Post: MySQL Query Cache

July 27, 2006 By 70 Comments

… execution plans are cached. MySQL Query Cache is not. It does not cache the plan but full result sets. This means it… of them quite likely would not have change their result set but MySQL has no way to identify which one of them… can be seen as large value of Qcache_free_blocks relatively to Qcache_free_memory. FLUSH QUERY CACHE command can be used…

Filed Under: Insight for DBAs Tagged With:

Post: How Percona strives to remain neutral and independent

March 21, 2011 By Leave a Comment

Many of the prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software developers, hosted … specific outcome in mind, then that will naturally influence the results of our research and subsequent publication. For example, suppose you…’s name is not mentioned, the vendor is free to cherry-pick from the results they disclose to the prospect. We are…

Filed Under: Events and Announcements, MySQL

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… datasets effective compression results in the need for fewer nodes in order to keep data entirely in memory. This frees disk to…

Filed Under: MySQL

Post: MySQL 5.5.8 - in search of stability

January 3, 2011 By 11 Comments

…)/(1+Innodb_buffer_pool_pages_data+Innodb_buffer_pool_pages_free). This is the exact formula that InnoDB uses internally to… is quite a critical parameter. So, the results for the initial run, using MySQL 5.5.8: Let me explain the… space. And, the Percona Server result is ~2x better than the best result I received with MySQL 5.5.8 (with innodb_doublewrite…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: MySQL performance: Impact of memory allocators (Part 2)

March 8, 2013 By 12 Comments

… malloc()/free() operations, so allocator efficiency is the key factor to achieve high throughput in this test. Observations: 4 vcpu – results are almost identical for all allocators (~2500tps) 8 vcpu – results doubled (~5000tps) for jemalloc and tcmalloc…: I’ve noted notable impact on MySQL performance after version 3.2.0 (see raw results below) so I used jemalloc-3…

Filed Under: Benchmarks, MySQL Tagged With: , , ,
« Older Posts
Newer Posts »