General discussion of OpenCATS

Moderators: RussH, cptr13

Forum rules: Just remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep comments directed to the topic at hand.
User avatar
By RussH
#2006
OpenCATS, as with all LAMP apps benefits from some tuning of your MySQL configuration. For example - by default the my.cnf config file on CentOS is largely empty, with most caching disabled.
-> Query cache will be disabled
-> Thread cache will be disabled

A good start is to run mysql tuner to see what it recommends - http://mysqltuner.com/ Recommednations will vary on your server, based upon processor size and installed memory.

Finally - if you're seeing fragmentation reported for your mysql database, schedule a cronjob to defragment it nightly;

Automating mysql defragmentation using cron

You can run mysqlcheck using cron automatically.

Open your crontab -e and add following line in it:

0 4 * * * mysqlcheck -Aos -u USER -pPASS > /dev/null 2>&1

Above will run mysqlcheck daily at 4AM.

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me