Erratic query performance

nid left join campaccommon.committee c on r.comm_id = c.Comm_id where recordtype = "INDIVIDUAL" and c.party = "D" and r.amount >= 1 Returns 294 records. Thanks for any insight you can offer. - Leo Siefert

Re: Why innodb can give the same X gap lock to two transactions?

r MySQL version is 4.1.18. Thx! -- Best regards, Leo Huang 2006/12/18, Heikki Tuuri <[EMAIL PROTECTED]>: Leo, 'gap' locks in InnoDB are purely 'inhibitive': they block inserts to the locked gap. But they do not give the holder of the lock any right to insert. Several transa

Why innodb can give the same X gap lock to two transactions?

same record. The MySQL Manual said that X lock is an exclusive lock. Why two transactions can get the same X lock? Any comment will be welcomed? Best regards, Leo Huang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: source compilatio or install precompiled packages

Hi Jose, there are only a few reasons why you should NOT use a pre-compiled package: 1. The version of MySQL you want to use (e.g. Alpha-Version) does not exist for your machine 2. You want to use features not available in the pre-compiled version. On the other hand there are some very good rea

Re: Moving DB to another System

Hello Ow Mun, there are various ways to backup InnoDB tables 1. SELECT ... INTO OUTFILE statement for your tables and reimport them 2. ibbackup (a commercial tool to copy InnoDB Databases while the server is running 3. Stop the server, copy the innodb tablespace files and logfiles to the new loc

Re: Trying to run two mysql instances on one server

Hello Low Kian, first, you cannot attach files to this mailing list, however from the error, i assume that you have not specified different socks and ports for each MySQL instance. You need to put that information into your configuration file for each server , e.g.: #server 1 option file port=33

dose mysqldump --single-transaction lock table?

Hi,all.I want to use mysqldump to backup a innodb table,and add the option --single-transaction,dose it lock all the table?thanks. -- Leo 2006-09-13 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Can Innodb reuse the deleted rows disk space?

hi, Dan Nelson, Jochem van Dieten, and Chris Thx! I think I understand it after your replies. Regards, Leo Huang 2006/7/30, Dan Nelson <[EMAIL PROTECTED]>: In the last episode (Jul 29), Jochem van Dieten said: > On 7/28/06, Dan Nelson wrote: > >In the last episode (Jul 28),

Re: Can Innodb reuse the deleted rows disk space?

hi, Chris So, the deleted rows' disk space in tablespace can't re-use when I use Innodb, can it? And the tablespace is growing when we update the tables, even the amount of rows do not increase. Regards, Leo Huang 2006/7/28, Chris <[EMAIL PROTECTED]>: leo huang wr

Re: Can Innodb reuse the deleted rows disk space?

ve me more? Regards, Leo Huang 2006/7/27, Chris <[EMAIL PROTECTED]>: leo huang wrote: > hi, Chris > > Thank you for your advice! > > I know that Innodb use the logfiles circularly. Can Innodb re-use the > deleted rows' disk space in tablespace? I'm sure it w

Re: Can Innodb reuse the deleted rows disk space?

hi, Chris Thank you for your advice! I know that Innodb use the logfiles circularly. Can Innodb re-use the deleted rows' disk space in tablespace? Regards, Leo Huang 2006/7/26, Chris <[EMAIL PROTECTED]>: leo huang wrote: > hi, Dilipkumar > > Thank you very much! > &g

Re: Can Innodb reuse the deleted rows disk space?

hi, Dilipkumar Thank you very much! I think I know the fact: The Innodb can't reuse the deleted rows' disk space. And a solution is: dump the data; shutdown mysql; delete the files; restart mysql; import the data. Regards, Leo Huang 2006/7/24, [EMAIL PROTECTED] <[EMAIL PROTECTED

Can Innodb reuse the deleted rows disk space?

ickly. Any recommend will be welcome! Regards, Leo Huang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is the fsync() fake on FreeBSD6.1?

er_pool_size = 384M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 regards, Leo Huang

Re: SELECT ALL and flag

hi, Peter Try this: select a.name, sum(if (b.table_a.id is NULL,0,1)) as indid from table_a a left join table_b b on(a.id=b.table_id.id) group by a.id; best regards, Leo Huang 2006/6/1, Peter Lauri <[EMAIL PROTECTED]>: Hi, I have a table table_a and table_b: table_a { id name } t

Re: Problem running multi master replication

with all the masters, you shouldn't have any problems. = jeremy even told something about writing to the same table from two master :D really .. i need someone's sucessful experience in multi mastering :) thanks - Leo

Re: Problem running multi master replication

> > Hold on, "(it should be, its the same file)", you're saying that db2 on > server1 and server2 are using the same database files (datadir)? If that's > the case, why? That doesn't make any sense. > > > Atle > - > Flying Crocodile Inc, Unix Systems Administrator > Im replying from another accoun

Re: mysql restart error

ysql and I got the error. Regards, Leo Huang 2006/3/28, [S] Dhandapani <[EMAIL PROTECTED] >: > > Hi Leo, > > check for cnf file for which port you have configured the port .If it is > in 3306 port then do netstat -an|grep LIST ,check for 3306 port is listening > on your syst

Re: mysql restart error

hi, Lakshmi The mysql process had ended. I get it from both mysql err log and ps output. regards, Leo Huang 2006/3/28, Lakshmi M P <[EMAIL PROTECTED]>: > > Run ps -ef | grep mysql and see any mysql process is running and if so > kill the same and try to start mysql.It

mysql restart error

s4.6479 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.7873 FIN_WAIT_2 Our mysql version is 4.1.18. It is running on FreeBSD 4.9-RELEASE. Any comment will be great thankful! Regards, Leo Huang

Re: mySQL 5 and CPu at 99.99%

ze and key_buffer_size from this: http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html Best regards, Leo Huang 2006/2/28, Taiyo <[EMAIL PROTECTED]>: > Greetings, > > We are running a server and the CPU is a

How to keep account independent in replication

B's my.cnf and use the INSERT or DELETE statement in A to deal with the account management now. replicate-ignore-db=mysql As you can see, it is ugly and discommodious. Is there any better solution? Best regards, Leo Huang

Re: Same question, better example

Ariel, You can try this: mysql>select stri from prueba order by stri+0 desc; Leo Huang 2006/2/17, Ariel Sánchez Mora <[EMAIL PROTECTED]>: > > mysql> describe prueba; > +---+-+--+-+-+---+ > | Field | Type| Null

Re: selecting min, max

hi, I think the following link would be some help for you! http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html Leo Huang 2006/2/14, Octavian Rasnita <[EMAIL PROTECTED]>: > > Hi, > > From: "Rhino" <[EMAIL PROTECTED]> > ... >

Problem with datetime value

d<="2005-12-01 24:00:00"; it return an empty set. What is going wrong? I know it should return 2 rows, as the previous sql result set got two rows of item 'A1'. is it because the value of "2005-12-01 24:00:00" which ofcourse is not a valid date time value. b

Re: how use sql_slave_skip_counter to restore slave replication

other than what Gleb says, you can avoid the error using 'insert ignore into' or better yet 'replace into' for every insert statement AESYS S.p.A. [Enzo Arlati] wrote: I'm trying to use teh parameter sql_slave_skip_counter at run-time to restore slave replication. When a slave replication bro

Re: Assigment sign not work on Delphi

cmiiw, dont you think you are supposed to pass the query as string in delphi??? somewhat like this : querystr:='SELECT @TOTAL:=PRICE * QTY FROM INV_PRODUCT'; mysql_query(@mysqlconnection,PChar(querystr)); ... etc ... so delphi will ignore the second ':=' because it's in a string, not an assign

Re: How to reload my.cnf?

pture the master and send it again to the slave (i've done this several times too, and it's painfully slow) changing the binlog-do-db afaik would not trouble the replication, unless it's a new database that hasnt been replicated earlier - leo Tedy Aulia wrote: >Hi Gleb

Max Connections of MySQL on Linux

it? 　　 Best regards, leo huang 2005-06-27 _ 享用世界上最大的电子邮件系统― MSN Hotmail。 http://www.hotmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Does the kernel options MAXSSIZ affect the MySQL max connections on FreeBSD

two test show that the MySQL max connections is the same. The max connections is about 1000. Have anyone kown how to tune the FreeBSD and MySQL to increase the max connections?　　 Best regards, leo huang [EMAIL PROTECTED] 2005-06-17

Problem with system tables

Hi, I'm working on a Linux Red Hat 7 (core 2.4.2-2), with Apache 2.0.53, PHP 5.0.3 and I'm trying to upgrade MySQL to version 4.1.10 with the rpms (I downloaded all of them). When i try to install, it reports a couple of errors here is screen shot sudo rpm --install -vv --force MySQL*.rpm [.

Re: summing from multiple tables

- Original Message - From: "Kevin Cagle" <[EMAIL PROTECTED]> To: "MySql List" <[EMAIL PROTECTED]> Sent: Saturday, November 20, 2004 10:46 AM Subject: summing from multiple tables mysql> select sum(amount), sum(totaltimesviewed) from bill, pageviewed; +-+--

Re: what is wrong woth this statement?

i didnt fully catch you... is this the kind of query statement you want? INSERT INTO some_other_table SELECT some_field_list FROM z_mail_systems HAVING COUNT(any_field)>0 On Tue, 19 Oct 2004 12:45:30 -0400, Josh Howe <[EMAIL PROTECTED]> wrote: > if (select count(*) from z_mail_systems > 0) then

OOT: Penawaran Untuk Subscriber Milis MySQL di Indonesia

Dear All, Siapa mau account gmail? Gratis 2 account.. Tanpa bayaran, tanpa uang.. Silahkan pm saya.. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Object pascal translation of mysql header

al Message- > From: Leo [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 24, 2004 9:42 AM > To: [EMAIL PROTECTED] > Subject: Object pascal translation of mysql header > > Dear All, > > Not long ago Jorge del Conde gave me his amazing translation > of mysql C header f

Object pascal translation of mysql header

Dear All, Not long ago Jorge del Conde gave me his amazing translation of mysql C header file to object pascal unit Including the remade dll, It was able to solve my problem of migrating the apps from using mysql 3.x to 4.x But now I am facing a new difficulty of trying to implement mysql 4.1.3 pr

Re: Nested query with GROUP BY ... HAVING COUNT(*) ... hangs 4.1.3 beta

hanks for the info, and for the query syntax to work around the problem. I still think this is a bug in processing the nested query, and if it is runing the subquery for each line in the master table, i think that is incorrect. - Leo Siefert "Leo Siefert" <[EMAIL PROTECT

Nested query with GROUP BY ... HAVING COUNT(*) ... hangs 4.1.3 beta

s workaround. Anyone have an idea on a solution to this? Is there something in setting up for INNO DB that I am missing, or should I file this as a bug? Thanks. - Leo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Combining multiple selects into 1 select.

M myTable WHERE Closeout = 'Y' HTH.. :) Leo > -Original Message- > From: Andy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 02, 2004 1:34 AM > To: [EMAIL PROTECTED] > Subject: Combining multiple selects into 1 select. > > Hello, > > Is is possible to c

Another loss of mysql

mourn for the dead of my mysql project good bye.. good luck -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com http://gtw.binasanprima.com/~leo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: mysql database, user table, two root accounts

Yes, this helps thank you. -Original Message- From: Arjun Subramanian [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:16 PM To: 'Leo Donahue'; [EMAIL PROTECTED] Subject: RE: mysql database, user table, two root accounts That's not two root accounts. What tha

mysql database, user table, two root accounts

I am less than 24 hours new to MySql. I have executed the following sql scripts: use mysql; delete from user where User=''; delete from db where User=''; flush privileges; select host, user, password from user; The last sql query yields the following: hostuserpassword -

MySQL user in Indonesia

Hi All, im sorry if this mail a bit out of topic =) im currently developing a new system based on MySQL for the company i work on. and i have to report how wide and famous is mysql had been used, especially in indonesia. i need the fact that i can show to my boss, why i choose mysql.. well i hav

Re: One Slave Many Master

Thank You All for the response, I'll try to set up your recomendation.. I'll post the result back in a few days.. thanks :) -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina San Prima, www.binasanprima.com

One Slave Many Master

I know someone already ask this, and the answer generally 'NO YOU CANT' :b but, is there any work around so i can make a backup server (slave), from many other server (master) through replication? well, it's not just a backup server actually.. it really is the headquarter's db server, and the bra

Problem with mysql_close() API

Hi All, i have a problem everytime i call the function mysql_close(), it result in Access Violation Error in module libmysql.dll fyi, im migrating from 3.23.52 to 4.0.x server runs under linux, im accesing the server through windows based application built with delphi, using Object Pascal transla

Re: Select with inner join NOT IN / IN

Hi Jens, try to rewrite you query to SELECT A.Kommentar, A.SequenzNr FROM Aufgabe A LEFT JOIN Taetigkeiten ON A.kommentar=Taetigkeiten.Bezeichnung AND Taetigkeiten.inaktiv = '1' WHERE isnull(Taetigkeiten.Bezeichnung) LIMIT 0, 30 -- Regards Leonardus Setiabudi IT Project Coordinator PT Bina Sa

Re: Cannot find an index that will be used for SELECT

,right) wouldnt make much use.. try to create an index on those four plus one (or more) field that represent your record as unique as possible i hope this help, cmiiw.. if ther's still a problem maybe you can mail me your table structure regards -leo- - Original Message - Fr

Re: How to move database to new server

-h theSourceHost --user=theUser --password=thePassword -l -n -r c:\dumpFile.sql -B theDatabase c:\mysql\bin\mysql.exe -h theTargetHost --user=theUser --password=thePassword < c:\dumpfile.sql i hope this help... cmiiw regards -leo- ps: you can see the online help for all the parame

search engine

where id like '%text%' or name like '%text%' but it's wayyy to slow :) anyone have a better idea.. i appreciate it so much regards -leo-

mysql API for Delphi

t did not support the authentication (or something like that.. i forgot to write it down :) ) and replacing the libmysql.dll wont work any idea? tia -leo-

