… won’t be needed. And that’s where the Debian startup script breaks down entirely, because it doesn’t follow this…. Why is that happening? Look at SHOW INNODB STATUS: ===================================== 090128 8:29:03 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the…. The real solution is to disable this startup process. It’s not even needed for InnoDB. Sooner or later you’ll find…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads to run inside Innodb kernel at the same… thread is not runniing inside innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is…. You can also see number of rows operation since system startup as well as average values. This is also very good…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… make InnoDB to write the full status output into innodb_status.
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup params… MyISAM / InnoDB: libexec/mysqld –no-defaults –user=root –key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread…
Post: InnoDB memory usage
May 30, 2006 By 6 Comments
… many questions how InnoDB allocates memory. I’ll try to give some explanation about the memory allocation at startup. Some important constants: NBLOCKS=count of block in innodb_buffer_pool = innodb_buffer_pool_size / 16384 OS_THREADS= if (innodb_buffer…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread… or on our page http://www.mysqlperformanceblog.com/files/benchmarks/innodb_scale.html (Note: This benchmark is synthetic micro benchmarks focusing…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance… happens on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find… file are applied and database is in “physically consistent” state, Innodb will need to roll back certain transactions which were not…
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 19 Comments
… just go through the recovery phase on startup, which can be even slower in stock InnoDB than the shutdown process, for a…: $ mysqladmin ext -i10 | grep dirty | Innodb_buffer_pool_pages_dirty | 1823484 | | Innodb_buffer_pool_pages_dirty | 1821293 | | Innodb_buffer_pool_pages_dirty | 1818938…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… dump file is synchronous, i.e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov….e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov). Fixed assertion failure in InnoDB. #814404…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… startup until LRU dump is loaded Added a new boolean option, –innodb-blocking-buffer-pool-restore (in 5.1 it is –innodb-blocking… dump file is synchronous, i.e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov… dump file is synchronous, i.e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov…
