Mysql query taking too long to execute

[kkrajdurai]

Hello,

it takes too much time to get the data from the mysql db, please help me to solve this problem, the db size is to large.

you can check the speed of the site from here.

zxtorrent.com

 

[virgin-heart]

speed is opening fine for me

 

[upbooth]

location

are you located in a different country from the server, sounds like your own personal connection is limiting you and has nothing to do with the server itself

 

[CERTCGOD]

Site is not working

 

[Lani]

Your domain is redirecting to visitors localhost address.

Is your website using PDO?
One thing I noticed with PDO was that, if I used MySql connect with "localhost" queries was slower.
When I changed MySql connection to 127.0.01, it worked fine.

Also make sure that your database engine is InnoDB.

 

[thehoster]

only cloudflare shown here

 

[scriptbolt]

or maybe you need better hosting

 

[Golovics]

Hello,

it takes too much time to get the data from the mysql db, please help me to solve this problem, the db size is to large.

you can check the speed of the site from here.

zxtorrent.com

Maybe you should put some SSDs to your server in RAID5, and move the database to the RAID array. Also you should have at least 16GB or 32GB ECC DDR3 ram. MySQL will love that.

 

[Djlatino]

or maybe you need better hosting

Hello,

it takes too much time to get the data from the mysql db, please help me to solve this problem, the db size is to large.

you can check the speed of the site from here.

zxtorrent.com

Maybe you should put some SSDs to your server in RAID5, and move the database to the RAID array. Also you should have at least 16GB or 32GB ECC DDR3 ram. MySQL will love that.

/thread. Your hosting is bad and you should feel bad.