Page 1 of 1
The Front page cann't load
Posted: Tue May 24, 2005 8:23 am
by 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......
Re: The Front page cann't load
Posted: Tue May 24, 2005 8:49 am
by 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
Re: The Front page cann't load
Posted: Tue May 24, 2005 9:57 am
by Guest
garvinhicking wrote: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
Posted: Tue May 24, 2005 11:25 am
by sexstoriescity
Fatal error: Maximum execution time of 300 seconds exceeded in C:\abc\xxx\sexstoriescity.com\include\db\mysql.inc.php on line 37
Posted: Tue May 24, 2005 12:17 pm
by 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
Posted: Tue May 24, 2005 1:24 pm
by sexstoriescity
garvinhicking wrote: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)
Posted: Tue May 24, 2005 1:50 pm
by 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
Posted: Tue May 24, 2005 2:07 pm
by sexstoriescity
garvinhicking wrote:make sure your server is not running any other high-load/traffic applications on the same time?
no,only one web site
Posted: Tue May 24, 2005 2:10 pm
by sexstoriescity
I can show my website(admin),phpmyadmin to you.
Posted: Tue May 24, 2005 4:18 pm
by 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
Posted: Tue May 24, 2005 7:16 pm
by sexstoriescity
garvinhicking wrote: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.