How To Set Up Database Replication In MySQ. This is a "copy & paste" HowTo!
The easiest way to follow this tutorial is to use a command line client/SSH client (like PuTTY for Windows) and simply copy and paste the commands (except where you have to provide own information like IP addresses, hostnames, passwords,...). This helps to avoid typos. How To Set Up Database Replication In MySQL. MySQL Query Analyzer - Improving SQL Query Performance. MySQL Gotchas. It's not a bug - it's a gotcha.
A "gotcha" is a feature or function which works as advertised - but not as expected. When working with the MySQL ™ database server I have repeatedly encountered situations where the results of various actions have been unexpected and/or contrary to the behaviour generally expected of an SQL relational database. The cause can usually be traced to implementation details which are documented in the manual. I have created this list in order to further a better understanding of the MySQL database server and hopefully save others unnecessary headscratching. The MySQL database server is being continually improved.
Make MySQL faster in one hour. There may be a simple way to improve InnoDB performance on SMP servers.
The benefit is not as great as that obtained by using the smpfix from Google or Percona, but the change is much simpler. It is also portable so it makes MySQL faster on non-x86 platforms. I want to hear from people who test this with real workloads on servers with 8+ cores or who do any type of testing on platforms other than Linux/x86. 15.3.4 Using MySQL and me.
MySQL Cookbook. To Insert or To Update. We talked about duplicating with MySQL earlier, and another MySQL tip worth pointing out is on inserting or updating in one query.
The idea is that there will be times when you would like to update a record if it exists, or insert if it does not exist. This becomes especially true in the world of web 2.0 and API’s where the return value may come over a delay. PHP MySQL Tutorial. MySQL Quick Admin - Free MySQL Web GUI. PHP & MySQL : Generating an RSS feed - Presentations & A. PHP & MySQL : Generating an RSS feed Published March 29, 2004, 3:32 pm by Neerav Bhatt This article was presented at the March 2004 Sydney PHP Group Meeting.
Storing Hierarchical Data in a Database [PHP & MySQL Tutoria. This article was written in 2003 and remains one of our most popular posts.
If you’re keen to learn more about mastering database management, you may find this recent article on MySQL of great interest. Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own cms: there will be a moment that you’ll want to store hierarchical data in a database. And, unless you’re using a XML-like database, tables aren’t hierarchical; they’re just a flat list. You’ll have to find a way to translate the hierarchy in a flat file. Common Queries. Common MySQL Queries Basic aggregation Last updated 05 Jan 2013 Aggregate across columns Last updated 09 Sep 2009.
Optimizing your MySQL Application [PHP & MySQL Tutorials] I’ve attempted to keep my queries as simple as possible, but I assume that you have a basic understanding of databases and the SQL language (more specifically, MySQL’s implementation of it).
I also assume you have MySQL 3.23, as a few of these queries may not work on 3.22. If you don’t have MySQL 3.23 yet, I highly recommend you install it if possible, as some of the performance increases are significant. What are Indexes? Indexes are organized versions of specific columns in your tables. MySQL uses indexes to facilitate quick retrieval of records. Dan Winchester - MySQL date_format. MySQL 5.0 Reference Manual.