Blog Archives

Starting MySQL… ERROR! The server quit without updating PID file

Starting MySQL… ERROR! The server quit without updating PID file

Sometimes you may see this error in your server. But don’t panic, just rename or move away the /etc/my.cnf in your server, and try to restart the MySQLd again.

 

[[email protected]:~ ] $ service mysqld start
Starting MySQL…

Read More …




How to create MySQL database in Directadmin

How to create MySQL database in Directadmin

You have to login to your admin page from your browser, I use justin.my as example in this tutorial.

Read More …




[Solved]Locked table in MySQL

  • InnoDB Supports transactions, row-level locking, and foreign keys
  • MyISAM Default engine as of MySQL 3.23 with great performance

Read More …




MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

[[email protected] src]# ./tuning-primer.sh

— MYSQL PERFORMANCE TUNING PRIMER —
– By: Matthew Montgomery –

MySQL Version 5.0.88-community-log i686

Uptime = 22 days 18 hrs 12 min 36 sec
Avg. qps = 14
Total Questions = 28279137
Threads Connected = 4

Read More …




Translate

Buy me a Caffè Latte

Thank you for the Caffè Latte

2013/02/15 saw art
2013/01/25 Parul Patel
2012/11/20 Barbara Nicholas $10
2012/10/08 Amy Stockman $5
2012/07/15 siewho chang $ 50
2012/06/08 Susan Hampton $10
2012/05/11 Chris Grima $10