I need a MySQL expert to help me make adjustments to my database server and my [url removed, login to view] file in order to increase performance of my website. I'd want you to be able to make the best adjustments based on my site's needs.
Many times throughout the day, some pages on my site give out this error: "Out of memory (Needed 8387468 bytes)" and I need help fixing that. My server is a dedicated server and is dedicated to the database, has no other purpose. It's got 16 GB of RAM but it usually never utilizes more than 6 GB at a time, I'd like to utilize more of my server's RAM in order to make my site faster and more reliable.
I have a cometchat bar on my site which we can chat on; we can also chat via Skype. My cometchat bar has a feature where I can show people my screen and also give them access to control my computer; this is how I'll let you view and access my database server and PHPMyAdmin.