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 Dalar a.k.a Jimmy
System Administrator Web Developer
http://www.dalar.net
--
MySQL General Mailing List
For list
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 [EMAIL PROTECTED
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 Developer
`), 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]
() 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 Jimmy
System
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]
Sent: Wednesday, August 11, 2004
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: Wednesday, August 11, 2004 8:32 PM
Subject: Re: Changing Fulltext
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 Regards,
Cemal Dalar a.k.a Jimmy
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: Salzgeber
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.dalar.net
--
MySQL General Mailing List
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]
Sent: Monday, July 19, 2004 12
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 PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday
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 [EMAIL PROTECTED]
To: [EMAIL
.. 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 Developer
http://www.gittigidiyor.com http
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.
Best Regards,
Cemal Dalar a.k.a Jimmy
System
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
From a Windows2000 machine, I use ODBC Data Source
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 -
From: Roy Nasser [EMAIL
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: [EMAIL PROTECTED]
Cc: [EMAIL
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 [EMAIL PROTECTED]
To: Cemal
.. 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 -
From: [EMAIL PROTECTED]
To: Cemal Dalar
22 matches
Mail list logo