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> ...

Save the Select Output to a File

›
Using SELECT INTO, we can save the output of a select command into a file.Instead of displaying the output on the screen mysql> SELECT...
Thursday, 21 April 2016

Mysql query result into HTML or XML

›
mysql can do that for you. Use mysql -H or mysql-X. mysql generates an HTML table from each query result set if you use the -H (or --html...
2 comments:
Wednesday, 20 April 2016

What is the default root pasword for MySQL 5.7

›
After you installed MySQL-community-server 5.7 from fresh on linux grep 'temporary password' /var/log/mysqld.log
Monday, 18 April 2016

Upgrade From MySQL 5.1 to 5.7 checklilst

›
Find mysql upgrade checklist 1.Dump all databases/schemas from the existing mysql server by using mysqldump command 2.intall/Initialize ...