NetFlow Central Server mysql tuning
Hello ManageEngine Community,
I have just installed the following NetFlow systems:
| Current Version | : 7.7.0 |
CentOS 6.2 x86_64 Central Server 24GB
CentOS 5.5 x86_64 Collector
CentOS 5.5 i386 Collector
Sometimes mysqld gets disconnected with errors like the following:
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
120107 14:11:03 [ERROR] Default storage engine (InnoDB) is not available
120107 14:11:03 [ERROR] Aborting
I believe I should tune mysqld settings and I am interested to know the right tuning values for InnoDB on Central Server. I have found the following forum thread:
Though it is 6 years old, I would like to know if there are updates or it is still valid.
Thanks for helping.
Best regards,
Fabio