If you are online then you should run: mysqlcheck
mysqlcheck -o –all-databases
If you are offline then you can run myisamchk which is a little more thorough.
myisamchk –sort-index
myisamchk -r tbl_name
Entries Tagged as 'Linux Software / Scripts'
Optimize MySQL DataBases
June 29th, 2010 by EZ linux · No Comments
Tags: Linux Software / Scripts · Linux Tricks
setroubleshoot bug
May 24th, 2010 by EZ linux · No Comments
There is a bug with the new option in Centos 5 called setroubleshoot.
The bug spins the program over and over causing high memory and sometimes CPU use. Unfortunately there is no permanent fix yet, but if you see something like this high in your daily process log:
/usr/bin/python -E /usr/sbin/setroubleshootd
To fix for now you simply have [...]
Tags: Cpanel and WHM · Linux Commands · Linux Software / Scripts
Mod_cband the new Mod_Bandwidth
March 29th, 2010 by EZ linux · 1 Comment
I spent hours trying to get mod_bandwidth to work simply because I have used it for years. But now with Apache 2.0 times have changed and there is a better option for Linux and it’s free. The new mod to regulate bandwidth and more is called Mod_cband I’m not sure what cband means but I [...]
Tags: Cheat Sheets · Cpanel and WHM · Linux Security · Linux Software / Scripts · Linux Tricks
Raise apache 2.0 max clients hard limit in cpanel
March 23rd, 2010 by EZ linux · No Comments
Apache 2.0 makes raising the max client from the default 256 hard limit a little harder now. If you have cpanel then it’s even a little harder or I should you just need to know what to do, figuring it out is a shot in the dark.
One main difference is you have raise the server [...]
Tags: Cpanel and WHM · Linux Software / Scripts · Linux Tricks
Repair DNS scripts and tips
March 19th, 2010 by EZ linux · No Comments
Fixing DNS is a tricky thing, with cpanel there is a couple steps to try first.
DNS failed you are not sure why, try this first:
/scripts/cleandns
/scripts/rebuildnamedconf
Still not working, try this:
/scripts/rebuilddnsconfig
/scripts/fixdns
Basically DNS has about 5 files that need to all be in sync for named DNS to run.
I highly recommend running three servers with DNS so you [...]
Tags: Cpanel and WHM · Linux Software / Scripts
Getting a md5sum error when tranferring a cpanel account?
March 3rd, 2010 by EZ linux · No Comments
This usually means you need to upgrade Perl on the server. Here is a example of a md5sum error.
The remote server didn’t report a correct md5sum of the archive. Please ensure you selected the correct type of remote server.
To fix upgrade Perl as shown here:
http://www.ezlinuxadmin.com/2009/08/upgrading-perl-on-cpanel/
Tags: Cpanel and WHM · Linux Commands · Linux Software / Scripts
My new favorite rsync command
March 3rd, 2010 by EZ linux · No Comments
rsync -vae ssh 12.123.123.123:/home/dwhsbackup/daily/username/ /backup/cpbackup/daily2/username/ –bwlimit=10000 –exclude-from ‘/root/exclude.txt’
Tags: Linux Commands · Linux Software / Scripts · Linux Tricks
Calm down rsync if it overloads your IO memory or CPU
March 3rd, 2010 by EZ linux · No Comments
The trick is to limit I/O bandwidth for rsync.
The –bwlimit option limit I/O bandwidth. You need to set bandwidth using KBytes per second. For example, limit I/O bandwidth to 10000KB/s (9.7MB/s), enter:
rsync –delete –numeric-ids –relative –delete-excluded –bwlimit=10000 /path/to/source /path/to/dest/?
10 megs a second is plenty of speed and will keep the server running smoothly when your [...]
Tags: Cheat Sheets · Linux Commands · Linux Security · Linux Software / Scripts · Linux Tricks
Path to PHP CLI in CPanel
February 9th, 2010 by EZ linux · No Comments
PHP CLI is installed by default by CPanel and placed in:
/usr/local/bin
or
/usr/bin
Tags: Cpanel and WHM · Linux Software / Scripts
Install FFMPEG from source
December 22nd, 2009 by EZ linux · 1 Comment
Do you prefer to manually install everything? Here is a article for you on installing FFMPEG on a Linux server.
For the automated people check this article out for FFMPEG Installation
FFmpeg is a complete solution to record, convert and stream audio and video. It includes libavcodec, the leading audio/video codec library.
NOTE:
- This guide is designed for [...]
Tags: Linux Software / Scripts
