Skip navigation links
Showing entries 1 to 4

Tags Filter: plugin (reset)

Videos
Add to Favourites +1 Vote Up -0Vote Down
What's new, in a nutshell: http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html Release notes: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html (In the video, it's the page entitled "Changes in release 5.1.x"). And yes, very early on (at about 2 minutes in) I talk about my take on Monty's controversial post at http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html The slides can be downloaded as a PDF at http://technocation.org/files/doc/2008_12_New51.pdf or in Open Office presentation format at http://technocation.org/files/doc/2008_12_New51.odp
Articles
Add to Favourites +0 Vote Up -0Vote Down
MySQL Full Text Search LimitationsSuppose you have a MyISAM table containing a column with a full text index. This table starts to grow to a significant size (millions of rows) and gets updated fairly frequently. Chances are that you'll start to see some bottlenecks when accessing this table, since without row level locking, the reading and writing operations will be blocking each other.A solution that many people would suggest right away is to use the master for writes and a slave for reads, but this only masks the problem, and it won't take long before enough read traffic on the slave starts causing slave lags.Why Sphinx?
Articles
Add to Favourites +1 Vote Up -0Vote Down
An example showing how to use Sphinx when MySQL Full Text Search limitations show up.
Articles
Add to Favourites +1 Vote Up -0Vote Down
MySQL 5.1.38 includes the InnoDB plugin. This article shows how to install the plugin, using MySQL Sandbox and the binary snapshots.
Showing entries 1 to 4