So a brand new version of Sphinx has come out. I’ve been using a beta version of 0.9.8 so I’ve been using most of the new features already but the list of new features and bug fixes is still pretty impressive. For those of you who don’t know, Sphinx is a MySQL full-text replacement for implementing search. And its hella fast.
I just recently found out that jQuery’s “get” method actually returns the DOM objects within the jQuery object. For the longest time, I’ve been using my own “dom” method to do the same thing. For some reason, I never use their documentation site. The search isn’t that great, and something about the site itself just makes me not want to use. Maybe its because I loved the old Visual jQuery site so much. Only if someone would update it for jQuery 1.2.
Found these two videos on Youtube and it really brought me back to the good ole days:
Working with Mysql a lot, I’ve come across a lot of resources for finding ways of improving Myql performance in relation to configurations, queries and importing/exporting data. Here’s a list of sources I use a lot:
MySQL Performance Blog: This is my favorite Mysql site and was absolutely indispensable when first starting out with Mysql. They pretty much cover any Mysql related topic.
MySQL Reference: The actual reference site is a must have. It’s fairly thorough and covers everything in simple detail.
Travis’s Mysql Postings: He’s the most knowledgeable database person I know and is usually the first person I go to with anything Mysql.
Jay’s Mysql Postings: He’s the 2nd most knowledgeable database person I know and he’s always spot-on with any tips he gives.
The rest are just a list of sites/pages that I find useful for whenever I need something specific:
Speeding up InnoDB Imports
10 Performance Tips
84 Performance Tips
Google Search