Tag Archives: Queries

MySQL Useful Command

Posted on May 25, 2010 by Mick Genie

If you are the database administrator, today post will help you to mange your server easily. mysqladmin ping -check whether the server is alive mysqladmin status -display a short server status message. mysqladmin variable -display the server system variables and … Continue reading →

Posted in Database | Tagged Backup Mysql, Database Administrator, Database Name, Lt, Mysql Database, MySQL Handy Guide, Queries, Server Status, Server System, Sql Backup, Sql Database, Stat, Status Message, System Variables | Leave a comment

Identify slow MySQL query

Posted on May 3, 2010 by Mick Genie

Sometimes, MySQL will make your server pain if you have user abusing it. Mick Genie will teach you to identify which MySQL database creating the problem to your server. Actually MySQL can log all of the those query that taking … Continue reading →

Posted in Database | Tagged Cnf, Code 3, Code 7, Genie, Mick Genie, my.cnf, Mysql Database, MySQL Pain, Mysql Query, MySQL Slow Query, mysqld, Queries, Query Time, Time 3, vi editor, Wq | 1 Comment

Reboot Server within a network in Windows Platform

Posted on March 16, 2008 by Mick Genie

Do you ever try to reboot or shut down a server/PC within a network? The mystery from Microsoft have done if you are running with administrator role, just try to the command as below if you could like to reboot/shutdown. … Continue reading →