4 ms·
What exactly is getting slow? Inserts? Updates? Queries? Which ones? Have you looked at the slow query log? Have you checked the plans for the slow queries? Ar
by geophile 13y ago
What exactly is getting slow? Inserts? Updates? Queries? Which ones? Have you looked at the slow query log? Have you checked the plans for the slow queries?
Are these MyISAM tables or InnoDB?
150GB and 100M records is not huge, not even close. You are looking for a quick fix and there isn't one. You need to start with (2).
- webvet 13y agoYes, we enable slow query logs from time to time, look at those and try to optimize for those. MyISAM tables. We've been cycling frequently (and painfully) through (2) (and less frequently through (1)) for the best part of three years now, so please don't accuse us at least of looking for a quick fix :)
- gmuslera 13y agoWith MyISAM tables you could have integrity problems. And if you are mixing innodb and myisam you are splitting buffers memory that well could go to just one kind (i.e. most memory for innodb) if you switch to that. If innodb is slow in insertions, you could try using TokuDB as storage engine, that is pretty fast in that and have a bunch of advantages. And if you are using MyISAM for some particular feature (i.e. full text indexing) MySQL 5.6 already have it in innodb, or you can separate that search to a sphyinx server.
- webvet 13y agoThanks. We'll check out TokuDB.
- webvet 13y ago> 150GB and 100M records is not huge, not even close. Close to what, if I may ask?
- nfailor 13y agonot even close to 'huge,' although my english syntax is a little rusty.
- webvet 13y agoRegardless of your English syntax (rusty or not), what would you define as 'huge' for a MySQL app?
- petervandijck 13y agoAgree. 1B rows is big. 100B rows is huge. 100M rows is large, but totally doable.