Recently I had a case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs – ib_logfile*. MySQL keeps InnoDB files… 3 -> /var/lib/mysql/ibdata1 (deleted) lrwx—— 1 root root 64 Aug 7 23:29 8 -> /var/lib/mysql/ib_logfile0 (deleted) lrwx—— 1 root… all pages. To stop write activity we can either stop application or lock tables: mysql> flush tables with read lock; Query OK…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
…DELETE: 1302645570629 MIN_TIMER_DELETE: 18127219 AVG_TIMER_DELETE: 303505097 MAX_TIMER_DELETE: 62494969560 Or using this data we can TOP 5 accessed tables via mysql…
Comment: Innodb Performance Optimization Basics
October 25, 2008 By 75 Comments
Just to make sure, you mean I can safely delete (after MySQL shutdown) the following files: ib_logfile0 ib_logfile1 ibdata1 ?
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… running MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system…chunks, updating/deleting may be thousands of rows per transaction may be better if your application can handle… is a bit experimental. One related question I get asked often is why Master and …
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…mysql> DELETE FROM child WHERE 1; — 6 Tickets Used Query OK, 3 rows affected (0.02 sec) mysql… case where I have two… too high can have startlingly …mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… where the bottleneck is… I‘ve read Peter Z …to the next question c. Can we have a limit …31′ ‘Com_dealloc_sql’, ’0′ ‘Com_delete‘, ’348788′ ‘Com_delete_multi’, ’1′ ‘Com_do’, ’0′…ibdata1:10240M;ibdata2:10240M;ibdata3:10240M;ibdata4:10240M;ibdata5:10M:autoextend innodb_log_group_home_dir=/var/log/mysql…
