RE: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!
I don't think [EMAIL PROTECTED] should be used for sales. Is there a policy about this? Ch -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince LaMonica Sent: 03 March 2006 22:01 To: David Griffiths Cc: mysql@lists.mysql.com Subject: Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool! On Fri, 3 Mar 2006, David Griffiths wrote: } Definitely give this tool a try if you haven't - it has some very powerful } features - schema diffs (and the ability to create patches, etc - very } powerful if you maintain development, quality-assurance, and production } databases). } } The ability to sort connections, etc, by machine, by database, etc, is very } powerful. Those features sound very nice, indeed, but alas, there is no Mac OS X or Linux version. Are there other products [free/not free] that can do what this tool does, but run under UNIX flavors? /vjl/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Enforcing Isolation in MySQL database
Vinay, - Original Message - From: Vinay [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Thursday, March 02, 2006 12:20 AM Subject: Enforcing Isolation in MySQL database --=_NextPart_000_002C_01C63D51.B51315D0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello , I suppose the InnoDB tables in Mysql have REPEATABLE-READ as = the default isolation. Is the concurrency enforced automatically by the = database or is there anything=20 the application programmer has to do to make sure the data consistent. How does the REPEATABLE-READ resolve the following scenario. User1 opens a application and reads a row on the screen. User2 opens the same application and read the same row on the screen. User2 updates a field (and commits ,as the autocommit is on), User1 still is reading the non-updated row , and updates the same field = updated by the User2 to different value. How does it affect the database when normal select , update queries are = used. you should use SELECT ... FOR UPDATE in this case. A normal plain SELECT in InnoDB does not lock the rows it reads. What should the application programmer to enforce database concurrency. Thank you, Vinay Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Movable Type + OSXServer + MySQL issues.
Movable Type + OSXServer + MySQL issues.Miles, David is correct - DBI isn't installed in OSX by default. check out http://www.brandonhutchinson.com/installing_perl_modules.html for a brief into on installing from CPAN. Make sure you do this as root or through sudo -- George - Original Message - From: m i l e s To: MySQL Sent: Friday, March 03, 2006 4:47 PM Subject: Movable Type + OSXServer + MySQL issues. Hi, Im having a rather nasty time installing MT on my G5XServe. IM trying to use MySQL but Im getting a rather NASTY error Stock Install of MySQL that came with the G5. ++ Got an error: Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC (@INC contains: /Volumes/webserver/ ~shoreweddings.com/blog/extlib lib /System/Library/Perl/5.8.6/darwin- thread-multi-2level /System/Library/Perl/5.8.6 /Library/Perl/5.8.6/ darwin-thread-multi-2level /Library/Perl/5.8.6 /Library/Perl /Network/ Library/Perl/5.8.6/darwin-thread-multi-2level /Network/Library/Perl/ 5.8.6 /Network/Library/Perl /System/Library/Perl/Extras/5.8.6/darwin- thread-multi-2level /System/Library/Perl/Extras/5.8.6 /Library/Perl/ 5.8.1 .) at lib/MT/ObjectDriver/DBI.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI.pm line 10. Compilation failed in require at lib/MT/ObjectDriver/DBI/mysql.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI/mysql.pm line 10. Compilation failed in require at (eval 6) line 1. BEGIN failed--compilation aborted at (eval 6) line 1. ++ Anyone seen this before ? And how best to resolve it ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]