Hi all,
I need a boolean column and at to this time I always used ENUM('Y','N')
for this. I'am wondering that will there be a performance difference between
using ENUM('Y','N') and TINYINT(1) or BOOLEAN?. And put 0 or 1 to TINYINT
column.
and make the
change.. At this time no error occurred when I do "slave start"..
Also when I do "slave stop;slave start" after the error occurs.. I
starts working without any errors. Why this happens?
Thanks,
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web
To debug the problem. Make "SHOW SLAVE STATUS" in the slave and check for
the error number..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
- Original Message -
From: "Nico Sabbi&
7; doesn't give
any error messages but writes some lines to .err file..
Check those files both in master and in slave..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
- Original Message -
From: "Nico Sabbi" <[EMAIL PROT
Take a look at this
http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
- Original Message -
From: "Laurent" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
s you can see I have lots of mysql daemons running which are mostly on
"sleep". I don't want these daemons to use RAM. Can you offer any solutions?
Also are the above values seems ok?
Thanks.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dal
There was a discussion about this topic at past. Check the previous posts.As
a simple answer they are technically the same. Use what ever you want..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
- Original Message -
From: "
Is this normal to have a index like below.. As I know there is no need to
have "KEY" and "UNIQUE" for a PRIMARY KEY
PRIMARY KEY (`urun_id`),
UNIQUE KEY `UC_urun_id` (`urun_id`),
KEY `IDX_urun_urun_id` (`urun_id`),
KEY `ktgr` (`ktgr`)
) TYPE=MyISAM
Best Regard
make you text file format same as the table format . then use
mysqlimport database_name table_name.txt
by default mysqlimport need tab delimited text. if you need ; or other
use --fields-terminated-by=
http://dev.mysql.com/doc/mysql/en/mysqlimport.html
Best Regards,
Cemal Dalar a.k.a Jimmy
put a line like below to your my.cnf file under [mysqld] section
ft_min_word_len=2
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
- Original Message -
From: "leegold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
for sure :)
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
- Original Message -
From: "leegold" <[EMAIL PROTECTED]>
To: "Cemal Dalar" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wedn
_insert_id() returns
the ID generated last according to the connecttion you used. For example if
you make two different connections and insert two different records you will
NOT get the same last_insert_id() value.. But at your case they will be
probably the same..
Best Regards,
Cemal Dalar a.k.a Ji
UNIQUE KEY
`UC_urun_id` (`urun_id`)," indexes are unnecessary?
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I used to check, optimize and repair tables, tar the database directory and
copy it simply. :) For me this is the simpliest way.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
- Original Message -
From: "Edd Dawson" <
It depends on lots of things. But as an estimate.. Probably you need to add
some indexes..
Which type of queries you are using? which database type?
Other things.. what about database size? maybe you need more RAM etc..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Devel
own the master (I was not willing to do this but I had to) and take a
snapshot and rebuild the master again.. Ans started the slave from the new
master binary log created.. So this solved my problem but Actually What
should I do in a situation like this if it happens again?
Best Regards,
Cemal Dala
QL_Running and Slave_IO_Running. I don't exactly
know that this is a bug or not but I need a solution for now.
Thanks for all replies.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.dalar.net
smime.p7s
Description: S/MIME cryptographic signature
Check your log file for details. Probably because of file permissions of
data folder.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMA
My point was this situation should affect on Slave_SQL_Running value.. but
in real it is NOT..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
- Original Message -
From: "gerald_clark" <
ve server is working fine.. Also I think that I
should this situation in "SHOW SLAVE STATUS" that slave is not working
properly.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
- Original Message
ent.html
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 18, 2004 12:51 PM
Subject: ODBC error
> &g
rformance on
the master.
I will also keep in touch with MySQL Cluster development and probably go
for this in the near future.
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator & Web Developer
http://www.gittigidiyor.com & http://www.dalar.net
- Original Message -
Fr
22 matches
Mail list logo
