MySQL Forums
Forum List  »  General

Re: Indexing problems
Posted by: James Woodward
Date: October 27, 2004 12:01AM

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.

Options: ReplyQuote


Subject
Written By
Posted
October 25, 2004 07:31PM
October 25, 2004 07:49PM
October 25, 2004 08:25PM
October 25, 2004 08:39PM
October 25, 2004 08:55PM
October 26, 2004 08:15PM
October 26, 2004 08:22PM
October 26, 2004 11:11PM
October 26, 2004 11:29PM
Re: Indexing problems
October 27, 2004 12:01AM
October 27, 2004 01:21AM
October 27, 2004 01:20PM
October 27, 2004 06:34PM
October 28, 2004 10:03PM
October 29, 2004 02:20AM
November 07, 2004 01:25AM
October 26, 2004 11:34AM
October 26, 2004 01:48PM
October 26, 2004 02:14PM
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.