MYSQL simultaneous access to records

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
cjkeane
Forum Contributor
Posts: 217
Joined: Fri Jun 11, 2010 1:17 pm

MYSQL simultaneous access to records

Post 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.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: MYSQL simultaneous access to records

Post 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
Post Reply