Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX
Is it possible to MySQL Community Edition (as target) from Informatica Powercenter 9.5.1 running on AIX? If so, what is ODBC driver should we use?
Re: MySQL Connector/ODBC 5.2.6 has been released
no binaries for AIX?
--
saqib
http://hivemined.net
On Wed, Oct 9, 2013 at 3:02 PM, Kent Boortz wrote:
>
> Dear MySQL users,
>
> MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the
> MySQL database management system, has been released.
>
> The available downloads include both a Unicode driver and an ANSI
> driver based on the same modern codebase. Please select driver type
> you need based on the type of your application - Unicode or ANSI.
> Server-side prepared statements are enabled by default. It is suitable
> for use with any MySQL version since 4.1 (It will not work with 4.0 or
> earlier releases.)
>
> The release is now available in source and binary form for a number of
> platforms from our download pages at
>
>
> https://urldefense.proofpoint.com/v1/url?u=http://dev.mysql.com/downloads/connector/odbc/5.2.html&k=2a4Akkj3oY%2FOkjwft1MTMw%3D%3D%0A&r=87QPkuwxTJwqBO%2Bh4edD4j3tpM%2BFzlMhKOz%2B9QNZPGo%3D%0A&m=L%2FgKYklRPKzhryVewvSQf1uRAbXq8OAWOmVW6e%2Fr%2Bg4%3D%0A&s=9074990ebf9e3277c9367db7b7881d214e8cf4ff3ca73847e2cab5b90b167d9c
>
> MySQL Connector/ODBC 5.2.6 will also be available for downloads via the
> Oracle Software Delivery Cloud in approximately 1-2 weeks.
>
> For information on installing, please see the documentation at
>
>
> https://urldefense.proofpoint.com/v1/url?u=http://dev.mysql.com/doc/refman/5.6/en/connector-odbc-installation.html&k=2a4Akkj3oY%2FOkjwft1MTMw%3D%3D%0A&r=87QPkuwxTJwqBO%2Bh4edD4j3tpM%2BFzlMhKOz%2B9QNZPGo%3D%0A&m=L%2FgKYklRPKzhryVewvSQf1uRAbXq8OAWOmVW6e%2Fr%2Bg4%3D%0A&s=544722c0f324655dcf7be180c365423e7cbdb91c9de221f2ef29cbd0ef2ed2dc
>
> Enjoy!
>
> The MySQL Connectors team at Oracle
>
>
>
> ==
> Changes in MySQL Connector/ODBC 5.2.6
>
> Functionality Added or Changed
>
> * Added a lock in the ENV structure against simultaneous accesses to
> an environment handle's connection list, in order to avoid memory
> access issues that might occur when multiple threads share the same
> environment handle. (Bug #17240611, Bug #69864)
>
> Bugs Fixed
>
> * Memory leaks occurred in SQLPrepare() and SQLExecDirect() when
> SQLBindParamater was used on the SQL statements. This fix frees
> previous results of mysql_stmt_result_metadata() in order to prevent
> the memory leaks. (Bug #17400483, Bug #70113)
>
> * The exit condition for a for loop in stringutil.c is changed to
> avoid a possible out-of-bounds error and the associated reports by
> Valgrind. (Bug #17397596, Bug #64105)
>
> * Microsoft Visual Studio 2010 crashed when reading rows from any
> table in Server Explorer with connections to DSNs made by
> Connector/ODBC. (Bug #17304031, Bug #69950)
>
> * When SQL TIME data was converted to the C data type of TIMESTAMP, if
> the value of the hour field is greater than 24, the date fields did
> not get set to the current date and the fraction field for seconds
> did not get set to zero as required by the ODBC specifications.
> (Bug #17016839, Bug #69545)
>
> * When trying to create a linked server in Micrsoft SQL Server 2008 to
> a MySQL server set up with Connector/ODBC as a DSN, the Microsoft
> SQL Server (if it is a 64-bit version) crashed or the linked server
> suffered a catastrophic failure (if a 32-bit version of the
> Microsoft SQL Server is used). (Bug #16604346, Bug #63386)
>
> * When reading TIME column data using the SQLGetData method into the
> SQL_C_TYPE_TIME datatype, errors occured when the time string
> contained more than 6-digits (e.g., 120:53:44).
> (Bug #16176981, Bug #67793)
>
> * When called after SQLPrepare, the funciton SQLMoreResults returned
> SQL_ERROR, instead of SQL_NO_DATA as required by the ODBC
> specification. (Bug #16101282, Bug #67920)
>
> * Connector/ODBC used the ";" character instead of a null byte ("\0")
> to terminate keyword-value pairs in attribute strings.
> (Bug #15940689, Bug #66548)
>
> * When using the Unicode-enabled version of the Connector/ODBC driver
> to connect to any MySQL server of version 5.5.2 or older, all
> statements failed with the error message .Server does not support
> 4-byte encoded UTF8 characters.. (Bug #14838690, Bug #67428)
>
> * The configured values of a DSN's parameters overrode the values
> provided through the connection string, instead of the other way
> round. (Bug #11760574, Bug #52996)
>
>
> Built against the MySQL server 5.6.14 client library.
>
> --
> Kent Boortz, Release Staff engineer
> Oracle, The MySQL Team
> Mobile: +46 76 77 69 049
>
> --
> MySQL General Mailing List
> For list archives:
> https://urldefense.proofpoint.com/v1/url?u=http://lists.mysql.com/mysql&k=2a4Akkj3oY%2FOkjwft1MTMw%3D%3D%0A&r=87QPkuwxTJwqBO%2Bh4edD4j3tpM%2BFzlMhKOz%2B9QNZPGo%3D%0A&m=L%2FgKYklRPKzhryVewvSQf1uRAbXq8OAWOmVW6e%2Fr%2Bg4%3D%0A&s=0406d8c5fc71760575ea672f27147b6cd35a3d2164f94c0f6e57396
optimizing left join query
Hello All, I have the following 2 tables and "LEFT join" query as follows: mysql> describe user_lic; +++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +++--+-+-+---+ | license_id | bigint(20) | | PRI | 0 | | | user_id| bigint(20) | | PRI | 0 | | | location | char(30) | YES | | NULL| | +++--+-+-+---+ mysql> describe user_info; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | uid | int(10) unsigned | YES | | NULL| | | location | char(30) | YES | | NULL| | | mail | char(100)| YES | | NULL| | +--+--+--+-+-+---+ query = SELECT * FROM user_lic LEFT JOIN user_info ON user_lic.user_id=user_info.uid WHERE user_info.uid is NULL AND (user_lic.location = 'Rochester, US') When I run this query on a 'user_lic' table with 1000+ rows, it takes about 20+ mins to complete the query. However a similar query on a Oracle DB takes couple of minutes. I am using a high-end Sun Server, connected to a Xiotech SAN, using Fiber Optics. I dont think the Hardware is the bottle neck. I am wondering how I can optimize the Query/MySQL DB to make this query go faster. In Peace, Saqib Ali "I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection)" Al-Quran 6:15 http://docbook.sc-icc.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: optimizing left join query
Diana, Thanks for the suggestion. I completely forgot to add the index/primary key. Now it works just fine :) Thanks again. In Peace, Saqib Ali "I fear, if I rebel against my Lord, the retribution of an Awful Day (The Day of Resurrection)" Al-Quran 6:15 http://docbook.sc-icc.org |+---> || Diana Soares | || <[EMAIL PROTECTED]| || p.pt>| || No Phone Info| || Available| || | || 02/11/2003 | || 08:59 AM | || | |+---> >| | | | To: [EMAIL PROTECTED] | | cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> | | Subject: Re: optimizing left join query | >| Your user_info table is not indexed... (user_info.uid should have an index) Check the manual: http://www.mysql.com/doc/en/MySQL_indexes.html On Tue, 2003-02-11 at 16:16, [EMAIL PROTECTED] wrote: > Hello All, > > I have the following 2 tables and "LEFT join" query as follows: > > > mysql> describe user_lic; > +++--+-+-+---+ > | Field | Type | Null | Key | Default | Extra | > +++--+-+-+---+ > | license_id | bigint(20) | | PRI | 0 | | > | user_id| bigint(20) | | PRI | 0 | | > | location | char(30) | YES | | NULL| | > +++--+-+-+---+ > > > mysql> describe user_info; > +--+--+--+-+-+---+ > | Field| Type | Null | Key | Default | Extra | > +--+--+--+-+-+---+ > | uid | int(10) unsigned | YES | | NULL| | > | location | char(30) | YES | | NULL| | > | mail | char(100)| YES | | NULL| | > +--+--+--+-+-+---+ > > query = SELECT * FROM user_lic LEFT JOIN user_info ON > user_lic.user_id=user_info.uid WHERE user_info.uid is NULL AND > (user_lic.location = 'Rochester, US') > > > When I run this query on a 'user_lic' table with 1000+ rows, it takes about > 20+ mins to complete the query. However a similar query on a Oracle DB > takes couple of minutes. > > I am using a high-end Sun Server, connected to a Xiotech SAN, using Fiber > Optics. I dont think the Hardware is the bottle neck. > > I am wondering how I can optimize the Query/MySQL DB to make this query go > faster. > > > > In Peace, > Saqib Ali > "I fear, if I rebel against my Lord, the retribution of an Awful Day (The > Day of Resurrection)" Al-Quran 6:15 > http://docbook.sc-icc.org > -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Not able to compile "mysql-test"
Hi, I have been working with mySQL and Apache for years on linux servers. But recently I purchased Solaris machine, and I am have problems compiling mySQL on it. I have - SunOS machine1 5.8 Generic_108528-10 sun4u sparc SUNW,Sun-Blade-100 - with gcc 2.95.3 20010315 And I am getting the following errors when I run the make command. And I am not using any weird option with configure. I m just using --prefix=/usr/local/mysql Making all in tests make[2]: Entering directory `/download/mysql-3.23.43/tests' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/download/mysql-3.23.43/tests' Making all in man make[2]: Entering directory `/download/mysql-3.23.43/man' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/download/mysql-3.23.43/man' Making all in sql-bench make[2]: Entering directory `/download/mysql-3.23.43/sql-bench' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/download/mysql-3.23.43/sql-bench' Making all in mysql-test make[2]: Entering directory `/download/mysql-3.23.43/mysql-test' make[2]: *** No rule to make target `all'. Stop. make[2]: Leaving directory `/download/mysql-3.23.43/mysql-test' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/download/mysql-3.23.43' make: *** [all-recursive-am] Error 2 Any help would be highly appreciated. Thanks Saqib Ali - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