Re: SQL query question

try group by SELECT firmal.beskrivelse as Businessline, lokasjon.navn as Location, count(person.name) as "Sum People" FROM firmal INNER JOIN ( person INNER JOIN lokasjon ON person.lokid = lokasjon.lokid) ON firmal.firmalid = person.firmalid group by firmal.beskrivelse, lokasjon.navn -

Re: Some help with a complex query

it would help alot if you dump the table structure for us - Original Message - From: Elisenda To: [EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 7:10 PM Subject: Some help with a complex query I have a query which tries to select different fields from 5 different tabl

Re: Aliases

what if we use the function at the right side of the equation? such as select anything from table1, table2 where table1.id=left(table2.id,somenumber) having both id in table were indexed dont you think the index in table1 would still be used.. :) cmiiw -leo- - Original Message

Re: Maybe easy, maybe hard SELECT puzzle :)

i know, IN keyword act simply as OR keyword didnt Jonathan wrote : >But it I want all records from Table1 that have features 'A01' _and_ 'B02' notice the _and_ ? -leo-

Re: Complex query woes

index my_id (id); -leo- - Original Message - From: Steffan A. Cline To: Leo ; [EMAIL PROTECTED] Sent: Monday, November 10, 2003 8:12 PM Subject: Re: Complex query woes Leo, Thanks for the quick reply. There was a typo but I fixed it. Below is what I used after

