…restore the whole system to operating state, especially for complex systems. Instead of looking just at data restore…with 1TB of database size replicating to 50 servers in 5 different Data Centers via single …in time with your data. One of vendors offering solution for MySQL is R1Soft. Though I…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially ….commanual Com_restore_tableblogpercona.commanual …data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… don’t have a backup or the backup restore process doesn’t work. How can I recover … 4, appr.key vals 306195, leaf pages 2189, size pages 2212 FIELDS: emp_no from_date [...] The …: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_table_definition With the …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… do good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is…+hours to feel 200GB buffer pool. Automatic Buffer Pool Save/Restore available in Percona Server is great help in this case…% difference in data size can be the difference between slave never lags and slave never is able to catch up. MySQL or OS…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql-data-201202230157′ using a script* I put together to make sure I have a consistent snapshot of the MySQL data files. Restoring…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…especially as the growing data size forces it to. This goes back to what data you really need to …much inevitable: if you do this kind of data processing in MySQL, you’re going to end up heavily … that are hard to maintain, back up, and restore. And the partitioning functionality is not done …
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…data things in MySQL is patience and careful planning. Both of which relate two single property of large data…quick to rearrange their database or even restore from backup. You need Patience simply …miscount is assuming data management operations will be proportional to the database size. Say it …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’, ’0′ ‘Com_restore_table’, ’0′ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size…
Comment: How to change innodb_log_file_size safely
March 18, 2013 By 17 Comments
… mysql 2) change the following parameters in my.ini innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 8M innodb_log_file_size…: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 130319 0:10…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…serious leap in compressed file size. Though in this example we used MySQL binary log file which …write speed to the hard drive – this means restoring from backup compressed with LZO will often … you actually can use LZO compression for faster data transfer between the boxes (ie together with netcat…
