Personal tools
You are here: Home WiKi MySQL

MySQL

Document Actions
last edited 10 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 http://www.mysql.org

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 http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html. Of particular interest should be:

 innodb_additional_mem_pool_size 
 innodb_autoextend_increment 
 innodb_buffer_pool_size 
 innodb_data_file_path

Configure these options as appropriate to your hardware. There are also some tuning tips available at http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html that are applicable from versions 4.1-5.1. These include:

 query_cache_type
 query_cache_size


subtopics:


Powered by Plone CMS, the Open Source Content Management System

This site conforms to the following standards: