undefined | Better HN

0 pointsjacques_chester12y ago0 comments

If it's a LAMP app, then not really.

If you have tables with TEXT fields, MySQL up to and including 5.5 will perform certain joins with on-disk tables no matter what you tell it to do and will ignore indexes you create to prevent that on-disk stupidity. This behaviour is independent of engine.

Being I/O choked on Linode is why I moved to DigitalOcean.

0 comments

3 comments · 1 top-level

ceol12y ago· 2 in thread

It sounds like you should have moved from MySQL to PostgreSQL instead of switching hosting providers.

jacques_chesterOP12y ago

Please call me when Wordpress and thousands of plugins and themes have been expunged of all MySQLisms.

Otherwise, heartily agreed.

ceol12y ago

Ahh, Wordpress. You have my deepest sympathies.

If you don't mind my asking, is there some key feature of Wordpress or its plugins that holds you to it? I'm always interested to hear why people stick with it.

1 more reply

j / k navigate · click thread line to collapse