Can someone kindly help me tweaking my slow server
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
=================
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
#If you have any other info about this subject , Please add it free.# |
