Re: Help optimizing this query?

2007-01-07 Thread Daniel Kasak
Brian Dunning wrote: This is the query that's killing me in the slow query log, usually taking around 20 seconds: select count(ip) as counted,stamp from ip_addr where stamp>=NOW()-interval 14 day and source='sometext' group by stamp order by stamp desc; Here is the table: CREATE TABLE `ip_

Strange Crashing Error - Assertion failed: fixed == 1, file item.h, line 1601

2007-01-07 Thread Jason J. W. Williams
Hello, We've been getting random crashes on our MySQL servers running MyISAM tables for the last month, its gotten very bad in the last two weeks. This has occurred on both 5.0.27, 5.1.11 and 5.1.15-nightly20070103. It crashes the tables with high queries per second. We've fixed the issue on one

[OT} How to pronounce GIF (was: Re: How to pronounce MyISAM and InnoDB)

2007-01-07 Thread TK
At 10:15 AM 1/7/2007 -0800, Brian Dunning wrote: >My friend says "my sam" and "in-NOD-b". I want to kill him every >time. He also says "jif" instead of "gif". The GIF Pronunciation Page: http://www.olsenhome.com/gif/ In short, the original inventors of the GIF format (CompuServe, 1987) have al

Re: How to pronounce MyISAM and InnoDB

2007-01-07 Thread Jan Pieter Kunst
2007/1/7, js <[EMAIL PROTECTED]>: Hi list, Sorry for this silly question but I've been always had trouble pronouncing "MyISAM" and InnoDB. How do you pronunce them? Thanks in advance. When I'm speaking Dutch (which is most of the time) I say My-ee-sahm Inno-day-bay JP -- MySQL General Mail

Re: How to pronounce MyISAM and InnoDB

2007-01-07 Thread Brian Dunning
My friend says "my sam" and "in-NOD-b". I want to kill him every time. He also says "jif" instead of "gif". On Jan 7, 2007, at 7:16 AM, Michael Stearne wrote: I just say "My, I, Sam" and "inno, d, b" Michael -Original Message- From: "js " <[EMAIL PROTECTED]> Date: Mon, 8 Jan 200

Help optimizing this query?

2007-01-07 Thread Brian Dunning
This is the query that's killing me in the slow query log, usually taking around 20 seconds: select count(ip) as counted,stamp from ip_addr where stamp>=NOW()- interval 14 day and source='sometext' group by stamp order by stamp desc; Here is the table: CREATE TABLE `ip_addr` ( `ip` int(

high load, tons of data

2007-01-07 Thread Michael Dykman
I am leading a project which has us (among other things) migrating around 4T of data from Mysql 4.0.18 to 5.x.. we are currently targeting 5.0.27 which seems to be holding up fairly well, although we still having some issues in a couple of places. Having put our migration suite through it's man

mysql backup methods

2007-01-07 Thread Vitaliy Okulov
Здравствуйте, mysql. Hi all. I searching mysql backup script, which detect type of table & use mysqlhotcopy for MyISAM or mysqldump --single-transaction for InnoDB. Also save structure of table in file. And support recovery for dumped db an tables. Somebody meet such type of mysqlbackup script? -

Re: How to pronounce MyISAM and InnoDB

2007-01-07 Thread Michael Stearne
I just say "My, I, Sam" and "inno, d, b" Michael -Original Message- From: "js " <[EMAIL PROTECTED]> Date: Mon, 8 Jan 2007 00:09:15 To:mysql@lists.mysql.com Subject: How to pronounce MyISAM and InnoDB Hi list, Sorry for this silly question but I've been always had trouble pronou

How to pronounce MyISAM and InnoDB

2007-01-07 Thread js
Hi list, Sorry for this silly question but I've been always had trouble pronouncing "MyISAM" and InnoDB. How do you pronunce them? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FreeBSD chroot problem...Please help!!!

2007-01-07 Thread Riemer Palstra
On Sun, Jan 07, 2007 at 12:50:34PM +0100, VeeJay wrote: > I trying to run MySQL and Apache under a chroot envoirnment. But I am > getting these errors. [ ... ] > # /usr/local/mysql/libexec/mysqld: Can't create/write to file > '/var/tmp/ibPM3e0d' (Errcode: 13) [ ... ] > fopen: Operation not supp

FreeBSD chroot problem...Please help!!!

2007-01-07 Thread VeeJay
Hello there I was wondering if someone having great knowledge of FreeBSD chroot system could give me some help. I trying to run MySQL and Apache under a chroot envoirnment. But I am getting these errors. Could you please help me to solve these problems. I have googled a lot but did't find any sol