News for hackers. Stuff that matters.
Re:Ask HN: Dealing with a huge MySQL database - help by gmuslera on Sunday September 08, 2013 @12:32PM (#6349228)
With 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.
Re:Ask HN: Dealing with a huge MySQL database - help by webvet on Monday September 09, 2013 @04:56AM (#6352434)
Thanks. We'll check out TokuDB.