MySQL Forums
Forum List  »  InnoDB

Re: Larger than expected tmp files querying InnoDB format database
Posted by: Michael Lueck
Date: July 07, 2014 04:12PM

Greetings,

I located this page:

"MySQL Maintenance Tasks for InnoDB with MySQL 5.1"
http://www.laurencegellert.com/2011/07/mysql-maintenance-tasks-for-innodb-with-mysql-5-1/

I ran the suggested commands:

/usr/bin/mysqlcheck -u root -p --check --databases micc_civicrm
/usr/bin/mysqlcheck -u root -p --optimize --databases micc_civicrm
/usr/bin/mysqlcheck -u root -p --analyze --databases micc_civicrm

All commands completed siting nothing out of ordinary.

I then stopped the Apache service, restarted the MySQL service, finally restarted Apache.

I ran the query with the same operational details as posted above. No improvement on the extremely large tmp file created while processing the query.

I am thankful,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Larger than expected tmp files querying InnoDB format database
1419
July 07, 2014 04:12PM


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.