By Capricorn20 on

I have been running Drupal 5 as my main site on my VPS and have set up a Druapl 6 site on the dev sub-domain. I get very high loads for seemingly simple tasks. If I run administration pages the load goes high and it then takes quite some time to load the pages. I have a fair amount of modules but nothing OTT. I'm torn between it being a conflict with some of the modules or it being an issue with the MySQL database server.

What data do I need to post here (modules used etc?) in order to help fault find? It is getting to the point that whenever I run admin tasks I have to also be logged into my VPS management tool so that I can reboot the server.

The VPS has 2 Xeon CPU and 256Mb guaranteed RAM

my.cnf = 
[mysqld]
max_connection = 200
key_buffer=128M
table_cache=128
wait_timeout = 300
interactive_timeout = 300
skip-bdb
skip-innodb
log-queries-not-using-indexes=1
open_files_limit=2048
long_query_time=1
log-slow-queries=/var/log/mysql-slow-queries.log
long_query_time = 5
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
⋅ Categories: Drupal 6.x

Comments

Capricorn20’s picture

Capricorn20 commented

Installed the "devel" module and found a couple of places within a contemplate page that used node_load(nid)->title and replaced with a simple function to get a title from another node. This has reduced the amount of data that is being loaded into the page and while not dramatically reducing the number of queries on the page the result is a much snappier page display and no need to do any page caching.