…also need to do this, the details are clearly explained here. The plugin writes its output …audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit …”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted…_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log…= 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…cleared (think restarting a memcache node). This is where a persistent cache can be invaluable. Enter MySQL… 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(“…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… out Thinking Clearly About Performance by Cary Millsap. So how we can use this data to estimate capacity of MySQL system ? We… get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat… Server, enabled full query logging and log_slow_verbosity=full you can also get great amount of related data from mk-query-digest report…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even if it is not clearly visible. mysqlcheck… just for this project. Query Validation It is often hard to ensure queries work same way with different MySQL version, unless you have… database and get query log (you can use mk-query-digest with tcpdump to sniff out queries if you can’t enable log for any…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, I explain the meaning of the output, so it’s clear what I’m showing them. Then, I go through it… top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server are extremely limited… logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… on slow query log, happily the server was running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take… kinds of MySQL Logs. Too bad MySQL Binary log is the only one which it does not support natively. Happily it supports “raw” query log file… -v -i -P “^(SET|use|#)” > q1.log I’m not sure if this would clear everything but in my case it did…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…, indexes and so on, information very helpful to have a clear picture of our users are doing in the database. To… MySQL we should try another approach. Percona Toolkit has a tool to check the usage of our index from the slow query log. The concept is easy to understand. pt-index-usage reads the slow query log and execute every query with EXPLAIN to ask MySQL…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… microsecond logging in the slow query log, and extended statistics in the same log. I logged a couple gigabytes of queries at 0-second threshold (all queries… can see it clearly when I scan the slow query log: there are just places where the log is full of these queries all taking… done about it — and that’s where improvements to the MySQL source code are necessary. But in many cases something can…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… sharp memory increase after executing a particular query. Or, maybe mysqld is seemingly using too…also) (see here if this is not clear) Now, before you run mysqld under Valgrind,…Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…
