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 …




Forbidden – You don’t have permission to access /wp-admin/post.php on this server.

Forbidden – You don’t have permission to access /wp-admin/post.php on this server.

Why I cannot post my post to my WordPress ?

This is because the server installed mod_security.

Read More …




Table does not support optimize, doing recreate + analyze instead

Everytime you do optimize MySQL, by using mysqlcheck -A -o or using ./mysql_optimize from here.
You may see the output

Table does not support optimize, doing recreate + analyze instead.

It is because the table that you are using is InnoDB.

Read More …




Optimize only fragmented tables in MySQL

Normally I use myqlcheck -A –optimize to optimize my MySQL database tables. But this will load your whole database and use more time than optimize only fragment tables.

I always use the MySQLTuner 1.1.1 – Major Hayden
to check and optimize my database,

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 …




How to view MySql running resources

If your server’s mysql always in high resources or down, I suggest you use this command to trace out which database that eat up your MySql resource

  • /usr/bin/mysqladmin proc stat
  • /usr/bin/watch -n 5 ‘mysqladmin proc stat’

Every 5.0s: mysqladmin proc stat Sat Aug 28 02:05:06 2010

+——+———-+———–+—-+———+——+——-+——————+
|  Id  |   User   | Host      | db | Command | Time | State | Info             |
+——+———-+———–+—-+———+——+——-+——————+
| 1404 | da_admin | localhost |    | Query   |  0   |       | show processlist |
+——+———-+———–+—-+———+——+——-+——————+
Uptime: 1408 Threads: 1 Questions: 32688 Slow queries: 1 Opens: 218 Flush tables: 1 Open table
s: 211 Queries per second avg: 23.215

Read More …




Update server with custombuild in DirectAdmin 1.36.0

Update server with custombuild in DirectAdmin from 1.35.1 to 1.36.0

cd /usr/local/directadmin/customebuild
./build clean
./build options
./build versions
./build update_versions

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