WTO ISCO database
Does anyone has a database dump of the World Trade Organisation’s International Standard Classification of Occupation. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Besoin d'aide urgent
Em Sat, 11 Nov 2006 16:03:41 +0100, Yannick Landry ANTONIO escreveu: Je viens au pres de vous solliciter une aide en ce qui concerne le demarrage du serveur mysql. Eſt-ce qu’il n’y a pas de liſte francophone ? J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-win Cette verſion eſt trop vielle, ſurtout ſur MS Windows il faudrait attendre des problèmes. Quelle verſion de MS Windows utilisez vous ? Il le faudrai au moins MS WNT, pas 3.11, 9[58] ou ME. Je constate qu'il n'y a pas un racourcie pour la source graphique. J'ai tente de demarrer le server en ligne de commande en me mettant sur: C:\mysql\bin puis en entrant la commande suivante: mysqld-nt.exe mais celui ci ne se lance pas. Existe t'il une autre maniere d'aborder la situation??? Il doive être un ſervice, pas lancé à la ligne de commande. Je vous remercie d'avance pour avoir une solution a ce probleme et j'aimerai savoir s'il existe un mode graphique pour cette version de mysql???. Pluſieurs, mais ça n’est pas ton problème maintenant. Ah, une note: eßayez PostgreSQL, c’eſt un ſyſtème plus ſolide. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: access full-text index
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote: Is it possible to access the Full-Text Index structures from SQL? What do you mean exactly? SQL is not intended for physical structures. -- Leandro Guimarães Faria Corcete DUTRA+55 (11) 5685 2219 http://br.geocities.com./lgcdutra/ +55 (11) 9406 7191 mailto:[EMAIL PROTECTED] +55 (11) 2122 0302 xmpp:[EMAIL PROTECTED] ymsgr:sendIM?lgcdutra BRASIL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimize question
On Wed, 08 Nov 2006 15:38:27 -0500, Francis wrote: If I do a select to get the log for this date 2006-01-01 : Select * from mytable where mydate = '2006-01-01' and mydate = '2006-01-01'. Do you think is more faster to do on table with have only one date or is the same think if I do it on table whit all day ? That is what indexes are for. And last question, if I do a group by, I think the group by is faster on column as type INT Vs Varchar ? Not necessarily so. -- Leandro Guimarães Faria Corcete DUTRA+55 (11) 5685 2219 http://br.geocities.com./lgcdutra/ +55 (11) 9406 7191 mailto:[EMAIL PROTECTED] +55 (11) 2122 0302 xmpp:[EMAIL PROTECTED] ymsgr:sendIM?lgcdutra BRASIL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: www.innodb.com
Em Thu, 09 Nov 2006 09:26:52 -0800, Bill MacAllister escreveu: What happened to the Innodb web pages? What comes up for be is a search page with a bunch of related links on it. I wanted to pull down a copy of ibbackup documentation and it isn't there anymore. Perhaps they are at Oracle now? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Regular expression not working as expected (documented)?
I must have understood something wrong in the regexps docs: SELECT login FROM orolixMain.Usersu WHERE u.login REGEXP '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' ; [EMAIL PROTECTED](none) \. usr/src/oro/qry/phshr.sql +---+ | login | +---+ […] | walt[…] | […] +---+ 49 rows in set (4.46 sec) The regexp I used was to return strings began by wa, followed by [bhkl], and then by one to five characters in the [_[.period.]-acegmnopqrsuvwxyz] list. But I get, among otherss, a string beginning with 'walt' (several, in fact). Ideas? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Regular expression not working as expected (documented)?
Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu: On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote: u.login REGEXP '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' ... But I get, among otherss, a string beginning with 'walt' (several, in fact). Probably MySQL don't know about this [.period.] thing and just takes the . in it as any char, e.g. your t from walt. I got that from cname.h, mentioned in the MySQL regexp documentation. Try '^wa[bhkl][-_acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*', if there is a - at the beginning of a character class it is usually threaten literally as it makes no sense as from..to separator in those cases. Hm, but I do need to take into account the period. Also, do you mean the - at the beginning will make all following characters be treated literally? -- +55 (11) 5685 2219 xmpp:[EMAIL PROTECTED] +55 (11) 9406 7191 Yahoo!: ymsgr:sendIM?lgcdutra +55 (11) 5686 9607 ICQ/AIM: aim:GoIM?screenname=61287803 MSN: msnim:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Regular expression not working as expected (documented)?
Em Qua, 2006-11-08 às 12:53 -0600, Dan Nelson escreveu: . within brackets is treated literally anyway, so there's no need to use [.period.]. OK, I had taken the effects of - as being the effects of . REGEXP BINARY '^wa[bhkl][-_.acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' It indeeds works much better. I tried to improve it: '^wa[bhkl][-_.acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ][-_.acegmnopqrsuvwxyz]*' This is to account that the last characters can’t have ascendents (don’t ask me why), but it still doesn’t seem to be quite right: […] | wabatizelli | -- I don’t want two ‘l’s | wabetosp| -- I want one of [23890IJOQ] after that t | walvent33 | -- I don’t want two ‘3’s, only one. […] I tried putting {1} after each of [14Lt] and [23890IJOQ] to no avail; and MySQL didn’t accept *? at the end, to become non-greedy. Perhaps regexps are just too hard to me… -- +55 (11) 5685 2219 xmpp:[EMAIL PROTECTED] +55 (11) 9406 7191 Yahoo!: ymsgr:sendIM?lgcdutra +55 (11) 5686 9607 ICQ/AIM: aim:GoIM?screenname=61287803 MSN: msnim:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM vs InnoDB
Em Fri, 03 Nov 2006 09:18:21 +0100, Martijn Tonies escreveu: On two-phase commits? I guess it's the IB 6 docs where you have to read that, or get a copy of Helen Borries Firebird book. Get a copy of the IBPhoenix CD that includes docs. The Firebird project itself has no full documentation yet - it's being worked on. Hm, do you mean 2PC are only documented in old IB6 stuff? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM vs InnoDB
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu: PostgreSQL supports 2 phase commit. IIRC except for transaction interleaving, join and suspend/resume it supports XA. I think that puts it about on par with Ingres and Firebird. I would have to analyze better, but I think you are mistaken, sadly. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Pushing mysql to the limits
Em Wed, 01 Nov 2006 00:00:23 -0800, Cabbar Duzayak escreveu: We have huge amount of data, and we are planning to use logical partitioning to divide it over multiple machines/mysql instances. This is a hard call. You will have to keep data consistent among servers, and MySQL does not support distributed transactions: it does have the XA interface, but it does not do its job properly. As far as I know, the only free SQL DBMS supporting distributed transactions is Ingres. We are planning to use Intel based machines and will prefer ISAM since there is not much updates but mostly selects. You are asking for trouble. Hear the voice of experience. So, what I wanted to learn is how much can we push it to the limits on a single machine with about 2 gig rams? Do you think MYSQL can handle ~ 700-800 gigabyte on a single machine? Probably yes, but it will all depend on what you will do precisely with it. Anyway, you would be much better of with a more solid system, preferrably with proper XA distributed transactions (two-phase commit). And, is it OK to put this much data in a single table, or should we divide it over multiple tables? With a proper DBMS, you can partition the table in physical segments without complicating the logical model. Check Ingres or PostgreSQL, perhaps MySQL’s own MaxDB. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM vs InnoDB
Em Wed, 01 Nov 2006 09:34:05 -0600, mos escreveu: At 05:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote: Always use a DBMS, and MySQL is no (proper) DBMS without a transactional backend. There are InnoDB, which is not completely free (needs a proprietary backup tool); BDB, which is deprecated until further notices; and SolidDB, which is still β. Ok, so your solution is to use something else? Well, this is a MySQL list… you can use MySQL with InnoDB, if you are willing to either have a proprietary backup solution or to use a β backend. Is there a better open source database out there for that amount of data? Several. MySQL’s own MaxDB, PostgreSQL, Firebird if you are into Borland stuff, Ingres if you need XA distributed transactions. I usually recommend PostgreSQL, or Ingres if two-phase commits are needed. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM vs InnoDB
Em Thu, 02 Nov 2006 15:32:06 +0100, Martijn Tonies escreveu: Several. MySQL’s own MaxDB, PostgreSQL, Firebird if you are into Borland stuff, Ingres if you need XA distributed transactions. Firebird isn't Borland Granted. But it is (even more) attractive if you are already a Borland shop. I usually recommend PostgreSQL, or Ingres if two-phase commits are needed. Firebird has two-phase commits. Great to know — do you have any pointers? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM vs InnoDB
Em Thu, 02 Nov 2006 17:30:14 +0100, Martijn Tonies escreveu: Falcon has a transactional storage engine, including Foreign Keys (Jim wouldn't do a database without em) Obviouſly. MGA Ma ze? -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM vs InnoDB
Em Thu, 02 Nov 2006 17:40:44 +0100, Martijn Tonies escreveu: InterBase had two-phase commits ages ago, Firebird inherited it. If there's anything specific you want to know, ask I *am* asking — where is the specific piece of documentation? Because if you don’t read MySQL’s documentation attentively, it gives you the impression everything’s A-OK with XA. And it’s not. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM vs InnoDB
Em Tue, 31 Oct 2006 15:24:44 -0500, Francis escreveu: MyISAM vs InnoDB ? What is the best to use Always use a DBMS, and MySQL is no (proper) DBMS without a transactional backend. There are InnoDB, which is not completely free (needs a proprietary backup tool); BDB, which is deprecated until further notices; and SolidDB, which is still β. Choose your evil. -- Leandro Guimarães Faria Corcete DUTRA +55 (11) 9406 7191 (cel) Administrador de (Bases de) Dados +55 (11) 2122 0302 (com) http://br.geocities.com./lgcdutra/+55 (11) 5685 2219 (res) BRASILmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]