Previous Thread
Next Thread
Print Thread
Hop To
#204450 01/09/2008 8:27 AM
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
We'e had a problem since our upgrade to 7.2.2.

We need someone with expertise in MySQL to contact us directly. Pleae use e-mail admin at fishingminnesta.com if you can help.

Here is what the last check said after attempting the repair utility.
Code
MySQL Account Maintenance

   

Checking Database
fishingm_forum7 is now being checked. 
fishingm_forum7.ubbt_ADDRESS_BOOK                  OK
fishingm_forum7.ubbt_ADMIN_LOG                     OK
fishingm_forum7.ubbt_ADMIN_SEARCHES                OK
fishingm_forum7.ubbt_ANNOUNCEMENTS                 OK
fishingm_forum7.ubbt_BANNED_EMAILS                 OK
fishingm_forum7.ubbt_BANNED_HOSTS                  OK
fishingm_forum7.ubbt_BANNED_USERS                  OK
fishingm_forum7.ubbt_CACHE                         OK
fishingm_forum7.ubbt_CACHED_PERMISSIONS            OK
fishingm_forum7.ubbt_CALENDAR_EVENTS               OK
fishingm_forum7.ubbt_CAPTCHA                       OK
fishingm_forum7.ubbt_CATEGORIES                    OK
fishingm_forum7.ubbt_CENSOR_LIST                   OK
fishingm_forum7.ubbt_DISPLAY_NAMES                 OK
fishingm_forum7.ubbt_FILES                         OK
fishingm_forum7.ubbt_FORUMS                        OK
fishingm_forum7.ubbt_FORUM_LAST_VISIT              OK
fishingm_forum7.ubbt_FORUM_PERMISSIONS             OK
fishingm_forum7.ubbt_GRAEMLINS                     OK
fishingm_forum7.ubbt_GROUPS                        OK
fishingm_forum7.ubbt_IMPORT_MAP                    OK
fishingm_forum7.ubbt_LANGUAGES                     OK
fishingm_forum7.ubbt_MAILER                        OK
fishingm_forum7.ubbt_MEMBER_SEARCHES               OK
fishingm_forum7.ubbt_MODERATORS                    OK
fishingm_forum7.ubbt_MODERATOR_NOTIFICATIONS       OK
fishingm_forum7.ubbt_MODERATOR_PERMISSIONS         OK
fishingm_forum7.ubbt_ONLINE
error    : The handler for the table doesn't support check
fishingm_forum7.ubbt_POINTER_DELETE                OK
fishingm_forum7.ubbt_POLL_DATA                     OK
fishingm_forum7.ubbt_POLL_OPTIONS                  OK
fishingm_forum7.ubbt_POLL_VOTES                    OK
fishingm_forum7.ubbt_PORTAL_BOXES                  OK
fishingm_forum7.ubbt_POSTS
warning  : Table is marked as crashed and last repair failed
warning  : Size of datafile is: 1034712912       Should be: 1034700300
error    : Keypointers and record positions doesn't match
warning  : Found 1224985 parts                Should be: 1224371 parts
error    : Corrupt
fishingm_forum7.ubbt_PRIVATE_MESSAGE_POSTS         OK
fishingm_forum7.ubbt_PRIVATE_MESSAGE_TOPICS        OK
fishingm_forum7.ubbt_PRIVATE_MESSAGE_USERS         OK
fishingm_forum7.ubbt_RATINGS                       OK
fishingm_forum7.ubbt_REFERER_LOG
warning  : 2 clients are using or haven't closed the table properly
status   : OK
fishingm_forum7.ubbt_REGISTRATION_FIELDS           OK
fishingm_forum7.ubbt_RESERVED_NAMES                OK
fishingm_forum7.ubbt_RSS_FEEDS                     OK
fishingm_forum7.ubbt_SAVED_QUERIES                 OK
fishingm_forum7.ubbt_SEARCH_AGENTS                 OK
fishingm_forum7.ubbt_SEARCH_RESULTS                OK
fishingm_forum7.ubbt_SHOUT_BOX                     OK
fishingm_forum7.ubbt_STYLES                        OK
fishingm_forum7.ubbt_TOPICS                        OK
fishingm_forum7.ubbt_TOPIC_VIEWS
error    : The handler for the table doesn't support check
fishingm_forum7.ubbt_USERS
warning  : 2 clients are using or haven't closed the table properly
status   : OK
fishingm_forum7.ubbt_USER_DATA
warning  : 2 clients are using or haven't closed the table properly
status   : OK
fishingm_forum7.ubbt_USER_GROUPS                   OK
fishingm_forum7.ubbt_USER_NOTES                    OK
fishingm_forum7.ubbt_USER_PROFILE
warning  : 1 client is using or hasn't closed the table properly
status   : OK
fishingm_forum7.ubbt_USER_TITLES                   OK
fishingm_forum7.ubbt_VERSION                       OK
fishingm_forum7.ubbt_WATCH_LISTS                   OK


