ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.7, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.7 Pro For more information, see http://www.upscene.com/go/?go=newsid=20140617 Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.6, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.6 Pro For more information, see http://www.upscene.com/go/?go=newsid=20140429 The FREE Lite Editions will be released at a later stage. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.4, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.4 Pro For more information, see http://www.upscene.com/go/?go=newsid=20140127 The FREE Lite Editions will be released at a later stage. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.3 Pro This release fixes a blocking problem after a recent Windows XP security update. There's a 15% autumn discount until the end of November! For more information, see http://www.upscene.com/go/?go=newsid=20131127 The FREE Lite Editions are also updated, this includes several enhancements compared to the previous available Lite Editions. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.2, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.2 Pro There's a 15% autumn discount until the end of November! This release includes enhancements and fixes several bugs as reported by our users. For more information, see http://www.upscene.com/go/?go=newsid=20131024 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com
ANN: Database Workbench 4.4.1, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.1 Pro This release includes new features and fixes several bugs as reported by the users. For more information, see http://www.upscene.com/go/?go=newsid=20130819 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available!
ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.4.0 Pro This release includes new features and fixes several bugs as reported by the users. For more information, see http://www.upscene.com/go/?go=newsid=20130423 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available!
ANN: Database Workbench 4.3.2, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.2 Pro This release fixes several bugs as reported by the users. For more information, see http://www.upscene.com/go/?go=newsid=20121112 The FREE Lite Editions will follow later. Database Workbench supports: - Borland InterBase ( 6.x and up ) - Firebird ( 1.x and up ) - MS SQL Server/MSDE ( 7 and up ) - MySQL 4.x and up - Oracle Database ( 8i and up ) - Sybase SQL Anywhere ( 9 and up ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available!
ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.1 Pro This release fixes a few issues with MySQL support. For more information, see http://www.upscene.com/go/?go=newsid=20120820 The FREE Lite Editions will follow later. Changes include: - NEW: Stored Procedure Trigger debugger for MySQL - NEW: incremental data search in SQL, Table View Editor - FIXED: Oracle Debugger fixes - FIXED: NexusDB error when testing Stored Functions - FIXED: MySQL module not properly displaying stored procedures/functions without mysql.procs access and much more... Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available!
ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.3.0 Pro For more information, see http://www.upscene.com/go/?go=newsid=20120813 The FREE Lite Editions will follow later. Changes include: - NEW: Stored Procedure Trigger debugger for MySQL - NEW: incremental data search in SQL, Table View Editor - FIXED: Oracle Debugger fixes - FIXED: NexusDB error when testing Stored Functions - FIXED: MySQL module not properly displaying stored procedures/functions without mysql.procs access and much more... For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.3.0id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Database Workbench 4.2.3, the multi-DBMS IDE now available!
Hello Daevid, Any plans to add sqlite to your list of supported DBs there? I develop Android and use LAMP as the server backend. Currently I use SQLYog as I have for like 10 years. But I would really like one GUI to work on both the android sqlite and the mysql backend since they usually tie together. Full native SQLite is not planned. You probably can access it as a read only datasource, run queries etc, via ODBC, I haven't tested that. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available!
ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.3 Pro For more information, see http://www.upscene.com/go/?go=newsid=20120323 Today's release includes the FREE Lite Editions. For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.3id=3 http://www.upscene.com/go/?go=trackerv=4.2.2id=3 http://www.upscene.com/go/?go=trackerv=4.2.1id=3 http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Database Workbench 4.2.3, the multi-DBMS IDE now available!
Any plans to add sqlite to your list of supported DBs there? I develop Android and use LAMP as the server backend. Currently I use SQLYog as I have for like 10 years. But I would really like one GUI to work on both the android sqlite and the mysql backend since they usually tie together. -Original Message- From: Martijn Tonies [mailto:m.ton...@upscene.com] Sent: Friday, March 23, 2012 2:10 AM To: mysql@lists.mysql.com; firebird-to...@yahoogroups.com Subject: ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available! ANN: Database Workbench 4.2.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.3 Pro For more information, see http://www.upscene.com/go/?go=newsid=20120323 Today's release includes the FREE Lite Editions. For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.3id=3 http://www.upscene.com/go/?go=trackerv=4.2.2id=3 http://www.upscene.com/go/?go=trackerv=4.2.1id=3 http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 6.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008 ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available!
ANN: Database Workbench 4.2.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular Windows-based multi-DBMS development tool: Database Workbench 4.2.1 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=newsid=20120209 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.1id=3 http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Database Workbench 4.2.0, the multi-DBMS IDE now available!
ANN: Database Workbench 4.2.0, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS Windows-based development tool: Database Workbench 4.2.0 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. There's a 40% discount available until the 1st of January 2012! For more information, see http://www.upscene.com/go/?go=newsid=20111212 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.2.0id=3 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
Hi all, No SQLite support? http://www.sqlite.org/ Seems curious you wouldn't have this yet, especially given its popularity on both embedded systems and Android to say the least. Indeed, no native SQLite support. Lots of other systems are popular and not supported. The reason for this is that the tool is not generic and tries to get the most of all. Apparently Winblows-only. It sure would be nice if people would note platform requirements in their announcement, rather than forcing people to dig through their websites for such info. I guess I should know better; if it doesn't list platform requirements, the developer hasn't thought beyond the dominant paradigm. You sure have a point, I'll list it in the future. However, I should note that Database Workbench users have succesfully used it under Wine. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
Apparently Winblows-only. It sure would be nice if people would note platform requirements in their announcement, rather than forcing people to dig through their websites for such info. I guess I should know better; if it doesn't list platform requirements, the developer hasn't thought beyond the dominant paradigm. You have a very real relationship with God, a Force that responds to your every thought. Not that you are telling God how to run the universe; you are simply aligning with the Force for your good, or not aligning with it. The more aligned you are, the better your life goes. Unlike what you may have been told by fearful teachers, all God wants is for you to be happy. When that is all you want for yourself, that is what you will have. -- Alan Cohen Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!
ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.3 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=newsid=20110816 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.1.3id=3 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Database Workbench 4.1.3, the multi-DBMS IDE now available!
No SQLite support? http://www.sqlite.org/ Seems curious you wouldn't have this yet, especially given its popularity on both embedded systems and Android to say the least. -Original Message- From: Martijn Tonies [mailto:m.ton...@upscene.com] Sent: Tuesday, August 16, 2011 6:56 AM To: mysql@lists.mysql.com Cc: firebird-to...@yahoogroups.com Subject: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available! ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.3 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=newsid=20110816 For a full list of fixes in this release, see: http://www.upscene.com/go/?go=trackerv=4.1.3id=3 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available!
ANN: Database Workbench 4.1.2, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.2 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. For more information, see http://www.upscene.com/go/?go=newsid=20110330 For a full list of fixes in 4.1 releases, see: http://www.upscene.com/go/?go=trackerv=4.1.2id=1 http://www.upscene.com/go/?go=trackerv=4.1.1id=1 http://www.upscene.com/go/?go=trackerv=4.1.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available!
ANN: Database Workbench 4.1.1, the multi-DBMS IDE now available! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.1 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. This release fixes a possible crash and some other issues. For more information, see http://www.upscene.com/go/?go=newsid=20110216 For a full list of fixes in version 4.1.1 and 4.1.0, see: http://www.upscene.com/go/?go=trackerv=4.1.1id=1 http://www.upscene.com/go/?go=trackerv=4.1.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.1.0, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.1.0 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.1.0 adds new features, latest DBMS support and improved functionality. For more information, see http://www.upscene.com/go/?go=newsid=20101224 For a full list of fixes in version 4.1.0 and previous versions, see: http://www.upscene.com/go/?go=trackerv=4.1.0id=1 http://www.upscene.com/go/?go=trackerv=4.0.3id=1 http://www.upscene.com/go/?go=trackerv=4.0.2id=1 http://www.upscene.com/go/?go=trackerv=4.0.1id=1 http://www.upscene.com/go/?go=trackerv=4.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - XE ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10, 11 and 12 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: Database Workbench 4.0.3, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0.3 Pro This release includes the FREE Lite versions for InterBase, Firebird and MySQL. Version 4 introduced full Unicode support, 4.0.3 fixes some issues found in that initial release and subsequent releases, including the Query was empty-error in some parts of the MySQL module. There have been numerous improvements to existing tools and the user interface making it even better than before. For more information, see http://www.upscene.com/ For a full list of fixes in version 4.0.3 and previous versions, see: http://www.upscene.com/go/?go=trackerv=4.0.3id=1 http://www.upscene.com/go/?go=trackerv=4.0.2id=1 http://www.upscene.com/go/?go=trackerv=4.0.1id=1 http://www.upscene.com/go/?go=trackerv=4.0id=1 Database Workbench supports: - Borland InterBase ( 4.x - 9.x ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10 and 11 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: New version of Database Workbench, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: Database Workbench 4.0 Pro With this version we're reached a milestone: Database Workbench is now fully Unicode enabled and offers new tools to increase your productivity. There have been numerous improvements to existing tools and the user interface making it even better than before. For more information, see http://www.upscene.com/ Database Workbench supports: - Borland InterBase ( 4.x - 9.x ) - Firebird ( 1.x, 2.x ) - MS SQL Server/MSDE ( 7, 2000, 2005, 2008, MSDE 1 2, SQL Express ) - MySQL 4.x, 5.x - Oracle Database ( 8i, 9i, 10g, 11g ) - Sybase SQL Anywhere ( 9, 10 and 11 ) - NexusDB ( 3.0 and up ) Thank you for your support, Martijn Tonies Database Workbench - the database developer tool for professionals Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: IDE
Hello Mosaed, Can you contact me personally? Is any of the e-mails coming through to you? Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed With regards, Martijn Tonies Upscene Productions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: IDE
Hello Mosaed, Can you contact me personally? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: IDE
Hi. This is a good choice! On Tue, Jun 23, 2009 at 5:53 PM, Janek Bogucki janek.bogu...@studylink.comwrote: Have you tried SQL Developer? It works great with Oracle and also supports MySQL, http://www.oracle.com/technology/products/database/sql_developer/files/what_is_sqldev.html Cheers, -Janek On Tue, 2009-06-09 at 19:40 +0300, Mosaed zamil wrote: Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yueliangdao0...@gmail.com -- David Yeung, MySQL Senior Support Engineer, Sun Gold Partner. My Blog:http://yueliangdao0608.cublog.cn
Re: IDE
Have you tried SQL Developer? It works great with Oracle and also supports MySQL, http://www.oracle.com/technology/products/database/sql_developer/files/what_is_sqldev.html Cheers, -Janek On Tue, 2009-06-09 at 19:40 +0300, Mosaed zamil wrote: Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: IDE - Toad
I was skeptical of a tool with a goofy name like Toad and the website looks like absolute 1992 ass, so it didn't give me a solid and professional impression. Then a DBA here at work mentioned it and I had to give him a chance to speak and convince me... Well, after a few minutes of a demonstration, I have to say I was impressed. It is far more feature rich than I expected and blows away the crappy mySQL Workbench (and the other free tools they offer). I'm not sure if it is better than SQLYog Enterprise, but they are certainly the two front-runners in my book now. -Original Message- From: Jason Trebilcock [mailto:jason.trebilc...@gmail.com] Sent: Wednesday, June 10, 2009 12:04 PM To: mysql@lists.mysql.com Subject: Re: IDE - SQLYog I think we've got almost all of the big ones listed. To complete the list (or at least grow the list by one), let me offer up Toad for MySQL: http://www.toadsoft.com/toadmysql/Overview.htm On Tue, Jun 9, 2009 at 8:57 PM, Daevid Vincent SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not even a question. I've used them all I think. http://webyog.com/en/ There's even a free community version, but honestly it's worth purchasing the extended one for all the added features. They also release new ones all the time so it's very actively developed. http://daevid.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: IDE - SQLYog
I've been using phpmyadmin as a MySQL GUI for some time and worked great for me. www.*phpmyadmin*.net Isart On Tue, Jun 9, 2009 at 8:57 PM, Daevid Vincent dae...@daevid.com wrote: SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not even a question. I've used them all I think. http://webyog.com/en/ There's even a free community version, but honestly it's worth purchasing the extended one for all the added features. They also release new ones all the time so it's very actively developed. http://daevid.com -Original Message- From: Mosaed zamil [mailto:mzamils...@gmail.com] Sent: Tuesday, June 09, 2009 9:41 AM To: mysql@lists.mysql.com Subject: IDE Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=isart.mont...@gmail.com
Re: IDE - SQLYog
I think we've got almost all of the big ones listed. To complete the list (or at least grow the list by one), let me offer up Toad for MySQL: http://www.toadsoft.com/toadmysql/ On Wed, Jun 10, 2009 at 1:55 PM, Isart Montane isart.mont...@gmail.comwrote: I've been using phpmyadmin as a MySQL GUI for some time and worked great for me. www.*phpmyadmin*.net Isart On Tue, Jun 9, 2009 at 8:57 PM, Daevid Vincent dae...@daevid.com wrote: SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not even a question. I've used them all I think. http://webyog.com/en/ There's even a free community version, but honestly it's worth purchasing the extended one for all the added features. They also release new ones all the time so it's very actively developed. http://daevid.com -Original Message- From: Mosaed zamil [mailto:mzamils...@gmail.com] Sent: Tuesday, June 09, 2009 9:41 AM To: mysql@lists.mysql.com Subject: IDE Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=isart.mont...@gmail.com
IDE
Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed
RE: IDE - SQLYog
SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not even a question. I've used them all I think. http://webyog.com/en/ There's even a free community version, but honestly it's worth purchasing the extended one for all the added features. They also release new ones all the time so it's very actively developed. http://daevid.com -Original Message- From: Mosaed zamil [mailto:mzamils...@gmail.com] Sent: Tuesday, June 09, 2009 9:41 AM To: mysql@lists.mysql.com Subject: IDE Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql and onboard ide raid
On Mon, Feb 18, 2002 at 03:05:09PM -0500, Andrew Crum wrote: As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I would _highly_ recommend a journaling filesystem such as Reiserfs (http://www.namesys.com) or XFS (http://oss.sgi.com). You do know that ext3 is journaling, right? I've used reiserfs for a long time, but XFS is growing on me. It seems to be more stable in latest 2.4 kernels. More stable that what? Old kernels? Or ReiserFS? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 17 days, processed 555,986,038 queries (359/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and onboard ide raid
As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I would _highly_ recommend a journaling filesystem such as Reiserfs (http://www.namesys.com) or XFS (http://oss.sgi.com). I've used reiserfs for a long time, but XFS is growing on me. It seems to be more stable in latest 2.4 kernels. I don't know the reason for this. I'd refer people to http://www.linuxjournal.com//article.php?sid=5840 Although that article talks about Oracle, we also found ext3 for mysql data disks to be the best choice from our own experience. Reiserfs jams with lots of small files though; useful when compiling (mysql source for example) or for a webserver. Actually, I like it for everything but the mysql data dir. Is it better to take Raid level 1 or 0 ? RAID 0 or RAID 0+1 with a lot of disks makes a huge speed difference under load. SQL server speed (trx/s) can correlate to the rotational speed of the disks once the server is disk bound. RAID 0 lets you increase the effective speed of the virtual drive by summing the speed of the disks (roughly). I have no experience with IDE RAID though. SCSI still outperforms and likely always will. Sincerely, Steven Roussey http://Network54.com/?pp=e sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL PHP Development IDE
This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL PHP Development IDE
His interest lies not so much in using for database table modeling, but for PHP and Perl development. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? I've just finished using Quanta+ for doing a fairly small PHP frontend to a MySQL database. I didn't choose this for any reason other than it got installed on the Suse-based laptop I was using. Got to say though, it's pretty slick (syntax highlighting, inbuilt docs, inbuilt preview, etc) - and best of all free from Sourceforge. However, since I'm now getting more into the web development, (heck I quite like PHP!), side of things I'm now thinking of spending the USD49.99 (CD version, download-only is USD10 cheaper) and getting the uprated version - Quanta Gold - from TheKompany. Certainly the feature list and screenshots look good. To me, USD500 sounds an awful lot of money for a 'mere' PHP/Perl editor. The cynic in me would wonder if it's not overkill. I used to do all my PHP and Perl stuff just using the appropriate modes in Xemacs which is free. Xemacs doesn't have the nice inbuilt docs and project handling that Quanta does though. Just my personal opinion above. Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL PHP Development IDE
This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. If he's not really that interested in the mysql integration than I would say that you could probably go with a different IDE. PHPed's db integration and built-in php debugger are about the only two things that set it apart from other IDE's. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Before you make a commitment, you can apply for a trial version of PHPed. You have to give them real contact information, (I think I've gotten like 5 sales-pitch emails since I downloaded my free trial 3 months ago.) So you can give it a shot before you buy... and at $500 you should probably try it first. As for feedback on experience with the editor: When you try to install the editor (at least this was what it did three months ago) It wants to install it's own copies of Apache and MySQL. kind of un-handy if you've got current installs you want to use. I think it gave you the option to keep your own, but after I got everything installed, the database integration wouldn't work. So I decided that I had free time on my hands, I hosed my installs of apache and mysql and let it install it's own stuff. after that I still couldn't get it to work properly. I probably could have tweeked something here or there and gotten everything to go, but my reaction was kind of like.. I'm going to pay $300 to have to play with it this much to get it to work? It just didn't seem worth it Given that I currently used allaire's homesite and the only things that PHPed had over that in features was the db integration and php debugger, and I had already worked out my own solutions to those problems. I recommend downloading the trial version before you buy. I also recommend downloading the trial version of homesite as well. Homesite gives you syntax highlighting, project management, web deployment. scriptable deployment wich lets you decide what gets sent, where it gets put etc... all in a script that you can re-run. Plus homesite let's you edit the ide to add in features that you may need (http://www.macromedia.com/software/homesite/) Or look into Quanta depending on what platform you plan on developing on. I found it ironic that if you buy PHPed standard, it only runs on windows platforms, and that if you decided to buy PHP advantage, then you get linux support. seems like it should be the other way around given that the product they are trying to sell was built on the back of Open Source technologies. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL PHP Development IDE
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is pretty good. It creates PHP scripts that manipulate MySQL databases. It is free and allows comparable functionality to the 'native' UltraDev languages (ASP, JSP, Cold Fusion). For more info - http://www.interakt.ro/products/PHAkt/ -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: 21 February 2002 14:58 To: 'Joel Wickard'; [EMAIL PROTECTED] Subject: RE: MySQL PHP Development IDE There is three options I use: 1. Macromedia Dreamweaver UltraDev4 with a PHP plugin or extension 2. PHPEdit, its free I forget the website. ItÂ’s a good IDE, but kinda annoying editor. 3. Notepad -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: Re: MySQL PHP Development IDE This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. If he's not really that interested in the mysql integration than I would say that you could probably go with a different IDE. PHPed's db integration and built-in php debugger are about the only two things that set it apart from other IDE's. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Before you make a commitment, you can apply for a trial version of PHPed. You have to give them real contact information, (I think I've gotten like 5 sales-pitch emails since I downloaded my free trial 3 months ago.) So you can give it a shot before you buy... and at $500 you should probably try it first. As for feedback on experience with the editor: When you try to install the editor (at least this was what it did three months ago) It wants to install it's own copies of Apache and MySQL. kind of un-handy if you've got current installs you want to use. I think it gave you the option to keep your own, but after I got everything installed, the database integration wouldn't work. So I decided that I had free time on my hands, I hosed my installs of apache and mysql and let it install it's own stuff. after that I still couldn't get it to work properly. I probably could have tweeked something here or there and gotten everything to go, but my reaction was kind of like.. I'm going to pay $300 to have to play with it this much to get it to work? It just didn't seem worth it Given that I currently used allaire's homesite and the only things that PHPed had over that in features was the db integration and php debugger, and I had already worked out my own solutions to those problems. I recommend downloading the trial version before you buy. I also recommend downloading the trial version of homesite as well. Homesite gives you syntax highlighting, project management, web deployment. scriptable deployment wich lets you decide what gets sent, where it gets put etc... all in a script that you can re-run. Plus homesite let's you edit the ide to add in features that you may need (http://www.macromedia.com/software/homesite/) Or look into Quanta depending on what platform you plan on developing on. I found it ironic that if you buy PHPed standard, it only runs on windows platforms, and that if you decided to buy PHP advantage, then you get linux support. seems like it should be the other way around given that the product they are trying to sell was built on the back of Open Source technologies. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http
RE: MySQL PHP Development IDE
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is pretty good. It creates PHP scripts that manipulate MySQL databases. It is free and allows comparable functionality to the 'native' UltraDev languages (ASP, JSP, Cold Fusion). For more info - http://www.interakt.ro/products/PHAkt/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL PHP Development IDE
At 06:37 AM 2/21/2002 , you wrote: This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Gerald Jensen Gerald, I tried PHPEd from NuSphere and it only partially worked. I spent a lot of time trying to get it to work properly and failed. :( I tried 4 or 5 different PHP debuggers and I didn't like any of them. Not being one to give up easily, I kept looking. I found an excellent PHP debugger and editor from https://sourceforge.net/projects/dbg2/. It took a little while getting it installed because there are no docs, but I've been using it for a month and couldn't be happier. The author Dmitri has borrowed a lot of ideas from the Delphi IDE so using it is quite intuitive. I use it as my main PHP editor. It is also faster than any other PHP debugger I've tried (there are no annoying delays or screen flashes when single stepping through the PHP code) and it can also debug into Include files which other debuggers may not be able to do. It can also display Local, Global, Call Stack, Watch, Immediate, Breakpoint windows at the bottom of the screen. It can also display arrays and all class object properties which is very cool. All in all, it's a great PHP editor/debugger. There are versions for Windows (which is what I'm using), BSD and Linux. You also get the source code for it and you'll definitely like the price. It's free. :-) Brent If you have a problem setting it up, shoot me off an email and I'll see what I can do. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL PHP Development IDE
Thanks for the advice ... I'll take a look at dbg2 ... if I get stuck, I'll shoot you a plea for help! Gerald Jensen -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 9:38 AM To: Gerald R. Jensen Cc: [EMAIL PROTECTED] Subject: Re: MySQL PHP Development IDE At 06:37 AM 2/21/2002 , you wrote: This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Gerald Jensen Gerald, I tried PHPEd from NuSphere and it only partially worked. I spent a lot of time trying to get it to work properly and failed. :( I tried 4 or 5 different PHP debuggers and I didn't like any of them. Not being one to give up easily, I kept looking. I found an excellent PHP debugger and editor from https://sourceforge.net/projects/dbg2/. It took a little while getting it installed because there are no docs, but I've been using it for a month and couldn't be happier. The author Dmitri has borrowed a lot of ideas from the Delphi IDE so using it is quite intuitive. I use it as my main PHP editor. It is also faster than any other PHP debugger I've tried (there are no annoying delays or screen flashes when single stepping through the PHP code) and it can also debug into Include files which other debuggers may not be able to do. It can also display Local, Global, Call Stack, Watch, Immediate, Breakpoint windows at the bottom of the screen. It can also display arrays and all class object properties which is very cool. All in all, it's a great PHP editor/debugger. There are versions for Windows (which is what I'm using), BSD and Linux. You also get the source code for it and you'll definitely like the price. It's free. :-) Brent If you have a problem setting it up, shoot me off an email and I'll see what I can do. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql and onboard ide raid
Hello, I am using a Gigabyte GA7DXR board with an onboard raid controller Ultra 100 from Promise. Now I would like to connect some old 15 GB disks to this controller. 2 or 4 disks are possible. On the raid I would like to have a mysql database with around 5 GB. The system should operate under linux 2.4. The board is able to run Raid level 0 with 4 or 2 disks and raid level 1 with 2 disks. It won't be a big problem if the system crashes after a few month. In general my harddisks were running over years without Raid. Is it better to take Raid level 1 or 0 ? If raid level 0, should I use 2 or 4 disks ? Are both raid-levels running stable in the daily usage ? Is the performance an really important point to choose a special raid level ? Should I use ext2, ext3 or an other filesystem ? Many thanks for your tips Matthias Jaekle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and onboard ide raid
I am using a Gigabyte GA7DXR board with an onboard raid controller Ultra 100 from Promise. Now I would like to connect some old 15 GB disks to this controller. 2 or 4 disks are possible. On the raid I would like to have a mysql database with around 5 GB. The system should operate under linux 2.4. The board is able to run Raid level 0 with 4 or 2 disks and raid level 1 with 2 disks. First make sure that your IDE-raid works reliably. I've had problems with ide-raid under linux in the past. Things may have changed now, but seriouslydo a thorough filesystem strain test. It won't be a big problem if the system crashes after a few month. In general my harddisks were running over years without Raid. Is it better to take Raid level 1 or 0 ? If raid level 0, should I use 2 or 4 disks ? Are both raid-levels running stable in the daily usage ? Is the performance an really important point to choose a special raid level ? Should I use ext2, ext3 or an other filesystem ? RAID 0 is won't give you much. If you have (2) 15 GB disk, you will now have a 30 GB disk slightly faster with striping, but you won't notice the difference with ide-disks. RAID 1 is mirroring. It's expensive because for every 15 GB disk you have, you must have another 15 GB disk to mirror it (you can use a smaller disk, say 10 GB, but your capacity will be 10 GB). You could use RAID 10. It's a hybrid of RAID 0 and RAID 1. Let's say you have (4) 15 GB disks. You could use concatenate the first two (RAID 0) to make a 30 GB, concatenate the other two to make another 30 GB, then you mirror the first 30GB to the second 30GB. This setup _requires_ a minimum of 4 disks. It's the most expensive, but it offeres the best speed and reliabilty in case of a failure. If one disk fails, just replace the disk and your RAID controller should automatically do its business in the background while your database is chugging away. Whereas RAID-5 you would have to wait _forever_ for the array to be reconstructed. RAID 10 probably won't be a specific option for your RAID controller, it will just be called RAID-1 with striping or something like that. As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I would _highly_ recommend a journaling filesystem such as Reiserfs (http://www.namesys.com) or XFS (http://oss.sgi.com). I've used reiserfs for a long time, but XFS is growing on me. It seems to be more stable in latest 2.4 kernels. Cheers, Andrew Crum [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SCSI vs IDE
Hi This is not an atempt to start a flamewar!! We're about to build a db server for educational purposes. Running 150+ databases pr. semester. Nothing big, nothing demanding when looking at a single database, but combined it may give some load (might be a lot of concurrent activity during classes, none afterwords, etc). Back to the question: we're on a limited budget, and have to choose between either inexpensive but large IDE disk or fast but small SCSI disks. The machine has 1GB memory. First thought would be IDE disks since we have enough memory to cache the DBs. Question: Does a write transaction in mysql wait for the disk to actually write the data onto the platter (thereby eliminating our cache), or doesn't it care about the data hitting the disk before returning (leaving it to the OS)? If it's the first we might opt for SCSI, if it's the latter we'll go for IDE. Thanks for your time. Regards Thomas, Denmark -- Webmaster and Systemprogrammer at * http://www.dina.kvl.dk/~thomassi/ Department of Mathematics and Physics * [EMAIL PROTECTED] Royal Veterinary and Agricultural University* Tel. +45 3528 2343 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SCSI vs IDE
Thomas S. Iversen wrote: Back to the question: we're on a limited budget, and have to choose between either inexpensive but large IDE disk or fast but small SCSI disks. The machine has 1GB memory. First thought would be IDE disks since we have enough memory to cache the DBs. If you're on a budget, check out some of the IDE RAID options. You can build a RAID 0 using a fairly cheap card (I would have suggested a MB with RAID 0, but you probably already have one without). Promise's SuperTrak SX 6000 will also do RAID 0, 1, 0+1, 3, 5 and JBOD on six disks with up to 128 MB cache (you buy one $20 SDRAM chip), but it is a bit pricier at ~$450. You can save your money by getting multiple $100 IDE drives. Do NOT get the SuperTrak 100, it is almost as slow as one drive in RAID 5. Anyone actually have experience running MySQL on a large-ish IDE RAID? Frank. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SCSI vs IDE
I'd say that if your database can fit on the SCSI drive you can afford, there is no reason for not choosing SCSI. Or, hec, if it's a really small database, why not ramdist? In regard to your question about whether it confirms a write before commiting a transaction. First of all, check to see if there are any notes about MySQL's behavior on your platform: http://www.mysql.com/doc/O/p/Operating_System_Specific_Notes.html you can also refer to the optimization guide. http://www.mysql.com/doc/M/y/MySQL_Optimisation.html I don't _think_ it checks to make sure the write actually happens before confirming the transaction, but I'm not certain. On Tuesday 20 November 2001 08:52 am, Thomas S. Iversen wrote: Hi This is not an atempt to start a flamewar!! We're about to build a db server for educational purposes. Running 150+ databases pr. semester. Nothing big, nothing demanding when looking at a single database, but combined it may give some load (might be a lot of concurrent activity during classes, none afterwords, etc). Back to the question: we're on a limited budget, and have to choose between either inexpensive but large IDE disk or fast but small SCSI disks. The machine has 1GB memory. First thought would be IDE disks since we have enough memory to cache the DBs. Question: Does a write transaction in mysql wait for the disk to actually write the data onto the platter (thereby eliminating our cache), or doesn't it care about the data hitting the disk before returning (leaving it to the OS)? If it's the first we might opt for SCSI, if it's the latter we'll go for IDE. Thanks for your time. Regards Thomas, Denmark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C IDE for Windows...........?
Hi... I'm new to MySQL. I can play it by ODBC connectivity using JDBC-ODBC bridge. But I want to write code in C using MySQL native C-APIs. One reason for me to switch to MySQL is its C-APIs. I've been using Borland Turbo C/C++ 3.0 for a long time on DOS/Windows OS. When I try to include MySQL headers, it throws errors...which I guess is the problem of long header file names (not complaint with DOS 8.3 file name convention). I'm in search of an IDE that can support MySQL and that should not be much different from the one I'm used to. Could anybody help me out Cheers.. Ali - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C IDE for Windows...........?
Hi At 10:46 12/11/2001 +, Syed Ali Dost wrote: Hi... I'm new to MySQL. I can play it by ODBC connectivity using JDBC-ODBC bridge. But I want to write code in C using MySQL native C-APIs. One reason for me to switch to MySQL is its C-APIs. I've been using Borland Turbo C/C++ 3.0 for a long time on DOS/Windows OS. When I try to include MySQL headers, it throws errors...which I guess is the problem of long header file names (not complaint with DOS 8.3 file name convention). I'm in search of an IDE that can support MySQL and that should not be much different from the one I'm used to. Could anybody help me out #include windows.h before #include mysql.h Cheers.. Ali - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
IDE-RAID QUESTION
Hi all, I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I would like to know if there is any beneficials running MySQL over IDE-RAID and is there any configuration I need to optimize MySQL to utilize the RAID?? All helps/suggestions are greatly appreciated. Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: IDE-RAID QUESTION
On 19 Sep 2001 12:25:35 -0700, Michael Tam wrote: Hi all, I realize IDE-RAID is relatively micky mouse to those SCSI-RAID but I would like to know if there is any beneficials running MySQL over IDE-RAID and is there any configuration I need to optimize MySQL to utilize the RAID?? RAID by itself doesn't mean much. You prorably have to define which exact RAID level you mean. Raid0 (striping), raid1 (mirroring), other raids? Of course, RAID0 can give double speed on whatever disks, RAID1 gives redundancy, and so on. RAIDx is usually right thing to go. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
scsi vs ide performance on fsync's
Hi! "Jeremy" == Jeremy Hansen [EMAIL PROTECTED] writes: Jeremy We're doing some mysql benchmarking. For some reason it seems that ide Jeremy drives are currently beating a scsi raid array and it seems to be related Jeremy to fsync's. Bonnie stats show the scsi array to blow away ide as Jeremy expected, but mysql tests still have the idea beating on plain insert Jeremy speeds. Can anyone explain how this is possible, or perhaps explain how Jeremy our testing may be flawed? Jeremy Here's the bonnie stats: Jeremy IDE Drive: Jeremy Version 1.00g --Sequential Output-- --Sequential Input- --Random- Jeremy -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- Jeremy MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP Jeremy jeremy 300M 9026 94 17524 12 8173 9 7269 83 23678 7 102.9 0 Jeremy --Sequential Create-- Random Create Jeremy -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- Jeremy files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP Jeremy 16 469 98 1476 98 16855 89 459 98 7132 99 688 25 Jeremy SCSI Array: Jeremy Version 1.00g --Sequential Output-- --Sequential Input- --Random- Jeremy -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- Jeremy MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP Jeremy orville300M 8433 100 134143 99 127982 99 8016 100 374457 99 1583.4 6 Jeremy --Sequential Create-- Random Create Jeremy -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- Jeremy files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP Jeremy 16 503 13 + +++ 538 13 490 13 + +++ 428 11 Jeremy So...obviously from bonnie stats, the scsi array blows away the ide...but Jeremy using the attached c program, here's what we get for fsync stats using the Jeremy little c program I've attached: Jeremy IDE Drive: Jeremy jeremy:~# time ./xlog file.out fsync Jeremy real0m1.850s Jeremy user0m0.000s Jeremy sys 0m0.220s Jeremy SCSI Array: Jeremy [root@orville mysql_data]# time /root/xlog file.out fsync Jeremy real0m23.586s Jeremy user0m0.010s Jeremy sys 0m0.110s cut Couldn't the problem simply be that the SCSI array is caching things in RAM before writing to disk while the IDE disk isn't but is flushing things down to disk at once. The behaveour of the above would be that when you do a lot of read/write the SCSI would be much faster, as there is less read/writes involved, but flush would be slower as there is always unflushed data in the RAM. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scsi vs ide performance on fsync's
Hi! "Mike" == Mike Black [EMAIL PROTECTED] writes: Mike Here's a strace -r on IDE: Mike 0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000516 fdatasync(0x3)= 0 Mike 0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000513 fdatasync(0x3)= 0 Mike 0.001555 write(3, "\216\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000517 fdatasync(0x3)= 0 Mike 0.001494 write(3, "\217\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000515 fdatasync(0x3)= 0 Mike 0.001495 write(3, "\220\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000522 fdatasync(0x3)= 0 Mike Here it is on SCSI: Mike 0.049285 write(3, "\3\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000689 fdatasync(0x3)= 0 Mike 0.049148 write(3, "\4\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000516 fdatasync(0x3)= 0 Mike 0.049318 write(3, "\5\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike 0.000516 fdatasync(0x3)= 0 Mike 0.049343 write(3, "\6\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Mike Looks like a constant 50ms delay on each fdatasync() on SCSI vs .5ms for Mike IDE. Maybe IDE isn't really doing a sync?? I find .5ms to be a little too Mike good. I wonder from where the fdatasync() is comming; MySQL is not doing those (if you are not running mysqld with --flush) Mike I did this on 4 different machines with different SCSI cards (include RAID5 Mike and non-RAID), disks, and IDE drives with the same behavior. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: scsi vs ide performance on fsync's
Hello, Michael Widenius wrote on Monday, March 05, 2001: I wonder from where the fdatasync() is comming; MySQL is not doing those (if you are not running mysqld with --flush) The call is either a fsync or an fdatasync that is done by Berkley DB on the transaction log. Regards, Chris Delaney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scsi vs ide performance on fsync's
There is definitely something strange going on here. As the bonnie test below shows, the SCSI disk used for my tests should vastly outperform the old IDE one: ---Sequential Output ---Sequential Input-- --Random-- Seagate -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- ST318451LW MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU SCSI 200 21544 96.8 51367 51.4 11141 16.3 17729 58.2 40968 40.4 602.9 5.4 Quantum ---Sequential Output ---Sequential Input-- --Random-- Fireball -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- ST3.2A MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU IDE 200 3884 72.8 4513 86.0 1781 36.4 3144 89.9 4052 95.3 131.5 0.9 I used a program based on Mike Black's "Blah Blah" test (shown below) in which 200 write()+fdatasync()s are performed. Each write() outputs either 20 or 4096 bytes. On my Celeron 533 Mhz 128 MB ram hardware with an ext2 fs, the "block" size that is seen by the sd driver for each fdatasync() is 4096 bytes. lk 2.4.2 is being used. The fs/buffer.c __wait_on_buffer() routine waits for IO completion in response to fdatasync(). Timings have been done with Andrew Morton's timepegs (units are microseconds). Here are the IDE results: IDE 20*200 Destination Count Min Max Average Total enter __wait_on_buffer:0 - leave __wait_on_buffer:0 2001,037.23 6,487.72 1,252.19 250,439.80 leave __wait_on_buffer:0 - enter __wait_on_buffer:0 1997.32 21.05 7.821,557.05 IDE 4096*200 Destination Count Min Max Average Total enter __wait_on_buffer:0 - leave __wait_on_buffer:0 2001,037.06 7,354.21 1,243.78 248,756.64 leave __wait_on_buffer:0 - enter __wait_on_buffer:0 199 23.01 67.32 37.037,370.51 So the size of each transfer doesn't matter to this IDE disk. Now the same test for the SCSI disk: SCSI(20*200) Destination Count Min Max Average Total enter __wait_on_buffer:0 - enter sd_init_command:0 200 1.86 13.27 2.05 411.48 enter sd_init_command:0 - enter rw_intr:0 200320.87 5,398.56 3,417.30 683,461.25 enter rw_intr:0 - leave __wait_on_buffer:0 200 4.04 15.81 4.42 885.73 leave __wait_on_buffer:0 - enter __wait_on_buffer:0 199 8.78 14.39 9.261,844.23 SCSI(4096*200) Destination Count MinMax Average Total enter __wait_on_buffer:0 - enter sd_init_command:0 200 1.97 13.20 2.21 443.52 enter sd_init_command:0 - enter rw_intr:0 200109.53 13,997.50 1,327.47 265,495.87 enter rw_intr:0 - leave __wait_on_buffer:0 200 4.37 22.50 4.75 951.44 leave __wait_on_buffer:0 - enter __wait_on_buffer:0 199 22.40 42.20 24.274,831.34 The extra timepegs inside the SCSI subsystem show that the IO transaction to that disk really did take that long. [Initially I suspected a "plugging" type elevator bug, but that isn't supported by the above and various other timepegs not shown.] Since there is a wait on completion for every write, tagged queuing should not be involved. So writing more data to the SCSI disk speeds it up! I suspect the critical point in the "20*200" test is that the same sequence of 8 512 byte sectors are being written to disk 200 times. BTW That disk spins at 15K rpm so one rotation takes 4 ms and it has a 4 MB cache. Even though the SCSI disk's "cache" mode page indicates that the write cache is on, it would seem that writing the same sectors continually causes flushes to the medium (and hence the associated delay). Here is scu's output of the "cache" mode page: $ scu -f /dev/sda show page cache Cache Control Parameters (Page 0x8 - Current Values): Mode Parameter Header: Mode Data Length: 31 Medium Type: 0 (Default Medium Type) Device Specific Parameter: 0x10 (Supports DPO FUA bits) Block Descriptor Length: 8 Mode Parameter Block Descriptor: Density Code: 0x2 Number of Logical Blocks: 2289239 (1117.792 megabytes) Logical Block Length: 512 Page Header / Data: Page Code: 0x8 Parameters Savable: Yes Page Length: 18 Read Cache Disable (RCD): No Multiplication Factor (MF): Off Write Cache Enable (WCE): Yes Cache Segment Size Enable (SIZE): Off Discontinuity (DISC): On Caching Analysis Permitted (CAP): Disabled Abort Pre-Fetch (ABPF): Off Initiator Control Enable (IC): Off Write Retention Priority: 0 (Not distiguished) Demand Read Ret
Re: scsi vs ide performance on fsync's
Since the intention of fsync and fdatasync seems to be to write dirty fs buffers to persistent storage (i.e. the "oxide") then the best time is not necessarily the objective. Given the IDE times that people have been reporting, it is very unlikely that any of those IDE disks were really doing 2000 discrete IO operations involving waiting for the those buffers to be written to the "oxide". [Reason: it should take at least 2000 revolutions of the disk to do it, since most of the 4KB writes are going to the same disk address as the prior write.] As it stands, the Linux SCSI subsystem has no mechanism to force a disk cache write through. The SCSI WRITE(10) command has a Force Unit Access bit (FUA) to do exactly that, but we don't use it. Do the fs/block layers flag they wish buffers written to the oxide?? The measurements that showed SCSI disks were taking a lot longer with the "xlog" test were more luck than good management. Here are some tests that show an IDE versus SCSI "xlog" comparison are very similar between FreeBSD 4.2 and lk 2.4.2 on the same hardware: # IBM DCHS04U SCSI disk 7200 rpm FreeBSD 4.2 [root@free /var]# time /root/xlog tst.txt real0m0.043s [root@free /var]# time /root/xlog tst.txt fsync real 0m33.131s # Quantum Fireball ST3.2A IDE disk 3600 rpm FreeBSD 4.2 [root@free dos]# time /root/xlog tst.txt real0m0.034s [root@free dos]# time /root/xlog tst.txt fsync real0m5.737s # IBM DCHS04U SCSI disk 7200 rpm lk 2.4.2 [root@tvilling extra]# time /root/xlog tst.txt 0:00.00elapsed 125%CPU [root@tvilling spare]# time /root/xlog tst.txt fsync 0:33.15elapsed 0%CPU # Quantum Fireball ST3.2A IDE disk 3600 rpm lk 2.4.2 [root@tvilling /root]# time /root/xlog tst.txt 0:00.02elapsed 43%CPU [root@tvilling /root]# time /root/xlog tst.txt fsync 0:05.99elapsed 69%CPU Notes: FreeBSD doesn't have fdatasync() so I changed xlog to use fsync(). Linux timings were the same with fsync() and fdatasync(). The xlog program crashed immediately in FreeBSD; it needed some sanity checks on its arguments. One further note: I wrote: [snip] So writing more data to the SCSI disk speeds it up! I suspect the critical point in the "20*200" test is that the same sequence of 8 512 byte sectors are being written to disk 200 times. BTW That disk spins at 15K rpm so one rotation takes 4 ms and it has a 4 MB cache. A clarification: by "same sequence" I meant written to the same disk address. If the 4 KB lies on the same track, then a delay of one disk revolution would be expected before you could write the next 4 KB to the "oxide" at the same address. Doug Gilbert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
scsi vs ide performance on fsync's
We're doing some mysql benchmarking. For some reason it seems that ide drives are currently beating a scsi raid array and it seems to be related to fsync's. Bonnie stats show the scsi array to blow away ide as expected, but mysql tests still have the idea beating on plain insert speeds. Can anyone explain how this is possible, or perhaps explain how our testing may be flawed? Here's the bonnie stats: IDE Drive: Version 1.00g --Sequential Output-- --Sequential Input- --Random- -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP jeremy 300M 9026 94 17524 12 8173 9 7269 83 23678 7 102.9 0 --Sequential Create-- Random Create -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 469 98 1476 98 16855 89 459 98 7132 99 688 25 SCSI Array: Version 1.00g --Sequential Output-- --Sequential Input- --Random- -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP orville300M 8433 100 134143 99 127982 99 8016 100 374457 99 1583.4 6 --Sequential Create-- Random Create -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 503 13 + +++ 538 13 490 13 + +++ 428 11 So...obviously from bonnie stats, the scsi array blows away the ide...but using the attached c program, here's what we get for fsync stats using the little c program I've attached: IDE Drive: jeremy:~# time ./xlog file.out fsync real0m1.850s user0m0.000s sys 0m0.220s SCSI Array: [root@orville mysql_data]# time /root/xlog file.out fsync real0m23.586s user0m0.010s sys 0m0.110s I would appreciate any help understand what I'm seeing here and any suggestions on how to improve the performance. The SCSI adapter on the raid array is an Adaptec 39160, the raid controller is a CMD-7040. Kernel 2.4.0 using XFS for the filesystem on the raid array, kernel 2.2.18 on ext2 on the IDE drive. The filesystem is not the problem, as I get almost the exact same results running this on ext2 on the raid array. Thanks -jeremy -- this is my sig. #include stdio.h #include string.h #include stdlib.h #include unistd.h #include fcntl.h struct Entry { int count; char string[50]; }; int main(int argc, char **argv) { int fd; struct Entry *trans; int x; if((fd = creat(argv[1], 0666)) == -1) { printf("Could not open file %s\n", argv[1]); return 1; } for(x=0; x 2000; ++x) { trans = malloc(sizeof(struct Entry)); trans-count = x; strcpy(trans-string, "Blah Blah Blah Blah Blah Blah Blah"); if(strcmp(argv[2],"fsync")== 0) { write(fd, (char *)trans, sizeof(struct Entry)); if(fdatasync(fd) != 0) { perror("Error"); } } else { write(fd, (char *)trans, sizeof(struct Entry)); } free(trans); } close(fd); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scsi vs ide performance on fsync's
This is just a guess - I have significant experience of Scsi drives but none of Unix internals. To do a good sync, you have to force the data from the CPU to the disk, and from the disk ram onto the disk oxide. IDE disks are not very clever, and I do not think that they cache unwritten data. If, therefore, the data has left the CPU, it will have hit the oxide. Scsi disks, however, play considerable tricks, which may include delayed writeback. If I were writing a Scsi disk drive, I would be strongly tempted to put a Scsi Rezero command into the sync operation. This has the effect of flushing all cached data to disk - amongst other things. It is the "amongst other things" which is the catch. Some disk manufacturers just do a simple reset of the disk's seek logic, which would only take a few milliseconds. Others treat a Rezero command as an instruction to do a full thermal recalibrate, which may take 250 milliseconds. This means that drivers tested on one brand of disk will show essentially no performance hit from doing a sync with Rezero, whilst a different brand would show a collossal hit. Yours appears to fall between the two extremes. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: scsi vs ide performance on fsync's
Here's a strace -r on IDE: 0.001488 write(3, "\214\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000516 fdatasync(0x3)= 0 0.001530 write(3, "\215\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000513 fdatasync(0x3)= 0 0.001555 write(3, "\216\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000517 fdatasync(0x3)= 0 0.001494 write(3, "\217\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000515 fdatasync(0x3)= 0 0.001495 write(3, "\220\1\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000522 fdatasync(0x3)= 0 Here it is on SCSI: 0.049285 write(3, "\3\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000689 fdatasync(0x3)= 0 0.049148 write(3, "\4\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000516 fdatasync(0x3)= 0 0.049318 write(3, "\5\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 0.000516 fdatasync(0x3)= 0 0.049343 write(3, "\6\0\0\0Blah Blah Blah Blah Blah Bla"..., 56) = 56 Looks like a constant 50ms delay on each fdatasync() on SCSI vs .5ms for IDE. Maybe IDE isn't really doing a sync?? I find .5ms to be a little too good. I did this on 4 different machines with different SCSI cards (include RAID5 and non-RAID), disks, and IDE drives with the same behavior. Michael D. Black Principal Engineer [EMAIL PROTECTED] 321-676-2923,x203 http://www.csihq.com Computer Science Innovations http://www.csihq.com/~mike My home page FAX 321-676-2355 - Original Message - From: "Jeremy Hansen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 02, 2001 11:27 AM Subject: scsi vs ide performance on fsync's We're doing some mysql benchmarking. For some reason it seems that ide drives are currently beating a scsi raid array and it seems to be related to fsync's. Bonnie stats show the scsi array to blow away ide as expected, but mysql tests still have the idea beating on plain insert speeds. Can anyone explain how this is possible, or perhaps explain how our testing may be flawed? Here's the bonnie stats: IDE Drive: Version 1.00g --Sequential Output-- --Sequential Input- --Random- -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP jeremy 300M 9026 94 17524 12 8173 9 7269 83 23678 7 102.9 0 --Sequential Create-- Random Create -Create-- --Read--- -Delete-- -Create-- --Read--- -Delet e-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 469 98 1476 98 16855 89 459 98 7132 99 688 25 SCSI Array: Version 1.00g --Sequential Output-- --Sequential Input- --Random- -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- MachineSize K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP orville300M 8433 100 134143 99 127982 99 8016 100 374457 99 1583.4 6 --Sequential Create-- Random Create -Create-- --Read--- -Delete-- -Create-- --Read--- -Delet e-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 503 13 + +++ 538 13 490 13 + +++ 428 11 So...obviously from bonnie stats, the scsi array blows away the ide...but using the attached c program, here's what we get for fsync stats using the little c program I've attached: IDE Drive: jeremy:~# time ./xlog file.out fsync real0m1.850s user0m0.000s sys 0m0.220s SCSI Array: [root@orville mysql_data]# time /root/xlog file.out fsync real0m23.586s user0m0.010s sys 0m0.110s I would appreciate any help understand what I'm seeing here and any suggestions on how to improve the performance. The SCSI adapter on the raid array is an Adaptec 39160, the raid controller is a CMD-7040. Kernel 2.4.0 using XFS for the filesystem on the raid array, kernel 2.2.18 on ext2 on the IDE drive. The filesystem is not the problem, as I get almost the exact same results running this on ext2 on the raid array. Thanks -jeremy -- this is my sig. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php