Re: Single Column Indexes Vs. Multi Column
Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? Regards, Cor - Original Message - From: Sebastian Mendel [EMAIL PROTECTED] To: Michael Stearne [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com Sent: Thursday, January 10, 2008 6:57 AM Subject: Re: Single Column Indexes Vs. Multi Column Michael Stearne schrieb: For a query like: SELECT id FROM properties WHERE `Country` = 'USA' AND Type='Residential' Is an multi-column index that is (Country, Type) better or worse or the same as a single index Country and another single index Type. better two single indexes depending on your MySQL version will not be used. -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Download MySQL 4.0.30
Iago, all, [EMAIL PROTECTED] wrote: Hi. I has a Linux server with MySQL 4.0.27 and I want to upgrade to 4.0.30 but I both the 4.0 and 4.1 MySQL release families have reached their end of active development and are in extended lifecycle only. This means there is neither development not continuous publishing for these release families, all they get is security fixes if severe issues should show up. 4.0.30 is such a version. Customers who pay for this extended support then get access to binaries including these fixes. You will find a more detailed description here: http://www.mysql.com/company/legal/mysql_lifecycle_policy.pdf couldn't find in HYPERLINK http://www.mysql.comwww.mysql.com or in the web the file mysql-standard-4.0.27-pc-linux-gnu-i686.tar.gz. Also the link HYPERLINK http://downloads.mysql.com/archives.phphttp://downloads.mysql.com/archives .php doesn't work. Could somebody provide a link to this file? I'm surprised about this and will try to check. HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Single Column Indexes Vs. Multi Column
C.R.Vegelin wrote: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? AFAIK, MySQL (atleast from version 5.0 onwards) is capable of using multiple indexes. -- Regards, Anup Shukla -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Download MySQL 4.0.30
Iago, all, Joerg Bruehe wrote: [EMAIL PROTECTED] wrote: [[...]] couldn't find in HYPERLINK http://www.mysql.comwww.mysql.com or in the web the file mysql-standard-4.0.27-pc-linux-gnu-i686.tar.gz. Also the link HYPERLINK http://downloads.mysql.com/archives.phphttp://downloads.mysql.com/archives .php doesn't work. Could somebody provide a link to this file? I'm surprised about this and will try to check. it seems this was an intentional change, maybe because the versions available there did not get fixes for newly discovered security issues. However, there are other archives which still carry this - a colleague pointed me to ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-4.0/ HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Single Column Indexes Vs. Multi Column
C.R.Vegelin schrieb: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? IMHO, but i heard elselike too, but cannot find any proof in the manual ... -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Single Column Indexes Vs. Multi Column
Anup Shukla schrieb: C.R.Vegelin wrote: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? AFAIK, MySQL (atleast from version 5.0 onwards) is capable of using multiple indexes. i have heard of something similar too, but cannot find any proof in the manual only counterpart, f.e.: http://dev.mysql.com/doc/refman/6.0/en/order-by-optimization.html In some cases, MySQL cannot use indexes to resolve the ORDER BY, although it still uses indexes to find the rows that match the WHERE clause. These cases include the following: [...] The key used to fetch the rows is not the same as the one used in the ORDER BY: -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Single Column Indexes Vs. Multi Column
Perrin Harkins schrieb: On Jan 11, 2008 7:22 AM, Sebastian Mendel [EMAIL PROTECTED] wrote: i can only find one source in the manual, where MySQL is using more than on index: http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html Uh, how many sources do you need? 1? It uses multiple indexes, just like it says. This has been true since 5.0. yes, i can read ... ;-) -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Single Column Indexes Vs. Multi Column
On Jan 11, 2008 7:22 AM, Sebastian Mendel [EMAIL PROTECTED] wrote: i can only find one source in the manual, where MySQL is using more than on index: http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html Uh, how many sources do you need? It uses multiple indexes, just like it says. This has been true since 5.0. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Help / Error Thx
Dear Users I searched google, find alot of tips, but none of the them was successfully. After a db move with ibdata files, which cannot be dumped (cause of a table failure) we made a hardcopy of the files and moved it onto the new server. Eg. we copy ibdatafiles, the original my.cnf to the new server, we did NOT copy the ib_logfiles (2) and the old bin files like hostname.0001 ..(we tough its only for slave/master) After starting the new mysql server, this follows in *.err log all the time. The Database is runnning fine, but the log is to full after few seconds. Re-dumping is not possible Any ideas how i can fix it? Check Tables means all is ok. Thank you -matthias 080111 14:42:20 InnoDB: Error: page 158199 log sequence number 3 974369182 InnoDB: is in the future! Current system log sequence number 0 3271712681. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See http://dev.mysql.com/doc/mysql/en/backing-up.html for more information. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Download MySQL 4.0.30
Hi, Joerg. Thanks for the response. In ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-4.0/ and other similars that I find looking for mysql/Downloads/MySQL-4.0 in google there is only MySQL 4.0.26 and 4.0.27. both the 4.0 and 4.1 MySQL release families have reached their end of active development and are in extended lifecycle only. This means there is neither development not continuous publishing for these release families, all they get is security fixes if severe issues should show up. 4.0.30 is such a version. Customers who pay for this extended support then get access to binaries including these fixes. This meens that 4.0.30 is never published publicy. Correct me if I wrong. Iago. -Mensaje original- De: Joerg Bruehe [mailto:[EMAIL PROTECTED] Enviado el: viernes, 11 de enero de 2008 11:51 Para: [EMAIL PROTECTED] CC: MySql Mail List Asunto: Re: Download MySQL 4.0.30 Iago, all, Joerg Bruehe wrote: [EMAIL PROTECTED] wrote: [[...]] couldn't find in HYPERLINK http://www.mysql.comwww.mysql.com or in the web the file mysql-standard-4.0.27-pc-linux-gnu-i686.tar.gz. Also the link HYPERLINK http://downloads.mysql.com/archives.phphttp://downloads.mysql.com/archives .php doesn't work. Could somebody provide a link to this file? I'm surprised about this and will try to check. it seems this was an intentional change, maybe because the versions available there did not get fixes for newly discovered security issues. However, there are other archives which still carry this - a colleague pointed me to ftp://mysql.secsup.org/pub/software/mysql/Downloads/MySQL-4.0/ HTH, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.0/1218 - Release Date: 10/01/2008 13:32 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.0/1218 - Release Date: 10/01/2008 13:32 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Single Column Indexes Vs. Multi Column
Sebastian Mendel schrieb: Anup Shukla schrieb: C.R.Vegelin wrote: Sebastian, MySQL uses only one index for searching. As far as I know this applies to all MySQL versions, right ? AFAIK, MySQL (atleast from version 5.0 onwards) is capable of using multiple indexes. i have heard of something similar too, but cannot find any proof in the manual only counterpart, f.e.: http://dev.mysql.com/doc/refman/6.0/en/order-by-optimization.html In some cases, MySQL cannot use indexes to resolve the ORDER BY, although it still uses indexes to find the rows that match the WHERE clause. These cases include the following: [...] The key used to fetch the rows is not the same as the one used in the ORDER BY: i can only find one source in the manual, where MySQL is using more than on index: http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
union operator problems in MySQL v3.23?
Notwithstanding end-of-life status, is there an issue in MySQL v3.23 r.e. the union operator? My installation returns a syntax error on any query containing the union operator, even with the sample queries provided in the documentation: mysql SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10); ERROR 1064: syntax error near 'UNION SELECT REPEAT('b',10)' at line 1 -- Thanks, Glenn Gillis ELAW U.S. Information Technology Manager Environmental Law Alliance Worldwide http://www.elaw.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: union operator problems in MySQL v3.23?
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote: Notwithstanding end-of-life status, is there an issue in MySQL v3.23 r.e. the union operator? My installation returns a syntax error on any query containing the union operator, even with the sample queries provided in the documentation: mysql SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10); ERROR 1064: syntax error near 'UNION SELECT REPEAT('b',10)' at line 1 Support for UNION was not added until 4.0. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: union operator problems in MySQL v3.23?
Jim Winstead wrote, On 1/11/2008 12:54 PM: On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote: Notwithstanding end-of-life status, is there an issue in MySQL v3.23 r.e. the union operator? My installation returns a syntax error on any query containing the union operator, even with the sample queries provided in the documentation: mysql SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10); ERROR 1064: syntax error near 'UNION SELECT REPEAT('b',10)' at line 1 Support for UNION was not added until 4.0. Jim Winstead MySQL Inc. Thanks, Jim and David. I guess it's about time to upgrade! -- Glenn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]