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. [adrotate …
We know that WordPress is most famous blog in the world, and the default link for WordPress is using /archives and /category. But this make problems to those sites that are not using WordPress, like my site is using Phpwind. Most of the search engine in the world will search for example.com/archives/… example.com/category/… sometimes search …
Problem with index.php/archives and index.php/category Read More »
grep -lir “text you want to find” * You could put it as background if it is longer time search grep -lir “text you want to find” * > searchresult.txt & example.
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 …
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 …
Cannot do mass delete ? Cannot remove spam files ? If you have too many files and with long file name. It is enable to delete using rm -rf or rm *.xx Here is the solution for the mass delete.
Some people blame that their server hard disk failure or bad sector. Actually can prevent this happen. You must understand the S.M.A.R.T that provide some informations in your hard disk. If any Raw Read Error Rate data is not 0 or more than 0, I suggest you change the hard disk now to prevent the …