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’;
Tag Archives: Linux
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”
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.
-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”
How to install Canon imageCLASS MF4380dn/MF4370dn/MF4350d/MF4320d in Ubuntu 10.04
Requirement: Printer must be connected via USB cable. Printer must be power on. Visit the website.
[solved] /usr/local/mrtg-2/bin/rateup: /usr/local/lib/libpng12.so.0: no version information available (required by /usr/local/lib/libgd.so.2)
/usr/local/mrtg-2/bin/rateup: /usr/local/lib/libpng12.so.0: no version information available (required by /usr/lib/libgd.so.2) /usr/local/mrtg-2/bin/rateup: /usr/local/lib/libpng12.so.0: no version information available (required by /usr/lib/libgd.so.2) /usr/local/mrtg-2/bin/rateup: /usr/local/lib/libpng12.so.0: no version information available (required by /usr/local/lib/libgd.so.2) /usr/local/mrtg-2/bin/rateup: /usr/local/lib/libpng12.so.0: no version information available (required by /usr/local/lib/libgd.so.2) vi /etc/crontab and edit the mrtg line by appending the >/dev/null 2>&1 at the end of line: */5 * Continue reading “[solved] /usr/local/mrtg-2/bin/rateup: /usr/local/lib/libpng12.so.0: no version information available (required by /usr/local/lib/libgd.so.2)”
Update server with custombuild in DirectAdmin
Update server with Custombuild in DirectAdmin cd /usr/local/directadmin/ ./build clean ./build options ./build versions ./build update_versions [root@server custombuild]# ./build versions Latest version of DirectAdmin: 1.35.1 Installed version of DirectAdmin: 1.35.1 Latest version of Apache: 2.2.15 Installed version of Apache: 2.2.15 Latest version of ProFTPD: 1.3.2 Installed version of ProFTPD: 1.3.2 Latest version of autoconf: 2.65 Continue reading “Update server with custombuild in DirectAdmin”
[Solved] [error] (28) No space left on device: mod_python: Failed to create global mutex 2 of 8 (/tmp/mpmtx142352).
[Mon Mar 22 20:28:47 2010] [notice] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads. [Mon Mar 22 20:28:47 2010] [notice] mod_python: using mutex_directory /tmp [Mon Mar 22 20:28:47 2010] [error] (28)No space left on device: mod_python: Failed to create global mutex 2 of 8 (/tmp/mpmtx142352). [Mon Mar 22 20:28:47 Continue reading “[Solved] [error] (28) No space left on device: mod_python: Failed to create global mutex 2 of 8 (/tmp/mpmtx142352).”