Can someone kindly help me tweaking my slow server

[Remi]

Hi

I wounder in you can help me please, my server is slow and I was talled that it can be improved if tweaked right.

I have duall 850 PIII
1 GB RAM
SCSI HDD.
PHP 4.1.2
MySQL 3.23.49.

this is my.cnf
====================

[mysqld]
set-variable = max_connections=500
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=14400
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[safe_mysqld]
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
=============================

and this is mysqlinfo:

Sun Mar 9 21:31:02 GMT 2003

9:31pm up 12 days, 11:41, 3 users, load average: 3.41, 5.25, 4.78
223 processes: 219 sleeping, 4 running, 0 zombie, 0 stopped
CPU0 states: 50.0% user, 10.1% system, 0.0% nice, 39.0% idle
CPU1 states: 44.0% user, 16.0% system, 0.0% nice, 39.0% idle
Mem: 1030520K av, 973016K used, 57504K free, 0K shrd, 62872K buff
Swap: 546080K av, 30424K used, 515656K free 645504K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
9085 mysql 16 0 25228 24M 2164 R 4.6 2.4 2:33 mysqld
15389 mysql 16 0 25228 24M 2164 R 3.9 2.4 0:06 mysqld

Http processes currently running = 55
Mysql processes currently running = 80
Netstat information summary
1 CLOSING
3 LAST_ACK
4 FIN_WAIT1
5 FIN_WAIT2
5 SYN_RECV
9 CLOSE_WAIT
27 LISTEN
42 ESTABLISHED
531 TIME_WAIT

+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 197466189 |
| Bytes_sent | 3016444107 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 36947 |
| 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 | 5537 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 8349 |
| Com_insert_select | 271 |
| 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 | 329 |
| Com_replace_select | 41 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 1116396 |
| 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_stat | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_stat | 0 |
| Com_show_status | 36320 |
| Com_show_tables | 0 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 81355 |
| Connections | 643 |
| Created_tmp_disk_tables | 7 |
| Created_tmp_tables | 22103 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 8025 |
| Handler_read_first | 22502 |
| Handler_read_key | 61108113 |
| Handler_read_next | 56463249 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 8613010 |
| Handler_read_rnd_next | 552530624 |
| Handler_update | 44834676 |
| Handler_write | 1015287 |
| Key_blocks_used | 9693 |
| Key_read_requests | 52193441 |
| Key_reads | 9007 |
| Key_write_requests | 77572 |
| Key_writes | 27050 |
| Max_used_connections | 72 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 133 | 13% of table_cache in use
| Open_files | 146 |
| Open_streams | 0 |
| Opened_tables | 139 |
| Questions | 1249839 |
| Select_full_join | 7 |
| Select_full_range_join | 0 |
| Select_range | 256273 |
| Select_range_check | 0 |
| Select_scan | 186832 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 1 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 272833 |
| Sort_rows | 8637295 |
| Sort_scan | 87426 |
| Table_locks_immediate | 1523092 |
| Table_locks_waited | 5290 |
| Threads_cached | 21 |
| Threads_created | 73 |
| Threads_connected | 52 |
| Threads_running | 1 |
| Uptime | 26228 | 7 hrs 17 mins 8 secs
+---------------------------+-----------------+

Key Reads/Key Read Requests = 0.000173 (Cache hit = 99.999827%)
Key Writes/Key Write Requests = 0.348708
Connections/second = 0.025 (/hour = 88.257)
KB received/second = 7.352 (/hour = 26468.537)
KB sent/second = 79.958 (/hour = 287850.526)
Temporary Tables Created/second = 0.843 (/hour = 3033.811)
Opened Tables/second = 0.005 (/hour = 19.079)
Slow Queries/second = 0.000 (/hour = 0.137)
% of slow queries = 0.000%
Queries/second = 47.653 (/hour = 171550.267)
================

Please tell me if you need any thing else

Thanks

[eva2000]

phpinfo.php and mysqlinfo.php urls would be nice

[Remi]

Thank you very much George, this is the PHP info:

=================
System Linux daffy.perf.redhat.com 2.4.18-11smp #1 SMP Thu Aug 15 06:41:59 EDT 2002 i686 unknown

Build Date Sep 26 2002

Configure Command './configure' 'i386-redhat-linux' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-config-file-path=/etc' '--enable-force-cgi-redirect' '--disable-debug' '--enable-pic' '--disable-rpath' '--enable-inline-optimization' '--with-bz2' '--with-db3' '--with-curl' '--with-dom=/usr' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gdbm' '--with-gettext' '--with-ncurses' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-mm' '--with-openssl' '--with-png' '--with-pspell' '--with-regex=system' '--with-xml' '--with-expat-dir=/usr' '--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-debugger' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-discard-path' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--without-oci8' '--with-imap=shared' '--with-imap-ssl' '--with-kerberos=/usr/kerberos' '--with-ldap=shared' '--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared' '--enable-memory-limit' '--enable-bcmath' '--enable-shmop' '--enable-versioning' '--enable-calendar' '--enable-dbx' '--enable-dio' '--enable-mbstring' '--enable-mbstr-enc-trans' '--with-apxs=/usr/sbin/apxs'

The php Configurations are the default options

and the MySQL info was included in my first post.

Thanks