…, the slow logs are disabled in the postrotate stanza. The order of operations is: 1. logrotate renames the log file. MySQL continues to… buffered logs to be flushed (select sleep(2);) 2c. File handles are reopened (FLUSH LOGS 
2d. Slow logging resumed (set global long_query_time=@lqt…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… is using InnoDB under the hood (redo logs, etc). Based on the above numbers, here … MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“… Cost of operations time to maintain an additional system Impact of warmup time to application Cost …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…–max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-…log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log… thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000… = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size=4096 #####…size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len =…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query_time: 2.365434 Lock_time: 0.000000 Rows_sent…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…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…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous … forced for log table if it is allowed or if there is a buffer of slow log queries which is used if log table…. I guess over time we would have more tools provided with these and similar features if not by MySQL than by community.
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 …techniques for logging queries with their execution times. I will list three. One is to make the application time the queries and write a query log. I…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat… 0 # Users user # Query_time distribution # 1us # 10us # # 100us ################################################################ # 1ms ############# # 10ms ###### # 100ms # # 1s # 10s+ We can see this query takes 2ms to respond… needs an increase. The query time distribution histogram is also very interesting here we can see this query which analyzes no more than…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…logs. General Query Log The first option is the General Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log =… TOTAL_CONNECTIONS: 25 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 464 BUSY_TIME: 96 CPU_TIME: 19 BYTES_RECEIVED: 62869617 BYTES_SENT: 14520…
