Why my site is so Slowwww ?

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Why my site is so Slowwww ?

Post by Chief »

Hi, what I have to check to find why my website is slow to refresh ?

my site take between 5 to 10 seconds to show a page ... I have try disable the left and right side with same result.

Here is my Event plugin
Browser Compatibility

Searches comments on quicksearch

RSS Aggregator

Fix common XHTML errors

Markup: NL2BR

Statistics

Start Page Category

Announce entries

Layout-Plugin: Printerfriendly version

Markup: Track exits

Sample! ( google analytics ) I have try disable

Extended properties for entries

Markup: BBCode

Static Pages

Contact Form

Contact Form

Spam Protector

Display RSS-Feed in Backend Overview

Customizable Entries Archive

What can I try ?
Last edited by Chief on Sat Dec 16, 2006 8:17 pm, edited 1 time in total.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Why my site is so Slowwww ?

Post by garvinhicking »

Hi!

Try to disable those event plugins:

Statistics
Display RSS-Feed in Backend Overview
Customizable Entries Archive

Then you page might also be slow due to sidebar plugins; which ones do you use?

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Post by Chief »

I have remove

Statistics
Display RSS-Feed in Backend Overview
Customizable Entries Archive

Same thing

this is my Sidebar plugin
Last comments entries

HTML Block ( I have try disable )

Quicksearch

Categories

Calendar

Archives

Syndicate This Blog

HTML Block ( I have try disable )
I have try to hide all sidebar plugin but samething


Thx Garvin!
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Wow. Your blog simply has a lot of entries! Depending on how well your mysql server is configured, it can simply be that the queries take too long.

At least you need to configure your categories sidebar plugin to not count the entries for each category. With such an amount of entries this takes up a LOT of performance.

Which mysql version are you using? Did you check that the tables have indices set?

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Post by Chief »

:D I am not a pro at server config and I dont know how to tune MySql, but I have access to the server config if you can give me some hints

here is the config of my server ... you have the info there ?

http://www.parlez-en.ca/phpinfo.php

For the number of entries I have to try something to clear the database.

Its possible to delete entries after 30days only if I have no extended or no comments in these entries ?

Like that the database can be cleared alone ..

Thx !
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

the phpinfo sadly does not help at all; MySQL version and configuration can only be investigated with tools like phpMyAdmin.
For the number of entries I have to try something to clear the database.

Its possible to delete entries after 30days only if I have no extended or no comments in these entries ?
A plugin for this could be created, yes. With some lines of PHP and some SQL lines the checks can be inserted.

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Post by Chief »

I can check MySql config by phpmyadmin ?

I have admin access there too ... what info you need ?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Version numbers and the use of indices in your serendipity tables, especially serendipity_entries and serendipity_entryproperties.
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Post by Chief »

Version

MySQL 4.0.18-nt


Table | Records | Type | Size

serendipity_entries | 16,318 | MyISAM | 14.2 MB

Space usage : Type Usage
Data 8,329 KB
Index 6,259 KB
Total 14,588 KB

Row Statistic : Statements Value
Format dynamic
Rows 16,318
Row length ø 522
Row size ø 915 Bytes
Next Autoindex 18,121
Creation Jul 29, 2006 at 10:45 PM
Last update Sep 09, 2006 at 06:16 PM
Last check Sep 09, 2006 at 05:48 PM






serendipity_entryproperties | 101,843 | MyISAM | 8.5 MB



Space usage : Type Usage
Data 5,591 KB
Index 3,150 KB
Total 8,741 KB


Row Statistic : Statements Value
Format dynamic
Rows 101,843
Row length ø 56
Row size ø 88 Bytes
Creation Jul 29, 2006 at 10:45 PM
Last update Sep 09, 2006 at 06:16 PM
Last check Sep 09, 2006 at 05:48 PM


Its that you need ?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

No, if you click on the specific tables you can see a lsting of all indices. The page where also the table structure is dsiplayed.

MYSQL 4.0.18 is really old. If possible you should upgrade to at least 4.1, which has an improved query cache.

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Post by Chief »

Sorry I feel stupid :roll:

I have update MySql to 4.1.21 and PHPMyAdmin to 2.8.2.4

But I am not familiar with the terminology, I can use but I dont know the exact name of use. :wink:

I learn by myself with try and error ... sorry if sometimes my question look stupid :? and MORE I am french :roll:

Can you make me a screen shot of what you need ?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Sure, here it is:

http://img147.imageshack.us/img147/7231 ... iesbr2.png

It'S the one in the lef tframe, bottom left. Labelled "indexes". There, for every serendipity table yuo should see some indexes set.

HTH,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Post by Chief »

garvinhicking wrote:
listing of all indices. The page where also the table structure is dsiplayed.
Ahhhh!! Properties lol

I was search for incices somewhere lol

http://www.parlez-en.ca/uploads/entries.jpg

and

http://www.parlez-en.ca/uploads/Entries_properties.jpg

I have a bug now since the update grrr lol

http://www.parlez-en.ca/uploads/MySql.jpg

You know why the unknown feild ?

I have try PHPMyAdmin new version but its full of error message there...
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Hm, okay. The indexes are okay! Then I think the only thing making your site slow was an old mysql and the large number of entries and the sidebar categories counting plugin.

The error messages are strange, if you mean that "unknown" stuff! Never seen that?!

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Chief
Regular
Posts: 69
Joined: Sun Jul 23, 2006 3:08 am

Post by Chief »

Nope never see that Unknown thing ..

for the Delete Entry after 30 days if I "have no comments or no extended" can you give me a hint ?

I can turn around myself ...

Thx Garvin
Post Reply