Re: Mysql too Slow when Copying to Tmp Table
Posted by:
karen wang
Date: November 12, 2012 12:08AM
thanks for you help
I excuted “flush tables" before i excute this query everytime.
when i excute the query a second time without 'flush tables' command,it's so fast.
A bigger "optimization" comes from noticing that the two tables have exactly the same number of rows. Are they 1:1?
yes it's 1:1 but we cant put the data in a single table because another reason.
I changed some column's character attribute as you suggested.
it's last 0.36seconds when i run this query in SecureCRT Client.
it's last 11.8419seconds when i run this query in phpmyadmin Client.
it's last 4.031seconds when i run this query in Navicat Client.
(I try some times!)
what is this caused??
Subject
Views
Written By
Posted
12378
November 10, 2012 07:57AM
6380
November 11, 2012 12:30PM
5638
November 11, 2012 07:53PM
5729
November 11, 2012 08:32PM
Re: Mysql too Slow when Copying to Tmp Table
4665
November 12, 2012 12:08AM
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.