…on CentOS. If you are using InnoDB, it is also important that your transaction logs (ib_logfile*) are on…removed done LV VG Attr LSize Origin Snap% Move Log Copy% Convert lv_root VolGroup -wi-ao 5.54g …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… feature differences between MyISAM and Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full text… would not fit to Innodb, though this is an exception. Space Innodb Tables tend to be larger. Again converting schema will show you… most important values to check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. There are a lot…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…-resolve is easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown… might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or… silence in the error log is interesting and needs to be investigated. You might find that there are InnoDB tables whose .frm…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…explain the difference between MyISAM and InnoDB table cache? 3) Would converting the MyISAM tables to InnoDB fix or help the os …= MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…MyISAM and InnoDB and the difference in how the OS handles opened files? 3) Would converting the MyISAM tables to InnoDB fix …= MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…… I’ve read Peter Z two guides but cannot really convert the gained knowledge to solve our situation. Lesser questions but… innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… no space requirements. Another issue with LVM snapshot it may convert pretty much sequential IO done while scanning the files to… get consistent binary logs in the backup and you do not want query log and general logs anyway. However DO place Innodb Log Files on the same LVM volume as you need them to be snapshoted at the same time as tablespaces. The logs…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… running with innodb_force_recovery=1 and as you can see even though I get the message in the log file about… do is to drop old table and convert new table back to Innodb after restarting without innodb_force_recovery option. You can also… to use higher innodb_force_recovery modes to block purging activity, insert buffer merge or recovery from transactional logs all together. Though…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… statements have to be serialized for the binary log; otherwise replaying the binary log can result in a different order of execution…. It just says If you are using the binary log, concurrent inserts are converted to normal inserts for CREATE … SELECT or INSERT… INTO OUTFILE followed by LOAD DATA INFILE. You can use InnoDB instead. Or you can do something more elaborate and application…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… InnoDB Tablespace Monitor. This monitor will write all the information related with tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id… recompile the tool. To help us in the task of converting the schema definition to a C header file there is…