Re: Complex query woes

hopefully it work :) -leo- - Original Message - From: Steffan A. Cline To: [EMAIL PROTECTED] Sent: Monday, November 10, 2003 12:56 PM Subject: Complex query woes Basically I have a table that contains 3 types of records. Property managers, buildings and tenants. They are

Re: multitable sum problem

from salesrep left join salesinvoices on salesrep.id=salesinvoices.salesrepid left join lysalesinvoices on salesrep.id=lysalesinvoices.salesrepid group by salesrep.id hope this help.. -Leo-

RE:sql question

tegories.order ASC imho, you should have a reference field in table topics to table categories so you wont end up with cross table query (multiplying the result) LEFT JOIN forum_posts ON forum_topics.id = forum_posts.topic left join forum_categories on forum_categories.id=forum_posts.id -Leo-

Re: Maybe easy, maybe hard SELECT puzzle :)

ke) where not isnull(f1.id) and not isnull(f2.id) . . . (as many as you like) you can generate the repeatance by some script hope this help -Leo-

Re: Viruses from the list

. Leo Al Bogner wrote: I use an email-adress for this list only and since my first posting a few days ago I got viruses, while I didn't before. VIRUS FROM mamo @ hvd.healthnet.lu (W32/[EMAIL PROTECTED]) VIRUS FROM kawamoto @ wave.tky.plala.or.jp ([EMAIL PROTECTED]) VIRUS FROM sales @ vulcanfo

Re: Problem with DELETE USING

Bamelis, The error message doesn't seem to match your SQL... It only shows up to 'AND tblTest.URL = tblT' but your SQL is 'AND tblTest.Comment = tblTest2.Comment' Is that a problem?? An example from MySQL manual is 'DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.

Re: Mysql Stoping

hope it helps. --prefix=/usr --datadir=/var/lib/mysql --with-innodb --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --quiet Cheers, Leo Trevor wrote: &g

Re: InnoDB Questions

nt directory, I won't be able to put another file anywhere else!? Leo Nitin wrote: >You're right, it wont decrease the physical size, but only free up the space >within file to optimize the tablespace, in case, you want to check the size >of this data fi

Re: InnoDB Questions

ggestion, what will Oracle do if I specify a datafile size less than the database size, e.g. I specify 20M in the my.cnf while there are actually 400M of data in my database? Leo Nitin wrote: >Hello, > >first things first, you cann't resize your datafiles without shutting down >

Re: InnoDB Questions

I don't know. I will get some time this week, shutdown MySQL, backup my binary files, have a go as what Nitin said and see what's going on there. Leo Gabriel Ricard wrote: On Tuesday, November 4, 2003, at 07:58 AM, Leo Huang wrote: In InnoDB documentation, it suggests to add an

