• Why not take a moment to introduce yourself to our members?

Cadiz.Jonathan

Advanced Reefer
Location
Bronx
Rating - 0%
0   0   0
I use the reefs app it's ok sometimes have to reload a page cuz it dosnt load properly but I'm never on the computer so idk which one is worst
 

cmantis

Advanced Reefer
Rating - 100%
103   0   0
These past 3-4 days have been the worst. When I click a link it either goes to a different thread several years old, goes to the registration page, or says it cannot load. I couldn't do anything on this site until last night.
 

Josh

in the coral sea...
Vendor
Location
Union Square, NY
Rating - 100%
90   0   0
database is the bottleneck to performance here. I am suggesting to reindex your MySQL DB and archive old posts. The amount of data and concurrent users add up quickly.

I don't know how you make a blanket statement like that without knowing specifics of the server configuration. I think you previously suggested that it was related to the database but that is incorrect.
 

Zimon

Experienced Reefer
Location
Stamford, CT
Rating - 100%
9   0   0
From my experience it is data related from the symptoms we've been seeing.
When the site fetches incorrect pages this is a problem with the primary key indexing.

OPTIMIZER_MODE: ALL_ROWS is good for Batch processing, FIRST_ROWS is good for Interactive(OLTP)
OPTIMIZER_INDEX_COST_ADJ : 100 means full table scan, 1-10 means use Index.

Create Index table space for Indexes( separate data and Index)
Separate the current data and historical data for large tables.

It's tough running a high traffic forum.. best of luck on a resolution!
 
Last edited:

Josh

in the coral sea...
Vendor
Location
Union Square, NY
Rating - 100%
90   0   0
From my experience it is data related from the symptoms we've been seeing.
When the site fetches incorrect pages this is a problem with the primary key indexing.

OPTIMIZER_MODE: ALL_ROWS is good for Batch processing, FIRST_ROWS is good for Interactive(OLTP)
OPTIMIZER_INDEX_COST_ADJ : 100 means full table scan, 1-10 means use Index.

Create Index table space for Indexes( separate data and Index)
Separate the current data and historical data for large tables.

It's tough running a high traffic forum.. best of luck on a resolution!

The problem is actually due to a misconfigured cache.
 

ReefMonkey13

Advanced Reefer
Location
Queens
Rating - 100%
105   0   0

Sponsor Reefs

We're a FREE website, and we exist because of hobbyists like YOU who help us run this community.

Click here to sponsor $10:


Top