… table with my delete statement succeeded. Next I tried by restarting mysql after the delete and then discarding tablespace, making sure none… after careful reading and understanding of your blog, I tried mysql restart by deleting the ib_logfiles and letting innodb create new… in this case. Next I set the option innodb_fast_shutdown=0, and restarted mysql, without any discard and import I got the…
Comment: Mystery Performance Variance with MySQL Restarts
February 28, 2013 By 18 Comments
Does the computed statistics change when restarting MySQL? Because after a restart, the slow schema becomes fast and one that was fast becomes slow.
Comment: Mystery Performance Variance with MySQL Restarts
February 28, 2013 By 18 Comments
… run fast. But sometimes I have to run ANALYZE TABLE multiple times for the queries to be fast. And each time I restart MySQL… statistics persistent would help as long as it’s the “fast” statistics that are kept. Thank you Jeff
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
… on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8. XtraDB now uses the fast recovery…_slow_control option to control slow-query logging globally without restarting, similar to –use_global_long_query_time. Added the –query… compile with CFLAGS=-DUNIV_DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL-server #589639 Recovery process may hang when tablespaces are…
Comment: How to change innodb_log_file_size safely
March 18, 2013 By 17 Comments
… change the innodb setting in my local machine. 1) shutdown mysql 2) change the following parameters in my.ini innodb_buffer…_size = 8M innodb_fast_shutdown = 1 3) rename the 2 log files (ib_logfile0 and ib_logfile1) 4) restart mysql I can see the new log file create as 64M now. but i saw some error in mysql_error.log…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… helpful as we might want to compare them to the fast transactions to understand why they are slow. What kind of… example I’d like to see number of mysql calls in addition to MySQL response time. This helps to understand if it… was restarted (and hence has almost empty cache). This is important example as it shows your increased response time from MySQL may…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…as RAID cache so it can handle system restarts. When putting log files on such device could…innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, …1 MB. Then a full table scan would be fast. Maybe the table has become fragmented? Or …
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…not use indexes it well can be flooded with fast and efficient queries, which just happen to do …to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter -T 0.5 -R 1000…time. Happily you can change long_query_time without restarting server so it is easy to get sample of…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…store counter of records, however calculates it pretty fast. Q0: select avg(c1) from (select year,month…in summary table at the bottom) Query Q1: mysql> SELECT DayOfWeek, count(*) AS c FROM ontime …totally idle, but query stuck. I killed query, restarted mysqld but could not connect to mysqld anymore….
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… of features I would like to see soon: Fast recovery. Both recovery after crash and recovery from …There is reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload table / … for operations team to complete task which requires restart of slave Copy single .ibd table from one …
