Database connection error (2): Could not connect to MySQL. - Joomla! Forum - community, help and support

hi,
i have error:
database connection error (2): not connect mysql.

we have large traffic , large number of visitors, took dediceted server @ hostgator. site worked well.

from reason transferred our old server "new server" , start having many errors.

they support fix issues 1 remain:
database connection error (2): not connect mysql.

we have 1 site on server:
joomla 2.5.7
cache_type: file
global cache: on - 45min
plugin system cache: on - doesnt use browser caching

they said problem occurs when large number of visitors enter site, cache mechanisam need put large number of cached files in database cousing db error.

we asked how possible twice visitors didnt make errors on old server, , twice less visitors makes db cracks on new server? no answer.

they suggest find developer make less db connections.

thanks!

hi,

shared hosting optimized lot of people share resources, result platform heavily optimized right balance of power, disk usage, cache, cpu, etc.

on own server, got out of box linux/windows os , amp stack (apache, mysql, php). there's lot of things need/should done optimize server.

i don't recommend developer change/alter php code, recommend server guy optimize platform. company can fee...

vps , dedicated hosting good, 1 of fall backs if don't know servers or have tech guy.

how paying month? use cheaper vps need even...

1)install opcode cache , use memory cache php (usually apc)
2)switch file based cache opcode cache (usually apc)
3)optimize apache number of concurrent connections , spawned processes+memory
4)optimize mysql , begin using more caching , memory

keep other joomla settings is, should fine. there's lot of online tutorials helping achieve above. i'm more familiar linux based systems , centos...if have windows...good luck! otherwise can lot more optimize server on forum.

it's better make use of more memory speed site in scenarios , read cache.

can please list server specs , run forum post assistant located on joomla forums? recommend linux based systems especialls centos small footprint , ease of use, via tutorials online , if require server help.

apc - http://sudoguides.com/server-software/c ... th-apache/

you can fine tune settings server well.

mysql - http://www.cyberciti.biz/tips/enable-th ... mance.html

play settings , adjust based on server. turn on slow query loggins , identify causing issues in joomla.

relieve burden on site investigating , using content delivery network (like cloudflare) have free , paid plans. reducing request load on server useful well.

this assuming on dedicated/vps mentioned.

more useful links
http://www.ibm.com/developerworks/libra ... index.html

check out using fastcgi handler running php scripts well, work on server first re-evaluate software running on joomla...it needs environment run on .

if have waaay many joomla extensions running @ once or on front page example, think trimming them down , disabling some. evaluate size of site , number of http requests. these problems increase server load!

provide url site can examine it. shooting in foot going overboard joomla.