MySQL :: Re: Almost whole table in single index: is there a better way?

New Topic

Re: Almost whole table in single index: is there a better way?

Posted by: Aftab Khan
Date: August 27, 2012 11:42AM

Please provide output of following (run them against PROD db):

SHOW TABLE STATUS 'RemoteStatuses'\G
SHOW GLOBAL STATUS;

>Here is my.cnf

Is this from your Test database or PROD ?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Almost whole table in single index: is there a better way?

3048

Andy Deakin

August 25, 2012 07:33AM

Re: Almost whole table in single index: is there a better way?

1740

Aftab Khan

August 27, 2012 09:18AM

Re: Almost whole table in single index: is there a better way?

1850

Andy Deakin

August 27, 2012 10:18AM

Re: Almost whole table in single index: is there a better way?

1915

Aftab Khan

August 27, 2012 10:53AM

Re: Almost whole table in single index: is there a better way?

1770

Aftab Khan

August 27, 2012 11:02AM

Re: Almost whole table in single index: is there a better way?

1799

Andy Deakin

August 27, 2012 11:16AM

Re: Almost whole table in single index: is there a better way?

1656

Aftab Khan

August 27, 2012 11:42AM

Re: Almost whole table in single index: is there a better way?

1827

Andy Deakin

August 27, 2012 12:29PM

Re: Almost whole table in single index: is there a better way?

2000

Rick James

August 28, 2012 08:43AM

Re: Almost whole table in single index: is there a better way?

1724

Andy Deakin

August 28, 2012 10:08AM

Re: Almost whole table in single index: is there a better way?

1653

Aftab Khan

August 28, 2012 10:52AM

Re: Almost whole table in single index: is there a better way?

1810

Rick James

August 28, 2012 11:20PM

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.