http://loadaveragezero.com/app/drx/Software/Databases/MySQL MySQL is an open source, relational database management system (RDBMS). It is designed for simplicity and speed, with many features of big commercial database systems as well. It is very popular with Web developers for delivering dynamic content. MySQL MySQL Computers/Software/Databases/MySQL © 2004-2008, Douglas W. Clifton, loadaveragezero.com, all rights reserved. http://creativecommons.org/licenses/by-nc-sa/2.0/ http://blogs.law.harvard.edu/tech/rss en-US doug@loadaveagezero.com (Douglas W. Clifton) 2008-12-03T18:00:50Z 240 http://loadaveragezero.com/drx/search Search the Database q http://loadaveragezero.com/img/fav/drx/logo/drxRSS.gif http://loadaveragezero.com/app/drx/Software/Databases/MySQL 88 31 A fully indexed, searchable Resource Directory for Web developers, designers and programmers. http://loadaveragezero.com/app/drx/Software/Databases/MySQL#mysql:manual The Reference Manual for the MySQL Database System. It documents MySQL up to the latest version, but is also applicable for older versions of the MySQL software. 2005-04-26T07:27:51Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#mysql:manual http://loadaveragezero.com/hnav/contact.php#form database mysql reference Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#forge:mysql MySQL Forge is a repository of tools, projects, roadmaps, and wiki content that is created and maintained by the MySQL user and developer community. It is intended to be a resource for learning, contributing, and sharing information, techniques, and code. 2008-12-03T18:00:50Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#forge:mysql http://loadaveragezero.com/hnav/contact.php#form code community developer mysql repository resources tools wiki Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#onlamp:devcenter An O'Reilly ONLamp Development Center dedicated to this popular open-source RDBMS. Features articles on such topics as installation and configuration, optimization and performance tuning, backups, table engines, replication, SQL, and scripting interfaces. 2008-10-26T04:35:59Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#onlamp:devcenter http://loadaveragezero.com/hnav/contact.php#form config database developer install mysql onlamp open-source oreilly performance sql Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#zawodny:stuff A collection of projects from the author that are related to MySQL, a fast and reliable Open Source Relational Database Server. 2006-10-20T04:08:31Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#zawodny:stuff http://loadaveragezero.com/hnav/contact.php#form database mysql open-source Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#oreillydb:cluster Serious business services really can't go down, whether due to hardware or software failures. If your necessary services rely on MySQL, clustering and high availability can prevent failures. This article covers configuring MySQL Cluster and Heartbeat. 2006-02-18T07:52:58Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#oreillydb:cluster http://loadaveragezero.com/hnav/contact.php#form config database mysql sysadmin Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#securityfocus:securing-mysql Unfortunately, the default installation of MySQL, and in particular the empty root password and the potential vulnerability to buffer overflow attacks, makes the database an easy target for attacks. Learn how to close these gaps in this detailed article. 2005-08-31T05:41:21Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#securityfocus:securing-mysql http://loadaveragezero.com/hnav/contact.php#form config mysql security sysadmin Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#schemeball:visualizer Schemaball is a Perl script which uses GD to generate formatted MySQL database schema views. Schemaball is well-suited for use in publications, online or print, presentations or schema development, and is suitable for visualizing schemas of all sizes. 2005-08-19T21:43:35Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#schemeball:visualizer http://loadaveragezero.com/hnav/contact.php#form database graphics mysql perl schema Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#google:mMaim MySQL Monitoring And Investigation Module: monitors and analyzes MySQL servers and easily integrates into any environment. It can show Master/Slave sync and efficiency stats, returns statistics from most of the "show" commands and more. From Google Code. 2005-08-19T05:25:18Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#google:mMaim http://loadaveragezero.com/hnav/contact.php#form database google mysql open-source performance python servers sysadmin Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#mysql:tips Content trumps everything else in this index, and this resource is basically just plain text (all 135k of it!). But oh what a resource, it's packed full of outstanding MySQL tips, and the advanced SQL query techniques towards the end are mind boggling. 2005-07-31T03:07:47Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#mysql:tips http://loadaveragezero.com/hnav/contact.php#form howto mysql sql sysadmin tutorial Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#earthweb:table-types In addition to the default MyISAM table type, MySQL supports several others, some of which have more advanced features like transactions and rollbacks. In this article, Dr. Horn discusses the advantages of the MERGE, HEAP (memory), InnoDB and BDB types. 2005-07-22T19:23:49Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#earthweb:table-types http://loadaveragezero.com/hnav/contact.php#form database mysql reference Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#peachpit:design Careful design of your database schema pays BIG dividends later. In this detailed 10-part article, the author covers keys and relationships, 1st, 2nd and 3rd Normal Form, MySQL data types, null and default values, and indexing to improve performance. 2005-06-27T05:47:04Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#peachpit:design http://loadaveragezero.com/hnav/contact.php#form database design mysql normalization performance schema Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#uklinux:protocol A detailed document describing the low-level implementation of the MySQL protocol (version 10). Included is a descripion of the two most common client-server connection methods: via localhost, or a Unix socket, and over a TCP/IP network (port 3306). 2005-06-26T04:09:53Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#uklinux:protocol http://loadaveragezero.com/hnav/contact.php#form client-server mysql protocol tcp Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#sitepoint:hierarchical If the category system for drx was large, I would need to redesign my recursive implementation of the treeview (and OPML). In this article, Gijs discusses this simple approach, and then moves on to the more robust tree traversal methods. 2005-06-22T18:27:57Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#sitepoint:hierarchical http://loadaveragezero.com/hnav/contact.php#form database developer mysql schema sql Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#keller:tagging This is Phillip's entire MySQL category, as all the articles are related and follow each other as he explores database schemas and query implementations for developing tagging systems in MySQL. Lots of developer feedback, highly recommended. 2005-06-22T18:22:38Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#keller:tagging http://loadaveragezero.com/hnav/contact.php#form del.icio.us mysql query schema sql tagging Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#sklar:myphp Embeds a PHP interpreter into your MySQL server. Afterwards, a single User-Defined Function (UDF), php() becomes a gateway to the entire PHP library of functions you can call against the data columns in your SQL queries. Hmmm...myPerl? Of course! 2005-06-19T22:06:06Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#sklar:myphp http://loadaveragezero.com/hnav/contact.php#form mysql php programming Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#mysql:normalization The goal of normalization is to reduce data redundancy and improve performance, if at the cost of more complex queries. Although not strictly related to MySQL, this excellent article is worth your time and will improve your DB schema design skills. 2005-06-19T17:55:20Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#mysql:normalization http://loadaveragezero.com/hnav/contact.php#form database mysql normalization performance schema sql Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#atmail:optimize Sometimes you find high quality resources in unlikely places. If this comprehensive guide to optimizing your MySQL installation, table and query design, and database maintenance, is any indication, then the folks at @Mail have a top-notch product. 2005-06-11T19:23:48Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#atmail:optimize http://loadaveragezero.com/hnav/contact.php#form database howto mysql performance sysadmin Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#addedbytes:cheatsheet Dave has done it again, this time for MySQL: a handy printable quick reference that includes built-in functions for use in your queries, a list of the MySQL data types, PHP functions for accessing your databases, and some sample MySQL queries. 2005-05-25T19:47:03Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#addedbytes:cheatsheet http://loadaveragezero.com/hnav/contact.php#form cheatsheet database mysql php query reference sql Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#newsforge:performance Detailed comparison of MySQL performance under a number of different operating systems, including Linux, FreeBSD, NetBSD, OpenBSD and Solaris using the Super Smack and SysBench benchmarking utilities. 2005-04-29T06:28:47Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#newsforge:performance http://loadaveragezero.com/hnav/contact.php#form benchmark bsd database freebsd linux mysql performance Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#devshed:mysql MySQL help, tutorials, articles, code samples, and other resources. Features in-house authors, freelance writers, and several exclusive publishing relationships. 2005-04-26T08:29:27Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#devshed:mysql http://loadaveragezero.com/hnav/contact.php#form mysql Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#faqts:mysql MySQL frequently asked questions and tips. 2005-04-05T01:20:32Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#faqts:mysql http://loadaveragezero.com/hnav/contact.php#form faq mysql Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#php:mysql Complete documentation on the PHP functions for accessing MySQL servers and the databases they contain. 2005-04-05T00:12:32Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#php:mysql http://loadaveragezero.com/hnav/contact.php#form database mysql php reference servers Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#sitepoint:build A hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database-driven Website using PHP & MySQL. 2005-04-05T00:09:52Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#sitepoint:build http://loadaveragezero.com/hnav/contact.php#form database developer mysql php Computers/Software/Databases/MySQL http://loadaveragezero.com/app/drx/Software/Databases/MySQL#myadmin:project phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. 2005-04-04T23:23:56Z http://loadaveragezero.com/app/drx/Software/Databases/MySQL#myadmin:project http://loadaveragezero.com/hnav/contact.php#form mysql php sysadmin Computers/Software/Databases/MySQL