Thanks, I changed the permissions, restarted, and everything is working great now. Thanks a lot.
> Shaun wrote: > > 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? > > Can the mysql user write to this file? > > --log-long-format should show you queries that don't use an index. > > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
