… dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and interestingly enough most people fail to… for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs but 256M…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… log entries 1 MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key constraint fails… 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_size is…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… the slave fails to # connect), the slave will create a master.info file, and any later # change in this file to …pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…fail. These things tend to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB…size…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… page tracking log files. In addition to… option innodb_changed_pages_limit. MySQL …innodb_force_recovery=6. When starting the server log tracking initialization would fail…innodb_log_block_size value is used in the combination with changed page tracking. Bug fixed #1114612 (Laurynas Biveinis). InnoDB…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log…command line option innodb_changed_pages_limit. MySQL option …innodb_force_recovery=6. When starting the server log tracking initialization would fail…AIO routines if large innodb_log_block_size value is used…
Comment: Btw xtrabackup is not only backup..
February 13, 2010 By 13 Comments
…innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size…
Comment: Choosing innodb_buffer_pool_size
January 24, 2010 By 39 Comments
… mysql installation + the exact logs file size + all the db folders and a simple “mysqld –innodb_log_file_size=xxxxxxxxx –innodb_force_recovery=6″ (where xxxxxxxxx is the phisical size… raid 5 system). Can this be the reason for a failed crash recovery? Our server is similar. Thank you for any…
Comment: Innodb Performance Optimization Basics
October 24, 2008 By 75 Comments
To change innodb_log_file_size you need to shut down mysql clearly remove old log files and start it again with new value so MySQL will create new log files otherwise it will complain about wrong log file size and Innodb will fail to initialize.
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…may be crashing , failing to execute …size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size…MySQL Server to consume at peak. This can be easily computed by memory needed for OS, File…
