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”
Category Archives: Linux
Problem with index.php/archives and index.php/category
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 Continue reading “Problem with index.php/archives and index.php/category”
Find files containing text in Linux
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.
[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
MySQLTuner result and Tuning Primer result
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 Continue reading “MySQLTuner result and Tuning Primer result”
You don’t have permission to access /wp-admin/plugins.php?page=visitor-maps-Fvisitor-maps.php
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.
CAPTCHA token file is missing
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 Continue reading “CAPTCHA token file is missing”
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”
-bash: /bin/rm: Argument list too long
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.
Check Linux HDD before Failure
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 Continue reading “Check Linux HDD before Failure”