Re: Poor Manual

On Sun, Apr 21, 2002 at 02:44:32PM +0200, Roger Baklund wrote: > * Sven Huster > > > > This manual is f@#$% up, since it seems like there is no manual for > > stable versions online or at least some annotations that say in which > > version a feature was introduced (it

Poor Manual [Was: Why using filesort here?]

On Sat, Apr 20, 2002 at 05:16:46AM +0200, Benjamin Pflugmann wrote: > Hi. > > [...] > > According to the MySQL doc (5.2.7, example 5) this should work > > using the index without any additional sorting. > > > > MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE > > I assume you are referring

Why using filesort here?

esort used here? According to the MySQL doc (5.2.7, example 5) this should work using the index without any additional sorting. btw: MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE Thanks Regards Sven Huster - B

RE: Enabling Logging of Slow Queries

i think the server does not run with privileges to write to /root regards Sven Huster Senior IT Systems Engineer Sven Huster Senior IT Systems Engineer > -Original Message- > From: Ryan Shrout [mailto:[EMAIL PROTECTED]] > Sent: 30 August, 2001 20:51 > To: [EMA

RE: mysql died with innodb

it also was my first idea to check /var/log/messages immediately, but nothing in there. we now run our servers as diskless machines over nfs on the netapp filer for +6 month and no errors at all, on any of the machines. regards Sven Huster Senior IT Systems Engineer > -Original Mess

Re: auto_increment "update"

On Thu, Jun 14, 2001 at 07:30:01PM -0500, Paul DuBois wrote: > *This message was transferred with a trial version of CommuniGate(tm) Pro* > At 1:36 AM +0200 6/15/01, Sven Huster wrote: > >Hi there > > > >can i somehow easily recreate the auto_increment col if is was no

mysql died with innodb

hi i got this on my mysql server (any ideas?): InnoDB: Assertion failure in thread 234323968 in file os0file.c line 637 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also p

auto_increment "update"

row. thanks regards Sven Huster - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]>

RE: load-balancing with NFS

etapp filer) regards Sven Huster Senior IT Systems Engineer > -Original Message- > From: Wouter de Jong [mailto:[EMAIL PROTECTED]] > Sent: 13 June, 2001 10:21 > To: [EMAIL PROTECTED] > Subject: load-balancing with NFS > > > *This message was transferred with a tria

Re: Root password forgotten in MySQL

>Please help me. >Thanks in advance. > >Sandeep I think you can restart the server with --skip-grant-tables and change the password then. regards Sven Huster Senior IT Systems Administrator *BSD, Linux, Solaris - B

Re: Creating database

+31 (0)35 6219819 >www.nibble.nl have you tried mysql -u root? Normally only user root has all privileges Create others with GRANT, check manual Check http://www.mysql.com/doc/A/c/Access_denied.html http://www.mysql.com/doc/G/R/GRANT.html Hope it helps regards Sven Huster Senior Unix System

Re: mysql over nfs on netapp filer

Am 00:20 30.03.2001 schrieb Joshua Chamas: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >Sven Huster wrote: > > > > Hi there, > > > > i anybody out there running mysql on a netapp filer as data storage? > > > >Yes, I

mysql over nfs on netapp filer

Hi there, i anybody out there running mysql on a netapp filer as data storage? regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php

Re: HASH tables...

scribing? Try: http://lists.mysql.com/php/unsubscribe.php maybe OT: but i am using it for session storage for www application since 2 month, not temp tables. no problem so far. works quite stable and really fast. Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris

Re: MySQL on NetApp Filer - Urgent Problem

Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: > > Am 11:22 16.03.2001 schrieben Sie: > > >*This message was transferred with a trial vers

Re: MySQL on NetApp Filer - Urgent Problem

Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: >*This message was transferred with a trial version of CommuniGate(tm) Pro* >On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: > > Am 11:22 16.03.2001 schrieben Sie: > > >*This message was transferred with a trial vers

Re: MySQL on NetApp Filer - Urgent Problem

eas about this? > >MySQL server: FreeBSD 4-Stable > >regards > >Sven Huster >Senior Unix System Administrator >*BSD, Linux, Solaris > > >- >Before posting, please check: > http://www.mysql.co

MySQL on NetApp Filer - Urgent Problem

cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris