Very slow subselect (parser bug)?

| HYX-Rjdmmtyubvbqeczvwxz | | 3622 | 4149 | 4149 | 0 | NULL | Uayfhjjlge | | 3741 | 4283 | 4283 | 0 | NULL | Sflnh QK/Flkudduiwmkbdqz | +++---++---+------+ 11 rows in set (0.00 sec) The same result

Re: mysql load balancing

orry I cannot help you, > but please, share here if you found something useful AND with good > performance. > > Merry Xmas! > -- > Jaime Crespo > MySQL & Java Instructor > Warp Networks > <http://warp.es> > > -- > MySQL General Mailing List > For list arc

Re: Monitoring MySQL availability

ous commercial offering, but they were all "sub-quality"/"way costlier" than those 2 solutions. Pascal Charest -- Pascal Charest, skype: pascal.charest Free software consultant @ Les Laboratoires Phoenix http://www.labsphoenix.com 2009/2/27 Claudio Nanni > We monitor hun

Re: [Solved] Compiled configure string

Hi, 'mysqlbug' is a sh shell script in which the configure string is hardcoded. You can get a cleaner output of the configure line by using this command: grep ^CONFIGURE_LINE $(which mysqlbug) P. -- Pascal Charest, Free software consultant {GNU/Linux} http://blog.pacharest.com O

Re: MySQL and Mandrake 10.2

THe MySQL packages was not well installed. I remove the packages and re-install them after, the file "/ect/sysconfig/mysql" appears, and after modifications, everything works well. Thanks. On Tuesday 26 July 2005 10:09, Pascal Francq wrote: > Since I make an install, Mandrake has

Re: MySQL and Mandrake 10.2

.mandriva.com/twiki/bin/view/Main/MandrivaLinux2005ReleaseNotes#My >SQL -- Prof. Pascal Francq Université libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brussels BELGIUM Tel. +32-2-650 47 65 Fax +32-2-650 47 24 -- MySQL General Mailing List For list archives: http://lists.mys

MySQL and Mandrake 10.2

hat something has changed concerning the configuration of MySQL or the access to the network, but I do not what. Anyone an idea? -- Prof. Pascal Francq Université libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brussels BELGIUM Tel. +32-2-650 47 65 Fax +32-2-650 47 24

MySQL 4.0.18 and Unicode

to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8' at line 1. -- Prof. Pascal Francq Université libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brussels BELGIUM Tel. +32-2-650 47 65 Fax +32-2-650 47 24 -- MyS

Re: MySQL and Unicode

http://www.pro.or.jp/~fuji/index-eng.html > [EMAIL PROTECTED] Puzzle Japan http://www.puzzle.jp/ > -- Prof. Pascal Francq Université Libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brus

MySQL and Unicode

can I use it with the C API? Thanks. -- Prof. Pascal Francq Université Libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brussels BELGIUM Tel. +32-2-650 47 65 Fax +32-2-650 47 24 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Difference between 'mysql_real_query' and 'mysql_send_query'

;t find the difference between mysql_send_query and mysql_real_query in MySQL documentation. Does anyone know something about it? thanks for help ! -- Prof. Pascal Francq Université Libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brussels BELGIUM Tel. +32-2-650 47 65 Fax +32-

Question on data structures

solution, two tables with one of them can be very large. For the second solution, many tables but with no large sizes. Is one of the solutions better than another with regards to the way MySQL handles tables and row (in fact, for practical reasons, I prefer the second solution). Thanks. -- Dr Ir

Re: Nested SELECT statements problem

Since I'm new to mySQL, could you point me how to create temporary tables dynamically? Le dimanche, 3 aoû 2003, à 15:32 Canada/Eastern, Jim McAtee a écrit : - Original Message - From: "Pascal Délisle" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sund

Re: Nested SELECT statements problem

The only problem I see is when there are concurrent access to the table "livreTemp", e.g. when there are multiple simultaneous requests of that kind. Is there a better way for achieving this under mySQL 3? Le dimanche, 3 aoû 2003, à 12:41 Canada/Eastern, Pascal Délisle a écrit : Th

