Need to tune, getting weird results on server.

[version2]

Ok, I upgraded to the latest php dist today and before that everything was running fast and fine on my boards. Now, however, the output has seem to slow down. It actually acts like its gzipping everything even though I have gzip turned off. I dont understand. Can someone take a look and see if you think this is whats going on and if so, what can I do to fix it?

Thanks.

http://www.mysticwicks.com

[version2]

Here is phpinfo and I am gathering more info.

http://www.mysticwicks.com/info.php

[version2]

Versions:

Apache/1.3.26 (port install)
Mysql 3.23.39 (port install)
PHP PHP/4.2.3 (Compiled --with-mysql --with-apxs)


OS:

FreeBSD 4.6.1-RC2

[version2]

Oh yikes. No my.conf. On freebsd it is not installed on default. Anyway, here is the output:


| Variable_name | Value |

| back_log | 50 |
| basedir | /usr/local/ |
| bdb_cache_size | 8388600 |
| bdb_log_buffer_size | 32768 |
| bdb_home | /var/db/mysql/ |
| bdb_max_lock | 10000 |
| bdb_logdir | |
| bdb_shared_data | OFF |
| bdb_tmpdir | /var/tmp/ |
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (June 3, 2002) |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/db/mysql/ |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | YES |
| have_gemini | NO |
| have_innodb | DISABLED |
| have_isam | YES |
| have_raid | NO |
| have_openssl | NO |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | OFF |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | |
| innodb_mirrored_log_groups | 1 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/local/share/mysql/english/ |

[version2]

Had to seperate. Too long.

| large_files_support | ON |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_long_queries | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 256 |
| myisam_max_sort_file_size | 2047 |
| myisam_recover_options | 0 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 1000000 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /var/db/mysql/www.pid |
| port | 0 |
| protocol_version | 10 |
| record_buffer | 131072 |
| record_rnd_buffer | 131072 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_locking | OFF |
| skip_networking | ON |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| sql_mode | 0 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | PDT |
| tmp_table_size | 33554432 |
| tmpdir | /var/tmp/ |
| version | 3.23.51 |
| wait_timeout | 28800

[version2]

+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 13 |
| Aborted_connects | 0 |
| Bytes_received | 1081570866 |
| Bytes_sent | 474011939 |
| Com_admin_commands | 0 |
| Com_alter_table | 5 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 337240 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 12 |
| Com_delete | 33603 |
| Com_drop_db | 4 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 54307 |
| Com_insert_select | 3705 |
| 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 | 10242 |
| Com_replace_select | 48 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 4994068 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 61 |
| Com_show_fields | 40 |
| Com_show_grants | 0 |
| Com_show_keys | 39 |
| 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 | 1 |
| Com_show_tables | 245 |
| Com_show_variables | 177 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 1277465 |
| Connections | 336483 |
| Created_tmp_disk_tables | 116 |
| Created_tmp_tables | 146924 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 56463 |
| Handler_read_first | 473247 |
| Handler_read_key | 50784247 |
| Handler_read_next | 202580828 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 73367781 |
| Handler_read_rnd_next | 1428237348 |
| Handler_update | 1706176 |
| Handler_write | 16665306 |
| Key_blocks_used | 7793 |
| Key_read_requests | 215643839 |
| Key_reads | 326432 |
| Key_write_requests | 507119 |
| Key_writes | 455700 |
| Max_used_connections | 14 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 52 |
| Open_files | 89 |
| Open_streams | 0 |
| Opened_tables | 994 |
| Questions | 7047757 |
| Select_full_join | 188 |
| Select_full_range_join | 0 |
| Select_range | 883340 |
| Select_range_check | 0 |
| Select_scan | 1158693 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 76 |
| Sort_merge_passes | 0 |
| Sort_range | 913298 |
| Sort_rows | 83818669 |
| Sort_scan | 438015 |
| Table_locks_immediate | 7559014 |
| Table_locks_waited | 3122 |
| Threads_cached | 0 |
| Threads_created | 336482 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 1683677 |
+--------------------------+------------+

[version2]

These forums are alone on the server.

VB version is 2.2.8

Httpd.conf info:

KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 300


Here is a top output for server specs:

last pid: 34112; load averages: 2.22, 2.14, 2.37 up 19+12:35:03 14:25:32
31 processes: 1 running, 30 sleeping
CPU states: 15.5% user, 0.0% nice, 51.0% system, 0.0% interrupt, 33.5% idle
Mem: 1226M Active, 323M Inact, 356M Wired, 67M Cache, 199M Buf, 38M Free
Swap: 1024M Total, 531M Used, 493M Free, 51% Inuse

[version2]

I think its apxs. Thats the only change. Im going to recompile php as strictly a module and see what happens. I will report my findings.

[version2]

That was it. Im going to leave this post for search value. There is INDEED a performance hit when using php compiled --with-apxs. Quite a performance hit in fact.

[eva2000]

well php compiled statically is faster but i can't see dynamically compiled php being as bad as your experienced (but then again i don't dabble in freebsd servers much at all :o )

you can try tweaking your mysql settings and reducing maxclients from 300 to 150 and restart apache

you're mysql version in variables out shows it's 3.23.52 but you have compiled php using the old mysql 3.23.39 client libraries as well