…/mysql/mysql.sock max_connections = 600 wait_timeout = 60 interactive_timeout=1800 skip-name-resolve skip-bdb default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query…=12M server-id = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
… university lab) have implemented this in our stresstesting vApus Client. I have described vApus here: http://www.anandtech.com…4. We went a step further 1) By turning logs into benchmarks so you use real user input (… have applied it to MS SQL Server, not to MySQL yet, but it is the same idea and …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual,…character_set_client_handshakeblogpercona….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…
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… it if they wanted to. Another reason for logging from the client is to log only selected traffic that is of interest, instead… log the queries is that it might not log everything, such as superfluous ‘ping’ commands. Another option is to make the client connector log…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… STATES for that it would trigger and log the query. Taking other Approach For our clients we often need to find a… slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log by… query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 14 Comments
… you need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can… old log files. The typical error message you’ll see in the client when InnoDB has refused to start due to log file… file… That really means that InnoDB hasn’t started, and MySQL is trying to access a table with the InnoDB storage…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 17 Comments
… back_log, which effectively serves as a queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL… for improvement, see this post by Domas]), With MySQL 5.5 default back_log of 50 and 2000 connections created per second… different server, but that can be fixed by setting the client connect timeout setting (which not a lot of people do…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… information from mk-query digest (I omit queries text for client privacy) # Query 1: 0 QPS, 0x concurrency, ID 0x382A5F3785EB3CEE at…
Post: MySQL Connection Timeouts
April 19, 2011 By 2 Comments
… kernel buffer of connection requests on LISTEN socket is overflow – MySQL is not accepting connections as quickly as it needs. There… connection. I’ll explain the math below. Second – is MySQL parameter back_log which has default value of just 50. You may… than 2 seconds does not make much sense because if client does not get a response within 3 seconds it will…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…is provided by Sysbench, a single table workload, 16 client threads. The growth of the history list and the…were innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite…not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is…
