Celeron 2.4 Ghz, 1 GB RAM for phpAdsNew or for MySQL
My server is at servermatrix and now they have a special for a Celeron ( https://www.servermatrix.com/solutions/sc24_server.html ) and we consider moving some content to another server. We consider 2 options:
1. Move the phpAdsNew software, database and subdomain to the new Celeron server.
2. Keep the phpAdsNew software and subdomain on old server but move every database to the Celeron server, so MySQL will be run from the other server.
Which one should we go with?
My current server info (load average + MySQL) is below:
Mon Jun 14 15:58:20 CDT 2004
15:58:21 up 54 min, 0 users, load average: 0.95, 1.11, 1.04
200 processes: 198 sleeping, 1 running, 1 zombie, 0 stopped
total 7.7% 0.0% 0.4% 0.0% 0.2% 0.0% 91.5%
cpu00 17.4% 0.0% 0.9% 0.0% 0.9% 0.0% 80.5%
cpu01 0.9% 0.0% 0.0% 0.0% 0.0% 0.0% 99.0%
cpu02 10.6% 0.0% 0.9% 0.0% 0.0% 0.0% 88.3%
cpu03 1.9% 0.0% 0.0% 0.0% 0.0% 0.0% 98.0%
Mem: 1544988k av, 898440k used, 646548k free, 0k shrd, 48192k buff
649692k actv, 84440k in_d, 292k in_c
Swap: 1020116k av, 0k used, 1020116k free 368372k cached
Http processes currently running = 82
Mysql processes currently running = 4
Netstat information summary
1 CLOSE_WAIT
1 LAST_ACK
2 CLOSING
3 FIN_WAIT2
5 SYN_RECV
8 FIN_WAIT1
11 ESTABLISHED
26 LISTEN
635 TIME_WAIT
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 56 |
| Aborted_connects | 0 |
| Bytes_received | 10186220 |
| Bytes_sent | 547053989 |
| Com_admin_commands | 6618 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 4472 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 2602 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 1038 |
| Com_insert_select | 175 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 1 |
| Com_optimize | 32 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 9 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 90364 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 10 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 1 |
| Com_show_variables | 10 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 1 |
| Com_update | 5472 |
| Connections | 6215 |
| Created_tmp_disk_tables | 155 |
| Created_tmp_tables | 4194 |
| Created_tmp_files | 326 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 33 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 642 |
| Handler_read_first | 2579 |
| Handler_read_key | 14243934 |
| Handler_read_next | 16225713 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 2678506 |
| Handler_read_rnd_next | 162080561 |
| Handler_update | 226644 |
| Handler_write | 3405750 |
| Key_blocks_used | 25678 |
| Key_read_requests | 40205737 |
| Key_reads | 21197 |
| Key_write_requests | 433629 |
| Key_writes | 4853 |
| Max_used_connections | 295 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 256 | 100% of table_cache in use
| Open_files | 406 |
| Open_streams | 0 |
| Opened_tables | 326 |
| Questions | 110064 |
| Select_full_join | 237 |
| Select_full_range_join | 40 |
| Select_range | 3942 |
| Select_range_check | 0 |
| Select_scan | 16482 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 4 | (execution time > 10 secs)
| Sort_merge_passes | 163 |
| Sort_range | 2541 |
| Sort_rows | 18347567 |
| Sort_scan | 7992 |
| Table_locks_immediate | 109515 |
| Table_locks_waited | 307 |
| Threads_cached | 7 |
| Threads_created | 328 |
| Threads_connected | 285 |
| Threads_running | 1 |
| Uptime | 3199 | 53 mins 19 secs
+--------------------------+-----------+
Key Reads/Key Read Requests = 0.000527 (Cache hit = 99.999473%)
Key Writes/Key Write Requests = 0.011192
Connections/second = 1.943 (/hour = 6994.061)
KB received/second = 3.109 (/hour = 11193.873)
KB sent/second = 167.000 (/hour = 601198.875)
Temporary Tables Created/second = 1.311 (/hour = 4719.725)
Opened Tables/second = 0.102 (/hour = 366.865)
Slow Queries/second = 0.001 (/hour = 4.501)
% of slow queries = 0.004%
Queries/second = 34.406 (/hour = 123860.706)
