… a reasonable value, believe it or not. Run these queries at your server’s peak usage time: mysql> pager grep…’re writing huge entries to the log, fewer log entries will fit into a given log file size, which will generally make recovery faster… pool size is just wrong. One final note: huge buffer pools or really unusual workloads may require bigger (or smaller!) log sizes. This…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew….08 0 # Tmp tbl size 0 4.78k 0 4.78k 9.43 0 211.60 0 # Query size 0 100.95k 19… a slow query log that lists all the queries that were executed during this session in the order they were executed: mk-query-digest…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… Tmp_table_sizes: 0 # InnoDB_trx_id: 12F03 use sbtest; SET timestamp=1347397784; select * from sbtest where pad=’abc’; The query in… query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed: 0 # Query…: 213 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: 12F14 SET timestamp=1347398285; select * from…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log_queries_not….commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log_fileblogpercona.commanual socketblogpercona.commanual sort_buffer_sizeblogpercona.commanual…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_freehold…/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_boonton…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size=0 query…_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size=0 query…_log_file_size=512M innodb_log_files_in_group=2 innodb_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size=0 query…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… in size. This will give us some interesting information about how Shard-Query will perform on each database. To do the size comparison, I used the du utility: InnoDB file size on disk…-from-xtrabackup=1 innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
….2.10 | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30… MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been increased from 5MB to approximately 50MB… was “ON” by default with query cache size of 0 which makes it disabled. I wish query_cache_size though would be larger by…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… Database size 1.31 GiB # of connections No logging, NOTPM Logging queries >1 SEC, NOTPM ratio 1 sec / no_logging Logging all queries, NOTPM Ratio all_logging / no_logging… warehouses Database size 10GiB # of connections No logging, NOTPM Logging queries > 1 sec, NOTPM Ratio no_logging / 1 sec_logging Logging all, NOTPM Ratio no_logging / all_logging 1…
