Activities

November 2019
M T W T F S S
« Apr    
 123
45678910
11121314151617
18192021222324
252627282930  

MySQL : You can’t use locks with log tables

I got “You can’t use locks with log tables” error when I’m trying to delete contents from the slow_log table which is always be opened on MySQL Engine in a MySQL 5.5 server. My idea is take a table dump and move the data to another remote DB server for later analysis.

I also get […]

InnoDB: Unable to find the AUTOINC column id in the InnoDB table

I got an error when I dump a database backup from a mission critical server. It’s shows the following error on the console even though my application working fine with this database. I googled lots of the forum and blog to get it solved. Most of the forum lead me to adjust the mysql variable […]