Skip to main content
Database Administrators

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

7
  • The index is not the whole table, there are 2 other columns. Anyway, I edited the question to add the INNODB Engine Status. Please review and advise more specifically if you are able. Commented Jul 14, 2014 at 15:28
  • The command shows no activity, probably because it has been execute only once. Try this instead: SHOW GLOBAL STATUS LIKE 'InnoDB%'; before and after executing several of your queries. Please add also the result of EXPLAIN SELECT + query, as suggested above. Commented Jul 15, 2014 at 10:09
  • I can already tell you that you have a 128MB buffer pool, which may be too small for you dataset. The typical size for a dedicated server is to cover the whole "working set" (frequently used rows) + 10%, up to the 80% of the available memory. Commented Jul 15, 2014 at 10:42
  • I have 8 GB of RAM, so would you recommend setting the buffer pool to, say, 5 or 6 GB? Commented Jul 15, 2014 at 13:43
  • Those are reasonable defaults, assuming you are only (mostly) using InnoDB and your data size is larger. Please note that MySQL should at any time have 0 swap activity, so make sure you monitor it after change it. Commented Jul 15, 2014 at 17:17