…. In my case here is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0… review. Columns – a listing of all columns in the schema, really handy to sort by name to see if you have any…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with… have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time periods or different regions… 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: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… option in /etc/my.cnf if bandwidth is a concern. If you’re thinking about employing a filtering solution of any sort…/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… of sorting order? Wouldn’t it be a problem if the keywords were returned in a different order from what you specify in… was more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This… the Percona Live MySQL Conference and Expo in Santa Clara, California starting March 31, 2014. Watch more webinars from Percona in the future!
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables in the…://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the cause of…_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have three nodes on…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features that have been added in MySQL 5… with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on…
Comment: Fun with the MySQL pager command
May 1, 2013 By 6 Comments
… modified it as follows: mysql> pager grep -v ‘\-\+\-’ | grep -v ” Id[ |]*User ” | awk -F ‘|’ ‘{print $6}’ | sort | uniq -c | sort -r PAGER set to ‘grep -v ‘\-\+\-’ | grep -v ” Id[ |]*User ” | awk -F ‘|’ ‘{print $6}’ | sort | uniq -c | sort -r’ mysql> show processlist; 5 Sleep 2 Connect 1 Query 8 rows in set (0.00 sec…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods… get a nice ranking of queries sorted by the number of times they appear in processlist. In this case, I extracted the first… work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work, in a safer way, and in less…
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 much worse than Galera. As I illustrated in a…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… nearly every recovery case the same question arises: How many MySQL records were recovered and how many were lost. Until now…, records inside an InnoDB page are organized in an unidirectional list. The list is sorted by primary key and starts with the… the records. It checks whether fields have permitted values, etc. In the end it knows how many records were actually recovered…
