81 posts tagged “mysql”
2007
Getting from point A to B (the right way)
If your laptop is relatively recent it might have hardware support for virtualization (Intel Core Duo chips do, for example). If so, it’s worth looking in to using VMWare or Parallels to run a virtual linux server locally on your machine. You’ll need a fair amount of RAM for this as well—2 GB minimum probably.
[... 194 words]CouchDB: Thinking beyond the RDBMS. CouchDB is a fascinating project—an Erlang powered non-relational database with a JSON API that lets you define “views” (really computed tables) based on JavaScript functions that execute using map/reduce. Damien Katz, the main developer currently works for MySQL and used to work on Lotus Notes.
Semi-synchronous replication for MySQL (via) Google’s patch for MySQL which enables more reliable master-slave replication (a transaction isn’t committed until at least one slave has replicated the data).
Capacity Planning for LAMP (via) John Allspaw’s MySQL Conf 2007 talk on capacity planning (John is Operations Engineering Manager at Flickr).
2006
MySQL: Get total number of rows when using LIMIT (via) Useful tip.
2005
TurboDbAdmin. Ajax phpMyAdmin clone built on Dojo. Worth trying the live demo.
Upgrading MySQL 4.0 to 4.1 (via) Some scary differences; PostgreSQL seems to be much better at this kind of thing.
2004
How to handle international dates and times in PHP and MySQL. Keith tackles a common point of irritation.
Installing PHP 5 on OS X if you’re using Server Logistics’ “Complete Apache 2” and “Complete MySQL”. Does exactly what it says on the tin.
Why MySQL grew so fast (via) A report from the MySQL users conference.
MySQL tips. Rob Hudson’s tips on MySQL paging and vertical result sets
2003
Storing Dates in MySQL
DevShed have a new article on Date Arithmetic With MySQL, which acts as a kind of missing manual for MySQL’s powerful date arithmetic functions. It reminded me of something I’ve been meaning to write about for some time: my thoughts on storing dates in a PHP application that uses a MySQL backend
[... 421 words]Stored procedures in MySQL?
Via Sam Buchanan, it looks like MySQL might get stored procedure support soon in a big way:
[... 109 words]Site search finally available
I’ve finally got around to adding a search page to this site. It uses MySQL’s full text indexing, which is extremely fast and provides good results but comes at the expense of flexibility. Search terms less than 4 letters long are ignored, and multi-word searches are handled using OR rather than AND. This nearly put me off using it, but the relevancy algorithm is excellent which I think outweighs the disadvantage of not being able to use pure AND queries.
[... 138 words]Useful mySQL articles
Paul DuBois, the author of the huge great MySQL Book I have sat on my bookshelf, has a whole bunch of useful MySQL articles published on his site.
2002
MySQL on Linux or FreeBSD?
Jeremy Zawodny: FreeBSD or Linux for your MySQL Server? Jeremy explains the differences in threading implementation between Linux and FreeBSD, and explains why Linux is a better option for MySQL databases running under a high load. Link via Scott who got it from Keith. I wonder if anyone has played with the idea of syndicating link-found-on information in an RSS feed? Tracking link trails could be quite interesting.
DevShed stuff
DevShed have published two useful new articles—MySQL Connectivity With Python and Understanding SQL Joins. They also now provide nice looking printer-friendly PDF versions of articles, which appear to be dynamically generated. Having found this article on Google I suspect they are using HTMLDOC to create the PDFs.
MySQL text limits
Today’s scary discovery: MySQL TEXT fields have a limit of 65,000 bytes. If you insert anything larger than that in to a normal TEXT field mySQL will silently truncate your data without telling you (meaning software checks are probably a good idea). MEDIUMTEXT will store 16 million characters and LONGTEXT can handle over 4 trillion, but this information does not appear to be readily available in the online mySQL manual (although it is hinted at in this table). Something to bare in mind when designing database applications.
MySQL best practise
O’Reilly have a new article up entitled Ten MySQL Best Practises. Jeremy Zawodny has a few problems with the article, and Tony Bowden throws in some comments as well. There’s plenty of useful information distributed between the three viewpoints.