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
voice (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
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]
(D
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/my
urrency
set-variable= 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://unixt
--
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.mys
ifferent table types available 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??
>
> /S
probably 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.
Hi all,
2 littles questions.
1. How can i log all connection attempt to the mysql database without logging all the
query in the mysql database ?
2. It is possible to prevent user to the 'show database' command, i know they can't
use it depending on the right granted but it will be pleasent to
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
err and read it.
'/usr/bin/mysql_install_db' did not change anything.
Any ideas?
cedric
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
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)
http
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.or
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.teamC
Code2 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 thre
e that it isn't, but what kind 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)
htt
r all 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, p
e docs where the position of sun = the position 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.
4th and 1022th word doc
45, etc..
Then 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
.
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 dat
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 KEY(teamCode,quarter,position,prio
22 matches
Mail list logo
