… Using the –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… it with insert… select statement as you need it. One little gotcha which confused me first is the order query come in… concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not checked if concurrent insert is always forced for log table if it is allowed or if there is a buffer of slow log queries which…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…: 0 INSERT IGNORE INTO articles (id, body,)VALUES(3558268,’sample text’); Filtering Slow Query Log – Especially after the changes to log all queries slow query log… may help to one queries but hurt others, for example adding indexes often help SELECT queries but slow down INSERT/UPDATE ones. Final Note…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f”, ulonglong2double(query_utime)/1000000.0); 1947 sprintf…,Init DB,Query,Field List,Create DB,Drop DB,Refresh,Shutdown,Statistics,Processlist,Connect,Kill,Debug,Ping,Time,Delayed insert,Change user…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time… pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can….0449 0.6% 260 0.0002 1.00 0.00 INSERT poller_output # MISC 0xMISC 0.8137 10.0% 3853 0…
Comment: Thoughts on MySQL Replication
October 17, 2008 By 18 Comments
… mean that each query gets properly inserted into the database successfully and timely? Or does it mean both? Clearly, a query ends up… slow query that may be dependent on completion of that slow query. Again, this can be solved by grouping these dependent queries together behind the slow query…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
When you process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical values… of queries * Colorized and normalized SQL syntax * Explain the query dynamically * Integrated pt-query-advisor support * Detailed query historic stats, support for log_slow_verbosity… Toolkit to do the slow query log collection. Specifically you can run pt-query-digest. To parse your slow logs and insert them into a…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… incoming data rate, enabling much higher query performance. Beside iiBench we run benchmarks of SELECT queries again one of our click analyzing… of queries, i.e. point select queries, as in this case TokuDB has to read and decompress big portion of data. – Despite Inserts… the problem of random IO, waste of RAM memory and slow inserts. This is where I think Tokutek appears to be positioned…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… is slow log enabled by –log-slow-queries parameter (MySQL 5.1 requires also –slow-query-log), which was designed to store poorly performing queries that… | perl -e ‘ while() { chomp; next if /^[^ ]+[ ]*$/; if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER)/i) { if (defined $q…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… can’t load all indexes in memory and this is slowing it down. I can tell because when I launch my… poor insertion rate now. The thing is that it’s difficult to tune this server because I have few reading queries but on large tables (~10 millions rows) and a lot lot of insertions queries on these same tables…
