The Front page cann't load

[sexstoriescity]

I've insert about 50000 lines into my s9y,then the front page cann't load,display the error:Fatal error: Maximum execution time of 30 seconds exceeded in...

This is the statistic of database:

serendipity_authors 5,479 304.6 KB
serendipity_category 27 3.3 KB
serendipity_comments 0 1.0 KB
serendipity_config 29 2.9 KB
serendipity_entries 48,486 1.5 GB
serendipity_entrycat 48,486 1.0 MB
serendipity_entryproperties 0 1.0 KB
serendipity_exits 0 1.0 KB
serendipity_images 0 1.0 KB
serendipity_plugins 12 3.9 KB
serendipity_references 0 1.0 KB
serendipity_referrers 0 1.0 KB
serendipity_suppress 1 2.1 KB

help......

[garvinhicking]

Wow. 1.5GB data in your table, that sure chokes your MySQL. If you want to make that data workable, you need to do some serous MySQL optimizing and have a Server with enough cache/RAM.

You might want to run those optimizations for your SQL tables; replace {PREFIX} with your dbPrefix (like "serendipity_"):

Code: Select all

CREATE INDEX commentry_idx ON {PREFIX}comments (entry_id);
CREATE INDEX commpentry_idx ON {PREFIX}comments (parent_id);
CREATE INDEX commtype_idx ON {PREFIX}comments (type);
CREATE INDEX commstat_idx ON {PREFIX}comments (status);

CREATE INDEX edraft_idx ON {PREFIX}entries (isdraft);
CREATE INDEX eauthor_idx ON {PREFIX}entries (authorid);

CREATE INDEX refentry_idx ON {PREFIX}references (entry_id);

CREATE INDEX exits_idx ON {PREFIX}exits (entry_id,day);

CREATE INDEX referrers_idx ON {PREFIX}referrers (entry_id,day);
CREATE INDEX urllast_idx on {PREFIX}suppress (last);
CREATE INDEX pluginplace_idx ON {PREFIX}plugins (placement);

CREATE INDEX categorya_idx ON {PREFIX}category (authorid);
CREATE INDEX categoryp_idx ON {PREFIX}category (parentid);
CREATE INDEX categorylr_idx ON {PREFIX}category (category_left, category_right);

After that you might want to execut OPTIMIZE TABLE queries on each of the serendipity tables.

Regards,
Garvin

[Guest]

Wow. 1.5GB data in your table, that sure chokes your MySQL. If you want to make that data workable, you need to do some serous MySQL optimizing and have a Server with enough cache/RAM.

You might want to run those optimizations for your SQL tables; replace {PREFIX} with your dbPrefix (like "serendipity_"):

Code: Select all

CREATE INDEX commentry_idx ON {PREFIX}comments (entry_id);
CREATE INDEX commpentry_idx ON {PREFIX}comments (parent_id);
CREATE INDEX commtype_idx ON {PREFIX}comments (type);
CREATE INDEX commstat_idx ON {PREFIX}comments (status);

CREATE INDEX edraft_idx ON {PREFIX}entries (isdraft);
CREATE INDEX eauthor_idx ON {PREFIX}entries (authorid);

CREATE INDEX refentry_idx ON {PREFIX}references (entry_id);

CREATE INDEX exits_idx ON {PREFIX}exits (entry_id,day);

CREATE INDEX referrers_idx ON {PREFIX}referrers (entry_id,day);
CREATE INDEX urllast_idx on {PREFIX}suppress (last);
CREATE INDEX pluginplace_idx ON {PREFIX}plugins (placement);

CREATE INDEX categorya_idx ON {PREFIX}category (authorid);
CREATE INDEX categoryp_idx ON {PREFIX}category (parentid);
CREATE INDEX categorylr_idx ON {PREFIX}category (category_left, category_right);

After that you might want to execut OPTIMIZE TABLE queries on each of the serendipity tables.

Regards,
Garvin

Thanks,I'll try it.

feedback later

[sexstoriescity]

Fatal error: Maximum execution time of 300 seconds exceeded in C:\abc\xxx\sexstoriescity.com\include\db\mysql.inc.php on line 37

[garvinhicking]

What kind of CPU and RAM do you have? Which MySQL version are you running?

Such a large site like yours certianly requires some special server setup.

Regards,
Garvin

[sexstoriescity]

What kind of CPU and RAM do you have? Which MySQL version are you running?

Such a large site like yours certianly requires some special server setup.

Regards,
Garvin

CPU:family 6 model 8 stepping 1 authenticamd 1995mhz
RAM:512M

mysql: 4.0.22 (windows)

[garvinhicking]

You should try do some MySQL tuning, mostly enabling the query cache and assigning as much as possible RAM to MySQL. Also make sure your server is not running any other high-load/traffic applications on the same time?

This is mostly a MySQL issue, other systems with 1.5GB of data will also not perform because MySQL does not deliver the data...

Regards,
Garvin

[sexstoriescity]

make sure your server is not running any other high-load/traffic applications on the same time?

no,only one web site

[sexstoriescity]

I can show my website(admin),phpmyadmin to you.

[garvinhicking]

I am sorry, this seems to lead a bit too far, as you seem to be running a commercial site, right? I can offer you commercial support then, or if you are running a non-commercial site I can look at your phpMyAdmin install and see what your MySQL options are...?

Regards,
Garvin

[sexstoriescity]

I am sorry, this seems to lead a bit too far, as you seem to be running a commercial site, right? I can offer you commercial support then, or if you are running a non-commercial site I can look at your phpMyAdmin install and see what your MySQL options are...?

Regards,
Garvin

non-commercial site

The free sex stories.