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
(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
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
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
= 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
--
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
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
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
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-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
/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)
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
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
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
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
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
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
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
.
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
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
20 matches
Mail list logo