On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… risk if you have irregular distribution of matching rows that you’ll get skewed results. For instance, if there’s a gap… rows in the `kind_type` table to be first, then look up matching rows in `title` by a secondary index. But the result…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… are executed on the intermediate server, thus resulting in less binary log data being sent …in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to …
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…, PRIMARY KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql_query(“SELECT a… “”; while ($row = mysql_fetch_assoc($result)) { if ($row['Count'] > 0) { echo “” . $row['label'] . “”; display_menu($row['id'], $level + 1); echo “”; } elseif ($row['Count']==0) { echo “” . $row['label'] . “”; } else…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name …step because update statements that match no rows or insert statements that have duplicate key… workload warmed up with chunk 3. The result is similar for every single graph, each…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… as they don’t touch the same row. Row locks are held for modifications until the… standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication?… often might multiple users join the same group? Results In both of the above examples you…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results we have rerun… round, since reportedly Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his tests, while in our…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… were conducted with approximately 78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool. The cache devices were… adjust the FlashCache configuration to produce better or more consistent results, or results that are more inline with the numbers put up… vCache performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL & Benchmark…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… for InnoDB. So let’s see what results we have. The results are in TPS (more is better)… can easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on…myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…where probably only recently read records will be cached, resulting in more disc reads. 2. If you need… easily be quicker on a partitioned table, as Mysql can fire off one thread per partition (at…and quicker than deleting a few hundred thousand rows… for example, if you need to delete. However,…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… expect from 24 core system. For comparison you can checkSysbench Results which Vadim published. For read only workload we get 17x…_p cur_open_with_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read…_p cur_open_with_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,handler::read…
