Bug0037
- Description
- Exporting large group by tables slow
Take a large table. Group by an IP column. Export the group by table (all rows). It seems extremely slow (slower than it should be). The database seems to be tied up with "Copying to tmp table" on "create table cache_NN select inet_ntoa('Source') as 'Source', count(*) as 'Count" from TABLE_NAME".
Attach backtrace here.
- Logged
- 2007-05-31
- Logged By
- Assigned to
- Status
- Open
Get back to the BugIndex
MySQL can actually use the csv storage engine to write a csv table directly. This should be faster than the way we do it (create the table and then select it) and would be more efficient as the copying to tmp table will immediately produce a csv file which could be streamed to the browser.
