php forum
php mysql forum
php mysql smarty
 
Topic Options
#269109 - 02/10/04 10:25 AM transactional integrity
dr jam Offline
Lurker

Registered: 02/10/04
Posts: 1
I have a site using threads and several other apps that all access member data. However the myISAM tables turn into a dog's dinner when they all try to read data at once (update even worse) due to unexpected conflicts, timeouts and retries by each of the apps.<br /><br />I see some people are using InnoDB tables to hold membership information. Has anyone had this running in busy production environments? Have there been any problems? Were any mods required to the threads code?<br /><br />Thanks

Top
#269110 - 02/10/04 11:37 AM Re: transactional integrity [Re: ebrahim]
Astaran Offline
Addict

Registered: 12/21/00
Posts: 1545
Loc: Germany
No changes to the code are required if you don't want to use transactions.<br />We ran our production board for a few days with InnoDB, but it needs significantly more memory than MyIsam, so we switched it back.
_________________________
Running a community? -> Keep informed and take it to the next level

Top


Who's Online
0 registered (), 25 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Forum 'Trader Ratings'.
by blaaskaak
11/20/08 08:27 AM
Problems reading a lot of old posts here
by Ruben Rocha
11/18/08 04:33 PM
PhotoPost BB Code Popup
by Iann128
11/15/08 01:24 PM
Customization needed
by Gizmo
11/12/08 12:28 PM
Team UBBDev Rides Again!
by AllenAyres
11/11/08 02:16 PM
Active Topics.
by AllenAyres
11/11/08 02:13 PM
Looking for a simple upload script
by AllenAyres
11/11/08 02:12 PM
New Mods
Forum 'Trader Ratings'.
by McLemore
11/19/08 02:14 PM
[7.4] Keep log of custom title changes
by blaaskaak
10/27/08 07:51 AM
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Newest Members
nick1, Begbie, cenk, MATTO, DougMMcts
13362 Registered Users
Top Posters
AllenAyres 25448
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks