New answers tagged

0

When seeking a dump which provides binlog position you will instruct MySQL to call Flush Tables With Read Lock. The acquisition this lock can block. This where you could impact the system. If you have long running transactions you may see problems but you can check this before starting the dump. Your command looks fine to me.


-1

File in etc/my.cnf Find this # The MySQL server [mysqld] and set lower_case_table_names = 1 There is no need to drop db. It works so first check with this. Reason is default value of lower_case_table_names =1 for Windows.


0

The answer is probably among http://forums.mysql.com/read.php?22,370578 (Lock wait timeout exceeded; try restarting transaction) http://forums.mysql.com/read.php?98,591655 (2014 - commands out of sync; you can't run this command now) http://forums.mysql.com/read.php?52,419733 (stored procedure issue in php script) http://forums.mysql.com/read.php?52,407069 (...


2

Since you are using MySQL 5.1.73, you can blow away the ibdata1 file without worries. First, let's look inside ibdata1 (picture created by Percona CTO Vadim Tkachenko) STEP 01 : Make sure there is no InnoDB Run the following SELECT table_schema,table_name, (data_length+index_length)/POWER(1024,3) table_sizegb FROM information_schema.tables ...



Top 50 recent answers are included