again, please contact:
admin at fishingminnesota.com

Last edited by Gizmo; 01/09/2008 8:54 AM.
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
What is the problem? It seems that the sql server found and corrected your errors... Run the repair utility again and see if it sees any additional errors after the previous repair.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #204464 01/09/2008 6:53 PM
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
I agree that you should run the REPAIR again, but it does show that the repair failed.

Quote
warning : Table is marked as crashed and last repair failed
warning : Size of datafile is: 1034712912 Should be: 1034700300
error : Keypointers and record positions doesn't match
warning : Found 1224985 parts Should be: 1224371 parts
error : Corrupt


Let us know how it goes upon repairing again.

ntdoc #204502 01/10/2008 2:12 PM
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
We have run the repair several times to no avail and have now imported the data again into a new MySQL database.

We really need to hire someone to optimize the MySQL variables to be adjusted in order to optimize its performance. Also we need to optimize the queries that we have in your UBB scripts and make sure the connections scripts establish during execution are gracefully closed when the transaction is done.

check out how slow our forums are at:
http://www.fishingminnesota.com/forum/ubbthreads.php

Our server is fine with room to spare.

e-mail us if you are interested in helping us through a very challenging situation. Let us know your hourly rate please.

Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Sorry to hear of your current issues.

Can you please provide your current Server details.
Linux/Windows, Shared,VPP,Dedicated hardware
RAM/CPU/HD

Current CPU utilization average

HD on RAID or single drive(s)

MySQL version
PHP version
Linux/Windows version
Apache version

ntdoc #204508 01/10/2008 4:05 PM
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
I'm checking

Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Total accesses: 162784 - Total Traffic: 2.7 GB
CPU Usage: u748.75 s114.85 cu193.65 cs115.1 - 25.5% CPU load
35.4 requests/sec - 0.6 MB/second - 17.4 kB/request
150 requests currently being processed, 0 idle servers

Processor InformationProcessor #1 Vendor: AuthenticAMD
Processor #1 Name: AMD Opteron(tm) Processor 246
Processor #1 speed: 1993.195 MHz
Processor #1 cache size: 1024 KB

Processor #2 Vendor: AuthenticAMD
Processor #2 Name: AMD Opteron(tm) Processor 246
Processor #2 speed: 1993.195 MHz
Processor #2 cache size: 1024 KB



Memory InformationMemory: 4133404k/4767744k available (1877k kernel code, 43436k reserved, 759k data, 184k init, 3260352k highmem)



System InformationLinux fishing.fishingminnesota.com 2.6.9-42.0.3.ELsmp #1 SMP Fri Oct 6 06:21:39 CDT 2006 i686 athlon i386 GNU/Linux



Physcial Diskshdc: SONY CD-ROM CDU5225, ATAPI CD/DVD-ROM drive
hdc: ATAPI 52X CD-ROM drive, 96kB Cache, UDMA(33)



Current Memory Usage total used free shared buffers cached
Mem: 4134716 4061120 73596 0 117452 2820288
-/+ buffers/cache: 1123380 3011336
Swap: 2048248 160 2048088
Total: 6182964 4061280 2121684



Current Disk UsageFilesystem Size Used Avail Use% Mounted on
/dev/sda3 3.9G 2.9G 814M 79% /
/dev/sda1 76M 17M 56M 23% /boot
none 2.0G 0 2.0G 0% /dev/shm
/dev/sda7 441G 39G 380G 10% /home
/dev/sda6 981M 19M 913M 2% /tmp
/dev/sda2 12G 5.7G 5.4G 52% /var


httpd (1.3.34 (Unix)) up
cpsrvd up
imap up
mysql (4.0.27-standard-log) up
exim-26 up
ftpd up
exim (exim-4.63-1_cpanel_smtpctl_av_rewrite_mm2_mmmtrap_exiscan_md5pass) up
Server Load 0.34 (2 cpus)
Memory Used 27 %
Swap Used 0.01 %
Disk sda3 (/) 79 %
Disk sda1 (/boot) 23 %
Disk sda7 (/home) 10 %
Disk sda6 (/tmp) 2 %
Disk sda2 (/var) 52 %

MySQL
Server version: 4.0.27-standard-log
Protocol version: 10
Server: Localhost via UNIX socket
User: root@localhost

