Announcement

  •  » Your Piwigo
  •  » how to configure Piwigo CMS not to send querries

#1 2014-02-16 08:32:55

junwang
Member
2014-02-16
8

how to configure Piwigo CMS not to send querries

Hello,

I have my piwigo gallery site, and recently, the website is blocked due to overload querries.

Piwigo version: v2.5.1 
PHP version: php3
MySQL version: unknown
Piwigo URL: http://ku.8964.com/tongxue/

The web hosting companies asked me to do:
To resolve the problem you can configure your Piwigo CMS website not to send these queries and optimize database to reduce it's size.

I have no idea how to do that, and I need your kind assistance, thank you

Jun Wang

Offline

 

#2 2014-02-16 08:40:22

ddtddt
Piwigo Team
Quetigny - France
2007-07-27
7207

Re: how to configure Piwigo CMS not to send querries

Hi :-)

junwang wrote:

PHP version: php3

What version piwigo use you ?

Have you accès on admin panel piwigo ?

Have you acces database ?


You love Piwigo so don't hesitate to participate, learn more on the "Contribute to Piwigo" page. If you don't have much time for contribution, you can also help the project with a donation.

Offline

 

#3 2014-02-16 13:20:54

junwang
Member
2014-02-16
8

Re: how to configure Piwigo CMS not to send querries

Thank you very much for your help.

What version piwigo use you ?
> version 2.5.1

Have you accès on admin panel piwigo ?
> the site is blocked by the hosting company due to overload of querries to the database.

Have you acces database ?
> yes, I can still get access to the database, but I am not good at database and do not know how to do with it.

THank you

Jun Wang

Offline

 

#4 2014-02-16 13:23:47

junwang
Member
2014-02-16
8

Re: how to configure Piwigo CMS not to send querries

by the way, I just checked out that the database version is: MySQL 5.1.68-community-log - MySQL Community Server (GPL)

Offline

 

#5 2014-02-16 13:52:02

flop25
Piwigo Team
2006-07-06
7037

Re: how to configure Piwigo CMS not to send querries

Ask them to provide your the slow querry log: if they don't provide it, that's a lack of professionalism


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#6 2014-02-17 13:45:19

junwang
Member
2014-02-16
8

Re: how to configure Piwigo CMS not to send querries

This is what I got just now (is it enough with this?):

I would like to let you that you may find copy of your database in FTP root: C292742_image.sql.gz
Also our administrators provided following slow query:
Time: 87% (6523 sec)
Amount: 91% (635 queries)
Rows Examined/Sent: 237857101 / 6313
Used databases: [C292742_image]
Query example: use C292742_image; SELECT com.id AS comment_id, com.image_id, com.author, com.author_id, u.mail_address AS user_email, com.email, com.date, com.website_url, com.content, com.validated FROM piwigo_image_category AS ic INNER JOIN piwigo_comments AS com ON ic.image_id = com.image_id LEFT JOIN piwigo_users As u ON u.id = com.author_id WHERE 1=1 AND validated='true' AND (category_id NOT IN (82,81,78,77,76,75,21,74,72,19,71,70,18,66,65,32,16,69,68,67,29,13,40,39,38,37,44,42,41,28,9,48,47,8,62,61,51,50,49,6,64,63,54,52,57,56,60,59)) GROUP BY comment_id, com.image_id, com.author, com.author_id, com.date, com.content, com.validated ORDER BY ... [too long]

Offline

 

#7 2014-02-17 15:55:44

flop25
Piwigo Team
2006-07-06
7037

Re: how to configure Piwigo CMS not to send querries

Could you use pastebin to share the whole queries please? Thanks


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#8 2014-02-18 02:37:53

junwang
Member
2014-02-16
8

Re: how to configure Piwigo CMS not to send querries

thanks flop25,

can you tell me where the bin is? I browsed the the whole directory, and I can not find that.

Jun Wang

Offline

 
  •  » Your Piwigo
  •  » how to configure Piwigo CMS not to send querries

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact