Full DB recover performance issue

[nicolasg]

Hi all,

According to the zabbix book I did a full data base backup using mysqldump

mysqldump -u$DB_USER -p$DB_PASSWORD --add-drop-table --add-locks --extended-insert --single-transaction --quick $DB_NAME| bzip2 > $DUMP_DIR/$DB_NAME-$TIME.db.bz2

The file size compressed was about 2GB and it took several hours to import all the data to a new Zabbix server.

Unfortunately the Zabbix front end seems to be very slow, I don't remember how many Zabbix processes were running before but at the moment I have :

ps -ef | grep zabbix_server | wc -l
26

Have anyone come across to a similar problem ? How is it possible to configure only the configuration with no historical data ?

[flashvoid]

look this blog