Re: Nested SELECT statements problem

be matched; or otherwise the query will not return anything. Hope this helps. Lin -Original Message- From: Pascal Délisle [mailto:[EMAIL PROTECTED] Sent: Saturday, August 02, 2003 11:46 PM To: [EMAIL PROTECTED] Subject: Nested SELECT statements problem Hi! I tr

Nested SELECT statements problem

Hi! I try to figure out how to use a nested "SELECT" statement after the "IN" predicate. For example, when I try this code, it doesn't return anything although it should: SELECT book.IDLivre, aut.Prenom, aut.Nom FROM livre book, livreEcritPar ecr, auteur aut WHERE ecr.IDLivre = book.IDLivre A

sum() autoconvert null to zero

Hi thanks for answer, maybe it would be good to have a sum_null() function to deal with my case ? because logically speaking, when a value is null in an operation the result is null, this is the case for normal functions in mysql (ie not "group by" function) i think it is perfect sense that cou

sum() autoconvert null to zero

- Original Message - From: pascal barbedor To: [EMAIL PROTECTED] Sent: Sunday, March 31, 2002 6:19 AM Subject: sum() autoconvert null to zero Egor, >Null is an unidentified value, but MySQL will store 0 or ''. You can read about >it at: > http://www.mysql.com/doc

Any limit of the Query Buffer ???

Anyone here know if there is a limit of the number of query I can do in a Do While of a VB program ? --- Pascal Richer [EMAIL PROTECTED] Étudiant en Informatique et Génie Logiciel Université du Québec à Montréal

Too many Query at the same time

L Server ON 192.168.1.34". Does I need to modify a connect_timeout or a variable like this to solve my problem and if so, how can I do it ? I'm on Win 98... Thanks ! --- Pascal Richer [EMAIL PROTECTED] Étudiant en Informatique et Génie Logic

Error while executing a MySQL command from C API

Hi, I have the following error while excuting a sql INSERT query: "Commands out of sync; you can't run this command now". What king of error is this? -- Ir Pascal Francq Researcher Université Libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 B

RE: Troubles with cutting a row(solved)

If somebody interested I've got a solution: SELECT count(*) as quan, SUBSTRING(r_js, 1, locate('/', r_js, 8)) as a FROM main where length(r_js) group by a order by quan desc; On 04-Oct-2001 [EMAIL PROTECTED] wrote: > Hi there! > I have a varchar(255) row in a table, that contains some URL f.e. >

RE: DISTINCT

Hi! select count(*), model from tbl group by model; On 04-Oct-2001 Osman Omar wrote: > Hi, > > I have a table like this > > model color > - > 135 blue > 135 red > 135 green > 235 black > 235 green > > > How do I get how many row in each

RE: Troubles with cutting a row

Excuse me for putting confirm reading flag ON. On 04-Oct-2001 [EMAIL PROTECTED] wrote: > Hi there! > I have a varchar(255) row in a table, that contains some URL f.e. -- Ruben Muradyan System Administrator/Security Manager PanARMENIAN Network +-

Troubles with cutting a row

Hi there! I have a varchar(255) row in a table, that contains some URL f.e. http://www.somehost.net/eng/headlines/cache/699.htm I need to cut the first (http://www.somehost.net) part from this URL. After looking at regexp realization in MySQL I've written SELECT r_js REGEXP "^[http://./]"; as

MySQL and Websphere Test Environment

Hello ! I'd like to know how I could use MySQL within Visual Age for Java's Websphere Test Environment. More precisely, i'd like to use MySQL to support the persistence capabilities of the EJB server of Visual Age for Java's Websphere Test Environment. Thanks for helping. P. Gos This email a

--default-character-set

my database or does it mean mysql would convert it dynamically when sending something to a client ? has anyone got the same problem ? looked in the docs, but not a word on utf-8. thanks pascal barbedor

bug

obase : we intentionnaly generat a memory trap Innobase : send a bug report to [EMAIL PROTECTED] got signal 11 aborting thanks for help pascal - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: php/mysql question

Did you try the following code $updtStmt = "update vusers set orgname=\"$tname1\" where id=$tid"; Should do the job. Regards P. Miquet - Original Message - From: "Adrian D'Costa" <[EMAIL PROTECTED]> To: "Mysql Mailing List" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 7:59 AM Subject

Re: Making SQL request from a Mac

let me make the link into this environnement. Regards Pascal Miquet - Original Message - From: "Ansgar Becker" <[EMAIL PROTECTED]> To: "Pascal MiQUET" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 6:

Making SQL request from a Mac

Hi, I'd like to get informations from my MySQL Server on LiNUX, and the query must be made from a Mac (Not an Os X)! Is there a good solution ? If it's not possible, How can I get access to a PC With windows ? Thanks for your help. Regards Pas

request

I'd like to know how many similtanous request support a MySql database . thanks for answering - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

RE: size limitation

Hi, For our benchmarks, we use for the MySQL Server a Sun Enterprise 3500 with 4 UltraSPARC processors, 6 Go of RAM, 3 disks of 40 Go... MySQL runs under Solaris 7. > -Message d'origine- > De: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]] > Date: vendredi 23 mars 2001 19:

RE: size limitation

se of storage limitations). 10 days of lifetime for our datas will be enough :) We make no update in order to be very quick. > -Message d'origine- > De: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Date: samedi 24 mars 2001 15:31 > À: [EMAIL PROTECTED]; [EMAIL PROTECT

RE: Compiling MySQL on Solaris with -static: Impossible? Why??

Sinisa Milivojevic explained me that : "Unfortunately you can not build static programs on Solaris, as Sun has not provided static versions for many of it's libraries." Regards, -- Pascal Thivent > -Message d'origine- > De: Johan Andersson [mailto:[EMAIL PR

size limitation

disk too (using symbolic links). I would like to know what are the requirement to store so much records. Does anyome have reference of site that manage a table bigger than 1 tera ? Did someone try that ? I hope it's possible. Otherwise, i'll to choose Oracle :( and Oracle is not c

HOWTO move the Index on another partition.

Hi, I've created a database whith one table. This table has 3 columns and use an index. I would like to move the file that stands for the index on another partition. What file does store the indexes ? Does a symbolincd link be enough to move the index on another disk ? Thanks -- P

mysql-3.23.35 installation under solaris 7

ake: *** [all-recursive-am] Error 2 Does this speak to someone ? Thanks -- Pascal Thivent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi

How to load a database in memory

tables!". INNOBASE table seems to be safer. Does this table type permit to load data in memory ? What type should i better use ? Is it recommanded to compile MySQL with the two table types (in ordrer to be very performant ?) Could someone give me a little more details ? Thanks a lot.

table + index repartition

Hi, I have to mananage a very big table (about 20 Go) A database correspond to a directory. A table correspond to a file. Is it possible to distribute the table on several physical partition (like with Oracle that can use several table space to store one table) ? Thanks, -- Pascal Thivent

grant for temporary tables or type=heap tables

I would like to know if a create and drop grants apply with no difference for all types of tables (heap for instance) and for temporary tables, just like for ordinary tables. if yes, isn't it a sort of limitation, because some complicated queries may require intermediate create and drops some

WebLogic 6.0 + MySQL

7;s very urgent ! Thanks, -- Pascal Thivent - 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 PROTEC

RE: Install Mysql3.22.32 in Solaris7

What is the strange exe attached whith those mails ? > -Message d'origine- > De: funky gao [mailto:[EMAIL PROTECTED]] > Date: mardi 16 janvier 2001 12:42 > À: [EMAIL PROTECTED] > Objet: Install Mysql3.22.32 in Solaris7 > > > Dear Sir, >I try to install Mysql3.22.32 in the Solaris7 O

RE: Install Mysql3.22.32 in Solaris7

what is the stange exe attached with your mail ? > -Message d'origine- > De: funky gao [mailto:[EMAIL PROTECTED]] > Date: mardi 16 janvier 2001 12:42 > À: [EMAIL PROTECTED] > Objet: Install Mysql3.22.32 in Solaris7 > > > Dear Sir, >I try to install Mysql3.22.32 in the Solaris7 OS. B