You should be able to raise tmp_table_size and max_heap_table_size to 64M and be okay. To use a little less memory, you can also set max_connections to 128.
This might be the hoster's uplink to the internet. Ask them to look at their eth0/1 in /var/log/messages for issues, perhaps a switchport is bad or flapping. Also have them check ethtool on those interfaces to confirm full duplex.
Lower max_connections to 128
Lower key_buffer to 50M
Insert query_cache_type=1
Insert max_seeks_for_key=10
Lower open_files_limit to 2048
Raise table_cache to 2048
It seems you have about 20.6G of InnoDB tables, which outweights the resources available on your server. I would suggest...
We'll need to know a few things:
cat /etc/my.cnf /etc/mysql/my.cnf
grep -c processor /proc/cpuinfo
free -mt
du -shc /var/lib/mysql/*/*.* | tail -n1
mysqladmin proc stat
Does yum take too long to find the fastest mirror? Save yourself some time by disabling it:
Set enabled=0 in /etc/yum/pluginconf.d/fastestmirror.conf
Run yum clean all
Run yum update
You're done!
You can very easily write a lyrics engine with a MySQL site, with low load. You could also use flatfile storage, just store the lyrics in a .txt file on the server.
Fully Managed cPanel Servers starting at $159/month
Visit us at http://www.pacifichost.com/
Servers are located in Databank in Houston, TX
Has your site outgrown all other forms of hosting? Our Dedicated Servers are well suited for power hungry websites. These servers are ready for...
WHAT: We are looking for new people to add to our team who have previous experience in the hosting industry with a verifiable employment and reference history. This is primarily a customer service position where you will be handling phone calls relating to billing/sales/support issues...
You might be using a Chained SSL Certificate, so when you install the Certificate in WHM, place Thawte's Root CA that your certificate was signed with in the "CA Certificate" field.
It also looks like you're using NGINX, so here's a config if you're using plain NGINX.
(Might not be 100%...
Unless your servers are already registered as nameservers, you will need to go to your Domain provider, and "Register" your nameservers for your domain. They must also be present as A records in your zonefile on your server. So, say for example, your domain was example.com:
ns1 300 IN A...
Greetings and Salutations,
My name is Zach. Thought I would come here and check out the forums. Looking forward to getting to know more of you, and maybe offer some awesome services to you guys in the Marketplace soon!
Have a great day!
Zach Taylor
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.