Upgrade from MySQL 3.23.x to MySQL 4.1.x [InnoDB question]

Hi all, A little question... Can I upgrade directly a server with MySQL 3.23.x version which has some MyISAM databases (no problem with it) and some InnoDB databases towards MySQL 4.1.x? Or have I to do a dump and restore instead of re-use databases? wdyt? -- Cedric Gavage - [EMAIL PROTECTED

how to join two tables and include all records from one

(IDInvoice) the qty Results for IDInvoice = 1001 IDItem NameQty 1 Orange 10 2 Apple 0 3 Bread 2 4 Milk0 Did somebody have an idea? I tried with LEFT JOIN / RIGHT JOIN / INNER JOIN... with no success Thanks for any help Cedric -- MySQL General Mailing List For list

Server Load by user/DB

Hello ! I'm trying to figure how to get how many queries are done by each DB/user and not for the whole MySQL server. How to know how many queries are done each done for each DB ? MySQL Server load is heavy and I need to know from which websites... -- Cedric - mailto:[EMAIL PROTECTED] (DH/DSS

MyISAM

Hi all, I have a question about MyISAM, during an UPDATE for a row, is it a row locking or a table locking? -- Cedric Gavage [EMAIL PROTECTED] http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

tuning problem or bug?

= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M I receive the error message when I have more than 255 threads at the same moment (mytop report). May be the kernel to tune? (ulimit ?) -- Cedric Gavage [EMAIL PROTECTED] - Niddle http://unixtech.be - http://gavage.com - OpenPGP

Re: mysql limitations

-- Cedric Gavage [EMAIL PROTECTED] - Niddle@IRC http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Quota Support

can enlighten us here. I never tried such a setup but I will have to soon. Any quirks I missed? Cedric Le December 11, 2002 12:06 am, Steven Adams a écrit : Well hows it spoes to work with disk qoutas if u dont chown it to the user id?? /Steve - Original Message - From: Dean

Very bad bug on FreeBSD

a race condition or something. The manual says mysql is less reliable on FreeBSD because of the poor multi-threading implementation. I didn't expect I'd have to restard it every day (!!) Any help would be very appreciated. Thank you, Cedric

[Solaris 2.7] Problem: MySQL lockup

I'm using MySQL 3.23.39 on Sun UltraSparc with Solaris 2.7. MySQL is started with bin/safe_mysqld When executing many SELECT in a short time (i.e. near 200 SELECT in 1 second), the mysqld process uses more an more CPU (96%) and seems to be locked : requests (SELECT) don't receive answers and are

MySQLGUI problem

MySQLGUI-1.7.5 was working. Now, when I start it and put the mouse pointer over it, it disappears. Reinstalled only to get the same thing. Any ideas? cedric - Before posting, please check: http://www.mysql.com/manual.php

DBI.pm

/usr/bin/mysql_setpermission returns the following: Can't locate DBI.pm in @INC (@INC contains: ) Perl 5 is installed. What do I do? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

SMP on Sparc/Solaris7

Hi all, Is there someone which use mysql-3.22.* or mysql-3.23.* on a UltraSparc bi cpu with Solaris7? In my case, mysqld (with all its threads ;)) is always on one cpu... the second is never used... Thanks -- Cédric Gavage [EMAIL PROTECTED] [www] http://linuxbe.org - http://bsdbe.org

SQL Problem

FROM Game, Turn WHERE Game.gameTurn = 3); Thanks Cedric Lefebvre - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

RE: SQL Problem

with at least Tactic.teamCode 2 / Game.TeamCode1 1 / Game.TeamCode2 3 / GameTurn 1 So your answer is not right at all. Does someone has a clue ? Cedric Lefebvre Something like SELECT Tactic.teamCode FROM Tactic t, Game g, Turn r WHERE t.teamCode g.teamCode1 AND t.teamCode g.teamCode2

secure connection (SSL/SSH tunneling) with windows client

of security/encryption is used and can we consider it safe? Any suggestions greatly appreciated. Cedric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

my InterBase vs mySQL benchmarks!

the times.. http://www.inetflex.com/db-bench.php?tests=100 (This will run the test on my home server, a p3 733 with 256 MB RAM and IDE drive). Both DB server are running on the box of course. Cedric - Before posting, please

Re: Large search engine

of red + 1 Thank you, Cedric Veilleux what you'll need is: 1 table with doc_ids (and perhaps document) 1 table with words 1 table which links words to docs 1 table which gives the position of a word in a doc. create table documents (doc_id integer primary key auto_increment, document

Large search engine

the search script will do all the job without sending any other queries. May get quite complicated but it should work, it may also be easier to process sun NEAR star (maybe this is easy to do with LIKE too, I don't know, but I saw nothing in the docs.) Thank you, Cedri

RE: BDB table corruption when inserting/retrieving a BLOB into a BDB table

. Cedric. -Original Message- From: Scott McCool [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 3:29 PM To: 'Stephen Faustino'; '[EMAIL PROTECTED]' Subject: RE: BDB table corruption when inserting/retrieving a BLOB into a BDB table I can also verify that the data seems to be stored

SQL PRIMARY KEY question

I have written the following SQL request, but I get an error, why ? create table MovementOrder ( teamCode INT(4) NOT NULL, quarter INT(4) NOT NULL, position INT(4) NOT NULL, priority INT(4) NOT NULL, order VARCHAR(10), parameter VARCHAR(5), PRIMARY