Huge cacti db /limits/performance ?

[dma667]

i am replacing in a big company for various reasons a snmp monitoring tool
with more than 500 devices and between 2000 and 3000 interfaces
i wil be monitoring mostly cisco devices

i have a quad p3 700 with 2 Gb of memory on taolinux (rhel clone )
raid 5 of 4* 18 gb at 10k scsi3
mysql 3.23
cacti 8.6c

i expect 1-3 simultaneous users
will it scale ?
what response time must i expect ?
should i upgrade to mysql 4 and/or more memory ?

i can afford to fail
thanks a lot

[rony]

You should be ok,

But some considerations:

Configure mysql to use some of the memory. Check out www.mysql.org and the documentation on Performance Tuning. You will need to worry about sorting buffers and row caches.

Make sure that your cacti installation and your database data files are NOT on the same disk. This way you will avoid the database and the cacti RRD update process from competing for disk I/0. But this really isn't a worry unless you run into performance issues on polling cycles.

Make sure that you are using Cactid! It will be much faster.

Good luck!

[bulek]

I would propose you to upgrade to MySQL 4. It has a feature called query cache which can considerably speedup read queries from MySQL.

- Piotr