mike | Shared With: Everyone - May 15 2009 | mysql, database, utilities
mike | Shared With: Everyone - May 15 2009 | mysql, windows, tools
mike | Shared With: Everyone - May 15 2009 | open source, database, mysql
mike | Shared With: Everyone - Sep 23 2008 | sql, reference, select, mysql
mike | Shared With: Everyone - Apr 08 2008 | php, mysql, programming, books
I like the "nutshell" books. This one teaches PHP.
Quoted: Amazon.com: PHP in a Nutshell (In a Nutshell (O'Reilly)): Paul Hudson: Books
Read online on Safari here (free w/ Seattle Library Card): http://safari.oreilly.com/0596100671

mike | Shared With: Everyone - Apr 08 2008 | programming, database, php, mysql, books
This looks like a good integrated introduction to both PHP and MySQL. It was published in 2004 - but does include PHP 5.
Quoted: Amazon.com: Web Database Applications with PHP & MySQL, 2nd Edition: Hugh E. Williams,David Lane: Books
Read online on Safari here (fee w/ Seattle Library Card):
http://safari.oreilly.com/0596005431
mike | Shared With: Everyone - Apr 06 2008 | drupal, install, apache, php, mysql
mike | Shared With: Everyone - Aug 25 2007 | hosting, php, mysql
mike | Shared With: Everyone - Aug 25 2007 | hosting, php, mysql
mike | Shared With: Everyone - Apr 25 2007 | google, mysql, data centerGoogle is releasing GPL'ed patches to MySQL for better data center management:
Quoted: The high availability features include support for semi-synchronous replication, mirroring the binlog from a master to a slave, quickly promoting a slave to a master during failover, and keeping InnoDB and replication state on a slave consistent during crash recovery.
...
The manageability features include new SQL statements for monitoring resource usage by table and account. This includes the ability to count the number of rows fetched or changed per account or per table. It also includes the number of seconds of database time an account uses to execute SQL commands.
Related Content from Around Faves
mysql
-
There are some helpful tips in here, whether or not you use replication. In my experience, the most important thing with database performance is to minimize the time and row range over which you hold write locks -- and that's what this post is essentially about.
1 FaverViewed: 6 TimesQuoted: Piping data through application is the best solution in many cases and is quite easy - it is trivial to write the function which will take SELECT query and the table to which store its result set and use in your application in all cases when you need this functionality.
- mike - May 15 20092 FaversViewed: 2 Times
- guido - Feb 22 20094 FaversViewed: 8 Times


