… long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL… simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL HA…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
….) First, we set long_query_time to 0 in order to log every query. (See part two … percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin… (we did 39 measurements), the next graph shows chunk 4’s workload warmed up with …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…read(dberr_t*, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long) … 31.41% 15534570 mysqld…MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows… table-definition-cache=1000 query_cache_size=0 query_cache_type=0 …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… to Dimitri’s environment. To put a long story short, the results are fairly consistent…: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-… cpu combinations with taskset. The following chart shows a results comparison on a single-node …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long…Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client… now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…SSD to run this experiment that long. So there we see the strong… I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2…4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word…threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…query: session10 > show profile for query 11; +——————————–+———-+ | Status | Duration | +——————————–+———-+ | starting | 0.000018 | | Waiting for query cache lock | 0.000003 | | checking query cache for query…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… attack the right query in the right way. But vanilla MySQL does have its …query logging and set a low enough value for long_query_time. We normally use a value of long_query…queries and shows the top queries with largest impact – longest sum of run time which typically (not always) shows queries…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL …show_privilegesblogpercona.commanual Com_show_procedure_codeblogpercona.commanual Com_show_procedure_statusblogpercona.commanual Com_show_processlistblogpercona.commanual Com_show_profileblogpercona.commanual Com_show_profilesblogpercona.commanual Com_show….commanual long_query_timeblogpercona….
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK…long to refresh: mysql> call flexviews.refresh( -> flexviews.get_id(‘demo’, -> ‘dashboard_customer_sales’),’BOTH’,NULL); Query…together. The complete method examples show how to create a complete…
