List Info

Thread: MySQL copying to tmp table
MySQL copying to tmp table
country flaguser name
Russian Federation		 2007-08-15 02:12:24 
Hi!

I noticed that mysql 'show full processlist' frequently show
next request status:


Copying to tmp table | SELECT distinct(mbx.name),
mbx.mailbox_idnr, mbx.owner_idnr FROM dbmail_mailboxes mbx
LEFT JOIN dbmail_acl acl ON mbx.mailbox_idnr =
acl.mailbox_id LEFT JOIN dbmail_users usr ON acl.user_id =
usr.user_idnr WHERE  ((mbx.owner_idnr = 33984) OR
(acl.user_id = 33984 AND   acl.lookup_flag = 1) OR
(usr.userid = 'anyone' AND acl.lookup_flag = 1)) 

We want create mass mail system on DBMail and now we serve
est. 18 000 IMAP4/POP3 account via Cyrus.
But I think than 'copying to tmp table' requests make
velocity too badly.

We will migrate in some next week to DBMail...

How to disable too same requests?

--
Ilyas
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: MySQL copying to tmp table
country flaguser name
United States		 2007-08-15 09:10:03 
> But I think than 'copying to tmp table' requests make
velocity too
> badly.

  This was discussed on the list not long ago .. iirc, the
proposed
solution was to have a config item for where your tmp
directory is
located; those who don't want it on a physical disk can
simply mount a
ram-based device somewhere and point it at that.  Eg. tmpfs
in linux.

> How to disable too same requests? 

  I'm not sure what you mean here ... how to cache the
results of a
query?


-- 
Jesse Norell
Kentec Communications, Inc.
jessekci.net
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: MySQL copying to tmp table
country flaguser name
Australia		 2007-08-15 09:13:01 

  


  

    
Jesse Norell wrote:

slug.kci.net"
 type="cite">
  

    
But I think than 'copying to tmp table' requests make velocity too
badly.
    

  

  

  This was discussed on the list not long ago .. iirc, the proposed
solution was to have a config item for where your tmp directory is
located; those who don't want it on a physical disk can simply mount a
ram-based device somewhere and point it at that.  Eg. tmpfs in linux.
  



He seems to be saying this is inside mysql. As i recall mysql uses temp
tables when it needs to sort things or runs out of ram.

The OP might want to take a look at how he is using the ram on the
machine to see if that fixes it.


slug.kci.net"
 type="cite">
  
  

  

    
How to disable too same requests? 
    

  

  

  I'm not sure what you mean here ... how to cache the results of a
query?



  






  

  
  
   
     
    

  

    Re:  MySQL copying to tmp table
  


  

     country flaguser name
Russian Federation		
     2007-08-19 10:23:33
  


  

    

  


  

    
Hi!
 ;
Thanks for your comments. I will research with problem. 
 
15.08.07, 18:13, Jake Anderson :


Jesse Norell wrote:

  

    
But I think than 'copying to tmp table' requests make velocity too
badly.
    

  

  

  This was discussed on the list not long ago .. iirc, the proposed
solution was to have a config item for where your tmp directory is
located; those who don't want it on a physical disk can simply mount a
ram-based device somewhere and point it at that.  Eg. tmpfs in linux.
  


He seems to be saying this is inside mysql. As i recall mysql uses temp
tables when it needs to sort things or runs out of ram.

The OP might want to take a look at how he is using 
 the ram on the
machine to see if that fixes it.


  

  

  

    
How to disable too same requests? 
    

  

  

  I'm not sure what you mean here ... how to cache the results of a
query?


  







  

  
  
   
     
    






 [1-4]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )