FreeBSD 4.2-stable + MySQL 3.23.32 sig 11 problem

2001-01-27 Thread Artem Koutchine
--prefix=/usr/local/mysql --with-charset=win1251 --localstatedir=/usr/local/mysql/data --with-mit-threads=no --without-debug --without-perl --without-bench gmake gmake install Now I am going to see if the problem goes away. Artem

Re: (+) Help needed

2001-01-27 Thread Artem Koutchine
Does ANYBODY read books manuals these days? Bye Artem - Original Message - From: "Alexei Sh." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 27, 2001 4:04 PM Subject: (+) Help needed Ok I need help with this.. I have to values like $dat1="2001-01-11

Re: (+)Help

2001-01-27 Thread Artem Koutchine
RTFM on Replication or do develop own methods! SEARCH THE LIST (start from www.mysql.com Documention/Mail lists) - Original Message - From: "Alexei Sh." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 27, 2001 8:20 PM Subject: (+)Help I have two mysql server with same

FS setup for MySQL (Was : RAW Device support)

2001-01-27 Thread Artem Koutchine
Interesting, how will MySQL benefit from using -async -noatime options for filesystem it is keeping its data on or from using SoftUpdates (for FreeBSD in particular). Anybody experimented? Artem - Original Message - From: "Dan Nelson" [EMAIL PROTECTED] To: "Nazeem Y&qu

Re: How to use a database from Sun solaris to Linux

2001-01-26 Thread Artem Koutchine
AFAIK, ISD, ISM is isam type table which are platform dependent. So, you cannot just COPY them. You need to do something trikier (sqldump and then restore using mysql) MYD, MYI - are myisam tables and they are declarede platform independet. You can move then around w/o trouble (AFAIK again).

Not a lame question about index usage of MySQL

2001-01-26 Thread Artem Koutchine
not apply another index after using the first one. So, my question is: Are things so bad? MySQL cannot apply more than one index per query per table? Regards, Artem - Before posting, please check: http://www.mysql.com

Re: 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots - Still CoreDump

2001-01-26 Thread Artem Koutchine
uot; I am having the same problem with 3.23.32 on 4.2-stable (dies sporadically with sig 11). Regards, Artem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: need help

2001-01-26 Thread Artem Koutchine
What do you mean "get stuck". You some kind of error or just it does shows that it compiles it and makes you wait a lot. Well, if you look a bit above you will see that the following compile may take a long time and IT DOES TAKE A VERY LONG TIME ON SLOW MACHINES. So.. WAIT! If you got error, then

Re: OT - Cron

2001-01-25 Thread Artem Koutchine
take your time and read man crontab - Original Message - From: "Derek Almond" [EMAIL PROTECTED] To: "Derek Almond" [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 1:25 PM Subject: Re: OT - Cron Actually now I look thats not the one i mean ;=(

Checking if a date is correct

2001-01-21 Thread Artem Koutchine
try doing "SELECT UNIX_TIMESTAMP('1990-2-31')" and you'll get a number. This is very weird, since this is an incorrect date. Is there any way to figure out if a date is correct in mysql SQL implementation? And why UNIX_TIMESTAMP does not return NULL for incorrect da

Connection Freeze (new feature proposal)

2001-01-19 Thread Artem Koutchine
sys_commit to 1 Sure, all SQL queries must manipulate only records with sys_commit to 1, and all other must be considered non-existing and cleaned up periodically. What do you think? (And Yes, i am aware of persistant database handlers which live in the web server space). Artem Koutchine

<    1   2