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’;
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 …
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.
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 …
Requirement: Printer must be connected via USB cable. Printer must be power on. Visit the website.
/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) [adrotate banner=”1″] /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: …
Update server with Custombuild in DirectAdmin cd /usr/local/directadmin/ ./build clean ./build options ./build versions ./build update_versions [adrotate banner=”1″] [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 …
[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). [adrotate banner=”1″] [Mon Mar …