skip to main
skip to sidebar
My MySQL Road
Do practicals, Learn subject, Share knowledge, Change ....
Friday, November 27, 2009
Collection of pdf
Post a Comment
Post Comments (Atom)
Feedjit Live Blog Stats
Maakit tool options description
Collection of pdf
MySQL Cluster Query execution process
Toronto, Ontario, Canada
* Certified MySQL 5.1 Database Administrator (CMDBA 5.1) * Certified MySQL 5.0 Database Administrator (CMDBA 5.0) * Oracle Certified Associate
View my complete profile
Investigating Sort aborted issues
A few days ago, I and few of my fellow members had a discussion about the "Sort aborted" error in the error log should be monitore...
Aborted connection 31084472 to db: ‘ms’ user: ‘login’ host: `x.x.x.12′ (Got timeout reading communication packets)
ERROR Message : 081016 23:25:44 Aborted connection 31084472 to db: ‘ms’ user: ‘login’ host: `x.x.x.12′ (Got timeout reading communication pa...
Fatal error: Can’t change to run as user ‘mysql’ ; Please check that the user exists!
Problem Statement: I got the error while starting the server, and is it not able to start as mysql user. It throws the below error 080915 ...
Got fatal error 1236: ‘Client requested master to start replication from impossible position’ from master when reading data from binary log
Problem statement: The below is problem I faced in a well running replication system. Error Message : 081016 18:34:43 Error reading packe...
Error: data file /mysql/data/mysqld/ibdata1 is of a different size
If the Mysql is not starting and the error log consists of the below error after the configuration of a slave with the tar file of master. ...
Replication stopped with duplicate entry upon starting up of MySQL from cold backup
A few days ago, we faced a Duplicate entry problem in the mysqld server on one of our customer’s slave after cold backup. We do regular da...
Replication resumed, Apparent master shutdown, Failed reading log event
The slave server is getting this error in error log. 081102 0:30:18 [Note] Slave: connected to master ‘email@example.com:3310′,replicatio...
ERROR 1251: Client does not support authentication protocol
Problem Statement: I got the below error while trying to accessing the upgraded mysqld server with a old client. Error : ERROR 1251: Clie...
InnoDB error : Total number of locks exceeds the lock table size
Recently, one of the clients that I'm working with had a problem with one of their replication slaves where an sql statement gave an err...
Alter waiting on Select statement to complete
A few days ago, we faced an interesting problem on one of our customer’s slave mysqld servers. An Alter for adding a new column was run on ...