Friday, 7 October 2016

mysql table is marked as crashed repair failed

›
mysql> repair table my_table; +------------------------------+--------+----------+-----------------------------------------------------...
Wednesday, 5 October 2016

Solved (without restart) Mysql slow query log is on but not logging anything

›
1.First cross check /etc/my.cnf to make it permanent slow_query_log = 1 slow_query_log_file = /var/log/mysql_slow_query.log 2.Permiss...
Tuesday, 16 August 2016

Solved Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work

›
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replicati...
1 comment:
Wednesday, 8 June 2016

Dumping MySQL Stored Procedures, Functions and Triggers

›
Mysqldump will backup by default all the triggers but NOT the stored procedures/functions. There are 2 mysqldump parameters that control th...
Monday, 23 May 2016

Mysql slow query log not working

›
Add this in my.cnf and then restart MySQL server: general_log = 1 log=/var/log/mysql_slowquery.log You can check whether the general_l...
Wednesday, 18 May 2016

Mysql change table engine MyISAM to InnoDB

›
 The easiest way is ALTER TABLE table_name ENGINE = InnoDB; InnoDB uses row level locks

Command to optimize all MySQL tables one by one automatically

›
 use mysqlcheck with --optimize and --databases combination. mysqlcheck is a command-line interface for administrators  mysqlcheck -uroo...
Tuesday, 10 May 2016

Speedly MySQL InnoDB Shutdown

›
Depending on the size of the databases you have in mysql innodb the time it takes mysql to restart can be very slow.Some tricks that can sp...
Tuesday, 3 May 2016

SELECT without Table

›
You can also issue  SELECT  without a table. For example, you can  SELECT  an expression or evaluate a built-in function. mysql> sele...
Monday, 2 May 2016

Recover a MySQL root password

›
Simple and smart reset mysql root password # /etc/init.d/mysql stop # mysqld_safe --skip-grant-tables & # mysql -u root mysql> ...