[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
InnoDB Supports transactions, row-level locking, and foreign keys MyISAM Default engine as of MySQL 3.23 with great performance
My server eat up of high CPU resource. I’ve figure out by using [root@server ~]# /usr/bin/watch -n 5 ‘mysqladmin proc stat’ and found out that these results. | 214024 | phpwind | localhost | phpwind | Query | 318 | Copying to tmp table | SELECT pt.tid,pt.fid,pt.subject,pa.attachurl FROM pw_threads pt ,pw_attachs pa,pw_forums pf where p …
After you install or update the Visitor Maps plugin, you need to update the Maxmind GeoLiteCity database too. You will notice the message appear. Visitor Maps plugin needs the Maxmind GeoLiteCity database installed.
After you install the SI Contact Form WP plugin, you may face this error while sending the form. There is a problem with the directory /captcha-secureimage/captcha-temp/. The directory is not found, a permissions problem may have prevented this directory from being created. Fixing the actual problem is recommended, but you can uncheck this setting on …
It take me few minutes to find the name of this. Finally I found the name of it, it is called Slipper lobster 琵琶虾 I cost me only 250 Baht / KG. If you take meal in any restaurant they will charge 500 Baht or more than that.
Many WP users still showing ugly url on thier blog or WP sites, why not enable this Permalinks feature and make it look nicer and without those numeric ? Many WP sites showing like
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 …