Re: InnoDB Questions

our tables, create a new database, and import your tables to the new database." It does reduce the size of the database(similar to optimize for MyISAM), but it doesn't reduce the size of the file. Could you explain a bit what is a "tablespace"? Thanks, Leo /etc/my.cnf: [mysq

InnoDB Questions

will be really appreciated if someone can briefly describe what's happening to those files or point me to some articles. Thanks a lot, Leo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Replicaiton

ing command: slave start IO_THREAD; without any luck. I have also tried to start and stop the slave server also wihtout any luck. Thank you in advance for any help. Leo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

ERROR 1186: Binlog closed, cannot RESET MASTER

I am getting the following error after trying to flush the master: mysql> flush master; ERROR 1186: Binlog closed, cannot RESET MASTER I am using mysql Ver 12.20 Distrib 4.0.13, for sun-solaris2.9 (sparc) Does anyone know what this might be? Thank you in advance, Leo. -- MySQL Gene

Updating MySQL db's

. Leo. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't drop a database

| | mysql | +--+ 51 rows in set (0.01 sec) Restarting mysql had no effect on this issue. Can anyone please help? Thank you in advance, Leo. -- MySQL General Mailing List For list archives: http://lists.mysql.

Re: Trouble converting SQL from Access

the columns returned? also, if you can, offload the calculations to PHP*, like the POW() function... grab the data from MYSQL and then use PHP to do the calcs...* -- Leo G. Divinagracia III [EMAIL PROTECTED] z - Before

JOIN based query problem (little help needed)

Hello list. Please help me to refine a JOIN based query which I am not able to correct. This the scenario (simplified). Three tables: Products - | id | description | - | 01 | bread| | 02 | milk | | 0

R: Inventory Query

Thank you for your attention, Adolfo. Sorry, it doesn't work. It looks like quantities are added more times into the SUM function. gigi > -Messaggio originale- > Da: Adolfo Bello [mailto:[EMAIL PROTECTED]] > Inviato: lunedì 16 dicembre 2002 19.04 > A: Gigi Di Leo;

Inventory Query

Hello list. Could you please suggest me a one-line query to solve a problem of inventory ? Three table: Products - | id | description | - | 01 | bread| | 02 | milk | | 03 | coffee | ---

Segmentation fault when using MySQL++

< endl; cout << "Fifth" << endl; } Error Message during Execution: Zero First Second Third Segmentation fault And the information from gdb about segmentation fault is follow: #0 0x4005f42f in SQLQuery::reset (this=0xbfffef48) at sql_query1.hh:30 3

Re: Database Structure

is being used in the application then the answer is, no, you do not have to install MySQL on the client machine unless the client machine is also the server machine. -Leo On Thu, 2002-10-10 at 05:59, Stephanie Piet wrote: > Does anyone know if there's a way in MySQL have the same funct

Database documentation

Hello list. At the end of a db programming job (using php) I have been asked for a document describing in details the structure of a MySQL database. The purpose of the document is to make other DB people able to manage and interface the database (I can figure out that there is also the intent t

R: Query problem

e. Gigi -Messaggio originale- Da: Jed Verity [mailto:[EMAIL PROTECTED]] Inviato: venerdì 5 luglio 2002 20.16 A: Gigi Di Leo; '[EMAIL PROTECTED]' Oggetto: Re: Query problem Hello, Gigi, By "decoded", do you mean that you want the words "Author" and "Publisher&

Query problem

-> record is about Authors flag=2 -> record is about Publishers Could you please suggest me the best query syntax to get BOOKS' data with Authors and Publishers decoded ? Thank you very much for your help. Gigi Di Leo -

Query problem

-> record is about Authors flag=2 -> record is about Publishers Could you please suggest me the best query syntax to get BOOKS' data with Authors and Publishers decoded ? Thank you very much for your help. Gigi Di Leo -

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 16.30, Dan Nelson wrote: > In the last episode (Jun 11), Leo De Geer said: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > > Do not assume that the way Linux manages th

Re: problem with mysql threads on freebsd

on FreeBSD. > One: Seems not to use both processors (on twin system) > Two: All ways a load on 1 even when the system in not at hi load (seem to > go down when it is!) > > What is up with freeBSD or MySQL. > > Simon > > -Original Message- > From: Leo De Geer

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > but in my case its not good to have it that way im having one dedikated > > dual server for the sql and now im yust using one cpu for the sql > > qu

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 09.26, Alexander V Zubchenko wrote: > Greetings! > > On Tue, 11 Jun 2002, Leo De Geer wrote: > > On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > > > On Tue, 11 Jun 2002 08:36:55 +0200 > > > > > > Leo De Geer <[EMAIL

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > On Tue, 11 Jun 2002 08:36:55 +0200 > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > &

Re: problem with mysql threads on freebsd

On Tuesday 11 June 2002 08.49, Dicky Wahyu Purnomo wrote: > On Tue, 11 Jun 2002 08:36:55 +0200 > > Leo De Geer <[EMAIL PROTECTED]> wrote: > > im not abel to get mysql to use more then one thread on my freebsd > > 4.5-stable any one having a klue that wrong? > &

problem with mysql threads on freebsd

im not abel to get mysql to use more then one thread on my freebsd 4.5-stable any one having a klue that wrong? regards leo -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - Before posting, please

Subqueries

Hello all, Does anyone know if MySQL can do subqueries? I am trying to provide a SELECT subquery to an IN clause and I am getting errors. Is this possible? -Leo - Before posting, please check: http://www.mysql.com

SV: problem with mysql3.23.49 server under freebsd 4.5

sql,query I cant get the server to starts more than one thread. I have installed the server from the port collections and im running freebsd 4.5 stable Regards leo de geer - Before posting, please check: http

RE: Faliue: Write huge binary data to blob Field of mysql use jdbc

Thanks for your reply. Use database to restore file is the requrement of our project ,So I must find the way of problem. As you said ,I trust the problem is beacuse of mysql protocol that is the filed must be send as a single packet. I have same test in postgresql ,In postgresql the blob type

Re: Berkeley DBD and locking

I encounter the same problem . And I think the BDB take the table lock instead of row level lock. To resolve the problem .You can use Innodb table. >From: Monika Andr?Jönsson <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Berkeley DBD and locking >Date: Thu, 20 Sep 2001 11:28:18 +0200 > >

RE: Faliue: Write huge binary data to blob Field of mysql use jdbc

Thanks! But my setting is "max_allowed_packet=50M",I have changed the setting before I send the help. Someone tell me It may be the jdbc problem or the stack value of jvm is too small. I'm very puzzle ! >From: [EMAIL PROTECTED] >Reply-To: <[EMAIL PROTECTED]> >To: "'Àî Çà'" <[EMAIL PROTECTED]>

Innodb does not work with NT Max 3.23.39

lease help. And please send the message also directly to me because I am not in the list. Leo _ Get Your Private, Free E-mail from MSN Hotmail at http://

Trying to compile/build MySQL on SUSEv7.0 running on S/390

t seems OK. Thanks for any help you can offer, Leo McCarthy Boston College Systems Services Tel: 617 552-4629 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

How to put and get gziped file to/from mysql db

Hello I am looking for help how to put gziped plain data file to mysql DB and then get it from there. Every time I try OUTFILE to file and then gzip -d file name I got file corrupted Any help will be appreciated Leo

Re: Tuple length Question

ase (like picture). Having multiple tables creates a redundancy of this data... My only concern in having tuples so long that I get other unforseen side effects. Also a limit in tuple size might limit my ability to include additional languages. Regards, Leo Cambilargiu Jason Landry wrote: &g

Tuple length Question

or [EMAIL PROTECTED] Leo Cambilargiu - 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 P

character sets error

hungarian.conf file but the error message still appear. What have I do to solve this problem? Thanks! Leo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

  1   2   >