Hi
If any one can help that would be great!
I saw this post however I cant get a solution.....
http://forums.mysql.com/read.php?132,218638,218638
I am running a JMeter test 1000 HTTP requests (1000 threaded loop going to the home page -> Category Page -> Product page)
Hitting my website www.perfectgift.ie (X-Cart ecommerce website)
The site grinds to a halt and I am getting a warning message returned from X-CART logs and it looks as if there is a socket connection limit is reached from X-Cart to the MySQL database:
Warning: mysql_select_db() [<a href='function.mysql-select-db'>function.mysql-select-db</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /var/www/html/include/func/func.db.php on line 47
Currently in config.php in x-cart the details to the database are setup as localhost.
# SQL database details
#
# This section sets up a connection between X-Cart shopping cart software
# and your MySQL database. If X-Cart is installed using Web installation, the
# variables of this section are configured via the Installation Wizard. If you
# install X-Cart manually, or if, after X-Cart has been installed, your MySQL
# server information changes, use this section to provide database access
# information manually.
#
$sql_host ='localhost';
However if i change this to 127.0.0.1 or the IP address of the machine the site fails altogether.
If someone could please help or point me in the right direction, i would be very greatful
Austin