Thanks for your help Dathan, I will make the required changes. I just have one other problem.
I'm not sure what queries don't use an index. I've attmepted to turn on the slow-queries-log, but nothing ever shows up in the file. Here's what I have in the my.cnf [mysqld] skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 set-variable = max_connections=500 set-variable = ft_min_word_len=1 long_query_time=1 log-long-format log-slow-queries = /var/log/slow.log Do you have any idea why my slow query log isn't working? Do I have something wrong in my syntax? I'm using MySQL 4.0. Thanks for your help, I really appreciate it. http://www.hdtv-info.org http://www.entertainment-news.org http://www.political-news.org > Look at > > > Created_tmp_disk_tables 14768 > > Created_tmp_tables 269520 > > Created_tmp_files 3 > > > Increase tmp_table_size = 64M: > > it's used to stop going to disk and some internal mysql operations. > > > Handler_read_rnd_next 58229817 > > Your tables are not index properly, your doing a lot of table scans. > > Your biggest perf. Gain will come from changing your schema and or > optimizing your queries. > > > > > > DVP > ---- > Dathan Vance Pattishall http://www.friendster.com > > > > > > Hello, > > > > I was wondering if a more knowledgeable person could help me out with my > > configuration and let me know how I could further optimize MySQL. Here's > > the hardware on my dedicated server: > > > > Processor #1 Vendor: GenuineIntel > > Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.40GHz > > Processor #1 speed: 2400.152 MHz > > Processor #1 cache size: 1024 KB > > Memory 512 MB > > > > > > Here's what I get for the command SHOW STATUS: > > > > Aborted_clients 247 > > Aborted_connects 483 > > Bytes_received 531539854 > > Bytes_sent 503095410 > > Connections 450758 > > Created_tmp_disk_tables 14768 > > Created_tmp_tables 269520 > > Created_tmp_files 3 > > Delayed_insert_threads 0 > > Delayed_writes 0 > > Delayed_errors 0 > > Flush_commands 1 > > Handler_commit 0 > > Handler_delete 27837 > > Handler_read_first 670529 > > Handler_read_key 285579436 > > Handler_read_next 394084433 > > Handler_read_prev 680815 > > Handler_read_rnd 5230552 > > Handler_read_rnd_next 58229817 > > Handler_rollback 0 > > Handler_update 384098 > > Handler_write 77442968 > > Key_blocks_used 50333 > > Key_read_requests 1081940322 > > Key_reads 45598 > > Key_write_requests 66458416 > > Key_writes 41372551 > > Max_used_connections 154 > > Not_flushed_key_blocks 0 > > Not_flushed_delayed_rows 0 > > Open_tables 256 > > Open_files 323 > > Open_streams 0 > > Opened_tables 1022 > > Questions 30428972 > > Qcache_queries_in_cache 0 > > Qcache_inserts 0 > > Qcache_hits 0 > > Qcache_lowmem_prunes 0 > > Qcache_not_cached 0 > > Qcache_free_memory 0 > > Qcache_free_blocks 0 > > Qcache_total_blocks 0 > > Rpl_status NULL > > Select_full_join 268 > > Select_full_range_join 0 > > Select_range 66211 > > Select_range_check 0 > > Select_scan 151459 > > Slave_open_temp_tables 0 > > Slave_running OFF > > Slow_launch_threads 2 > > Slow_queries 15783 > > Sort_merge_passes 0 > > Sort_range 476962 > > Sort_rows 5241809 > > Sort_scan 283556 > > Table_locks_immediate 31443397 > > Table_locks_waited 20243 > > Threads_cached 4 > > Threads_created 2423 > > Threads_connected 5 > > Threads_running 1 > > Uptime 771502 > > > > > > Here are the complete contents of my my.cnf file > > > > [mysqld] > > skip-locking > > set-variable = key_buffer=256M > > set-variable = max_allowed_packet=1M > > set-variable = table_cache=256 > > set-variable = sort_buffer=1M > > set-variable = record_buffer=1M > > set-variable = myisam_sort_buffer_size=64M > > set-variable = thread_cache=8 > > set-variable = max_connections=500 > > set-variable = ft_min_word_len=1 > > log-slow-queries=/var/log/slow-queries.log > > set-variable = long_query_time=1 > > safe-show-database > > > > > > Thanks a lot for your help! > > > > http://www.hdtv-info.org > > http://www.entertainment-news.org > > http://www.political-news.org > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
