Forum archive
Slow WordPress
Hello,
I am running WordPress on Turnkey LAMP Stack (/lampstack) ISO install. Recently installed last month.
Setup as a guest in VirtualBox on a Windows 2008 R2 Server.
Superfast Quad Core with 16GB ram, plenty of memory and CPU cycles availiable. when it spikes it might go as high as 50% CPU for a second maybe two seconds at times.
I am very new to TurnKey, but not to *nix.
Here are my conf - files.
System Host File
/etc/hosts file
127.0.0.1 localhost 127.0.1.1 lamp 127.0.0.1 pinehurst pinehurst.local 192.168.0.12 pinehurst pinehurst.local #Required for IPv6 capable hosts #::1 ip6-localhost ip6-loopback #fe00::0 ip6-localnet #ff00::0 ip6-mcastprefix #ff02::1 ip6-allnodes #ff02::2 ip6-allrouters #ff02::3 ip6-allhosts localhost ssl.gstatic.com localhost fonts.googlesapi.com localhost csi.gstatic.com
Apache VirtualHost File
/etc/apache2/sites-available/pinehurst.local.conf
<VirtualHost 192.168.0.12:80>
ServerName pinehurst.local
ServerAlias www.pinehurst.local
ServerAdmin webmaster@localhost
DocumentRoot /var/www/pinehurst.local
DirectoryIndex index.php index.html index.htm index.shtml
ErrorLog /var/www/pinehurst.local/logs/error.log
CustomLog /var/www/pinehurst.local/logs/access.log combined
<Directory /var/www/pinehurst.local>
Options Indexes FollowSymLinks MultiViews
Order allow,deny
allow from all
</Directory>
</VirtualHost>MySQL Conf File
/etc/mysql/my.cnf
# # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 384M sort_buffer_size = 2M net_buffer_length = 8K read_buffer_size = 2M read_rnd_buffer_size = 64M max_allowed_packet = 64M thread_stack = 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP max_connections = 50 #table_cache = 64 #thread_concurrency = 10 # # * Query Cache Configuration # # ORIGINAL NTP ## query_cache_limit = 1M ## query_cache_size = 16M query-cache-type = 1 #0=off, 1=on, 2=on demand query_cache_size = 75M #total amount of memory to use for the cache, depending on the amount of memory your server has query_cache_limit = 1M #the max size of any one query result which will be cached, prevents a single massive query filling up the cache # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. # As of 5.1 you can enable the log at runtime! #general_log_file = /var/log/mysql/mysql.log #general_log = 1 # # Error log - should be very few entries. # log_error = /var/log/mysql/error.log # # Here you can see queries with especially long duration #slow_query_log_file = /var/log/mysql/mysql-slow.log #slow_query_log = 1 #long_query_time = 2 #log_queries_not_using_indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 32M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # !includedir /etc/mysql/conf.d/
PHP Conf File
I have attached it, it is just to big for in here.
**Note:
The webmin Web interface/UI works perfectly, it is fast and load very quickly. So that helps narrow it down a bit, just not sure where to start. Any suggestion would be greatly appreaciated.
Thanks
It may pay to post in the VBox forums as they will know much more about VBox that I do! :)
Another thing that may be worth testing is trying your VM in VMware Player (not open source but it is free as in beer). If you export your VM as an OVA VMware will complain when you import it, but if you just click through all the warnings it should work fine (that's been my experience anyway).