PlanetMysql.ru — информация о СУБД MySQL

I was asked this question recently “I am wanting to create a simple MySQL database consisting of 5 tables”?

While it’s easy to tell people to RTFM, the question does warrant an answer for the MySQL beginner to provide a more specific guidance as to where to start, and what to do. As a expert in MySQL it’s easy to forget how you would describe what to do. Here are my tips to getting started.

Step 1. Download the MySQL 5.1 software for your platform (e.g. Linux, Windows, Mac etc) from MySQL 5.1 Downloads. There are many different versions of MySQL, MySQL 5.1 is the current production version.

Step 2. You will need to install the MySQL software. The MySQL reference manual is the place to go, Chapter 2 describes installing MySQL. You can also download a copy of the manual in various different formats at MySQL Documentation. This is also valuable for the time when the documentation may be be unavailable online.

Step 3. Download a GUI tool to help you in the design of your first MySQL Tables. There are a number of products available to do this, the MySQL Query Browser and WebYog are just two examples. If your bold, you can use the mysql client command line tool and use the CREATE TABLE command to create your table structures.

MySQL by itself is ineffective for producing a client facing end result unless you have an application purpose and therefore a general application to access the data in MySQL. Using a LAMP/WAMP stack is a good place to start. XAMPP is a good cross platform program that gives you MySQL and a PHP technology stack. You also get PhpMyAdmin included with XAMPP which is a good web based design tool. I don’t mention earlier because it needs a running php/apache/mysql environment. If you elect to start with this stack, then you don’t need to install any GUI tools.

Finally, there a wealth of knowledge, not at least the MySQL Forums and the #mysql channel on irc.freenode.net which can be good places to get free beginner information.

PlanetMySQL Voting: Vote UP / Vote DOWN

There are seven new INFORMATION_SCHEMA tables (plugins) available with the InnoDB plugin.  They need to be loaded to be used. New InnoDB Plugins contain information on: Compressed InnoDB tables Compressed InnoDB buffer pool Current InnoDB transactions Transaction Locks Blocking transactions These INFORMATION_SCHEMA plugins are available by setting the plugin-load parmeter: plugin-load=
PlanetMySQL Voting: Vote UP / Vote DOWN

The InnoDB Plugin (1.0.4) is  pretty easy to configure in the MySQL 5.1.38 release.  You can use the default version of InnoDB or the new Plugin but not both.  If using a non-default configuration make sure and set the plugin_dir variable to point to the ha_innodb_plugin library for your system.  Before setting the new innodb plugin perform the following to make sure it starts up with a fresh
PlanetMySQL Voting: Vote UP / Vote DOWN

The MySQL 5.1.38 release is available today with the InnoDB Plugin included in the software distribution.  The InnoDB Plugin offers a number of key management features that will be very helpful to MySQL environments.    I recommend you look into the new features available with the InnoDB Plugin. This storage engine can replace the default InnoDB storage engine by making a few configuration
PlanetMySQL Voting: Vote UP / Vote DOWN