We have a Joomla website that is running sobi2 and we keep having connection issues with the database. Overall the site seems to be rather slow and everything seems to point to the need for some Database tuning. We also have issues with running out of memory on the server and hitting a slmmemory limit causing us to have to restart the container, but this too may be because of the db issues.
Need someone to analyze the system, identify the issues, propose corrective action and then implement agreed upon actions. (can db setting be tweaked, based on site use can create new indexes or joins... are there changes needed to apache, or Linux, etc...)
Attached is a phpMyAdmin pdf of the db runtime information... keep in mind that our site is not officially live at this time so traffic is very low compared to what it will be when we go live.
We have up to $100.00 allocated to this project.
As a Linux/Unix engineer with a lot of experience with securing and tuning MySQL for the enterprise I gladly optimize your DBMS depending on your flexibility: configuration changes, OS change, Infrastructure change, Data Modelling, Kernel Tuning etc, etc. I try to keep lowest price guarantee for you.
I am a Linux system administrator with experience in web hosting and running services in large financial enterprises. I would be able to help tune your server.