QNAP - MySQL server SLOW response time / PHP

[authorleon]

Hello All

We are going to use our QNAP as a Web Dev server.

We have the following:

- TS-EC1279U-RP (Quad Core Intel Xeon E3-1225 3.1GHz Processor with 4GB ram & 12 HDDs in RAID 6)
- PHP Version 5.3.9
- MYSQL Server version: 5.1.36

We have installed Drupal and Joomla, however the response time seems to be very slows. We are waiting about 5 - 6 seconds before we get a response. We have edited the my.cnf for my sql (see below)

Code: Select all

[client]
#password   = your_password
port = 3306
socket      = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket      = /tmp/mysql.sock
skip-locking
skip-networking
skip-name-resolve

max_connections=500
key_buffer_size=384M
max_allowed_packet=16M
table_cache=256
sort_buffer_size=2M
read_buffer_size=2M
join_buffer_size=2M

thread_cache=256

query_cache_type=1
query_cache_limit=1M
query_cache_size=32M

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[myisamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]
interactive-timeout

However even with the change above recommended by different sites, the performance got better but just by a little.

We had our test sites on the QNAP and a hosting company. The response on the hosting company's servers is much faster. I know they have better hardware however the CPU charts on the QNAP does not even go above 3%.

Thank you

[authorleon]

Anyone please...

It make deving a pain...

[authorleon]

Solved.... Gave my php 512M and there was a RSS feed on the dev site which was SLOW as **