Help with MySQL & PHP Server Configuration

[CRX-2]

Hi,
I have a dedicated server that's building up ram usage fairly fast. It went from 6GB in use yesterday to 10GB in use today. Rebooting of course resets it back down to 6GB.

Core i3-4330
16GB Memory
2x 120GB SSD

Unfortunately we are still using MyISAM for the most part, there are a few InnoDB tables.

Here's what I currently have in the My.CNF file:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_allowed_packet = 64M
innodb_buffer_pool_size = 128M
key_buffer_size = 1024M
myisam_sort_buffer_size = 512M
query_cache_size = 512M
query_cache_limit = 8M
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0


And I added these into httpd.conf:
StartServers 8
MinSpareServers 5
MaxSpareServers 20

This is actually my first time managing the server on my own, I'm still learning as I go, please advise on configurations that will help stabilize the memory usage.

 

[nobaloney]

1. If you're not running DirectAdmin you won't get much help here; this forum is for isers of DirectAdmin webserver provisioning and operating software.

2. An Intel i3 is NOT a server level chip. It doesn't have enough cache memory, nor good enough cache management, to manage well in a multi-tasking webhoting environment. Though lots of people use it, it really could be a major bottleneck.

3. Your server's apparent memory usage will always grow rather quickly after a reboot, and stay high. Why? See: http://www.linuxatemyram.com/

Jeff