Personal tools
You are here: Home WiKi MySQL


Document Actions
last edited 11 years ago by mhyclak

MySQL is a simple Relational DataBase? Management System which can be used as PyKota's database backend.

It is Free Software available from

To use MySQL with PyKota, you must be using version 4.1 or greater. The reason for this is that subqueries were not supported until version 4.1. The MySQL database backend uses the InnoDB storage engine since it supports foreign keys and transactions. You may wish to tune the parameters for the InnoDB engine, especially if you have a large number of users and/or printers. This information is available in the MySQL reference manual available at Of particular interest should be:


Configure these options as appropriate to your hardware. There are also some tuning tips available at that are applicable from versions 4.1-5.1. These include:



Powered by Plone CMS, the Open Source Content Management System

This site conforms to the following standards: