MySQL Improve The Performance Of Your MySQL Server
Improve The Performance Of Your MySQL Server MySQL / General Guides
MySQL is a rock solid, lighting fast database server which has been designed for two factors speed and performance. It is the Ferrari of databases: Light weight, fast and Built for the high speed tracks! Learn how to get the best performance from you MySQL database server.
Connecting to and Disconnecting from the Server MySQL / General Guides
To connect to the server, you will usually need to provide a MySQL user name when you invoke mysql and, most likely, a password. If the server runs on a machine other than the one where you log in, you will also need to specify a host name.
Getting Started with MySQL Proxy MySQL / General Guides
MySQL Proxy is a lightweight binary application standing between one or more MySQL clients and a server. The clients connect to the Proxy with the usual credentials, instead of connecting to the server. The Proxy acts as man-in-the-middle between client and server.
How To Set Up Database Replication In MySQL MySQL / Replication and Backup
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.
MySQL DELAY_KEY_WRITE Option MySQL / General Guides
Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed.
MySQL System Architecture MySQL / General Guides
In this article, we're going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together.
Running Multiple MySQL Versions MySQL / General Guides
Sometimes we may require to run multiple versions of MySQL on the same Server. This can happen if you either need to test a new MySQL release or you need a new MySQL version and you don't want to make any changes to the existing system.
What is MySQL MySQL / General Guides
MySQL is a open source Relational Database Management System. MySQL is very fast reliable and flexible Database Management System. It provides a very high performance and it is multi threaded and multi user Relational Database management system.
MySQL System Architecture MySQL / General Guides
We are going to take a look at MySQL internals. It will be a fun, informative examination of how all the different pieces and parts of the MySQL server operate together. MySQL's implementation is a fascinating mix of technology that is truly a remarkable achievement - an achievement born from the sweat and inspiration of numerous developers overmany years.
MySQL Configuration MySQL / General Guides
In this lesson you will read about the configuration of MySQL. The MySQL server configuration normally started during installation process.
MySQL Command Line Help MySQL / General Guides
We tend to use MySQL from the interactive command line shell quite a bit (SSH to your db server and type the command mysql to start). We noticed today that there is a pretty extensive built in help system in this command.
MySQL Optimization Hints MySQL / Optimization
Every programmer loves to optimize, even when we know we shouldn't. To satisfy your cravings MySQL has several keywords that can be placed in your SQL statement to give the database server an explicit optimization instruction.
Optimizing MySQL Queries and Indexes MySQL / Optimization
Learn how to optimize queries and indexes, and potentially speed up your application many times over.The database is just too slow. Queries are queuing up, backlogs growing, users being refused connection. Management is ready to spend millions on "upgrading" to some other system, when the problem is really that MySQL is simply not being used properly. Badly defined or non-existent indexes are one of the primary reasons for poor performance, and fixing these can often lead to phenomenal improvements.
Backing Up And Restoring Your MySQL Database MySQL / Replication and Backup
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
Introduction to MySQL MySQL / General Guides
MySQL is the most popular open source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.