Hello.
> But now this takes forever... May be you have some locks or your system is heavy-loaded. Use 4.1.9 instead of 4.1.7. "Kevin A. Burton" <[EMAIL PROTECTED]> wrote: > Under 4.0.18 we were loading about 800M of data into a memory table to > get better performance from some of our main queries. > > Via crontab we would DELETE older links in the memory table and then > INSERT links from a myisam table. > > This process under 4.1.7 is MUCH slower. Specifically the DELETE is > taking forever. > > We would run: > > DELETE FROM FOO_MEMORY WHERE FOO_MEMORY.TIMESTAMP < 1105055409729; > > But now this takes forever... > > I realize that no index is used on this query but due to the fact that > its a memory table it should sitll be FAST as heck. > > Hash anything changed with rehashing that could effect the performance here? > > I could install a 4.0.18 node to benchmark but this would take a while > as they are all upgraded....... > > Kevin > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
