MySQL Forums
Forum List  »  InnoDB

Re: MySQL 5.5 performance is slow when querying cross database union view
Posted by: Rick James
Date: July 10, 2014 11:03PM

To assist in analyzing slow SELECTs, please provide (for both single- and dual-database cases):
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW CREATE VIEW ...
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
How much RAM do you have?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.5 performance is slow when querying cross database union view
1229
July 10, 2014 11:03PM


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.