database maintenance

Added by jerome l over 8 years ago

hello

i am running these environnement and would like to know what are the recommended maintenance task to keep redmine as fast as possibe?
I mean is there command, rake file to set up for a kind of automatic cleaning or compression, repair of the DB.
thanks

Environment:
Redmine version 2.3.1.stable
Ruby version 1.9.3 (i486-linux)
Rails version 3.2.13
Environment production
Database adapter Mysql2

Replies (4)

RE: database maintenance - Added by Jan Niggemann (redmine.org team member) over 8 years ago

jerome l wrote:

I mean is there command, rake file to set up for a kind of automatic cleaning or compression, repair of the DB.

AFAIK there isn't. Check the MySQL docs to see what they say about maintenance...
Tuning database performance is a task usually assigned to very experienced database administrators. Performance is impacted by a huge number of variables, i.e. hardware, DBMS, patchlevel, query optimization, and many more...

Do you have a specific reason to ask, is your instance slow?

RE: database maintenance - Added by jerome l over 8 years ago

hi Jan,

thanks for your answer, no my instance is as fast as the first day, this is just preventive maintenance, by experience with SQL Server I know database can grow very much and become slow and at the end stop working.

I will search in MySSQL doc, is there any recomandations regarding the redmine database ?

RE: database maintenance - Added by Jan Niggemann (redmine.org team member) over 8 years ago

jerome l wrote:

by experience with SQL Server I know database can grow very much and become slow and at the end stop working.

Literally stop working, you mean qou can't INSERT or UPDATE anymore (I expect SELECTing to sill be possible)?
That's hard stuff, I once had one of my systems run out of table space, but at least it didn't stop working :-)

I will search in MySSQL doc, is there any recomandations regarding the redmine database ?

Some argue that MySQL isn't a "real" DBMS and that postgres is waaay better, faster, bla bla bla... Others say that Percona or MariaDB are better than MySQL... I'm not sure if either of that is true, I have only run redmine on MySQL and all instances I support work quite fine that way. You can tune variables like query_cache_size or tmp_table_size, but that highly depends on the use case.

I can't recommend a specific doc though, if I were you I'd just Google "MySQL performance tuning" or something like that.

RE: database maintenance - Added by jerome l over 8 years ago

yes you are right, it was impossible to add new records in the database, I have used the wrong words :)

if your instance is in Mysql like me, and it's fast enough for you, that will be fast for me too, and I must add that since that post I discovered that my internet acces where is hosted my redmine, was in fact slowing my website ...

So i wil change our redmine's network at office for a fastest internet access.

I take your advice for my personal culture.

thanks again.

(1-4/4)