forum.webdiplomacy.net

webDip dev coordination forum / public access todo list
It is currently Sun Dec 17, 2017 9:25 pm

All times are UTC




Post new topic Reply to topic  [ 16 posts ]  Go to page Previous  1, 2
Author Message
PostPosted: Tue Oct 16, 2012 9:29 am 
Offline
Site Admin

Joined: Sat Jun 28, 2008 6:24 am
Posts: 892
At least the solution is straightforward; you've got to get a host with InnoDB support, there's really no excuse to have MySQL without it these days, it's all owned by Oracle, it's all licensed the same, there's no extra cost, etc. If your host doesn't support it you should really move hosts (and need to, if you want to run webDip reliably)


Top
 Profile  
 
PostPosted: Tue Oct 16, 2012 12:15 pm 
Offline

Joined: Sat Jan 14, 2012 7:08 am
Posts: 48
Location: Ukraine
I'm sorry for the late post but I've really fixed this by changing engine of tables to InnoDB, but 2 tables anyway wanna be like following:

wD_Notices MyISAM
wD_Sessions MEMORY

_________________
"There is nothing in the world more majestic than this idiotic Galicia" (GAL)
Jaroslav Hasek


Top
 Profile  
 
PostPosted: Tue Oct 16, 2012 6:33 pm 
Offline

Joined: Wed Jul 29, 2009 10:22 am
Posts: 841
At vdip the tables are like this:

InnoDB:
wD_CivilDisorders
wD_Games
wD_Members
wD_Orders
wD_Silences
wD_TerrStatus
wD_Units
wD_Users

Memory:
wD_Sessions

Rest: MyISAM


Top
 Profile  
 
PostPosted: Fri Oct 19, 2012 6:28 am 
Offline

Joined: Sat Jan 14, 2012 7:08 am
Posts: 48
Location: Ukraine
Sleepcap wrote:
At vdip the tables are like this:

InnoDB:
wD_CivilDisorders
wD_Games
wD_Members
wD_Orders
wD_Silences
wD_TerrStatus
wD_Units
wD_Users

Memory:
wD_Sessions

Rest: MyISAM


I've done as you say but i still don't understand why main Table is InnoDB and "backup"-ones are MyISAM:

wD_Backup_Members
wD_Backup_MovesArchive
wD_Backup_Orders
wD_Backup_TerrStatus
wD_Backup_TerrStatusArchive
....
wD_TerrStatusArchive

and so on.
???

_________________
"There is nothing in the world more majestic than this idiotic Galicia" (GAL)
Jaroslav Hasek


Top
 Profile  
 
PostPosted: Fri Oct 19, 2012 9:46 am 
Offline
Site Admin

Joined: Sat Jun 28, 2008 6:24 am
Posts: 892
InnoDB is all about being able to lock records, and have transactions, so that you'll be half way through a complicated set of changes to a game and suddenly things stop and it'll recover. The backup tables are just copies of the live data taken when games get cancelled / deleted, so they don't need any locking or transaction support.

MyISAM is generally faster and takes up less space, so it's the best choice if you don't need InnoDB features.


Top
 Profile  
 
PostPosted: Fri Oct 19, 2012 12:01 pm 
Offline

Joined: Sat Jan 14, 2012 7:08 am
Posts: 48
Location: Ukraine
kestasjk wrote:
InnoDB is all about being able to lock records, and have transactions, so that you'll be half way through a complicated set of changes to a game and suddenly things stop and it'll recover. The backup tables are just copies of the live data taken when games get cancelled / deleted, so they don't need any locking or transaction support.

MyISAM is generally faster and takes up less space, so it's the best choice if you don't need InnoDB features.

Thanx!

_________________
"There is nothing in the world more majestic than this idiotic Galicia" (GAL)
Jaroslav Hasek


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page Previous  1, 2

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group