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]
