Transaction and Atomic Operation Differences MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB transactional storage engine. In MySQL 5.5 and up,...
Upgrading MySQL As a general rule, to upgrade from one release series to another, go to the next series rather than skipping a series. To upgrade from a release series previous to MySQL 5.5, upgrade to each successive release series in turn unti...
Internal Details InnoDB has two different file formats (Antelope and Barracuda) and four different row formats (Redundant, Compact, Dynamic, and Compressed). The Antelope file format contains Redundant and Compact row formats. A tablespace that u...
Internal Details Every InnoDB per-table tablespace (represented by a *.ibd file) file is labeled with a file format identifier. The system tablespace (represented by the ibdata files) is tagged with the “highest” file format in use in a group of ...
Using Client Programs in a Multiple Server Environment To connect with a client program to a MySQL server that is listening to different network interfaces from those compiled into your clien...
Using Foreign Keys In MySQL, InnoDB tables support checking of foreign key constraints. See Section 14.2, “The InnoDB Storage Engine”, and Section 1.8.5.4, “Foreign Key Differences”. A foreign key constraint is not required merely to join two tab...
Using More Than one Table The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs to contain the followin...
Using mysql in Batch Mode In the previous sections, you used mysql interactively to enter queries and view the results. You can also run mysql in batch mode. To do this, put the commands you want to run in a file, then tell mysql to read its input from the file: shell mysql mysql -e "sourc...
Using MySQL with Apache There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table. You can change the Apache logging format to be easily readable by MySQL by putting the following into the Apache configuration file: Lo...
Using Option Files Most MySQL programs can read startup options from option files (also sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command ...
