OpenCATS 0.9.4-3

Free, Open-Source Applicant Tracking System including job-board. Entirely customisable!

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.
Empty backup.

Hi. My OpenCATS installation is working fine (0.9[…]

Hello again, I've included the 'pipeline' field i[…]

Nike Air Max 2090 White Orange

https://kickz.akamaized.net/no/media/images/p/60[…]

https://i2.wp.com/sneakerdaily.vn/wp-content/upl[…]

The version of XAMPP I am using has MariaDB versio[…]

EDB to PST Converter Software helps user to recove[…]

Encryption and security.

Good to hear. From other folks here on the forum, […]

I think I found it. I am having hte same issue […]