I am running a unmanaged VPS - CentOS 6, 1gig of ram, 60gig storage, 256mb Vswap
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 max_connections=100 max_user_connections=30 max_allowed_packet=64M wait_timeout=30 interactive_timeout=50 query_cache_type=1 query_cache_size=4M query_cache_limit=1M long_query_time=5 thread_cache_size=4 key_buffer_size=16M table_open_cache=80 log-queries-not-using-indexes log-slow-queries=/var/log/mysql/log-slow-queries.log #innodb_use_native_aio = 0 innodb_file_per_table [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
MySql tuning logs:
I installed wordpress(Deleted now) - my Vswap and SHOT up like crazy. I was probally the plugins but when i had shared i had a faster page loading time. I deleted WP, did a test and used a sample my.conf for 1gig of Ram i came across. My Vswap shot down to 6% and memory useage in the 30s.
Even before I installed WP my vswap was about half of what my Memory usuage was, only time it went down temporerary was when i restarted apache and did "swapoff" "swapon"
I would like to install wordpress again but i dont want my memory shooting up just because wordpress is installed.
My guess though is its the MySQL conf file based on the "test" i am. What should i put the values at to have everything run optimonal?