…) On the other hand, you shouldn’t use mysql_use_result() if you are doing a lot of processing for each row on… part of the result set for your next query. The C API gives the error Commands out of sync; you can‘t run this command now if you forget to do this! You may not use mysql_data_seek…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
… rather raname them. Unfortunately you can‘t rename locked tables (ERROR 1192 (HY000): Can‘t execute the given command because you have active locked tables… copy of old table in “rep_old” – this can be very handy if you would like to later investigate why data got out of sync and…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 5 Comments
… command make sure your master is operational and it still has all the logs needed to re-fetch events. How would you… tables are out of sync and when use mk-table-sync to resync them. Last method works in particularly well in case you can afford to run for a while with slaves which are a bit out of sync, which is quite often…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…command which prints out a lot of internal Innodb performance counters, statistics, information about transaction processing and all kinds of…of used cells and number of buffers used by adaptive hash index. You can also see number of hash index lookups and number of…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… of the MV will become incorrect (out of sync) when the underlying data changes. This loss of…you can build complete refresh views on top of incrementally refreshable view, which can give you a lot of flexibility to get the results you…as the first argument on the command line: $ cat sales.sql create …
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… making sure things can‘t run out of sync silently. For example you might know if slave server reboots (say power goes down) you can‘t be… command LVM based sync is also implemented so restoring broken replication safe way becomes very easy. Besides simple “cloning” of the nodes you can use…
Comment: Resyncing table on MySQL Slave
July 1, 2008 By 10 Comments
…. Also, you have not mentioned how one might determine that the slave is out of sync. There may be some data sync issues you discover through replication errors; or perhaps you use mk-table-sync or mk…-table-sync is actually the best tool anyway, as with one command it will checksum the table, determine differences, and can either write…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
…you need Both Memcached and the MySQL query cache are limited in size. If you try to cache more information than you can…commands can be used to either replace the contents of, or insert new data into the summary table. One advantage of… and thus they may be out of sync with the underlying data. If …
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…you really need to directly call the sync command. In my previous post someone pointed out…sync after writes ruined performance. Looking at the code you can see why calling a sync after each write can…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…filtered out only queries of this pattern and got a simplified part of production… what you would expect from 24 core system. For comparison you can checkSysbench …_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one…wait,os_event_wait_low,sync_array_wait_event,mutex_spin…
