Yet another layer in the scheme of your website...
Lots to learn over at HackMySQL, and best to start in the Optimize section which covers topics from Indexing Basic MySQL Queries to How To Index For MySQL Joins and for the non-technical, Non-technical Guide to Isolating Slow MySQL Queries.
There's more stuff in there for advanced users too, and overall this relatively small but interesting website looks like a good place to go and pick up some extra tips for intermediate users, and the topics covered are a must read for people just hacking there way into mySQL.
Written by Major Hayden, a Rackspace employee, this blog is a great read for those of us who are managing a server for clients who have a dedicated or virtual dedicated server (hello MT).
Major covers a lot of ground, but a great start would be Speeding up MySQL, where he offers up a few nuggets that are not usually seen in these types of posts.
Some of you probably recognize the name from his MySQLTuner script, which when run and iterated thru for a few days helps to get your my.cnf tuned up and your server performing well (keeping in mind his hints from the post linked above also helps for server performance :).
37 mySQL tips plus some additional links at the bottom of the page, there's a good chance that most users will find something useful here. Included are links to articles about normalization, tips for merging tables, doing a random select and many more things that may just be useful at some point!
I haven't tried this out, but I am pretty sure that I will need this some day for something. There are also variation where, using a different ODBC driver, you can suck the data down into Access as well.
A nice simple writeup about database normalization that includes some links at the end worth following (also see MySQL Database Design). From the article:
Over the years I, like many of you, have had the experience of taking over responsibility for an existing application and its associated schema (sometimes frustratingly woven together as part of a Microsoft Access solution).
I hear ya.
This is being bookmarked for future reference. From the website:
Generally, it's a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).
I started freelancing by diving in head first and getting on with it. Many years and a lot of experience later I was still able to take away some gems from this book, and there are plenty I wish I had thought of beforehand. If you are new to freelancing and have a lot of questions (or maybe don't know what questions to ask!) do yourself a favor and at least check out the sample chapters.
Like the other books listed here, this provides a great reference for the PHP developer looking to have the right answers from the right people at their fingertips. I tend to pull this off the shelf when I need to delve into new territory and usually find a workable solution to keep development moving. This only needs to happen once and you recoup the price of the book in time saved from having to develop the solution or find the right pattern for getting the job done..