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. [root@server:～ ] $ service mysqld start Starting MySQL… ERROR! The server quit without updating PID Continue reading “Starting MySQL… ERROR! The server quit without updating PID file”
Tag Archives: mysql
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.
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.
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. You can optimize the InnoDB tables by using this. ALTER TABLE table.name ENGINE=’InnoDB’;
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, and I found a lot of fragmented tables in my database. I Continue reading “Optimize only fragmented tables in MySQL”
[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
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 Continue reading “How to view MySql running resources”
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
MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1
[root@server 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