|
Joined: Jan 2006
Posts: 53
journeyman
|
journeyman
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. 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,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 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.
|
|
|
|
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. 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.
|
|
|
|
Joined: Jan 2006
Posts: 53
journeyman
|
journeyman
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.phpOur 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
|
|
|
|
Joined: Jan 2006
Posts: 53
journeyman
|
journeyman
Joined: Jan 2006
Posts: 53 |
|
|
|
|
Joined: Jan 2006
Posts: 53
journeyman
|
journeyman
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
journeyman
|
journeyman
Joined: Jan 2006
Posts: 53 |
Php Module 4.4.7 loaded on Apache
|
|
|
|
Joined: Jan 2006
Posts: 53
journeyman
|
journeyman
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
journeyman
|
journeyman
Joined: Jan 2006
Posts: 53 |
Thanks, that seems to have helped. We'll know more tonight and tomorrow am.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 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.
|
|
|
|
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,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 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...
|
|
|
|
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
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
There is a guide at ubbdev about optimizing MySQL; I'm sure Dave will be in soon to post th elink
|
|
|
|
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
journeyman
|
journeyman
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
journeyman
|
journeyman
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
Former Developer
|
Former Developer
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.
|
|
|
|
Joined: Jan 2006
Posts: 53
journeyman
|
journeyman
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
journeyman
|
journeyman
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
journeyman
|
journeyman
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 |
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
stranger
|
stranger
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!
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
2 members (DennyP, 1 invisible),
972
guests, and
155
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|