…to log those errors. It can log them to a table, file or just show them on STDOUT. Let’s see how to… MySQL on host 127.0.0.1 and storing all the errors on the host 10.0.05, database… error: ERROR 1025 (HY000): Error on rename of ‘./employees10/#sql-3da_2a’ to ‘./employees10/employees’ (errno: 150) Ok…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…to the database may have happened since the backup was taken. Replaying the binary logs brings the database up-to…old contents (using RENAME TABLE) which …used to prevent wide innodb primary keys on the MV. mysql…how you can combine both types of views together. The complete method examples show how to…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to…MySQL offers atomic RENAME TABLE call which can be used to…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…I’m working on a server without the toolkit installed. Q: How to make the tools connect to MySQL The …the tools are designed to write to the master. Q: How about pt-table-checksum with databases greater than 1TB… the meanwhile? The rename table itself should be fast, but as it needs to lock the table…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…) on the server and go to the directory where the sources archive and the patch is. First you should determine how your current MySQL… apply the changes to the database configuration, specifically you need to enable slow logging (see Configuration section for details). Then rename the binary, which…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… technique ? The problem comes from the fact how MySQL‘s Transactions work with DDL, In particular …data to that table and when drop original table and rename such temporary table to original name. How does…can also use Percona Xtrabackup, LVM or other database backup approach which does not relay on …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…Database page corruption on disk or a failed and crash with assertion failure. So what can you do to…to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So we looked at how to…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…| | copy to tmp table | 61.816063 | | rename result table …how performance is affected when turning expand_fast_index_creation on. Here and in later examples I’m extending the VARCHAR column to trigger table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=ON…database…
Post: SHOW OPEN TABLES - what is in your table cache
December 14, 2008 By 3 Comments
…to examine what tables do you have open right now: mysql> show open tables from test; +———-+——-+——–+————-+ | Database…how many threads are currently using this table, meaning have it locked or waiting on the table lock for this table to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…every user clicks on a link,…how do you determine the memory consumption per connection in average? This leads to…’Com_purge_before_date’, ’0′ ‘Com_rename_table’, ’0′ ‘Com_repair’, ’0…_table’, ’2661′ ‘Com_show_databases‘, ’93′ ‘Com_show_errors’, ’0′…Lowered from 32M according to MySQL innodb_additional_…
