Hi,
I'm doing research on DBMS recently and have found
some bugs in mysql's source codes.I think it will be
more convenient to point out them directly than using
mysqlbug.The following are my finds.
mysqladmin -version output:
mysqladmin Ver 8.22 Distrib 3.23.44, for pc-linux-gnu
on i686
On Fri, Jun 28, 2002 at 09:24:02AM +0530, Arul wrote:
Hi
Just was curious to know...
I saw a posting by one of the guys here that Yahoo uses MySQL. Is
this true..
Guilty as charged.
Any idea how many MySQL servers does Yahoo Use amd for which domain
they use MYSQL.
How many servers?
Description:
(1) file:innobase/os/os0sync.c
function: os_event_wait_time
line:237
In this function, it use Windows API
WaitForSingleObject while passing a wrong parameter.
Because WaitForSingleObject wants the second
parameter to be quantity
Mikhail,
I think MySQL in this case waits for a MySQL table level lock. Note that
CREATE TABLE ... SELECT ... sets shared locks on the rows it reads in the
SELECTed table.
Workaround: use
SELECT INTO OUTFILE
+
LOAD DATA INFILE
In that way you can avoid locking altogether and do a consistent
Phil,
since InnoDB has its own internal data dictionary, simply renaming a
directory of the .frm files does not rename a database inside InnoDB, like
it does for MyISAM.
To move InnoDB tables to another database you have to do
mysql USE olddatabasename;
mysql RENAME yourtable TO
hello everyone
i am working on a project in which db is mysql and it should support
japanese and korean simultaneously I have mysql 3.23.36 running on
red_hat_linux_7.1_sea-wolf and default ecoding for mysql is sjis
Kindly tell meif is it possible to make a database support japanese and
Heikki,
Thank you very much for response.
But I still don't understand why do I have lock in Conn1.
Let's go through statement again.
Conn1: begin;
Conn1: update test set name = 'rat' where id = 3;
InnoDB docs: UPDATE ... SET ... WHERE ... : sets an exclusive next-key lock
on every record
Hi!
rhuddleston == rhuddleston [EMAIL PROTECTED] writes:
Description:
rhuddlestonThe following query results in a different # of rows if the
sql_big_tables is set to 1:
rhuddleston select count(incidents.ref_no) from incidents, labels where
incidents.ref_no like '020531%' group by
Just made some additional testing...
If you change
Conn2: create temporary table Temp select id, name from test where id = 3;
to
Conn2: insert into Temp select id, name from test where id = 3;
then it won't work too. But if you change it to
Conn2: select id, name from
I have a bit of an issue:
I have just upgraded my version of MySQL on my Cobalt Qube Linux server,
and the installation would appear to have removed (or not created) a
mysql.sock file in the /var/lib/mysql/ directory. It has created a link
in the /tmp/ directory. I have verified that there are
Hi all,
I want to setup (on linux systems) a pair of redundant mysql servers,
working this way :
* one master and one backup
* the master handles all the requests, the backup updates its data
frequently (and, if possible, CONSISTENTLY) from the master
* on failure of the master, the backup
Hi Every Body,
I am not able to install MySQL
(MySQL-Max-3.23.51-1.i386) on Red Hat Linux 7.1.
After running the installer(i.e. rpm file), mysql
folder is getting created at /usr/lid with one
file in it named mysqld-max.sym. I am not able to
proceed from that point.
So, please guide me how to
Hi all,
What are the major differences between BDB and MyISAM separate the fact
that BDB is slower and suports transactions, and MyISAM faster and does
not support transactions ?
(On most recent version of MySQL 3.23)
What are the major avantages/drawbacks of InnoDB ?
Thanks
Mathieu DESPRIEE writes:
Hi all,
I want to setup (on linux systems) a pair of redundant mysql servers,
working this way :
* one master and one backup
* the master handles all the requests, the backup updates its data
frequently (and, if possible, CONSISTENTLY) from the master
* on
Hi All
MYSQL Supports Unions in 4.0.1.
Similarly any idea when it will support other SET Operators Like Minus
Regards,
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
hi guyz
i va all my tables myisam since its da default type
how can i make isam tables
1. will someone plz guide me with about the syntex
2. how can i change the type of my myisam tables to isam
:( without having to drop them
thnx a million
toby .
sql, query
Hi Mikhail
What i meant to say is that My First Query returns 3 rows satisfying two
conditions Like CI.IndustryID IN (2,3) and Count(C.CompanyID) = 2
So when i add another OR say (CI.IndustryID IN (2,3) OR C.b2b = 'N') and
Count(C.CompanyID) = 2
I guess it should aways have the possibilty of
On Friday, 28. June 2002 19:29, Anil Garg wrote:
Hi Anil,
Now, when i run the following query:
mysql select * from xoops_groups_modules_link where type='R' and mid=2 and
groupid=3 ;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:1
Current
At 5:29 + 6/29/02, toby - wrote:
hi guyz
i va all my tables myisam since its da default type
how can i make isam tables
Add
TYPE = ISAM
to the end of your CREATE TABLE statement.
1. will someone plz guide me with about the syntex
2. how can i change the type of my myisam
thnx a million paul
got that :)
So ... why do you want to do this?
well i get really irretated of seein row# 66 right after 5
but seriously i dont know the + or - points of the types
besides my project supervisor just declared v DONT NEED isam
since v dont NEED row 6 after 5 n not
20 matches
Mail list logo
