I finally setup my website on a Cloud server with Virtualmin.
I used Wordpress and somehow it takes up to 10 seconds just for the initial load of the page. Everything else (images, css, js, etc) load very fast it's just the initial html loading that takes ages.
I turned on APC OPcode cache and MySQL database cache (in my.cnf) and set them up at my best but it still loads very very slow. This is the website: www (dot) trovaziende.net.
I have 4GB of RAM and usually half of it is always occupied, 2GB of virtual memory (I don't even know what it is) and it's always at 0.
I'm pretty sure it has something to do with the database. It is in total 350MB and just one table is 200MB.
Can somebody help me find out what the problem is? Thank you very much!
These are the settings I have in my.cnf
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
thread_concurrency = 8
query_cache_type = 1
query_cache_size = 384M
query_cache_limit = 128M
thread_cache_size = 8
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 8M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 512
max_allowed_packet = 1M
key_buffer_size = 384M