August 2020
« Apr    

InnoDB: The error means mysqld does not have the access rights to

I’m migrating my CentOS 6.4 Desktop to Ubuntu 14.04 LTS on this week as I found that CentOS 7 was not much Great that I expected. It does not support aged hardwares.

While I’m changing MySQL data directory to a different location and initializing the server. I got a strange error like this “InnoDB: […]

MySQL : How do I store Slow sql queries in to a Table

One of the Dev. find difficulties to populate the large slow queries file which he ask to fix the Application performance issue. After few checking he informed me we can log slow queries on one the system table in MySQL version 5.5. So that we can pragmatically manipulate and explore it easily.

But I do […]

MySQL 5.5 : How do I enable slow query log

Prior to optimize the performance of a busy MySQL Database server, I need to enable all the queries those consume more than 10 second to complete the execution. This server load is high most of the time and being hit on performance issue due to this load.

I’m using the server which have 32 CPU’s […]

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol

While I’m accessing MySQL server 5.5 remotely from a windows server which was MySQL 5.6 libraries installed, I got the following errors.

C:\Documents and Settings\Administrator>mysql -h -ureadusr -p Enter password: ************ ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ‘secure_auth’ enabled)

How do I skip this error and able […]

Warning: Skipping the data of table mysql.event.

You may get this warning when you take full MySQL server backup on above MySQL 5.2 GA version.This warnings cab be ignored since it is related to MySQL new feature “Event Scheduler”.

Solution : You may simply add parameter “–ignore-table=mysql.event” along with MySQL Dump command.


 mysqldump –all-databases -r alldb.sql –ignore-table=mysql.event

Or you may add […]

MySQL Replication : Removing aged MySQL Binary Logs

You will experience lack of disk space if you have setup MySQL replication for long time. Also in some case if there is any bulk insertion/updation occur in the database will also cause to increase the MySQL data folder size as well as binary logs files size too. Sometime these two combination may cause to […]