… has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory … binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… presentation, it’s currently up and available for viewing over at percona.com. My apologies if we … the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves…-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… deals with an empty transaction list when creating read views. However, the more general descriptors optimization in Percona Server … innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially… the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially… the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… in log files. By monitoring log sequence number and value up to which logs have been flushed you can check if your innodb_log_buffer…/1000. ————– ROW OPERATIONS ————– 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 10099, id…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… better. Q28: My impression (from an external user of Innodb point of view) is that performance bugs don’t receive very hi… not forget you may need to increase size of your Innodb log files to be able to use a lot of memory… solid state disks for storing ib_log* files; I know that innodb writes files in the log file group in a round robin…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… recovery time even if logs are of reasonable size and wikipedia has 40 minutes or so with innodb_log_file_size=256MB. In other cases I know same log file time may have recovery… the cache and so having pretty scattered updates instead updating view counter for popular movie hundreds of times per second. Database…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
…, optimizer) and storage engine. From storage engine’s point of view it works how (very simplified): mysql calls storage engine’s… up cache on your log volume you might want to play with larger values such as 20. If innodb_log_flush_at_trx_commit=0 or 2 smaller values may make sense. If you have binary log enabled it…
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… and used queries is avaiable here: http://docs.google.com/View?docid=d7fzh8b_7dwd8m7 or on our page http://www.mysqlperformanceblog…
