Why my site is so Slowwww ?

[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 ?

[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

[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]

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

[Chief]

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]

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

[Chief]

I can check MySql config by phpmyadmin ?

I have admin access there too ... what info you need ?

[garvinhicking]

Hi!

Version numbers and the use of indices in your serendipity tables, especially serendipity_entries and serendipity_entryproperties.

[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]

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

[Chief]

Sorry I feel stupid

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.

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

Can you make me a screen shot of what you need ?

[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

[Chief]

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]

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

[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