POLALA.COM welcome to my space |
| New Dedicated Server is Slower! | | Published by: rose 2009-01-07 |
direct pc to pc transfer:: Nor can PC 1 use a dedicated cable or satellite connection. . but it would be much more difficult, expensive, and slow than doing it with a modem. http://answers.google.com/answers/threadview?id=373641HOME | I am in the process of switching to a new dedicated server. Initially it was very fast, but right now it's dog slow when loading php pages. Here's the server specs:
New url instead of ip
WebSite URL: http://www.lancerforums.com/
PHPInfo: http://www.lancerforums.com/phpinfo.php
Intel 1Ghz
512MB RAM
40 GB HD
RH 7.2
PHP 4.1.1
MySQL 3.23.47
I have no php.ini file and no my.cnf, but I do have a my-huge.cnf, my-medium.cnf, etc. Peer to peer network:: A switch provides a dedicated connection to each computer, such that one hoggy user cannot slow network performance for the rest of the users. http://answers.google.com/answers/threadview/id/96812.htmlHOME |
Here's my extended-status specs:
+--------------------------+-----------+
Variable_name Value
+--------------------------+-----------+
Aborted_clients 0
Aborted_connects 3
Bytes_received 662459983
Bytes_sent 22067939
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 1772
Com_change_master 0
Com_check 0
Com_commit 0
Com_create_db 1
Com_create_function 0
Com_create_index 0
Com_create_table 697
Com_delete 30
Com_drop_db 1
Com_drop_function 0
Com_drop_index 0
Com_drop_table 708
Com_flush 1
Com_grant 0
Com_insert 343938
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 4
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_select 5521
Com_set_option 26
Com_show_binlogs 0
Com_show_create 26
Com_show_databases 152
Com_show_fields 13
Com_show_grants 4
Com_show_keys 10
Com_show_logs 0
Com_show_master_stat 0
Com_show_open_tables 0
Com_show_processlist 2
Com_show_slave_stat 0
Com_show_status 6
Com_show_tables 625
Com_show_variables 13
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 372
Connections 1170
Created_tmp_disk_tables 2
Created_tmp_tables 176
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 21
Handler_read_first 314
Handler_read_key 19625
Handler_read_next 28933
Handler_read_prev 60
Handler_read_rnd 33150
Handler_read_rnd_next 281186
Handler_update 354
Handler_write 347658
Key_blocks_used 7793
Key_read_requests 2161525
Key_reads 442
Key_write_requests 905056
Key_writes 905045
Max_used_connections 3
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 64
Open_files 128
Open_streams 0
Opened_tables 5167
Questions 355092
Select_full_join 0
Select_full_range_join 0
Select_range 475
Select_range_check 0
Select_scan 2255
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 0 UNIX Internals:: Message queues are a richer interface, usually used in a client /server type of adding a single seek / read can slow transfers substantially. http://answers.google.com/answers/threadview/id/193616.htmlHOME | Top names in financial services processing:: Searching for a good deal on a merchant account is a slow and tedious process . Commerce NTI - Offers a scalable server-based payment processing platform http://answers.google.com/answers/threadview?id=354968HOME |
Sort_merge_passes 0
Sort_range 421
Sort_rows 43651
Sort_scan 826
Table_locks_immediate 356256
Table_locks_waited 0
Threads_cached 0
Threads_created 1169
Threads_connected 1
Threads_running 1
Uptime 1052563
+--------------------------+-----------+
Here's my results from top currently:
2:02am up 13 days, 2:02, 2 users, load average: 0.00, 0.00, 0.00
56 processes: 55 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 0.1% user, 0.0% system, 0.0% nice, 0.9% idle
Mem: 505256K av, 402256K used, 103000K free, 48K shrd, 74672K buff
Swap: 1228932K av, 13124K used, 1215808K free 235236K cached
:( Mark :(
Thanks, I placed the php.ini file in and reloaded apache. Site is still a little slow loading, but that may be the NOC. Let me try a few tracerts and see what I get.
I also notice that a lot of memory was used up out of the 512MB RAM... could that be causing the slowness?
Mark
Works fine for me, and speed seems reasonable. It's not the fastest, but it's not slow either.
does work for me now. works fine but not speedy. this is on asdl from the UK.
Tracing route to lancerforums.com [216.177.33.30]
over a maximum of 30 hops:
1 * * * Request timed out.
2 29 ms 28 ms 25 ms 217.32.69.110
3 82 ms 33 ms 29 ms 62.7.251.129
4 48 ms 81 ms 97 ms 213.120.62.147
5 143 ms 23 ms 33 ms 217.32.244.225
6 75 ms 63 ms 94 ms core2-pos12-3.bletchley.ukcore.bt.net [194.72.31
.45]
7 38 ms 27 ms 31 ms core2-pos13-3.ilford.ukcore.bt.net [62.6.196.222
]
8 30 ms 27 ms 27 ms transit1-pos4-0.ilford.ukcore.bt.net [194.72.20.
230]
9 101 ms 159 ms 225 ms 194.72.20.158
10 97 ms 99 ms 95 ms sl-gw9-nyc-7-2.sprintlink.net [144.232.173.125]
11 97 ms 101 ms 100 ms sl-bb26-nyc-15-2.sprintlink.net [144.232.7.97]
12 101 ms 99 ms 97 ms sl-bb25-nyc-8-0.sprintlink.net [144.232.13.189]
13 101 ms 128 ms 101 ms sl-bb20-rly-14-0.sprintlink.net [144.232.18.253]
14 478 ms 106 ms 113 ms sl-dr10-res-9-0.sprintlink.net [144.232.19.122]
15 101 ms 113 ms 159 ms 63.173.24.174
16 301 ms 115 ms 110 ms 208.1.115.201
17 106 ms 105 ms 104 ms 216.177.33.30
Thanks,
I did a search and there is no php ini file of any kind :confused: I ran updatedb and then locate .ini and nothing. I have PHP 4.1.1. Do you happen to have a php.ini file available that I could copy to use?
Mark
No, nothing comes up. I did the my.cnf and restarted mysql and it's gotten better, but not perfect. The url should work now. http://www.lancerforums.com
Thanks,
Mark
does a search for php.ini-optimized reveal anything ?
Originally posted by LancerForums
Hmmm, I still experience some slowness with any php/mysql pages. I just turned on persisitent connections in vB, but so far no real improvement yet.
Any ideas :confused:
Mark
seems fine to me :)
if you download the php source tarball and extract it you should fine one in there you can copy and rename to php.ini to use
I am getting a 404 on the link, and tracert is unable to resolve domain name.
Right now it seems to be slow again. I ran top and noticed it used the swap a little. What do you think could cause these occasional slowdowns? There were about 38-50 users online when it was slowing.
Mark
Originally posted by LancerForums
Right now it seems to be slow again. I ran top and noticed it used the swap a little. What do you think could cause these occasional slowdowns? There were about 38-50 users online when it was slowing.
Mark
Do you have any crontabs running a specific times? Backups scripts, log analyzers, file copies - anything like that?
create a my.cnf file at /etc/my.cnf with the below settings and restart mysql
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=400
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=2M
set-variable = record_buffer=2M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
[safe_mysqld]
open-files-limit=8192
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
as to php.ini try doing asearch in shell telnet
locate php.ini
you might find a file named php.ini-optimised you need to copy and rename it to php.ini in your php configuration path listed in phpinfo at /usr/local/lib and restart apache
Hmmm, I still experience some slowness with any php/mysql pages. I just turned on persisitent connections in vB, but so far no real improvement yet.
Any ideas :confused:
Mark
Where's The Advantage In Windows Genuine Advantage?
Stocks Bounce After S&P Joins Bear Market |
#If you have any other info about this subject , Please add it free.# | |
|