Recent content by PacificHost

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.

For context: http://blog.cloudflare.com/todays-outage-post-mortem-82515

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

You may have to ask your host to temporarily increase your Guaranteed RAM allocation to 1024M, then try to run a yum update.

By the way, is this a VPS? If so, how much RAM?

How many repos do you have added? yum repolist

Let that run for a while, and let us know if it says anything else, paste the full output to pastebin.com

Try: yum -v update

yum clean all yum update yum install wget

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...