… you’re thinking about employing a filtering solution of any sort and it’s something you’re not that familiar with… initial reaction was, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… for your database — I’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0… listing of all columns in the schema, really handy to sort by name to see if you have any implicit constraints…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema… with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, …another equivalent solution. If you’re talking about using a temporary table to store an interim result…tradeoff. Q: Is the tuple comparison independent of sorting order? Wouldn’t it be a problem …
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
…sort` int(11) default NULL, PRIMARY KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 4432877 K… in the equation. Thread pointer: 0x7f9234000990 Attempting backtrace. You can use the following information to find out where mysqld died. If…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the wealth of… with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… typically on a single Innodb node we can have all sorts modifications floating around as long as they don’t touch… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… tradeoffs. Most of us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…pt-stalk come in handy, but if you’ve used them, you know it can be a daunting … at least you get a nice ranking of queries sorted by the number of times they appear in processlist…. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work,…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…-up aggregation, which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements for that), so it…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock…