PHP
phpMyAdmin - 2.9.0.2
MySQL client version: 4.1.10
Used PHP extensions: mysql
Language : English (iso-8859-1

Does this info help?




Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Php Module 4.4.7 loaded on Apache

Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
We have just adjusted all the performance related variables and loaded into MySQL. Our server folks did that and they assured us all we need to do is as follows:

We now need to optimize the queries that we have in the 7.2.2 UBB scripts and make sure the connection scripts established during execution are gracefully closed when the transaction is done.

Still looking for help with this one. It's a paid gig for whomever can help us speed this baby up.

Joined: Apr 2007
Posts: 120
member
member
Joined: Apr 2007
Posts: 120
Do you have Zlib compression turned on in the control panel?

When I moved our board from classic to threads the system was a crawling until I ticked that little box. Now it flies.

We have around 11,400 members, 51K topics and over 450K posts. On average we have 200+ members online during peak periods.


Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Thanks, that seems to have helped. We'll know more tonight and tomorrow am.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
ZLib compression will more be noticed by users vs the server; as the server just sends the data out compressed (if the users browser supports it), thus it serves faster to the users.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #204522 01/10/2008 8:08 PM
Joined: Apr 2007
Posts: 120
member
member
Joined: Apr 2007
Posts: 120
Hmmm. Without that option enabled the system was a slug, forums, ACP everything.

But hey, if the pages display in < 1 sec with it on -vs- > 2 minutes with it off...

load averages with it on and off were noticable, we saw 60 to 80 percent CPU loads on the machine (peaks) with it off, now the system loafs along barely breaking a sweat. I doubt we see more than 10 to 20 percent load at our peak period.


Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
weird, as the compression is known to slug down servers (just about any documentation one can find on coding with it on specify it'll trade speed for cpu hits) but you seem to be experiencing the meere opposite...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Well MySQL 5 is faster than 4 (Rick or Gizmo may be able to shed light on the MySQL version as it may be too low for UBBT 7.2.2)

Also you did not list the actual version of PHP but many sites claim that 5.x is much faster than 4.x

SD seems to know a bit about MySQL/PHP so he might be able to help.

There is also the Dev site, but most of those guys also frequent this site as well.

I would love to help, but I'm not qualified to make such tweaks, just know enough to be dangerous wink

ntdoc #204531 01/10/2008 10:14 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
There is a guide at ubbdev about optimizing MySQL; I'm sure Dave will be in soon to post th elink wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
ntdoc #204532 01/10/2008 10:22 PM
Joined: Apr 2007
Posts: 120
member
member
Joined: Apr 2007
Posts: 120
We're running 5.x something (don't care to look at the moment) we are fairly knowledable on tuning/tweaking. We use MySQL databases for some fairly RW intensive systems so having the db tuned to near perfection is critical.

I'm not the db guru by any measure, but I have guys working for me that are pretty wiz-bang.

The thing is, we did all of our tune/tweak processes BEFORE enabling Zlib compression, nothing worked or at least made any noticable difference. But turning on that compression was like flipping on a light switch, instantly the sluggish forum issue was behind us and has been since May 07.


Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
I guess we still need to optimize the queries that we have in the 7.2.2 UBB scripts and make sure the connection scripts established during execution are gracefully closed when the transaction is done.

If there are faster MySQL and PHP versions that we can use that would be great as well.

Still looking for help with this one. It's a paid gig for whomever can help us speed this baby up.

Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Is it possible the number of posts we have (1,227,123) are slowing the forums down somehow?

If so is there a way to fix it while keeping the post counts for each forum from being reduced?

Is there anyone who would like to help us speed up our forums? It's frustratingly slow at times.

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
It really relies on a properly tuned and configured MySQL installation. Are you on a dedicated or shared host? If you're just running a stock version of MySQL without any tweaks, then yeah the number of posts you have will definitely be a bit slow.

Configuring and tweaking MySQL takes a while. I'd recommend visiting UBBDev.com There are 2 topics you really should read. Let's tune MySQL I and II.

I'd also turn on debugging down so you can get a good idea what the actual page generation times are, and what portion of those are just CPU time as opposed to MySQL time.

Rick #204817 01/14/2008 1:10 PM
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Thanks Rick.

I really don't know MySQL so if anyone could lend assistance that would be great. We do have a dedicated server.

Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
Rick,
how do I tell whether it's MySQL time or if it's CPU time. My server guys tell me it's not CPU.

Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
24 hours and no interest ehhh?

That's OK because we might have figured it out and the UBB forums are blazing along now at a peak time.

Thanks for all the help. Hopefully we won't need to bother you again anytime soon. - Except for the 7.3 upgrade of course....looking forward to it.

Joined: Apr 2007
Posts: 120
member
member
Joined: Apr 2007
Posts: 120
Originally Posted by HotSpotOutdoors.com
24 hours and no interest ehhh?

That's OK because we might have figured it out and the UBB forums are blazing along now at a peak time.

Thanks for all the help. Hopefully we won't need to bother you again anytime soon. - Except for the 7.3 upgrade of course....looking forward to it.

Inquiring minds (mine at least) want to know, what was the fix?


Joined: Dec 2007
Posts: 13
F
stranger
stranger
F Offline
Joined: Dec 2007
Posts: 13
We tweaked apache and the my.cnf files and that seems to have done the trick. Our forums have been flying along for the last two days.

Thanks for the help!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
2 members (Havenofsobriety, rootman), 624 guests, and 106 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)