[wp-hackers] OT: MySQL optimization

Computer Guru computerguru at neosmart.net
Tue May 8 14:29:07 GMT 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Aubrey Kilian wrote:
> And it'd be a good idea to see the pros and cons of innodb vs. myisam
> tables, amongst others, as Matt pointed out, is performance increase
> on heavilly indexed tables,  and transactions support, but there's a
> bit of a performance hit for reading, and you lose fulltext indexes.
> It'd be worth doing benchmarks on your specific instance me thinks. 

MySQL has FullText support in InnoDB on their "to-do" list, though the
insider's word is that's not going to happen.

Now, I could SWEAR I read about this in so many different places, but
for the life of me I can't find a link now nor remember its name, but
MySQL is supposed to be working on the successor to InnoDB and MyISAM,
something that combines the speed of InnoDB and gives it FullText
searches amongst other things. I can't remember the name of this in-dev
tabletype, and it seems Google can't either :/

Anyone here have better memory than me? Help me out?

:)

- --
Computer Guru
NeoSmart Technologies
http://neosmart.net/blog/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGQIkz3SICh4XKUt0RAmsRAKDiNcXLdu9d+o18c0iwY1f+94oy4QCg5jzD
LovWCb/d7neNgfK5maT2XOo=
=iKRz
-----END PGP SIGNATURE-----


More information about the wp-hackers mailing list