Page 1 of 1

MYSQL simultaneous access to records

Posted: Thu Oct 21, 2010 2:46 pm
by cjkeane
Hi.

A client of mine wants to migrate from lotus domino to mysql. I have a few questions.
1. What are the limitations of mysql in regards to database/record sizes?
2. Can lotus domino records be imported into mysql
3. Does mysql allow simultaneous access to records, not just concurrent access to the db.
4. What happens if a person creates record 1 and another person creates record 2. if record 2 is saved before record one is saved, is record 1 lost? i have created a lot of ms access databases but not mysql databases so i'm unsure how mysql functions.

thx.

Re: MYSQL simultaneous access to records

Posted: Mon Oct 25, 2010 10:26 pm
by josh
#1 - http://dev.mysql.com/doc/refman/5.0/en/full-table.html The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. With JFS and XFS, petabyte and larger files are possible on Linux. 8O
#2 - export to CSV, and then yea
#3 - of course. With innodb locking happens on the row level. With myisam it locks the whole table. Use innodb. Locking happens during write queries, and backups done with the 'mysqldump' tool.
#4 - both are saved, of course. If the id # requested is taken, and the column type is auto increment, I believe only then would the ID # that is actually saved differ from the requested ID.

I recommend searching the manual for future questions: http://dev.mysql.com/doc/refman/5.0/en/index.html