hi all,
currently, i have a machine with raid 1 and raid 5 (backplane). in order
to boost up the mysql performance, does it advise install /var/ (mysql
data directory) into raid 1 or raid 5? please advise. thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
can i replicating innoble tables? does the master db and the slave db
will having the same of information when they are doing replication? thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi all,
i have a mysql which only localhost can be logged in. if i have created
an account [EMAIL PROTECTED], then, i cant login in as that host.
mysql -u user -h mymachine.com -p
ERROR 2003 (HY000) Cant connect to the MySQL server on 'x.x.x.x' (111)
please advise. thanks
--
MySQL General Ma
Is that stable if i started mysql server by defining default_table_type
= INNODB at the my.cnf file? from which by default my.cnf is defining
MYISAM table to be the defaulted.
Richard Dale wrote:
this is my error log file.
InnoDB: Error: log file ./ib_logfile0 is of different size
Jigal van Hemert wrote:
- Original Message -
From: "Hiu Yen Onn" <[EMAIL PROTECTED]>
if i uncomment it, then mysql server wont start at all. if i comment it,
then, that's ok. please advise. thanks again
If the mysql server does not start it will pr
,
then, that's ok. please advise. thanks again
Hiu Yen Onn wrote:
Are you using the my-innodb-heavy-4G.cnf file for your machine? i
loaded the cnf file to /etc/my.cnf. then, it fails to start. what's
wrong with it?
mind to tell me on how to set the default table type equal to
inno
chine for mysql? thanks again
Ady Wicaksono wrote:
Currently i have 4 Gbyte RAM and RH 9 Linux using InnoDB
and yes, it's stable :)
Hiu Yen Onn wrote:
hi,
i have a machine with 6G memory, loaded with RHEL4. now, my question
is mysql support innodb as the default table type? will
hi,
i have a machine with 6G memory, loaded with RHEL4. now, my question is
mysql support innodb as the default table type? will be stable running
RHEL4?
i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replace the
existing one (/etc/my.cnf). but, it failed to start the mysql server
b.cfg file. i have not noticed that file
in my machine. weird pls give me more information and
ideas.thanks
--
Mr. Hiu Yen Onn
System Administrator
Shin Yang Group of companies
Website: www.shinyang.com.my
Email: [EMAIL PROTECTED]
Tel: (6085)6
hi,
i compiled mysql-4.1.7 from source. actually, i want to configure a
mysql cluster. from the documentation, i need to add some flag into a
file called "my.cnf". i searched through the files. it consisted of
my-small.cnf, my-medium.cnf, my-huge.cnf. but, i cant see the file
my.cnf file. where
Hiu Yen Onn wrote:
hi,
I wish to have clusters of MySQL. i installed it from RPM. version,
4.1.7.
but, i cant get the "ndbd" command to start my NDB.
do i really need to install from tarball??
i am really new to MySQL clustering. all this while, i am using MySQL
standalone database.
hi,
I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7.
but, i cant get the "ndbd" command to start my NDB.
do i really need to install from tarball??
i am really new to MySQL clustering. all this while, i am using MySQL
standalone database.
pls guide me... i am willing to
N¬ë,j°jËkj{ zºÞw
«k©oz»"¢z
¦ºxj×úèThanks for reply.
- Original Message -
From: "Ludwig Pummer" <[EMAIL PROTECTED]>
To: "Oscar Yen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 8:39 AM
Subject: Re: Simi
N¬™ë,j°jËkj{ zºÞw…«k‰©oz»"¢z
‰¦ºx†jטúèDear all,
I have asked the question days before, but no one seems interested in it
Considering table imgstore, defined as
create table a (
imgid int not null,
parent int,
imgtype char(3),
img longtext,
primary key (imgid),
key searchke
a and b, the result is similar.
Thanks you for your attention.
Oscar Yen.
t support under mysql 4.0.12, we have to create
temporary tables :< );
I suspect that mysql will drop the temporary tables automatically when
associated connection dropped unexpectedly, am I right?
Has anybody encountered similar situation, and how he resolved the problem?
Thanx
Oscar Yen
hi,
i am using linux redhat 8 to power mysql. i installed mysql version 4.0.13
using rpm package. by default, the data file of mysql is alocated at
/var/lib/mysql, but i have a limited of diskspace of /var dir (it is about
1G), so, it was easily full loaded with data. now, i want to archive the
da
i want to create a user who access from internet remotely to my db (outside
firewall)?
what is the solution then? how can i define the user accoutn?
[EMAIL PROTECTED]
Cheers,
yenonn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
ad, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
Best regards,Yen-Chu Chen
[EMAIL PROTECTED]
Office: (63
___
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> ---------
> Before posting, please check:
>http://www.mysql.com/manual.ph
Is there a version of MySQL lib that is complied with '-64' option
on SGI IRIX 6.5?
I also tried to look for source code of MySQL but I could not find it
in the 'download' area of http://www.mysql.com. Maybe I didn't look hard
enough. Could some one tell me where I
t could not find any source code. Could someone
tell me where I can find it? Also can we have a tar ball that contains
MySQL compiled with '-64' option?
Best regards,
Yen-Chu Chen
Institute of Physics, Academia Sinica, Taiwan, ROC
--
Thank you Jeremy, these really help!! I can't find the manual :D
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 13, 2001 4:00 PM
To: Yen
Cc: [EMAIL PROTECTED]
Subject: Re: Does MySQL support sub queries ?
On Fri, Apr 13, 2001 at 04:02:31PM
, anyone can help?
ERROR 1064: You have an error in your SQL syntax near 'select ref from tool1
where detail='yyy')' at line 1
Thank you.
rgds,
Yen
-
Before posting, please check:
http://www.mysql.com/m
24 matches
Mail list logo
