Re: Indexing problems
Ok so I've done what you asked but I also ran analyze table to see what would happen. And that seems to have spead it up again. Unfortunately I did this before reading you latest post so There is no slow_query at this time.
Anyways the differences at this point in time are these
1. was done after the flush but before the query
2. was done after the flush and after the query
1. Bytes_received: 16
2. Bytes_received: 638
1. Bytes_sent: 9
2. Bytes_sent: 21270740
1. Com_change_db: 0
2. Com_change_db: 2
1. Com_select: 0
2. Com_select: 7
1. Com_show_status: 1
2. Com_show_status: 2
1. Connections: 10231
2. Connections: 10232
1. Handler_read_key: 0
2. Handler_read_key: 1
1. Handler_read_next: 0
2. Handler_read_next: 8540
1. Handler_read_rnd: 0
2. Handler_read_rnd: 4145
1. Handler_read_rnd_next: 0
2. Handler_read_rnd_next: 5176
1. Key_read_requests: 0
2. Key_read_requests: 122
1. Key_reads: 0
2. Key_reads: 29
1. Max_used_connections: 0
2. Max_used_connections: 1
1. Questions: 1162502
2. Questions: 1162513
1. Select_scan: 0
2. Select_scan: 6
1. Sort_range: 0
2. Sort_range: 1
1. Sort_rows: 0
2. Sort_rows: 4145
1. Sort_scan: 0
2. Sort_scan: 1
1. Table_locks_immediate: 0
2. Table_locks_immediate: 7
1. Threads_created: 10230
2. Threads_created: 10231
1. Uptime: 170712
2. Uptime: 170739
If it helps I can do the query again once the table slows down to see if there is a difference then as well.
Subject
Written By
Posted
Re: Indexing problems
October 27, 2004 12:01AM
November 07, 2004 01:25AM
November 10, 2004 11:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.