21.2. Database

From open-support.info

< Book:OTRS 3.0 - Admin Manual | Chapter 21
Revision as of 08:09, 24 April 2011 by Dick6809 (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

DB issues vary by the database being used. Study the documentation for your database or check with your database administrator.

Contents

MySQL

If you use the MySQL table type MyISAM (which is the default), and have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, BLOB or TEXT columns), you need to defragment the datafile (tables) with the "optimize" command.

You should try this if the mysqld daemon needs a lot of your CPU time. Optimize the tables - ticket, ticket_history and article (see Script 21.2 below).

shell$ mysql -u user -p database
mysql$ optimize table ticket;
mysql$ optimize table ticket_history;
mysql$ optimize table article;
Script 21.2. Optimizing data base tables.


PostgreSQL

PostgreSQL is best tuned by modifying the postgresql.conf file in your PostgreSQL data directory. For advice on how to do this, see these articles:

http://www.revsys.com/writings/postgresql-performance.html

http://varlena.com/GeneralBits/Tidbits/perf.html

http://varlena.com/GeneralBits/Tidbits/annotated_conf_e.html


If performance is still not satisfactory, we suggest that you join the PostgreSQL Performance mailing list ( http://www.postgresql.org/community/lists/ ), and ask questions there. The folks on the PostgreSQL list are very friendly and can probably help.

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox