Results 1 to 3 of 3
  1. #1

    fixing "Copying to tmp table"

    I've noticed I've been getting a lot of "Copying to tmp table" and from a google search this is bad. Any idea on how I can fix this in my shared hosting environment?

    Running MySQL 5.0.81 on CPanel.

  2. #2
    have you tried increasing values?

  3. #3
    Join Date
    Jul 2009
    Location
    Charlotte, NC
    Posts
    42
    You'll need to find the SQL statements that are causing the "Copying to tmp table". For example, * ORDER BY RAND() is an example of a query that causes this behavior, and the way to get around it is to find different queries or methods to replace it with.

    You can find out if a query will cause it by using 'EXPLAIN' on the statement. "Copying to tmp table" is not too horrible if only a few queries cause it, but writing to disk will always be slower than most alternatives.

Similar Threads

  1. How efficient are topic titles like "BLOWOUT", "SPECIAL" and "KILLER OFFER"?
    By BluewaveHosted in forum Running a Web Hosting Business
    Replies: 18
    Last Post: 06-30-2009, 11:21 AM
  2. MySQL Keeps "crashing" missing table files.
    By Canadaka in forum Hosting Security and Technology
    Replies: 16
    Last Post: 06-29-2006, 07:19 PM
  3. copying "symbolic folders"
    By kafloofen in forum Hosting Security and Technology
    Replies: 1
    Last Post: 12-12-2005, 01:06 PM
  4. Kernel need fixing "I have no idea what does it mean"
    By FunnyFo in forum Hosting Security and Technology
    Replies: 2
    Last Post: 01-13-2003, 01:38 AM
  5. can't create table called "when" with MySQL 3.23.37
    By dico in forum Dedicated Server
    Replies: 1
    Last Post: 11-17-2002, 07:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •