1

I'm facing a lot of problems with my shared hosting company regarding the performance of my website.

My website is not complicated at all, just text pages, and also some pages using the Views module, I'm not using Panels, and I aggregate my css and js, and also I have 7 image styles (thumbnail,large etc...).

But even so my hosting company told me that I exceeded the memory limit and I have to optimize the website.

I have also another site in a different hosting company .... another problem appears in the database and this is the error message:

PDOException: SQLSTATE[00000] [1129] Host '...' is blocked because of many connection errors;

I don't know if the problem is because of Drupal or something else.

4

What's your hosts memory limit?

For MySQL Run this MySQL command

SHOW VARIABLES LIKE 'innodb_buffer_pool_size'

If it's at the default I would see if you can increase it to at least the same size as your database. If you can not, I would look at converting some of your tables to MyISAM. http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/

  • Memory limit exactly 786432 KB and this is the result of sql query 8388608 – user7683 May 30 '12 at 10:33
  • 96MB should be enough ram for most things... I would swap in drupal.org/project/imagemagick I would see if you can increase that value in MySQL. If you can not up this value, change all tables except for semaphore, node_access, sessions, queue, batch, and history to MyISAM. – mikeytown2 May 30 '12 at 22:05
  • it does not make a problem to the site – user7683 Jun 3 '12 at 20:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy