Welcome to the MySQL Knowledge Base and Tutorial
Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted
To Resolve such kind of issue, check the master relay log as follow; mysql> slave stop; Query OK, 0 rowsRead More »
MySQL Replication Slave I/O Thread States
Waiting for master update The initial state before Connecting to master. Connecting to master The thread is attempting to connectRead More »
Change default MySQL Data Directory in Linux
Mostly MySQL uses /var/lib/mysql directory as default data directory for Linux based systems We are showing here how to changeRead More »
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
I have noticed one issue here : mysql> CHANGE MASTER TO MASTER_HOST=’127.0.0.1′, MASTER_PORT=53306, MASTER_USER=’username’, MASTER_PASSWORD = ‘password’, MASTER_LOG_FILE=’mysql-bin.000000′, MASTER_LOG_POS=12345; ERRORRead More »
Dumping MySQL Stored Procedures, Functions and Triggers
MySQL has introduced some new interesting features, like stored procedures and triggers. I will show in this small post howRead More »
How can I stop a running MySQL query?
I connect to mysql from my Linux shell. Every now and then I run a SELECT query that is tooRead More »
MySQL: Count occurrences of distinct values in a column
What i want to do is : example db id name ----- ------ 1 Mark 2 Mike 3 Paul 4Read More »
Joining to different databases table
SELECT <...> FROM A.table1 t1 JOIN B.table2 t2 ON t2.column2 = t1.column1;Read More »
MYSQL Partitioning : What is and HOW To ?
The idea behind partitioning isn’t to use multiple servers but to use multiple tables instead of one table. You canRead More »
What is the best way to reduce the size of ibdata in mysql?
The busiest file in the InnoDB infrastructure is /var/lib/mysql/ibdata1 This file normally houses many classes of information (when innodb_file_per_table is 0) TableRead More »
Set Up MySQL Master-Master Replication
Here we will help you to set up Master-Master replication between MySQL servers. In this setup if any changes madeRead More »
How to convert all tables from MyISAM into InnoDB?
If you omit the ENGINE option, the default storage engine is used. Normally, this is MyISAM, but you can change it byRead More »
innodb vs myisam : comparision of mysql database engines
MYISAM: MYISAM supports Table-level Locking MyISAM designed for need of speed MyISAM does not support foreign keys hence we callRead More »