Help - Search - Members - Calendar
Full Version: Is time to upgrade server's RAM?
The Planet Forums > Control Panels > Plesk
AngAnt
Hello,

One of my Ev1 servers, that has P4@2400MHz with 1GB of RAM, Plesk CP with Premiere License and MySQL 4.0.x. installed and about 100domains hosted started to have load average near 0.7-0.8 and sometimes upper than 2-3.

There are some statistics about mysql (the load ave. for Apache is 0.3max):

QUOTE
22:21:17  up 28:25,  0 users,  load average: 0.27, 0.38, 0.43
133 processes: 132 sleeping, 1 running, 0 zombie, 0 stopped
          total    6.6%    0.0%    1.9%   0.0%     0.9%    9.5%   80.9%
Mem:  1030560k av, 1011240k used,   19320k free,       0k shrd,   10724k buff
                   843712k actv,   79480k in_d,   14236k in_c
Swap: 2048276k av,  189088k used, 1859188k free                  608484k cached



Http processes currently running = 36
Mysql processes currently running = 2

Netstat information summary
     2  FIN_WAIT2    
     5  CLOSE_WAIT  
     5  FIN_WAIT1    
    11  SYN_RECV    
    33  LISTEN      
    94  ESTABLISHED  
   599  TIME_WAIT    

+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| Aborted_clients          | 116        |
| Aborted_connects         | 1          |
| Bytes_received           | 395448222  |
| Bytes_sent               | 3734009046 |
| Com_select               | 111891     |
| Com_set_option           | 2608       |
| Com_update               | 59761      |
| Connections              | 41669      |
| Created_tmp_disk_tables  | 314        |
| Created_tmp_tables       | 9213       |
| Created_tmp_files        | 0          |
| Flush_commands           | 1          |
| Handler_delete           | 9778       |
| Handler_read_first       | 7482       |
| Handler_read_key         | 851716     |
| Handler_read_next        | 16251079   |
| Handler_read_prev        | 2882233    |
| Handler_read_rnd         | 108148     |
| Handler_read_rnd_next    | 283574976  |
| Handler_rollback         | 0          |
| Handler_update           | 647212     |
| Handler_write            | 210481     |
| Key_blocks_used          | 11636      |
| Key_read_requests        | 2419489    |
| Key_reads                | 10189      |
| Key_write_requests       | 167511     |
| Key_writes               | 18228      |
| Max_used_connections     | 10         |
| Not_flushed_key_blocks   | 0          |
| Not_flushed_delayed_rows | 0          |
| Open_tables              | 400        | 100% of table_cache in use
| Open_files               | 782        |
| Open_streams             | 0          |
| Opened_tables            | 1587       |
| Questions                | 5186091    |
| Qcache_queries_in_cache  | 3888       |
| Qcache_inserts           | 96511      |
| Qcache_hits              | 4898975    |
| Qcache_lowmem_prunes     | 2639       |
| Qcache_not_cached        | 15372      |
| Qcache_free_memory       | 4954616    |
| Qcache_free_blocks       | 1239       |
| Qcache_total_blocks      | 9702       |
| Rpl_status               | NULL       |
| Select_full_join         | 67         |
| Select_full_range_join   | 12         |
| Select_range             | 1965       |
| Select_range_check       | 0          |
| Select_scan              | 64756      |
| Slave_open_temp_tables   | 0          |
| Slave_running            | OFF        |
| Slow_launch_threads      | 0          |
| Slow_queries             | 3          | (execution time > 10 secs)
| Sort_merge_passes        | 0          |
| Sort_range               | 2245       |
| Sort_rows                | 93358      |
| Sort_scan                | 25012      |
| Table_locks_immediate    | 204162     |
| Table_locks_waited       | 116        |
| Threads_cached           | 9          |
| Threads_created          | 11         |
| Threads_connected        | 2          |
| Threads_running          | 1          |
| Uptime                   | 15576      | 4 hrs 19 mins 36 secs
+--------------------------+------------+


Key Reads/Key Read Requests = 0.004211  (Cache hit = 99.995789%)
Key Writes/Key Write Requests = 0.108817
Connections/second = 2.675 (/hour = 9630.740)
KB received/second = 24.793 (/hour = 89255.547)
KB sent/second = 134.640 (/hour = 484703.621)
Temporary Tables Created/second = 0.591 (/hour = 2129.353)
Opened Tables/second = 0.102 (/hour = 366.795)
Slow Queries/second = 0.000 (/hour = 0.693)
% of slow queries = 0.000%
Queries/second = 332.954 (/hour = 1198634.284)
MySQL Query Cache hits = 4898975/5010858(98%)



So, my question is: Is time to upgrade server's RAM? Is minimize load ave. possible with another optimization of mysql server?

This is my.cnf:

QUOTE
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=16M
query_cache_type=1
max_connections=100
interactive_timeout=20
wait_timeout=20
connect_timeout=10
thread_cache_size=50
key_buffer_size=64M
join_buffer_size=1M
max_allowed_packet=16M
table_cache=400
record_buffer=1M
sort_buffer_size=768K
read_buffer_size=1M
read_rnd_buffer_size=768K
max_connect_errors=5
thread_concurrency=2
myisam_sort_buffer_size=32M
log-bin
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/svr01.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=8M
write_buffer=8M

[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=8M
write_buffer=8M

[mysqlhotcopy]
interactive-timeout


Regards,
AngAnt. icon_smile.gif
4PSA
More RAM is always better, but if I just look at the above stats, the usage is pretty normal.
eth00
Have you tried optimizing apache first? That can really help as wlel.
EvolutionCrazy
hey Angelino nice to see you here icon_razz.gif !

about the load... take a look also to
"top"
during the "pick load" so you can see what is putting more load icon_wink.gif

about the mysql config:
why: "log-bin" ?

i think that if you aren't using mysql replication you can disable the log-bin icon_wink.gif
aussie
.7.8 loads in my opinion is not a reason to buy more ram. Try optimizing your box first.
Byrnie
QUOTE (aussie)
.7.8 loads in my opinion is not a reason to buy more ram. Try optimizing your box first.


I'm looking at similar problems. Please explain what steps you mean by optimization? Thank you!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.