… and not its performance, which seems to be on par with having the general log enabled. The … the log. – audit_whitelist_users : This one is undocumented on the wiki at the time of writing…”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time …performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance…mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…logs which are no longer complete or useful for point-in-time recovery. Generally if you’re considering the binary log…But, if you can connect and run a simple query and receive a response back in a reasonable … want to use MySQL on top of something like that? I can’t imagine the performance being all…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries…52G innodb_log_file_size = 2000M innodb_log_…5000 query_cache_type=OFF performance_schema…time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops in performance… O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit… table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… MySQL called pt-query-digest. One customer was suffering from periods of high load on their database server, leading to degraded application performance… review even if we couldn’t be logged in to the server at the time the problem happened. As I began reviewing… queries. To my luck, one query stood out right away, always appearing many times more than any other one during peaks. Rewriting that query…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql…query_cache_size = 0 query…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…performs if PK is (`id`,`hid`,`mid`). This also will affect select performance…mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time…_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_…_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
…slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal of additional performance…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… slow query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed: 0 # Query_time… lookup is being perform but as only actual rows which are found and returned up to the top level MySQL part for… the query: # Time: 120911 17:31:48 # User@Host: root[root] @ localhost [] # Thread_id: 65144 Schema: sbtest Last_errno: 0 Killed: 0 # Query_time…
