4 ms·
This is pretty basic, but in addition to mysql table structure and query optimization, have you done/considered any tweaking of the mysql config itself? (Usuall
by sagacity 16y ago
This is pretty basic, but in addition to mysql table structure and query optimization, have you done/considered any tweaking of the mysql config itself? (Usually at /etc/my.cnf)
We've repeatedly experienced huge performance gains even with basic/minor tweaks of my.cnf.
HTH
- digamber_kamat 16y agoCool. Something that I dint know. So far I have changed some table types to innoDB from MyISAM. Rewritten a lot of queries and in some cases maintained redundancy instead of normalization.
- sagacity 16y agoLikewise, you might want to check/tweak your apache config too (usually at /etc/httpd/conf/httpd.conf). As you probably know, the default configs of both - mysql and apache are usually pretty minimalistic so tuning these in accordance with your load/traffic scenarios can pay you off big-time in terms of performance boost. On that note, I'm sure they have some highly competent people out there at RackSpace who should also be able to help you out with all this.