[ANN] [Qt ORM] QxOrm 1.4.5 and QxEntityEditor 1.2.3 released : support MongoDB database and code source now on GitHub
Hello, *QxOrm library 1.4.5* and *QxEntityEditor application 1.2.3* just released : https://www.qxorm.com/ *QxOrm library 1.4.5 changes log :* * - Support MongoDB database : QxOrm library becomes a C++/Qt Object Document Mapper ODM library !- For more details about MongoDB integration, see QxOrm manual (https://www.qxorm.com/qxorm_en/manual.html#manual_95 <https://www.qxorm.com/qxorm_en/manual.html#manual_95>) and new sample project available in ./test/qxBlogMongoDB/ directory- QxOrm library is now available on GitHub (official repository) : https://github.com/QxOrm/QxOrm <https://github.com/QxOrm/QxOrm>- Fix an issue in qx::IxSqlQueryBuilder class when QxOrm library is used in a multi-thread environment- Support latest version of boost (1.66)- Update boost portable binary serialization classes to version 5.1 (provided by https://archive.codeplex.com/?p=epa <https://archive.codeplex.com/?p=epa>)- Fix an issue building SQL query for Oracle database (doesn't support AS keyword for table alias)- Improve qx::QxClassX::registerAllClasses() function : possibility to initialize all relations (useful to work with introspection engine)- Improve qx::IxPersistable interface : provide new methods toJson() / fromJson()- Improve documentation/website : change http://www.qxorm.com <http://www.qxorm.com/> by https://www.qxorm.com <http://www.qxorm.com/> everywhere- Fix fetching relations with soft delete putting SQL condition in the JOIN part instead of WHERE part- Fix SQL generator for Oracle database : use new limit/pagination syntax (version Oracle > 12.1)- Improve SQL generator interface : add 'onBeforeSqlPrepare()' method to modify/log SQL queries in custom classes- Add an option in qx::QxSqlDatabase class to format SQL query (pretty-printing) before logging it (can be customized creating a qx::dao::detail::IxSqlGenerator sub-class)- Fix an issue with boost/std::optional (to manage NULL database values) and some databases : if optional is empty, then create a NULL QVariant based on QVariant::Type- Add an option in qx::QxSqlDatabase class to insert square brackets (or any other delimiters) in SQL queries for table name and/or column name (to support specific database keywords)- Improve introspection engine : add getType() method in qx::IxDataMember interface to get C++ type of a property dynamically- Improve qx::QxSqlDatabase singleton settings class to make easier working with several databases : now there are 3 levels of settings : global >> per thread >> per database (see 'bJustForCurrentThread' and 'pJustForThisDatabase' optional parameters in all set() methods)- Fix QxOrm.pri for MinGW compiler on Windows : an issue could occurred to export some symbols from shared library (some Qt signals for example)- Add an option in qx::QxSqlDatabase singleton class to display only slow SQL queries (see setTraceSqlOnlySlowQueriesDatabase() and setTraceSqlOnlySlowQueriesTotal() methods)* *QxEntityEditor application 1.2.3 changes log :* *- Fix a crash which appears sometimes with complex database schema to draw relationships (orthogonal way)- Improve QxEntityEditor command line parameters : possibility to import/export without using GUI (useful to manage a Jenkins server for example)- For more details about command line parameters, go to QxEntityEditor documentation : https://www.qxorm.com/qxorm_en/manual_qxee.html#qxee_command_line <https://www.qxorm.com/qxorm_en/manual_qxee.html#qxee_command_line>* You can download latest version of QxOrm library and QxEntityEditor application on QxOrm website : https://www.qxorm.com/ Regards, Lionel Marty - QxOrm library
ANN: Database Workbench 5.2 now includes PostgreSQL support
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2 " This release includes support for PostgreSQL and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB connections. The most recent version adds support for PostgreSQL, as requested by many of our customers." For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
mysqld_multi doesn't support !include or !includedir directives
Hi, I try to use !includedir directive with mysqld_multi for load other option files but nothing is loaded by mysql. In the default my.cnf, I have only the includedir directive for my configuration directory : !includedir /etc/my.cnf.d And in /etc/my.cnf.d/mysql3306.cnf I have : [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin user = toto password = toto log= /var/log/mysqld_multi.log [mysqld3306] port = 3306 socket = /var/lib/mysql_3306/mysql.sock pid-file = /var/lib/mysql_3306/test.pid datadir = /var/lib/mysql_3306 tmpdir = /tmp user = mysql mysqld = /usr/sbin/mysqld log-error= /var/lib/mysql_3306/test.err But mysqld_multi doesn't not load mysql3306.cnf file. # service mysqld_multi report Reporting MySQL servers No groups to be reported (check your GNRs) Whereas # my_print_defaults --defaults-file=/etc/my.cnf mysqld3306 --port=3306 --socket=/var/lib/mysql_3306/mysql.sock --pid-file=/var/lib/mysql_3306/test.pid --datadir=/var/lib/mysql_3306 --tmpdir=/tmp --user=mysql I found the Bug #29327 dated 2007 but without fix. I use mysqld_multi log file version 2.16 and MySQL 5.6.24 on CentOS 6. Someone as an idea please? Where is my mistake? Regards, Thomas
[ANN] QxOrm 1.4.2 & QxEntityEditor 1.1.9 released : support JSON serialization
Hello, QxOrm 1.4.2 and QxEntityEditor 1.1.9 just released : http://www.qxorm.com/ QxOrm library 1.4.2 changes log : - Support JSON serialization : each C++ class registered in QxOrm context can be serialized/deserialized in JSON format (JSON feature requires Qt5) - For more details about JSON serialization, read QxOrm manual here : http://www.qxorm.com/qxorm_en/manual.html#manual_606 - With JSON serialization and QxService module : it is now possible to create REST Web Services to send data to a javascript engine (web pages for example) - Fix some compilation errors with recent (and less permissive) compilers and latest versions of boost and Qt - Fix relationship initialization assertion with complex, deep and circular relationships in large database schema - Improve QDataStream serialization : should be faster now and fix an issue with circular instances dependencies - Fix a bug fetching 1-n and n-n relationships when root is a container of stack objects (it worked only with pointers or smart-pointers, for example : QList vs QList<std::shared_ptr>) - Improve qx::dump() function : possibility to display a C++ instance state in XML or JSON format QxEntityEditor application 1.1.9 changes log : - New import plugin to connect to MySQL or MariaDB database without having to deal with ODBC settings - New import plugin to connect to PostgreSQL database without having to deal with ODBC settings - New import plugin to load a QxEntityEditor project from a JSON file - Fix SQLite import process to manage composite keys - Improve Javascript engine to customize export process : new types available by script to manage files and directories + possibility to get/set environment variables (read custom_script.js file in ./samples/ directory for script examples) - Improve Javascript engine to customize export process : new events/actions available by script : PLUGIN_EXPORT_START, PLUGIN_EXPORT_END, AFTER_CLOSING_FILE - New message box displayed if directory doesn't exist when starting an export process (to create it automatically) - Fix an issue with the "Tag project state" function (project historic) : each tag double the size of a *.qxee project file (now each tag is optimized) - Fix C++ services export process when C++11 features are enabled in QxOrm.pri configuration file - Possibility to export a *.qxee project file to a JSON text file (can be useful to store a text representation in a source control, like Perforce, VSS, CVS, Git, etc...) - Possibility to use an environment variable to define QxOrm library location (using the same syntax as qmake, for example $$(QXORM_DIR)) You can download latest versions of QxOrm library and QxEntityEditor application on QxOrm website : http://www.qxorm.com/ Regards, Lionel Marty - QxOrm library
ANN: DAC for MySQL 3.0.0 with RAD Studio 10 Seattle support is out!
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll. What’s new in v3.0.0: Support for RAD Studio 10 Seattle added, support for Android, MacOS & IOS target platforms introduced, several minor bugs fixed. Full changelog: [!] Package for RX10 Seattle added [!] Android target platform support added [!] iOS target platform support added [!] MacOS target platform support added [+] Function TableEngineToString added [-] Linker error "Unresolved external 'getaddrinfo' referenced" in C++ Builder when link with runtime packages is disabled fixed [-] "AV occurs when setting TMySQLTable.IndexFieldNames and TMySQLTable.IndexName properties for empty table" bug fixed [-] "Incorrect SSL error message in IDE with Unicode support" bug fixed You're welcome to download the DAC for MySQL v3.0.0 right now at: http://microolap.com/products/connectivity/mysqldac/download/ , or login to your private area on our site at http://microolap.com/my/downloads/ Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/ -- Aleksandr Andreev Developer MicroOLAP Technologies LTD aleksandr.andr...@gf.microolap.com http://microolap.com
ANN: DAC for MySQL 3.0.0-beta with RAD Studio 10 Seattle and mobile platforms support is out!
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll. What’s new in v3.0.0-beta: Support for RAD Studio 10 Seattle added, support for Android, MacOS & IOS target platforms introduced, several minor bugs fixed. Full changelog: [!] Package for RX10 Seattle added [!] Android target platform support added [!] iOS target platform support added [!] MacOS target platform support added [+] Function TableEngineToString added [-] Linker error "Unresolved external 'getaddrinfo' referenced" in C++ Builder when link with runtime packages is disabled fixed [-] "AV occurs when setting TMySQLTable.IndexFieldNames and TMySQLTable.IndexName properties for empty table" bug fixed [-] "Incorrect SSL error message in IDE with Unicode support" bug fixed You're welcome to download the DAC for MySQL v3.0.0-beta right now at: http://microolap.com/products/connectivity/mysqldac/download/ , or login to your private area on our site at http://microolap.com/my/downloads/ Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/ -- Aleksandr Andreev Developer MicroOLAP Technologies LTD aleksandr.andr...@gf.microolap.com http://microolap.com
[ANNOUNCE] QxOrm 1.3.2 and QxEntityEditor 1.1.8 released, support C++11 types
Hello, *QxOrm 1.3.2* (C++/Qt ORM Object Relational Mapping database library) and *QxEntityEditor 1.1.8* (the graphic editor) just released (http://www.qxorm.com/) ! Changes in version *QxOrm 1.3.2*: *- Support C++11 types (need to set compilation options in QxOrm.pri config file to enable these features)- With _QX_CPP_11_SMART_PTR compilation option : std::unique_ptr, std::shared_ptr, std::weak_ptr- With _QX_CPP_11_CONTAINER compilation option : std::unordered_map, std::unordered_set, std::unordered_multimap, std::unordered_multiset- With _QX_CPP_11_TUPLE compilation option : std::tuple* Changes in version *QxEntityEditor 1.1.8*: *- Improve import plugins : reduce import process time : now, you can import hundred of entities in few seconds into a QxEntityEditor project- Relationship n-1 : possibility to define a database column name different than the relationship name- New file qxBlogExec.zip in the ./samples/ directory of QxEntityEditor package : this is a C++/Qt example project which depends on the qxBlog.qxee generated files- Improve import by ODBC plugin screen : new schema/namespace level in the list of tables/views treeview- Fix a performance issue to load large diagram with new style to draw relationships : you can now load quickly a project with hundred of entities- Add new C++11 types to manage relationships, decoration, collection (std::shared_ptr, std::unordered_map and std::unordered_set) : C++11 features must be enabled in QxOrm.pri config file to use these classes- Import process more permissive : possibility to import tables without primary key and tables without column* For more details about QxOrm library and QxEntityEditor application, please go to website : http://www.qxorm.com/ Regards, Lionel Marty - QxOrm library
[ANN] ODB C++ ORM 2.4.0 released, adds MySQL stored procedure support
I am pleased to announce the release of ODB 2.4.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major new features in this release: * Support for bulk operations in Oracle and SQL Server. Bulk operations can be used to persist, update, or erase a range of objects using a single database statement execution which often translates to a significantly better performance. * Ability to join and load one or more complete objects instead of, or in addition to, a subset of their data members with a single SELECT statement execution (object loading views). * Support for specifying object and table join types in views (LEFT, RIGHT, FULL, INNER, or CROSS). * Support for calling MySQL and SQL Server stored procedures. * Support for defining persistent objects as instantiations of C++ class templates. A more detailed discussion of these features can be found in the following blog post: http://www.codesynthesis.com/~boris/blog/2015/02/11/odb-2-4-0-released/ For the complete list of new features in this version see the official release announcement: http://codesynthesis.com/pipermail/odb-announcements/2015/41.html ODB is written in portable C++ (both C++98/03 and C++11 are supported) and you should be able to use it with any modern C++ compiler. In particular, we have tested this release on GNU/Linux (x86/x86-64/ARM), Windows (x86/x86-64), Mac OS X (x86/x86_64), and Solaris (x86/x86-64/SPARC) with GNU g++ 4.2.x-5.x, MS Visual C++ 2005, 2008, 2010, 2012, and 2013, Sun Studio 12u2, and Clang 3.x. The currently supported database systems are MySQL, SQLite, PostgreSQL, Oracle, and SQL Server. ODB also provides optional profiles for Boost and Qt, which allow you to seamlessly use value types, containers, and smart pointers from these libraries in your persistent classes. More information, documentation, source code, and pre-compiled binaries are available from: http://www.codesynthesis.com/products/odb/ Enjoy, Boris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
LAMP Support
Hey gang, I need a few hours of support from a LAMP developer to resolve a few issues via TeamViewer or GoToMeeting. Anyone who is interested, has the skills, and can offer this to me, please contact me PRIVATELY. Please include your support hourly rate. Thanks! Don Wieland d...@pointmade.net http://www.pointmade.net https://www.facebook.com/pointmade.band
DAC for MySQL 2.10.0 with support RAD Studio XE7 is out!
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll. What’s new in v2.10.0: Support for Delphi XE7 and C++ Builder XE7 introduced immediately! Full changelog: [!] Support for Delphi XE7 and C++ Builder XE7 introduced [-] After TmySQLDataSet.SortBy the cursor changes position when using Data Controls bug fixed You're welcome to download the DAC for MySQL v2.10.0 right now at: http://microolap.com/products/connectivity/mysqldac/download/ , or login to your private area on our site at http://microolap.com/my/downloads/ Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/ -- Aleksandr Andreev Developer MicroOLAP Technologies LTD aleksandr.andr...@gf.microolap.com http://microolap.com
When will MySQL support the ANSI SQL MERGE command?
I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: When will MySQL support the ANSI SQL MERGE command?
Hello ccleve, On 9/19/2014 3:06 PM, ccleve wrote: I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? You appear to be looking for one of these commands that MySQL does support. INSERT... SELECT ... ON DUPLICATE KEY UPDATE ... http://dev.mysql.com/doc/refman/5.6/en/insert.html http://dev.mysql.com/doc/refman/5.6/en/insert-on-duplicate.html REPLACE... SELECT ... http://dev.mysql.com/doc/refman/5.6/en/replace.html You can file a feature request to add a new command (MERGE) to the parser, here. http://bugs.mysql.com/ But the odds are low that we will add the predicate MERGE to our syntaxes simply because we already have a storage engine called MERGE. http://dev.mysql.com/doc/refman/5.6/en/merge-storage-engine.html -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
mySQL Query support/assistance...
Hi gang, I am looking for someone that I can pay a few hours to work with me on coming up with a few needed QUERIES for a large mysql database. The queries will span across tables, so I great knowledge of JOINS will most likely be necessary. We will work using SKYPE and GoToMeeting. Please contact me, privately, if you can assist. I am located in California, USA (PST). Thanks! Don Wieland d...@pointmade.net http://www.pointmade.net
[ANN] ODB C++ ORM 2.3.0 released, adds schema evolution support
I am pleased to announce the release of ODB 2.3.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major new features in this release: * Support for database schema evolution, including automatic schema migration, immediate and gradual data migration, as well as soft object model changes (ability to work with multiple schema versions using the same C++ classes). For a quick showcase of this functionality see the Changing Persistent Classes section in the Hello World Example chapter: http://www.codesynthesis.com/products/odb/doc/manual.xhtml#2.9 * Support for object sections which provide the ability to split data members of a persistent C++ class into independently loaded/updated groups. * Support for automatic mapping of C++11 enum classes. A more detailed discussion of these features can be found in the following blog post: http://www.codesynthesis.com/~boris/blog/2013/10/30/odb-2-3-0-released/ For the complete list of new features in this version see the official release announcement: http://www.codesynthesis.com/pipermail/odb-announcements/2013/37.html ODB is written in portable C++ (both C++98/03 and C++11 are supported) and you should be able to use it with any modern C++ compiler. In particular, we have tested this release on GNU/Linux (x86/x86-64/ARM), Windows (x86/x86-64), Mac OS X (x86), and Solaris (x86/x86-64/SPARC) with GNU g++ 4.2.x-4.8.x, MS Visual C++ 2005, 2008, 2010, and 2012, Sun Studio 12u2, and Clang 3.x. The currently supported database systems are MySQL, SQLite, PostgreSQL, Oracle, and SQL Server. ODB also provides optional profiles for Boost and Qt, which allow you to seamlessly use value types, containers, and smart pointers from these libraries in your persistent classes. More information, documentation, source code, and pre-compiled binaries are available from: http://www.codesynthesis.com/products/odb/ Enjoy, Boris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Adding language support to tables
Hi, I've the following database structure of 4 tables for geographical information CREATE TABLE IF NOT EXISTS `mydb`.`country` ( `country_id` INT NOT NULL , `country_code` CHAR(2) NOT NULL , `name` VARCHAR(255) NOT NULL , PRIMARY KEY (`country_id`) , UNIQUE INDEX `country_code_UNIQUE` (`country_code` ASC) ) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`region` ( `region_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `country_code` CHAR(2) NOT NULL , PRIMARY KEY (`region_id`) , INDEX `FK_country_code` (`country_code` ASC) , CONSTRAINT `FK_country_code` FOREIGN KEY (`country_code` ) REFERENCES `mydb`.`country` (`country_code` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`city` ( `city_id` INT NOT NULL , `region_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `latitude` DOUBLE NOT NULL , `longitude` DOUBLE NOT NULL , PRIMARY KEY (`city_id`) , INDEX `FK_region_id` (`region_id` ASC) , CONSTRAINT `FK_region_id` FOREIGN KEY (`region_id` ) REFERENCES `mydb`.`region` (`region_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`district` ( `district_id` INT NOT NULL , `city_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `latitude` DOUBLE NOT NULL , `longitude` DOUBLE NOT NULL , PRIMARY KEY (`district_id`) , INDEX `FK_city_id` (`city_id` ASC) , CONSTRAINT `FK_city_id` FOREIGN KEY (`city_id` ) REFERENCES `mydb`.`city` (`city_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; Basically I'm wanting to add language support for each table to translate the name field in each instance. All other information will remain the same. Therefore is my best approach to add some sort of look-up table with the translation...? Thanks Neil
Re: Adding language support to tables
You want to say either Germany or Deutschland, depending on a language_code somewhere? *Yes, this is the exact issue I'm on on about. * I like your idea. Does anyone else have any thoughts before I try this way ? On Wed, May 1, 2013 at 4:19 PM, Rick James rja...@yahoo-inc.com wrote: You want to say either Germany or Deutschland, depending on a language_code somewhere? Remove the strings you have in those tables now; add about 4 new tables, each one paralleling the existing tables, but more rows and these columns: * id (the PK of the existing table) * language code (ENUM or TINYINT UNSIGNED indicating the language) * spelling (utf8 version for the language in question) There may be better ways to do your task, but see how this feels. Sketch out the CREATE TABLEs, INSERTs and SELECTs. (Adding N columns for N languages is a maintenance and coding nightmare. Tomorrow, you will need N+1 languages.) I would jettison the id in: `country_id` INT NOT NULL , `country_code` CHAR(2) NOT NULL , and use country_code as the PRIMARY KEY, and make it ASCII, not UTF8. That would turn the 4-byte id into a 2-byte string. I gather you are using an new-enough NDB so that FOREIGN KEYs are implemented? -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: Wednesday, May 01, 2013 5:53 AM To: [MySQL] Subject: Adding language support to tables Hi, I've the following database structure of 4 tables for geographical information CREATE TABLE IF NOT EXISTS `mydb`.`country` ( `country_id` INT NOT NULL , `country_code` CHAR(2) NOT NULL , `name` VARCHAR(255) NOT NULL , PRIMARY KEY (`country_id`) , UNIQUE INDEX `country_code_UNIQUE` (`country_code` ASC) ) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`region` ( `region_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `country_code` CHAR(2) NOT NULL , PRIMARY KEY (`region_id`) , INDEX `FK_country_code` (`country_code` ASC) , CONSTRAINT `FK_country_code` FOREIGN KEY (`country_code` ) REFERENCES `mydb`.`country` (`country_code` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`city` ( `city_id` INT NOT NULL , `region_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `latitude` DOUBLE NOT NULL , `longitude` DOUBLE NOT NULL , PRIMARY KEY (`city_id`) , INDEX `FK_region_id` (`region_id` ASC) , CONSTRAINT `FK_region_id` FOREIGN KEY (`region_id` ) REFERENCES `mydb`.`region` (`region_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`district` ( `district_id` INT NOT NULL , `city_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `latitude` DOUBLE NOT NULL , `longitude` DOUBLE NOT NULL , PRIMARY KEY (`district_id`) , INDEX `FK_city_id` (`city_id` ASC) , CONSTRAINT `FK_city_id` FOREIGN KEY (`city_id` ) REFERENCES `mydb`.`city` (`city_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; Basically I'm wanting to add language support for each table to translate the name field in each instance. All other information will remain the same. Therefore is my best approach to add some sort of look-up table with the translation...? Thanks Neil
RE: Adding language support to tables
You want to say either Germany or Deutschland, depending on a language_code somewhere? Remove the strings you have in those tables now; add about 4 new tables, each one paralleling the existing tables, but more rows and these columns: * id (the PK of the existing table) * language code (ENUM or TINYINT UNSIGNED indicating the language) * spelling (utf8 version for the language in question) There may be better ways to do your task, but see how this feels. Sketch out the CREATE TABLEs, INSERTs and SELECTs. (Adding N columns for N languages is a maintenance and coding nightmare. Tomorrow, you will need N+1 languages.) I would jettison the id in: `country_id` INT NOT NULL , `country_code` CHAR(2) NOT NULL , and use country_code as the PRIMARY KEY, and make it ASCII, not UTF8. That would turn the 4-byte id into a 2-byte string. I gather you are using an new-enough NDB so that FOREIGN KEYs are implemented? -Original Message- From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] Sent: Wednesday, May 01, 2013 5:53 AM To: [MySQL] Subject: Adding language support to tables Hi, I've the following database structure of 4 tables for geographical information CREATE TABLE IF NOT EXISTS `mydb`.`country` ( `country_id` INT NOT NULL , `country_code` CHAR(2) NOT NULL , `name` VARCHAR(255) NOT NULL , PRIMARY KEY (`country_id`) , UNIQUE INDEX `country_code_UNIQUE` (`country_code` ASC) ) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`region` ( `region_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `country_code` CHAR(2) NOT NULL , PRIMARY KEY (`region_id`) , INDEX `FK_country_code` (`country_code` ASC) , CONSTRAINT `FK_country_code` FOREIGN KEY (`country_code` ) REFERENCES `mydb`.`country` (`country_code` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`city` ( `city_id` INT NOT NULL , `region_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `latitude` DOUBLE NOT NULL , `longitude` DOUBLE NOT NULL , PRIMARY KEY (`city_id`) , INDEX `FK_region_id` (`region_id` ASC) , CONSTRAINT `FK_region_id` FOREIGN KEY (`region_id` ) REFERENCES `mydb`.`region` (`region_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; CREATE TABLE IF NOT EXISTS `mydb`.`district` ( `district_id` INT NOT NULL , `city_id` INT NOT NULL , `name` VARCHAR(255) NOT NULL , `latitude` DOUBLE NOT NULL , `longitude` DOUBLE NOT NULL , PRIMARY KEY (`district_id`) , INDEX `FK_city_id` (`city_id` ASC) , CONSTRAINT `FK_city_id` FOREIGN KEY (`city_id` ) REFERENCES `mydb`.`city` (`city_id` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = ndbcluster DEFAULT CHARACTER SET = utf8 COLLATE = utf8_unicode_ci; Basically I'm wanting to add language support for each table to translate the name field in each instance. All other information will remain the same. Therefore is my best approach to add some sort of look-up table with the translation...? Thanks Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Myisam won't support replication in an MySQL Cluster environment
- Original Message - From: Charles Brown cbr...@bmi.com Interestingly, over the years, I've been reading your postings and threads - without a doubt you're a major contributor. You've been very resourceful and helpful to your peers. We may never know what caused you to violently snap this time. However, I would encourage Interestingly, if you *had* been following so closely over the years, you'd know both that this isn't violently snapping at all - I've seen him explode much worse; *and* that you should both provide relevant data as well as actually bother to read people's answers if you expect help. you to continue to be nice and respectful to others -- particularly others you don't know. While this forum provides an excellent opportunity for us to exchange and share our experiences in MySQL, yet we expect everyone to conduct themselves politely and restrain from ideological overtures. The thought that an intelligent individual like you would bring himself this low flies in the face of all rational behavior. That's a whole lot of quite good managementspeak - and just as meaningless. I've seen your threads over the past couple of weeks, and have come to the same conclusion as Harald: you keep reposting the same inane question, all the while blatantly ignoring any and all relevant and informative replies you get from knowledgeable and experienced DBAs, highly specialised consultants and people from the actualy MySQL support alike. The main difference between his and my reaction to the kind of behaviour you are showing is that he get annoyed, whereas I simply ignore the thread. The answer to your question has been posted repeatedly. There is also perfectly good documentation available, yet you choose to ignore both and keep reposting the same thing over and over again, giving no indication of any form of comprehension whatsoever. Go read the documentation, go search the internet, and if you *still* have issues, come back here and ask intelligent questions instead of things you find in the first few pages of any introductory paper. This list consists of volunteers who freely provide their expertise, spending their time and asking nothing in return. It is NOT your personal helpdesk. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Myisam won't support replication in an MySQL Cluster environment
Am 04.05.2012 06:45, schrieb Brown: Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. whould you please start to read DOCUMENTATIONS instead open permanently new threads for the same problem which has the root cause that it seems you are doing a job without any qualification for it you can not expectz a mailing-list to replace documentation and education in your job - really this is not the intention of a mailinglist and yes, if you still do not know how to act after reading docs hire somebody who knows and pay him money signature.asc Description: OpenPGP digital signature
RE: Myisam won't support replication in an MySQL Cluster environment
Hello Mr Reindl, Interestingly, over the years, I've been reading your postings and threads - without a doubt you're a major contributor. You've been very resourceful and helpful to your peers. We may never know what caused you to violently snap this time. However, I would encourage you to continue to be nice and respectful to others -- particularly others you don't know. While this forum provides an excellent opportunity for us to exchange and share our experiences in MySQL, yet we expect everyone to conduct themselves politely and restrain from ideological overtures. The thought that an intelligent individual like you would bring himself this low flies in the face of all rational behavior. Best regards, -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, May 04, 2012 3:23 AM To: mysql@lists.mysql.com Subject: Re: Myisam won't support replication in an MySQL Cluster environment Am 04.05.2012 06:45, schrieb Brown: Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. whould you please start to read DOCUMENTATIONS instead open permanently new threads for the same problem which has the root cause that it seems you are doing a job without any qualification for it you can not expectz a mailing-list to replace documentation and education in your job - really this is not the intention of a mailinglist and yes, if you still do not know how to act after reading docs hire somebody who knows and pay him money This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Re: Myisam won't support replication in an MySQL Cluster environment
you did not get my point the problem is you are starting permanently NEW threads and you are not inclduing ANY informations in your posts I noticed that... as start is a bad joke you ahve to provide at least logs, configurations and describe HOW you notice things becasue others have no idea how your setup looks like BTW: get rid of your This message is intended only for the use of the Addressee at the bottom of your mails, this is only childish because a) after read the message nobody can erase the content from his brain and b) WHO is the Addressee if not the one you sent your mail? additionally get rid of HTML messages if you are posting to mailing-lists Am 04.05.2012 15:54, schrieb Brown: Hello Mr Reindl, Interestingly, over the years, I've been reading your postings and threads - without a doubt you're a major contributor. You've been very resourceful and helpful to your peers. We may never know what caused you to violently snap this time. However, I would encourage you to continue to be nice and respectful to others -- particularly others you don't know. While this forum provides an excellent opportunity for us to exchange and share our experiences in MySQL, yet we expect everyone to conduct themselves politely and restrain from ideological overtures. The thought that an intelligent individual like you would bring himself this low flies in the face of all rational behavior. Best regards, -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, May 04, 2012 3:23 AM To: mysql@lists.mysql.com Subject: Re: Myisam won't support replication in an MySQL Cluster environment Am 04.05.2012 06:45, schrieb Brown: Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. whould you please start to read DOCUMENTATIONS instead open permanently new threads for the same problem which has the root cause that it seems you are doing a job without any qualification for it you can not expectz a mailing-list to replace documentation and education in your job - really this is not the intention of a mailinglist and yes, if you still do not know how to act after reading docs hire somebody who knows and pay him money signature.asc Description: OpenPGP digital signature
Myisam won't support replication
I noticed that my replication stopped working after migrating to MySQL cluster. My current engine is myisam. Does anyone have an idea why repl won't work. Do I have to use the ndbengine? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Myisam won't support replication
Charles, How do you know your replication isn't working? On Thu, May 3, 2012 at 9:50 PM, Brown, Charles cbr...@bmi.com wrote: I noticed that my replication stopped working after migrating to MySQL cluster. My current engine is myisam. Does anyone have an idea why repl won't work. Do I have to use the ndbengine? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
RE: Myisam won't support replication
If I am not mistaken, NDB Cluster replication is separate from InnoDB/MyISAM. Perhaps you set one up, but not the other? -Original Message- From: Andrew Moore [mailto:eroomy...@gmail.com] Sent: Thursday, May 03, 2012 2:35 PM To: Brown, Charles Cc: MySQL; DC Subject: Re: Myisam won't support replication Charles, How do you know your replication isn't working? On Thu, May 3, 2012 at 9:50 PM, Brown, Charles cbr...@bmi.com wrote: I noticed that my replication stopped working after migrating to MySQL cluster. My current engine is myisam. Does anyone have an idea why repl won't work. Do I have to use the ndbengine? This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- 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
Myisam won't support replication in an MySQL Cluster environment
Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
Myisam won't support replication in an MySQL Cluster environment
Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not replicate. This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you.
[ANN] ODB C++ ORM 2.0.0 released, adds support for C++11, polymorphism
Hi, I am pleased to announce the release of ODB 2.0.0. ODB is an open source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major new features in this release: * Support for C++11 which adds integration with the new C++11 standard library components, including smart pointers and containers. Now you can use std::unique_ptr and std::shared_ptr as object pointers (their lazy versions are also provided). For containers, support was added for std::array, std::forward_list, and the unordered containers. * Support for polymorphism which allows you to persist, load, update, erase, and query objects of derived classes using their base class interfaces. Persistent class hierarchies are mapped to the relational database model using the table-per-difference mapping. * Support for composite object ids which are translated to composite primary keys in the relational database. * Support for the NULL semantics for composite values. This release has also been tested with GCC 4.7 and Clang 3.0 with the ODB compiler now supporting the GCC 4.7 series plugin interface. With this release we are also introducing a free proprietary license for small object models. A more detailed discussion of these features can be found in the following blog post: http://www.codesynthesis.com/~boris/blog/2012/05/02/odb-2-0-0-released/ For the complete list of new features in this version see the official release announcement: http://www.codesynthesis.com/pipermail/odb-announcements/2012/13.html ODB is written in portable C++ and you should be able to use it with any modern C++ compiler. In particular, we have tested this release on GNU/Linux (x86/x86-64), Windows (x86/x86-64), Mac OS X, and Solaris (x86/x86-64/SPARC) with GNU g++ 4.2.x-4.7.x, MS Visual C++ 2008 and 2010, Sun Studio 12, and Clang 3.0. The currently supported database systems are MySQL, SQLite, PostgreSQL, Oracle, and SQL Server. ODB also provides profiles for Boost and Qt, which allow you to seamlessly use value types, containers, and smart pointers from these libraries in your persistent classes. More information, documentation, source code, and pre-compiled binaries are available from: http://www.codesynthesis.com/products/odb/ Enjoy, Boris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
[ANN] ODB C++ ORM 1.7.0 adds support for optimistic concurrency
Hi, I am pleased to announce the release of ODB 1.7.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code. Major new features in this release: * Support for optimistic concurrency using object versioning. * Support for SQL statement execution tracing. * Support for read-only/const data members. * Support for persistent classes without object ids. * Support for the Oracle database, including updates to the Boost and Qt profiles. A more detailed discussion of these features can be found in the following blog post: http://www.codesynthesis.com/~boris/blog/2011/12/07/odb-1-7-0-released/ For the complete list of new features in this version see the official release announcement: http://www.codesynthesis.com/pipermail/odb-announcements/2011/11.html ODB is written in portable C++ and you should be able to use it with any modern C++ compiler. In particular, we have tested this release on GNU/Linux (x86/x86-64), Windows (x86/x86-64), Mac OS X, and Solaris (x86/x86-64/SPARC) with GNU g++ 4.2.x-4.6.x, MS Visual C++ 2008 and 2010, and Sun Studio 12. The currently supported database systems are MySQL, SQLite, PostgreSQL, and Oracle. ODB also provides profiles for Boost and Qt, which allow you to seamlessly use value types, containers, and smart pointers from these libraries in your persistent classes. More information, documentation, source code, and pre-compiled binaries are available from: http://www.codesynthesis.com/products/odb/ Enjoy, Boris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL anemic GIS support
Anyone have any idea on if/when MySQL will get real GIS support? http://mysqldbnews.blogspot.com/2007/10/does-mysql-gis-make-grade.html …is what I'm referring to. Specifically, the factor that many functions are quietly replaced with MBRContains(). This makes it, for example, not possible to determine with certainty (in SQL) if a point lies within a non-rectangular polygon. I ask because I'm looking at moving a big part of our applications to Postgresql, and, well, I'd rather not have to. …Rene -- 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 anemic GIS support
Somebody feel to jump in and contradict me here, but I have never had any love from the MySQL GIS stack. For the very few functions it does support, the performance has been abysmal and I generally find myself hacking together UDFs against columns of FLOAT and avoiding POINT altogether. - md On Fri, Oct 7, 2011 at 10:41 PM, René Fournier m...@renefournier.com wrote: Anyone have any idea on if/when MySQL will get real GIS support? http://mysqldbnews.blogspot.com/2007/10/does-mysql-gis-make-grade.html …is what I'm referring to. Specifically, the factor that many functions are quietly replaced with MBRContains(). This makes it, for example, not possible to determine with certainty (in SQL) if a point lies within a non-rectangular polygon. I ask because I'm looking at moving a big part of our applications to Postgresql, and, well, I'd rather not have to. …Rene -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com May the Source be with you.
Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??)
This comment has me intrigued: On 9/21/2011 17:50, John Daisley wrote: Partitioning is available in the community edition and has been for a while now. Support is the only real difference and since Oracle took over the support available in the community is usually faster and better than you get from Oracle. I work in MySQL Support and other than the tools that we were given to work with, very little should have changed in our attitude, our knowledge, or our level of professionalism (that I am aware of). Perhaps there are thinks that the other support providers are doing better? Please use this thread as a forum to which you can vent all of your complaints or concerns about MySQL support or to describe ways in which the other support systems are better. If it's policy changes, tell us. If it's response times, tell us. If it's our level of services, tell us. If you don't like the font on the web site, tell us. This is your chance to completely rip us a new one and to brag about your favorite service offerings at the same time. All opinions about any support providers are welcome. Thank you kindly, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??)
That's a great attitude. I always appreciate it when a support organization listens to users. I've been on both sides of the fence, and I always hated it when there //was// a fence. One thing I always favored, again as both a user and as a tech support professional, was a public list of known bugs (excluding security-related ones, of course). It saves a lot of head-banging, the kind of frustration that can lead to a very high level of anger. Just last week I spent a day trying to get a particular feature to work (in a completely unrelated product), not knowing that it was flat out broken. The company in question has three options: - Paid support: they gave me a free trial, and I quickly discovered that it was useless. Their only response was Take two reboots and call me in the morning. - E-mail support: bitbuc...@blackhole.com - The user forum: it has many experienced users, some beta testers, and (because the product is used world-wide) a response time measured in hours. What it doesn't have is any presence from the company. As you can imagine, if not for the other users this program would be just a bad memory. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.giiresearch.com -Original Message- From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com] Sent: Thursday, September 22, 2011 9:53 AM To: john.dais...@butterflysystems.co.uk Cc: John Daisley; Claudio Nanni; Johan De Meersman; Alastair Armstrong; mysql@lists.mysql.com Subject: Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??) This comment has me intrigued: On 9/21/2011 17:50, John Daisley wrote: Partitioning is available in the community edition and has been for a while now. Support is the only real difference and since Oracle took over the support available in the community is usually faster and better than you get from Oracle. I work in MySQL Support and other than the tools that we were given to work with, very little should have changed in our attitude, our knowledge, or our level of professionalism (that I am aware of). Perhaps there are thinks that the other support providers are doing better? Please use this thread as a forum to which you can vent all of your complaints or concerns about MySQL support or to describe ways in which the other support systems are better. If it's policy changes, tell us. If it's response times, tell us. If it's our level of services, tell us. If you don't like the font on the web site, tell us. This is your chance to completely rip us a new one and to brag about your favorite service offerings at the same time. All opinions about any support providers are welcome. Thank you kindly, -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Community Support better than Official Support? (was: Can I Develop using Community Edition and Deploy onto Enterprise Edition??)
; 2011/09/22 13:08 -0400, Jerry Schwartz The user forum: it has many experienced users, some beta testers, and (because the product is used world-wide) a response time measured in hours. What it doesn't have is any presence from the company. Is n't that what companies nowadays want? Computers are now often used to get workers and patrons to pay for that which formerly the company paid: forms, instruction books, With online banking the bank pays fewer tellers. The company s only bizness is to sell something, and after the sale vanish if may be. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: does mysql support master to master replication
Any mysql instance can replicate from any other as long as binary logging is enabled on the designated master. Two instances can replicate from one another yes, but precautions must be taken especially in the case of active-active configuration. Cheers, Claudio On Aug 3, 2011 7:19 AM, Jon Siebert jon.siebe...@gmail.com wrote: I had seen a discussion here as well, but honestly did not test it. It may be of help. http://www.linkedin.com/groupItem?view=srchtype=discussedNewsgid=72881item=60056153type=membertrk=eml-anet_dig-b_pd-ttl-cn On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com wrote: Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela
Re: does mysql support master to master replication
Any mysql instance can replicate from any other as long as binary logging is enabled on the designated master. Two instances can replicate from one another yes, but precautions must be taken especially in the case of active-active configuration. Works perfectly indeed, to name the precautions to take: 1, Set proper server_id's 2. When using auto-incrementing fields, set the auto_increment_offset auto_increment_increment. 3. If you write on 2 servers simultaneously, UNIQUE indexes can break replication. If your application requires both enforcing them AND writing to both servers, look at clustering instead. -- Rik Wasmus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
does mysql support master to master replication
Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela
Re: does mysql support master to master replication
I have been using the M-M replication over years. But we only write to one node at any time. When this node is unusable, we write to another node. On Wed, Aug 3, 2011 at 1:10 PM, Angela liu yyll2...@yahoo.com wrote: Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: does mysql support master to master replication
MySQL, to my knowledge, supports only Master to Slave replication- as well as Master-slave-slave replication. http://dev.mysql.com/doc/refman/5.0/en/replication.html On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com wrote: Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela
Re: does mysql support master to master replication
I had seen a discussion here as well, but honestly did not test it. It may be of help. http://www.linkedin.com/groupItem?view=srchtype=discussedNewsgid=72881item=60056153type=membertrk=eml-anet_dig-b_pd-ttl-cn On Wed, Aug 3, 2011 at 1:10 AM, Angela liu yyll2...@yahoo.com wrote: Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y? I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know? if so, anybody has implemented master to master replication in production? Thanks Angela
MySQL Enterprise support now at Oracle?
Wow! We paid for MySQL enterprise plus enterprise support back in the good old days before ORACLE bought MySQL. I just sacrificed the sacred chicken and sprinkled the blood around my computer and went to sign up for support at support.oracle.com. After wading through the crappy Flash interface and telling them my dog's mother's maiden name and all, 3 hours later I got an email saying I was Approved. I feel better. I read a few of the numerous tutorials on HOW TO USE THEIR HELP THING and I still don't understand it. I did a search for MySQL on their site and got NOTHING. Have they dropped all support for MySQL? Is there somewhere else we should go to pay for one on one support for things like my little join query problem? Has anyone else had a good experience with Oracle's MySQL support? Maybe this is a bad dream and I'll wake up soon. Thanks, Jim McNeely -- 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 Enterprise support now at Oracle?
Shawn Green works for Oracle and has been very helpful, and I am happy to eat a little bit of shoe leather! Thanks Shawn! Jim On Mar 10, 2011, at 11:11 AM, Jim McNeely wrote: Wow! We paid for MySQL enterprise plus enterprise support back in the good old days before ORACLE bought MySQL. I just sacrificed the sacred chicken and sprinkled the blood around my computer and went to sign up for support at support.oracle.com. After wading through the crappy Flash interface and telling them my dog's mother's maiden name and all, 3 hours later I got an email saying I was Approved. I feel better. I read a few of the numerous tutorials on HOW TO USE THEIR HELP THING and I still don't understand it. I did a search for MySQL on their site and got NOTHING. Have they dropped all support for MySQL? Is there somewhere else we should go to pay for one on one support for things like my little join query problem? Has anyone else had a good experience with Oracle's MySQL support? Maybe this is a bad dream and I'll wake up soon. Thanks, Jim McNeely -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=j...@newcenturydata.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: MySQL Enterprise support now at Oracle?
On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely j...@newcenturydata.com wrote: Shawn Green works for Oracle and has been very helpful, and I am happy to eat a little bit of shoe leather! Thanks Shawn! Jim Check the archives for Shawn's posts. IMNSHO, they are unparalleled in clarity and depth and breadth of useful information. David
Re: CR: add support of interactive transactions for webclients
I can't speak for the MySQL people, but in my view your workaround is the correct way of implementing this. It is not the database's job to keep track of which user wants to keep what session open, and HTTP is stateless by design. Keeping transactions open for relatively long periods of time would be a major load on the database, as it needs to keep track of all the different changesets and consistent views. I'd rather have my database be good at handling data :-) I can see your need, but that's what middleware is for. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
CR: add support of interactive transactions for webclients
CR: add support of interactive transactions for webclients Hello, I dont know how to place an idea (CR) for mySQL. I try it that way. At the moment I am implementing an easy-to-use multiuser webclient for database usage. (phpMyAdmin in contrast is a very powerful tool for people with technical background knowledge and I like to use it.) In an multiuser environment the usage of transactions to avoid data loss by access conflicts between different users is mandatory. But: Webserver (e.g. apache) doesnt keep open the connection to mySQL after the script (e.g. PHP) has been executed. mySQL thread is terminated and any open transaction is rolled back. Idea (CR): provide new session-variable KEEP_PROCESS and new command CHANGE_PROCESS. --- scenario (simplified): user1 navigates through database SELECT but NOT for update user1 likes to checkout a row to do some changes: ?PHP mySQL authentification START TRANSACTION SELECT FOR UPDATE SET @@KEEP_PROCESS=1 // process shall NOT be terminated after connection has been closed SELECT CONNECTION_ID() data is displayed in webclient FORM for editing ? row (InnoDB) is locked for user1 and cannot be SELECT FOR UPDATE by any other user user1 likes to write the changes back: ?PHP mySQL authentification CHANGE_PROCESS $connectionId // process shall be overtaken if a lot of conditions are satisfied (see bellow) UPDATE . COMMIT SET @@KEEP_PROCESS=NULL // process shall be terminated after connection has been closed ? --- conditions for CHANGE_PROCESS $connectionId : - user (and host) have to match between currently active (new) process and (old, kept) process with ID=$connectionId - currently active (new) process and (old, kept) process have to have successfully finnished user authentification - (original, last) connection of (old, kept) process has to be terminated before active (new) process can overtake if (original, last) connection has not been terminated then CHANGE_PROCESS is queued until (original, last) connection terminates I have been implementing a workaround (around 500 lines of code) that implements the above described behaviour. But this is implemented in C++ as PHP to MySQL bridge acting towards PHP as simulated mySQL server on port 3307 and acting towards mySQL as simulated PHP client on port 3306. This workaround does satisfy my needs but of course it would be much better to have this functionality implemented directly in mySQL if other users need interactive transactions for webclients too. Please give me feedback. Thank you very much! Herbert Don't get soaked. Take a quick peek at the forecast with the Yahoo! Search weather shortcut. http://tools.search.yahoo.com/shortcuts/#loc_weather
Re: ENGINE=ARCHIVE doesn't support INDEX!!??
Correct. I assume the thinking behind it, is that you use that kind of table for huge amounts of inactive data, so it doesn't matter if your selects are a bit slower. Also, keep in mind that because it is a compressed file format, you will be scanning much more data per physical read than with a regular table, and so the table scan will be quite a bit faster, too. If there are specific values you tend to use in where clauses all the time, though, you can always consider partitioning the archived table. On Thu, Sep 30, 2010 at 1:22 AM, Daevid Vincent dae...@daevid.com wrote: I gotta ask... http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
ENGINE=ARCHIVE doesn't support INDEX!!??
I gotta ask... http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
odbc connector 5.1 for windows unicode support
Hi, I have a database with UTF8 characters. These are shown correctly by the query browser. I installed the odbc/connector 5.1 and tried to access the same table using OpenOffice base and a Qt application I wrote myself. In both clients the UTF8 character so not show up properly as if the database said the returned string is NOT utf8 (i.e the binary data looks OK but the apps do not consider the binary as utf8). Does the connector support utf8 and if so why does say openoffice do not consider the data to be utf8 T -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
Hi, I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. Because if i create the the triggers as below i am getting error. First trigger (Succesfull) ++ CREATE TRIGGER CONSUMER_PROFILE_before_delete BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW begin INSERT INTO DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERPRISE_URL_ID,CONSUMER_FIRST_NAME,CONSUMER_MIDDLE_INITIAL,CONSUMER_LAST_NAME,DATE_OF_BIRTH,GENDER,MARITAL_STATUS,MARRIED_TO,LOCALE_ID,PROFILE_PHOTO_PATH,STATUS,SKIP_STEP,LAST_MOD_TIME,LAST_MOD_BY ) VALUES(old.CONSUMER_ID,old.CONSUMER_TYPE_ID,old.ENTERPRISE_URL_ID,old.CONSUMER_FIRST_NAME,old.CONSUMER_MIDDLE_INITIAL,old.CONSUMER_LAST_NAME,old.DATE_OF_BIRTH,old.GENDER,old.MARITAL_STATUS,old.MARRIED_TO,old.LOCALE_ID,old.PROFILE_PHOTO_PATH,old.STATUS,old.SKIP_STEP,old.LAST_MOD_TIME,old.LAST_MOD_BY ); END Second trigger (generating error) +++ CREATE TRIGGER AUDIT_REPOSITORY_before_delete BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW begin INSERT INTO DELETED_AUDIT_REPOSITORY(AUDIT_ENTRY_ID,AUDIT_ATTRIBUTE_ID,AFFECTED_CONSUMER_ID,AFFECTED_INTEREST_ID,ACTION_ID,OLD_VALUE_ID,OLD_VALUE,NEW_VALUE_ID,NEW_VALUE,IS_ACTIVE,LAST_MOD_TIME,LAST_MOD_BY ) VALUES(old.AUDIT_ENTRY_ID,old.AUDIT_ATTRIBUTE_ID,old.AFFECTED_CONSUMER_ID,old.AFFECTED_INTEREST_ID,old.ACTION_ID,old.OLD_VALUE_ID,old.OLD_VALUE,old.NEW_VALUE_ID,old.NEW_VALUE,old.IS_ACTIVE,old.LAST_MOD_TIME,old.LAST_MOD_BY );END - // ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' Or any other alternate to do the same ? Thanks Regards Jeetendra Ranjan
Re: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
On Wed, 9 Dec 2009 16:39:33 Jeetendra Ranjan wrote: Hi, I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. I'm not sure there is any plan to implement support for multiple triggers with the same action and timing. In your case, the solution is simply to combine the two: CREATE TRIGGER CONSUMER_PROFILE_before_delete BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW begin INSERT INTO DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERPRISE_URL_ID,CONSUMER_FIRST_NAME,CONSUMER_MIDDLE_INITIAL,CONSUMER_LAST_NAME,DATE_OF_BIRTH,GENDER,MARITAL_STATUS,MARRIED_TO,LOCALE_ID,PROFILE_PHOTO_PATH,STATUS,SKIP_STEP,LAST_MOD_TIME,LAST_MOD_BY ) VALUES(old.CONSUMER_ID,old.CONSUMER_TYPE_ID,old.ENTERPRISE_URL_ID,old.CONSUMER_FIRST_NAME,old.CONSUMER_MIDDLE_INITIAL,old.CONSUMER_LAST_NAME,old.DATE_OF_BIRTH,old.GENDER,old.MARITAL_STATUS,old.MARRIED_TO,old.LOCALE_ID,old.PROFILE_PHOTO_PATH,old.STATUS,old.SKIP_STEP,old.LAST_MOD_TIME,old.LAST_MOD_BY ); INSERT INTO DELETED_AUDIT_REPOSITORY(AUDIT_ENTRY_ID,AUDIT_ATTRIBUTE_ID,AFFECTED_CONSUMER_ID,AFFECTED_INTEREST_ID,ACTION_ID,OLD_VALUE_ID,OLD_VALUE,NEW_VALUE_ID,NEW_VALUE,IS_ACTIVE,LAST_MOD_TIME,LAST_MOD_BY ) VALUES(old.AUDIT_ENTRY_ID,old.AUDIT_ATTRIBUTE_ID,old.AFFECTED_CONSUMER_ID,old.AFFECTED_INTEREST_ID,old.ACTION_ID,old.OLD_VALUE_ID,old.OLD_VALUE,old.NEW_VALUE_ID,old.NEW_VALUE,old.IS_ACTIVE,old.LAST_MOD_TIME,old.LAST_MOD_BY ); END// - Jesper Because if i create the the triggers as below i am getting error. First trigger (Succesfull) ++ CREATE TRIGGER CONSUMER_PROFILE_before_delete BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW begin INSERT INTO DELETED_CONSUMER_PROFILE(CONSUMER_ID,CONSUMER_TYPE_ID,ENTERPRISE_URL_ID,CON SUMER_FIRST_NAME,CONSUMER_MIDDLE_INITIAL,CONSUMER_LAST_NAME,DATE_OF_BIRTH,GE NDER,MARITAL_STATUS,MARRIED_TO,LOCALE_ID,PROFILE_PHOTO_PATH,STATUS,SKIP_STEP ,LAST_MOD_TIME,LAST_MOD_BY ) VALUES(old.CONSUMER_ID,old.CONSUMER_TYPE_ID,old.ENTERPRISE_URL_ID,old.CONSU MER_FIRST_NAME,old.CONSUMER_MIDDLE_INITIAL,old.CONSUMER_LAST_NAME,old.DATE_O F_BIRTH,old.GENDER,old.MARITAL_STATUS,old.MARRIED_TO,old.LOCALE_ID,old.PROFI LE_PHOTO_PATH,old.STATUS,old.SKIP_STEP,old.LAST_MOD_TIME,old.LAST_MOD_BY ); END Second trigger (generating error) +++ CREATE TRIGGER AUDIT_REPOSITORY_before_delete BEFORE DELETE ON CONSUMER_PROFILE FOR EACH ROW begin INSERT INTO DELETED_AUDIT_REPOSITORY(AUDIT_ENTRY_ID,AUDIT_ATTRIBUTE_ID,AFFECTED_CONSUME R_ID,AFFECTED_INTEREST_ID,ACTION_ID,OLD_VALUE_ID,OLD_VALUE,NEW_VALUE_ID,NEW_ VALUE,IS_ACTIVE,LAST_MOD_TIME,LAST_MOD_BY ) VALUES(old.AUDIT_ENTRY_ID,old.AUDIT_ATTRIBUTE_ID,old.AFFECTED_CONSUMER_ID,o ld.AFFECTED_INTEREST_ID,old.ACTION_ID,old.OLD_VALUE_ID,old.OLD_VALUE,old.NEW _VALUE_ID,old.NEW_VALUE,old.IS_ACTIVE,old.LAST_MOD_TIME,old.LAST_MOD_BY );END - // ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' Or any other alternate to do the same ? Thanks Regards Jeetendra Ranjan -- Jesper Wisborg Krogh Team Lead Noggin IT • Level 8, 28 Foveaux St, Surry Hills NSW Australia 2010 T: +61 2 9219 8800 • F: +61 2 9280 4669 • E: jes...@noggin.com.au http://www.noggin.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
I just would like to know which version of MySQL support the creation of database triggers with the same action and event for one table. I'm not sure there is any plan to implement support for multiple triggers with the same action and timing. I certainly hope so... If not, it seems yet another half-baked implementation of a feature they never understood the power of ;-) /Martijn -- 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 5.4 Support for Mac OS X 10.6.x ?
Hi, As I did not get any reply, I started to install the mysql-5.4.3-beta osx10.5-x86_64 build on My Snow Leopard 10.6.2 64 bits , and I wanted to share my user experience with you :) the installation went well (logged as a normal user) though there were not any mysql user created on my OS, all files installed at /usr/local/mysql-5.4.3-beta-osx10.5-x86_64/ and a link /usr/local/mysql has been created pointing to /usr/local/mysql-5.4.3-beta-osx10.5-x86_64/ I then tried to create environment variables following the here under docs : http://developer.apple.com/mac/library/qa/qa2001/qa1255.html http://developer.apple.com/mac/library/qa/qa2001/qa1067.html http://dev.mysql.com/doc/refman/5.4/en/setting-environment-variables.html ttp://dev.mysql.com/doc/refman/5.4/en/setting-environment-variables.htmlhttp://dev.mysql.com/doc/refman/5.4/en/setting-environment-variables.html http://dev.mysql.com/doc/mysql-macosx-excerpt/5.4/en/mac-os-x-installation.html but it did not work though I created a file /Users/MyUserName/.MacOSX/environment.plist ?xml version=1.0 encoding=UTF-8? !DOCTYPE plist PUBLIC -//Apple//DTD PLIST 1.0//EN http://www.apple.com/DTDs/PropertyList-1.0.dtd; plist version=1.0 dict keyMYSQL_TCP_PORT/key string3306/string keyPATH/key string${PATH}:/usr/local/mysql/bin/string /dict /plist so I finally created a file e /Users/MyUserName/.bash_profile and this worked for me : MYSQL_TCP_PORT=3306 PATH=${PATH}:/usr/local/mysql/bin export MYSQL_TCP_PORT export PATH I then ran . .bash_profile ls -al /usr/local/mysql/data/ and noticed the files are owned by a user _mysql (group wheel) which I do not know (and does not exist I guess) : I then successfully ran the here under command though I have not performed yet the UNIX Post install stepshttp://dev.mysql.com/doc/refman/5.4/en/mysql-install-db.html: mysql -u root mysql I finnaly downloaded the MySQL Workbench 5.2.10 beta (mysql-workbench-oss-5.2.10-osx10.5-i686.dmg ) for Mac OS X 10.5 (x86, 32-bit) though I run mac Os X Snow Leopard 10.6.2 (x86, 64 bits) , I then saw the wizard as described at http://dev.mysql.com/doc/workbench/en/wb-installing-mac.html and can succefully run the Workbench GUI. I created then a new instance with a Mac OS X (MySQL Package) System Profile and all looked fine except the configuration file path set by default to /etc/my.cnf , which does not exist I only found a *.cnf file at /usr/local/mysql-5.4.3-beta-osx10.5-x86_64//mysql-test/suite/ndb/my.cnf To be followed ... and congratulations to the MySQL Team for the quality of this 5.4 beta version which looks yet great :) Regards, Steve 2009/11/29 Steve Pincaud jav...@gmail.com Hello, I have a Mac Book Pro (64 bits x86) running with Snow Leopard aka Mac OS X 10.6.2, I have read the here under pages and my conclusion is that MySQL currently does not support Mac OS X 10.6.x, so my question is: is there any plan in the roadmap to support it ? and if so what would be the ETA for GA and to get beta versions (the mysql-5.4.3-beta is supported only on osx10.5-x86_64) ? Thanks, Steve http://dev.mysql.com/downloads/mysql/5.4.html#macosx-dmg http://dev.mysql.com/doc/mysql-macosx-excerpt/5.4/en/mac-os-x-installation.html http://bugs.mysql.com/bug.php?id=46999 http://lists.mysql.com/mysql/218618 http://lists.mysql.com/mysql/218638 http://macosx.com/forums/mac-os-x-system-mac-software/311841-mysql-installation.html http://tomkeur.net/39/how-to-remove-mysql-completely-mac-os-x-leopard.html
MySQL 5.4 Support for Mac OS X 10.6.x ?
Hello, I have a Mac Book Pro (64 bits x86) running with Snow Leopard aka Mac OS X 10.6.2, I have read the here under pages and my conclusion is that MySQL currently does not support Mac OS X 10.6.x, so my question is: is there any plan in the roadmap to support it ? and if so what would be the ETA for GA and to get beta versions (the mysql-5.4.3-beta is supported only on osx10.5-x86_64) ? Thanks, Steve http://dev.mysql.com/downloads/mysql/5.4.html#macosx-dmg http://dev.mysql.com/doc/mysql-macosx-excerpt/5.4/en/mac-os-x-installation.html http://bugs.mysql.com/bug.php?id=46999 http://lists.mysql.com/mysql/218618 http://lists.mysql.com/mysql/218638 http://macosx.com/forums/mac-os-x-system-mac-software/311841-mysql-installation.html http://tomkeur.net/39/how-to-remove-mysql-completely-mac-os-x-leopard.html
does ado/myodbc not support blob data insert in vc6?
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk and GetChunk Methods Example (VC++) http://msdn.microsoft.com/en-us/library/ms676103(VS.85).aspx The connection to mysql server was changed by following: _bstr_t strCnn(DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;DATABASE=test; USER=root; PASSWORD=111;OPTION=3;); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
does ado/myodbc not support blob data insert in vc6?
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk and GetChunk Methods Example (VC++) http://msdn.microsoft.com/en-us/library/ms676103(VS.85).aspx The connection to mysql server was changed by following: _bstr_t strCnn(DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;DATABASE=test; USER=root; PASSWORD=111;OPTION=3;); -- 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 could not support bit storage?
Computer memory is not bit-addressable, how can you store a bit as an independent data unit ? Other than as part of a record, there are no C data types (which is used to implement MySQL kernel) that can process bit as a data type. If i miss the context, please advise me back. thanks On Mon, May 11, 2009 at 7:42 AM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. MySQL only has one datatype called bit, but its smallest storage is one byte. How to save a bit on disk, but not a byte? Any reply is appreciated. -- David Yeung, MySQL Senior Support Engineer, Sun Gold Partner. My Blog:http://yueliangdao0608.cublog.cn Comanpy: http://www.actionsky.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: MySQL could not support bit storage?
On Sun, May 10, 2009 at 10:12 PM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. MySQL only has one datatype called bit, but its smallest storage is one byte. How to save a bit on disk, but not a byte? In some cases, CHAR(0) NULL can actually use one bit on disk. You either store the empty string '', or you leave the column NULL. If it is NULL, there is one bit in a bitmask that gets set. If it stores the empty string, it uses no space, and the NULL bit is unset. This is a stupid hack that is probably not a good idea in the general case. Of course, the bitmap of NULL-ness is larger than one bit, so it makes no sense to do this if there is only one such column in the table. And in that case, you might be better off using an integer and packing many bits together into it. -- 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 could not support bit storage?
Thanks for your sincerely reply. On Mon, May 11, 2009 at 11:04 PM, Baron Schwartz ba...@xaprb.com wrote: On Sun, May 10, 2009 at 10:12 PM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. MySQL only has one datatype called bit, but its smallest storage is one byte. How to save a bit on disk, but not a byte? In some cases, CHAR(0) NULL can actually use one bit on disk. You either store the empty string '', or you leave the column NULL. If it is NULL, there is one bit in a bitmask that gets set. If it stores the empty string, it uses no space, and the NULL bit is unset. This is a stupid hack that is probably not a good idea in the general case. Of course, the bitmap of NULL-ness is larger than one bit, so it makes no sense to do this if there is only one such column in the table. And in that case, you might be better off using an integer and packing many bits together into it. -- David Yeung, MySQL Senior Support Engineer, Sun Gold Partner. My Blog:http://yueliangdao0608.cublog.cn Comanpy: http://www.actionsky.com
Re: Does mysql support materialized views?
No, you will have to emulate them using triggers or stored procedures. On Mon, Apr 20, 2009 at 12:28 PM, Lin Chun franks1...@gmail.com wrote: Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Does mysql support materialized views?
On Apr 20, 2009, at 11:34 AM, Olexandr Melnyk wrote: No, you will have to emulate them using triggers or stored procedures. Or: 1. Create table this_is_not_a_view and use that as the materialized view 2. Build a new version in the background this_is_not_a_view_pending as per your data freshness requirements 3. Use RENAME TABLE to push the pending table to production so to speak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Does mysql support materialized views?
On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun franks1...@gmail.com wrote: Hi Olexandr Melnyk That's to say, create the aggregation tables and update them by triggers? I've noticed a update view in Mysql , can it work under the aggretate operation? You're not looking for views, you need to use normal tables. If you will update the table by triggers, it will always be up-to-date but query cache will be cleared on every such update. On the other hand, if you do it periodically, data will not always be accurate, but query cache can be used efficiently. On Mon, Apr 20, 2009 at 11:34 AM, Olexandr Melnyk omel...@gmail.com wrote: No, you will have to emulate them using triggers or stored procedures. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Does mysql support materialized views?
Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun
Re: Does mysql support materialized views?
No On Mon, Apr 20, 2009 at 2:58 PM, Lin Chun franks1...@gmail.com wrote: Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun -- Krishna Chandra Prajapati
Fwd: Does mysql support materialized views?
Query cache stores select query together with its results. When the same query is sent again, result from the cache is returned. Whenever some table is modified, all cache entries referencing it are deleted. That happens even when modification doesn't affect cached rows, eg.: SELECT a FROM a_table WHERE id = 1; # Result gets cached UPDATE a_table SET a = 2 WHERE id = 2; # Result is removed from the query cache SELECT a FROM a_table WHERE id = 1; # Query cache can't be used On Mon, Apr 20, 2009 at 12:56 PM, Lin Chun franks1...@gmail.com wrote: Hi I don't know very well MySQL, the query cache is something like the Snapshotone of the s mod listed in the query is modified, the in Oracle, so we can get the result immediately? On Mon, Apr 20, 2009 at 11:47 AM, Olexandr Melnyk omel...@gmail.com wrote: On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun franks1...@gmail.com wrote: Hi Olexandr Melnyk That's to say, create the aggregation tables and update them by triggers? I've noticed a update view in Mysql , can it work under the aggretate operation? You're not looking for views, you need to use normal tables. If you will update the table by triggers, it will always be up-to-date but query cache will be cleared on every such update. On the other hand, if you do it periodically, data will not always be accurate, but query cache can be used efficiently. On Mon, Apr 20, 2009 at 11:34 AM, Olexandr Melnyk omel...@gmail.com wrote: No, you will have to emulate them using triggers or stored procedures. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: When will MySQL support array datatype?
Thanks for your fast reply. Then only temporary table can simulate array datatype. On Mon, Feb 16, 2009 at 3:12 AM, Claudio Nanni claudio.na...@gmail.comwrote: Complex datatypes are not compatible with the concept of relational databases, probably you want to refer to an Object-Oriented DBMS or Object-Relational DBMS. Cheers Claudio Nanni Moon's Father wrote: Hi. Who could tell me when the MySQL support array datatype? Any reply will be appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: When will MySQL support array datatype?
Moon, I'm not sure exactly what you are trying to do, but why don't you just serialize() or json_encode() your data into a column? On Tue, Mar 10, 2009 at 9:35 AM, Moon's Father yueliangdao0...@gmail.com wrote: Thanks for your fast reply. Then only temporary table can simulate array datatype. On Mon, Feb 16, 2009 at 3:12 AM, Claudio Nanni claudio.na...@gmail.comwrote: Complex datatypes are not compatible with the concept of relational databases, probably you want to refer to an Object-Oriented DBMS or Object-Relational DBMS. Cheers Claudio Nanni Moon's Father wrote: Hi. Who could tell me when the MySQL support array datatype? Any reply will be appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: When will MySQL support array datatype?
This is part of the SQL Standard. MySQL has a worklog open on it: http://forge.mysql.com/worklog/task.php?id=2081 On Sat, Feb 14, 2009 at 9:05 PM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. Who could tell me when the MySQL support array datatype? Any reply will be appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: When will MySQL support array datatype?
Who could tell me when the MySQL support array datatype? Any reply will be appreciated. Given that you appreciate -any- reply ... I hope it never supports it. 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: When will MySQL support array datatype?
Complex datatypes are not compatible with the concept of relational databases, probably you want to refer to an Object-Oriented DBMS or Object-Relational DBMS. Cheers Claudio Nanni Moon's Father wrote: Hi. Who could tell me when the MySQL support array datatype? Any reply will be appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
[ANN]: MicroOLAP Database Designer for MySQL 1.9.8 has been released. Now with Russian language support!
Greetings, Microolap Technologies is happy to announce that the version 1.9.8 of MicroOLAP Database Designer for MySQL is immediately available. This release introduces completely new View Parser. Placing of objects pasted from clipboard significantly improved. Russian localization added (experimental). Several minor bugs and improvements. Full changelog: http://microolap.com/products/database/mysql-designer/news/ Downloads: http://microolap.com/products/database/mysql-designer/download/ Details about Russian language support: http://kitchen.microolap.com/mymdd-russian (in Russian) If you have any questions or require further assistance, please do not hesitate to create a support ticket at http://microolap.com/support/ Have a nice day, -- Mikhail Oleynik MicroOLAP Technologies mikhail.oley...@gf.microolap.com http://microolap.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Additional language support for tracking server usage.
Folks, I work at a Web Hosting company and we were frustrated by our inability to account for user activity on a busy server. We could see gross spikes in activity by SHOW STATUS, but couldn't tell where they were coming from easily. We finally developed an extensive set of patches for MySQL and released them as Open Source (we hope it will get picked up in the main MySQL soon!). I have some brief examples below, you can read more and download the source at http://www.ExtSQL.com/ I'm also our representative on the INCITS (H2) technical committee (the US ANSI body with responsibility for the SQL standard) -- from our review of other major DB vendors these changes look like some welcome additions to the SQL standard (most likely under INFORMATION_SCHEMA). We are very interested in feedback/suggestions from the community. - # Show number of select, updates, and total queries from all # [EMAIL PROTECTED] host machines where more than 10,000 queries were # issued: sql SHOW STATISTICS Com_select, Questions, Com_update FROM conuser WHERE Questions 1; ++-+---++ | conuser ([EMAIL PROTECTED]) | Com_select | Questions | Com_update | +- --+-+---++ | [EMAIL PROTECTED]| 8306726 | 23163320 | 3439850933 | | [EMAIL PROTECTED] | 1704040 | 3831803 | 3365501841 | | [EMAIL PROTECTED] | 24920 |95662 | 156529077 | # Show number of select, updates, and total queries for DB bandala for # the past three minutes: sql SHOW STATISTICS Com_select, Questions, Com_update FROM db LIKE 'bandala' HISTORY LIMIT 3; +-+-++---++ | db | minutes | Com_select | Questions | Com_update | +-+-++---++ | bandala | 11/20 13:56 | 216| 382 | 318343 | | bandala | 11/20 13:55 | 642|1618 | 1386347| | bandala | 11/20 13:54 | 280| 699 | 646855 | -- John ___ John Murtari Software Workshop Inc. [EMAIL PROTECTED] 315.635.1968(x-211) TheBook.Com (TM) http://www.thebook.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Current state of CONNECT BY support in MySQL?
Many people seem to ask this question periodically but I wanted the most recent answer... What's the current state of having support for CONNECT BY in MySQL? I'm using MySQL 5.0.45 on CentOS 5.2 and noticed in the documentation that I can't write my own recursive functions: Stored functions cannot be recursive. http://dev.mysql.com/doc/refman/5.1/en/stored-routines-syntax.html ... so I guess I can't build my own recursive tree-traversing stored procedures. Is there support in MySQL 5.x, or MySQL 6.x for doing heirarchical queries? Does MySQL now ... or will it later ... support CONNECT BY syntax? Help would be appreciated. -- Dante -- D. Dante Lorenso [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Time Zone Support
you'll need to set the datetime function before presenting date/time to the user http://www.w3schools.com/php/func_date_default_timezone_set.asp Martin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. From: [EMAIL PROTECTED] To: mysql@lists.mysql.com CC: [EMAIL PROTECTED] Subject: Time Zone Support Date: Tue, 26 Aug 2008 22:26:36 -0600 Hi, We need to add support for time zone to our existing PHP Board Member Extranet applications. Could those of you with experience supporting a time zone field in your MySQL data tables offer some advice? Would you use a single field? Would you use just an offset value? How would you represent the information on presentation data? How would you list the time zone options in your form dropdowns? Would you use a separate time zone table to support the offset values, an abbreviated time zone, a full time zone name and a daylight savings time value? We greatly appreciate any advice you can offer. Thank you for taking the time to share your knowledge... Keith _ Talk to your Yahoo! Friends via Windows Live Messenger. Find out how. http://www.windowslive.com/explore/messenger?ocid=TXT_TAGLM_WL_messenger_yahoo_082008
Time Zone Support
Hi, We need to add support for time zone to our existing PHP Board Member Extranet applications. Could those of you with experience supporting a time zone field in your MySQL data tables offer some advice? Would you use a single field? Would you use just an offset value? How would you represent the information on presentation data? How would you list the time zone options in your form dropdowns? Would you use a separate time zone table to support the offset values, an abbreviated time zone, a full time zone name and a daylight savings time value? We greatly appreciate any advice you can offer. Thank you for taking the time to share your knowledge... Keith
mySQL support required
Hi , We are in Urgent need of support to recover from a database problem Details of our license product are as below License serial numbers is : 565076 Received on 19/Apr/006 The Problem detail is said below, We are not able to access the innodb data from the mysql Database . Any select statement results in an error ERROR 1033 (HY000): Incorrect information in file: We have taken the instance of the Database and tested on a different system, the data seems to be fine . The Queries seems to work fine . We would like to know ,if any changes are required in the Database to recover from this situation , Since we assume there is no problem with the data Regards Kishore Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Re: mySQL support required
Hi Kishore, Please see the following approach : http://dschneller.blogspot.com/2007/09/error-1033-hy000-on-innodb.html Regards, Juan On Mon, Jun 9, 2008 at 8:26 AM, [EMAIL PROTECTED] wrote: Hi , We are in Urgent need of support to recover from a database problem Details of our license product are as below License serial numbers is : 565076 Received on 19/Apr/006 The Problem detail is said below, We are not able to access the innodb data from the mysql Database . Any select statement results in an error ERROR 1033 (HY000): Incorrect information in file: We have taken the instance of the Database and tested on a different system, the data seems to be fine . The Queries seems to work fine . We would like to know ,if any changes are required in the Database to recover from this situation , Since we assume there is no problem with the data Regards Kishore Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
Re: MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint...
On Thursday 14 February 2008 01:21:31 Jacob, Raymond A Jr wrote: I apologize for asking this question. I am somewhat confused by Microsoft's Licensing and I personally can not justify to senior management why MS SQL should be procured instead of procuring software more urgent requirements. I had the not so bright idea that maybe a MS SQL emulator or compatibility mode existed for/in MySQL. Does such a beast exist? In particular, I wanted to use MySQL as backend database for MS Project Server and Sharepoint, and other applications that use MS SQL as their backend database. Again, I apologize for asking this question. I could not figure out the correct string to search for such software. thank you Have you ever considered dotproject? It as a web-enabled, Opensource project management tool with *lots* more features than MS-Project offers. And it is MySQL based. I don't know sharepoint but I people want to shre documents, it is always possible to use a Twiki-server for that. -- --- Peter M. Groen Open Systems Development Klipperwerf 12 2317 DZ Leiden Tel : +31-(0)71-5216317 Mobile: +31-(0)6-29563390 Email : [EMAIL PROTECTED] Skype : peter_m_groen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint...
I apologize for asking this question. I am somewhat confused by Microsoft's Licensing and I personally can not justify to senior management why MS SQL should be procured instead of procuring software more urgent requirements. I had the not so bright idea that maybe a MS SQL emulator or compatibility mode existed for/in MySQL. Does such a beast exist? In particular, I wanted to use MySQL as backend database for MS Project Server and Sharepoint, and other applications that use MS SQL as their backend database. Again, I apologize for asking this question. I could not figure out the correct string to search for such software. thank you
RE: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject
http://blogs.ittoolbox.com/km/sharepoint/archives/sharepoint-and-mysql-2 2051 hmm.. but I think you might have problems getting support from sharepoint's vendor... IIRC they always push to use SQL server for this.. (we know the reason why.. :) ) -Original Message- From: Jacob, Raymond A Jr [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 13, 2008 7:22 PM To: mysql@lists.mysql.com Subject: [SPAM] - MS SQL emulator for MySQL in order to support MS Project Server, Sharepoint... - Email found in subject I apologize for asking this question. I am somewhat confused by Microsoft's Licensing and I personally can not justify to senior management why MS SQL should be procured instead of procuring software more urgent requirements. I had the not so bright idea that maybe a MS SQL emulator or compatibility mode existed for/in MySQL. Does such a beast exist? In particular, I wanted to use MySQL as backend database for MS Project Server and Sharepoint, and other applications that use MS SQL as their backend database. Again, I apologize for asking this question. I could not figure out the correct string to search for such software. thank you This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Linq support
Hi, Did latest Mysql .net provider (5.1.4) support Linq? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are the initiator.
RE: Client does not support authentication protocol requested by server
I would have a look here: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Secondly, if I'm not mistaking, the some_host should be localhost if you want the script only to be able to connect from the local computer and % if you want the connection to be possible from any possible host. At least that is what I think... Regards -Oorspronkelijk bericht- Van: John Berman [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 9 oktober 2007 23:47 Aan: mysql@lists.mysql.com Onderwerp: Client does not support authentication protocol requested by server Hi We have php 4.3.4 and mysql 5 My test script produces this Client does not support authentication protocol requested by server http://www.jewishgen.org/cemetery/connect-test.php Research suggests that I can upgrade php or SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD ('') So I did this but it makes no difference, pointers appreciated Regards John B No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.5/1058 - Release Date: 08/10/2007 16:54 -- 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]
Client does not support authentication protocol requested by server
Hi We have php 4.3.4 and mysql 5 My test script produces this Client does not support authentication protocol requested by server http://www.jewishgen.org/cemetery/connect-test.php Research suggests that I can upgrade php or SET PASSWORD FOR [EMAIL PROTECTED] = OLD_PASSWORD ('') So I did this but it makes no difference, pointers appreciated Regards John B No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.14.5/1058 - Release Date: 08/10/2007 16:54 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#1017 - Can't find file: './support/orderpc.frm' (errno: 13)
Hi everyone, all of a sudden today, I keep getting the error mentioned in the subject when I open the dbase in phpmyadmin.. I have a dbase with 14 tables. When I open it in phpmyadmin, it will list all the tables until it reaches the table orderpc and then stops right there. I went into /var/lib/mysql/support and the orderpc.frm is there along with its respective myd myi files. Any idea on how to fix this? I'm using suse 10.1 with mysql 5.x. Also, when I run a simple search to list all items in that table, I get nothing. Thanks Haig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: #1017 - Can't find file: './support/orderpc.frm' (errno: 13)
[EMAIL PROTECTED] ~]# perror 13 OS error code 13: Permission denied check permissions that it is read/write for the mysql user On 9/14/07, Haig Dedeyan [EMAIL PROTECTED] wrote: Hi everyone, all of a sudden today, I keep getting the error mentioned in the subject when I open the dbase in phpmyadmin.. I have a dbase with 14 tables. When I open it in phpmyadmin, it will list all the tables until it reaches the table orderpc and then stops right there. I went into /var/lib/mysql/support and the orderpc.frm is there along with its respective myd myi files. Any idea on how to fix this? I'm using suse 10.1 with mysql 5.x. Also, when I run a simple search to list all items in that table, I get nothing. Thanks Haig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: #1017 - Can't find file: './support/orderpc.frm' (errno: 13)
Thanks Mike. Thanks Mike. Don't know why the permissions were read only all of a sudden but that was the problem. Haig Mike Zupan wrote: [EMAIL PROTECTED] ~]# perror 13 OS error code 13: Permission denied check permissions that it is read/write for the mysql user On 9/14/07, Haig Dedeyan [EMAIL PROTECTED] wrote: Hi everyone, all of a sudden today, I keep getting the error mentioned in the subject when I open the dbase in phpmyadmin.. I have a dbase with 14 tables. When I open it in phpmyadmin, it will list all the tables until it reaches the table orderpc and then stops right there. I went into /var/lib/mysql/support and the orderpc.frm is there along with its respective myd myi files. Any idea on how to fix this? I'm using suse 10.1 with mysql 5.x. Also, when I run a simple search to list all items in that table, I get nothing. Thanks Haig -- 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]
Fwd: [commercial] MySQL cluster setup and support
-- Forwarded message -- From: C K [EMAIL PROTECTED] Date: Aug 13, 2007 11:37 AM Subject: [commercial] MySQL cluster setup and support To: [EMAIL PROTECTED] Dear all, we are a medium sized company in India having mfg. facilities about 65 kms. from Pune and Head Office in Pune. We are running a mysql based ERP system for our operations. Now we are shifting some of our departments to Pune and requires support to connect two mysql database servers through VPN/Leased Line. If any commercial service provider from PUNE or nearby cities in INDIA only can give such service related to MySQL cluster/replication etc., please submit your proposals to [EMAIL PROTECTED] Please call 9975844665 for more details. Thank you. CPKulkarni -- Keep your Environment clean and green. -- Keep your Environment clean and green.
Why doesn't MySQL support gzip encode/decode functions.
Why doesn't mysql support gzip for COMPRESS/UNCOMPRESS and only zlib For network applications zlib is a lot less compatible than gzip. For example I could send gzip'd content directly from the database within a larger gzip'd stream. Kevin -- Founder/CEO Tailrank.com Location: San Francisco, CA AIM/YIM: sfburtonator Skype: burtonator Blog: feedblog.org Cell: 415-637-8078
Does mysql support groups?
Does Mysql support groups of users? I am working on porting an application from Sybase to Mysql and it relies heavily on using groups to control access to the data. I am not seeing this mentioned in Mysql, but I might be overlooking something. So does it support groups? Thanks, Chris
Re: Does mysql support groups?
Hi Chris, Chris Hoover wrote: Does Mysql support groups of users? I am working on porting an application from Sybase to Mysql and it relies heavily on using groups to control access to the data. I am not seeing this mentioned in Mysql, but I might be overlooking something. So does it support groups? No, just straightforward user accounts with individual GRANT and REVOKE. I too miss groups/roles, alas. If it helps, the way I tend to manage it is just assign everyone to the same user account, and name it as though it's a group -- e.g. analyst, developer, intern, and so forth. I know that's not the same thing and has obvious limitations, but for my purposes it's easier than having to maintain many accounts. If anyone has nifty ways to do interesting stuff with user accounts, I'd love to hear about them! Baron -- Baron Schwartz http://www.xaprb.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Does mysql support groups?
Chris, Does Mysql support groups of users? It does not implement groups, but they are relatively easy to implement by linking a usergroups table to mysql.users. PB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table compression with write (append) support
At 12:31a -0400 on 28 May 2007, Dan Nelson wrote: In the last episode (May 27), Yves Goergen said: I'm thinking about using a MySQL table to store an Apache access log and do statistics on it. Currently all access log files are stored as files and compressed by day. Older log files are compressed by month, with bzip2. This gives a very good compression ratio, since there's a lot of repetition in those files. If I store all that in a regular table, it would be several gigabytes large. So I'm looking for a way to compress the database table but still be able to append new rows. As the nature of a log file, it is not required to alter previous data. It could only be useful to delete older rows. Do you know something for that? You want the ARCHIVE storage engine. http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html Huh. This is the first I've heard of the archive engine. Cool! However, I'm curious how the compression offered by OPTIMIZE TABLE and the zlib library would compare to denormalization of the log schema. In particular, I imagine a lot of the HTTP requests would be the same, so you could create a table to store the requested URLs, and then have a second table with the timestamp and foreign key relationship into the first. Depending on how wide the original rows are and how often they're requested, I imagine you could get quite a savings. Anything else that's repeated as well? IP's? Return codes? Would be curious about the results if you were able to implement both. Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table compression with write (append) support
On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote: At 12:31a -0400 on 28 May 2007, Dan Nelson wrote: You want the ARCHIVE storage engine. http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html Hm, it doesn't support deleting rows and it cannot use indexes. So doing statistics on them (which can be a little more complex than counting rows within a timespan, which is why I wanted to use an SQL database) could get quite resource demanding. In particular, I imagine a lot of the HTTP requests would be the same, so you could create a table to store the requested URLs, and then have a second table with the timestamp and foreign key relationship into the first. Interesting idea. Inserting would be more work to find the already present dictionary rows. Also, URLs sometimes contain things like session IDs. They're probably not of interest for my use but it's not always easy to detect them for removal. I could also parse user agent strings for easier evaluation, but this takes me the possibility to add support for newer browsers at a later time. (Well, I could update the database from the original access log files when I've updated the UA parser.) IP addresses (IPv4) and especially return codes (which can be mapped to a 1-byte value) are probably not worth the reference. Data size values should be too distributed for this. How large is a row reference? 4 bytes? -- Yves Goergen LonelyPixel [EMAIL PROTECTED] Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table compression with write (append) support
Yves Goergen wrote: On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote: At 12:31a -0400 on 28 May 2007, Dan Nelson wrote: You want the ARCHIVE storage engine. http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html Hm, it doesn't support deleting rows and it cannot use indexes. So doing statistics on them (which can be a little more complex than counting rows within a timespan, which is why I wanted to use an SQL database) could get quite resource demanding. Another option might be to use compressed MyISAM tables, which you create with myisampack. Suppose you create a new table every day, and after you start inserting into the new table, you compress yesterday's file. Then you could use the MERGE storage engine to provide a view over all the tables as though they are one. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table compression with write (append) support
At 5:45a -0400 on 28 May 2007, Yves Goergen wrote: On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote: In particular, I imagine a lot of the HTTP requests would be the same, so you could create a table to store the requested URLs, and then have a second table with the timestamp and foreign key relationship into the first. Interesting idea. Inserting would be more work to find the already present dictionary rows. My guess is not /that/ much work, since you should only have a known and relatively small set in this dictionary, it'd basically be cached the whole time. But, that's my guess. Haven't tried it. Practice and theory . . . Also, URLs sometimes contain things like session IDs. They're probably not of interest for my use but it's not always easy to detect them for removal. Really? Why wouldn't it be easy to detect them? You presumably know what variable you're looking for in the URL string, and applying a simple regex search-and-replace . . . ? IP addresses (IPv4) and especially return codes (which can be mapped to a 1-byte value) are probably not worth the reference. Data size values should be too distributed for this. Well, presumably, you'd normalize that part of the table. That is, rather than include multiple foreign keys in your data rows, you'd create a cartesian product of the the return codes with the dictionary table. You'd have a slightly more bloated dictionary, but depending on the number of requests the site(s) get(s), the aggregation would more than make up for it. I could also parse user agent strings for easier evaluation, but this takes me the possibility to add support for newer browsers at a later time. (Well, I could update the database from the original access log files when I've updated the UA parser.) Same thought. If you've only a known set of UA strings, you could normalize them with the dictionary table as well. How large is a row reference? 4 bytes? I don't know, I'm fairly new to MySQL. I suppose it'd also matter on the type of index. Anyone more knowledgeable wanna pipe up? Well. Whatever method works for your needs, cool. I'm going to check out both MYISAMPACK and ARCHIVE. I was unaware of those. Thanks list! Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table compression with write (append) support
On 28.05.2007 18:34 CE(S)T, Kevin Hunter wrote: At 5:45a -0400 on 28 May 2007, Yves Goergen wrote: Also, URLs sometimes contain things like session IDs. They're probably not of interest for my use but it's not always easy to detect them for removal. Really? Why wouldn't it be easy to detect them? You presumably know what variable you're looking for in the URL string, and applying a simple regex search-and-replace . . . ? I don't control what applications run on that web server. Same thought. If you've only a known set of UA strings, you could normalize them with the dictionary table as well. Well, I don't know (in advance) what's all running around out there... -- Yves Goergen LonelyPixel [EMAIL PROTECTED] Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table compression with write (append) support
Hi, I'm thinking about using a MySQL table to store an Apache access log and do statistics on it. Currently all access log files are stored as files and compressed by day. Older log files are compressed by month, with bzip2. This gives a very good compression ratio, since there's a lot of repetition in those files. If I store all that in a regular table, it would be several gigabytes large. So I'm looking for a way to compress the database table but still be able to append new rows. As the nature of a log file, it is not required to alter previous data. It could only be useful to delete older rows. Do you know something for that? -- Yves Goergen LonelyPixel [EMAIL PROTECTED] Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table compression with write (append) support
In the last episode (May 27), Yves Goergen said: I'm thinking about using a MySQL table to store an Apache access log and do statistics on it. Currently all access log files are stored as files and compressed by day. Older log files are compressed by month, with bzip2. This gives a very good compression ratio, since there's a lot of repetition in those files. If I store all that in a regular table, it would be several gigabytes large. So I'm looking for a way to compress the database table but still be able to append new rows. As the nature of a log file, it is not required to alter previous data. It could only be useful to delete older rows. Do you know something for that? You want the ARCHIVE storage engine. http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FK support on myISAM, Parallelization, pronunciation and all kinds of goodness...
Whoa!? I was just reading this page (http://en.wikipedia.org/wiki/MySQL), and noticed a few things... http://en.wikipedia.org/wiki/Foreign_key Foreign key support for all storage engines will likely be released with MySQL 5.2 (although it has been present since version 3.23.44 for http://en.wikipedia.org/wiki/InnoDB InnoDB). Does this mean that myISAM tables will have FK support? So I can then ditch this InnoDB with all the transaction bloat, and the fact that auto_increment PK resets itself. http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html And the second interesting thing is: Support for http://en.wikipedia.org/wiki/Parallel_computing parallelization is also part of the roadmap for future versions Does this mean we can have several mySQL servers all running as one, on different physical servers. Sort of like clustering, or maybe RAID-ish? What are the current roadmap dates(ish) for these features. And I'm sure this has been asked a billion times, but when will 5.1 branch become GA (again, ballpark)? ÐÆ5ÏÐ PS. Here's a bit of trivia for you if you don't feel like reading the whole wikipedia page: MySQL's official pronunciation of the name is My Ess Que Ell, pronounced as /maɪ ɛs kjuː ɛl/, not My sequel /maɪ siːkwəl/. However, the company does not take issue with the pronunciation My sequel or other local variations. The My portion of the name comes from the name of Widenius's child, spelled My but pronounced in http://en.wikipedia.org/wiki/Swedish Swedish as mü /my/ (or approximately in English, me). The SQL portion uses the fully spelled-out pronunciation of the http://en.wikipedia.org/wiki/Acronym_and_initialism initials, S-Q-L (Structured Query Language), not the sequel pronunciation. This adheres to the official ANSI pronunciation but conflicts with the earlier IBM database of that name.[5] http://en.wikipedia.org/wiki/MySQL#_note-3 The Swedish (MySQL AB is a Swedish company) word Myskväll (/myskvæl/ cozy evening, or My's evening as Mys kväll) is pronounced in a similar way, but this may be a coincidence. Nevertheless this pronunciation is quite usual in Sweden. The dolphin symbol in the MySQL http://en.wikipedia.org/wiki/Logo logo was given the http://en.wikipedia.org/wiki/Swati_language Swati name Sakila in October 2002 after a naming contest
Re: Question on InnoDB support
Hi Waldo, all! [EMAIL PROTECTED] wrote: I'm making an assessment of MySQL possible official adoption in my company. A question I have is: with InnoDB codebase being owned by Oracle, is there any impact to its reliability and support? Any other issues? The developers of InnoDB have never been employees of MySQL AB but rather worked for an independent company, Innobase Oy (AFAIR). There were contracts between Innobase and MySQL about cooperation and support, and this worked well to the satisfaction of all parties (including the customers). Last year, *after* Innobase was bought by Oracle, these contracts were renewed (the old period had expired), and cooperation and support continue as before. InnoDB developers continue to be active on this mailing list and in MySQL bug handling, so I see no reason to be concerned. Regards, Joerg Bruehe -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com MySQL GmbH, Hauptsitz: Radlkoferstr. 2, D-81373 München Geschäftsführer: Kaj Arnö - HRB München 162140 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question on InnoDB support
I'm making an assessment of MySQL possible official adoption in my company. A question I have is: with InnoDB codebase being owned by Oracle, is there any impact to its reliability and support? Any other issues? Waldo Tumanut Database Analyst CONFIDENTIALITY NOTICE: This electronic mail transmission (including any accompanying attachments) is intended solely for its authorized recipient(s), and may contain confidential and/or legally privileged information. If you are not an intended recipient, or responsible for delivering some or all of this transmission to an intended recipient, be aware that any review, copying, printing, distribution, use or disclosure of the contents of this message is strictly prohibited. If you have received this electronic mail message in error, please contact us immediately by electronic mail at [EMAIL PROTECTED] and destroy the original and all copies of this transmission (including any attachments). Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL IPv6 Support?
Hello, I have searched every corner of the internet for info on MySQL's IPv6 support, but have not found much information. I have a Linux box with an IPv6 address. It can be pinged from other machines (Linux and Windows) by its IPv6 address. However, I cannot get this command to work: mysql -h ::1 This gives me an “Unknown Host” error. Has anyone ever gotten an example like that to work? This is the IPv6 equivalent of mysql -f 127.0.0.1 (which works on that machine). Obviously, my goal is to do something a bit more complicated, but I can't even get that simple use of IPv6 to work. Any help appreciated. -- View this message in context: http://www.nabble.com/MySQL-IPv6-Support--tf3584588.html#a10016526 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]