Recent searches
Search options
Which database do you use?
@tweets MySQL with innoDB
I recently dealed with a more than 8 million row full text innoDB db. A good starting point is MylSQL tuner:
https://github.com/major/MySQLTuner-perl
Most import settings in context of scaling issues are index and innodb_buffer_pool_size. First is a question of reading/writing ratio, second a question of hardware. Maybe these are some starting points. :)
https://github.com/major/MySQLTuner-perl
Most import settings in context of scaling issues are index and innodb_buffer_pool_size. First is a question of reading/writing ratio, second a question of hardware. Maybe these are some starting points. :)
GitHubGitHub - major/MySQLTuner-perl: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. - GitHub - major/MySQLTuner-perl: MySQLTu...