Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sat May 25, 2019 1:11 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Separating mysql database to different location
PostPosted: Fri Feb 01, 2019 10:26 am 
Offline

Joined: Sat Jan 26, 2019 3:23 pm
Posts: 4
I have a VM Linux server (CentOS Linux release 7.2.1511 (Core) running mysql (mysql Ver 14.14 Distrib 5.6.29) and cacti Version 0.8.8h.
Recently i realized, mysql takes a chunk of memory resources and there are frequent breaks in cacti graphs. I am considering moving the mysql database to a different location to see if memory utilization goes down and graphs are restored

cacti has 620 devices & 28798 graphs

Anyone with this experience ...please advise


Top
 Profile  
 
 Post subject: Re: Separating mysql database to different location
PostPosted: Sat Feb 02, 2019 3:56 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2474
When you are starting to get to heavy database usage on ANY database product, you should always consider giving it it's own dedicated resource.

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Separating mysql database to different location
PostPosted: Sat Feb 02, 2019 3:04 pm 
Offline

Joined: Sat Jan 26, 2019 3:23 pm
Posts: 4
ok thanks


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: Bing [Bot], Google Adsense [Bot] and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group