rpm packages for 4.0.20 (compat-libs)

2004-05-23 Thread Thomas Seifert
Hey folks, just wanted to upgrade from 4.0.18 to 4.0.20 but found the following. The "Dynamic client libraries (including 3.23.x libraries)" are still 4.0.18 ... does that mean that they don't NEED to be changed or were they just forgotten? TIA, Thomas -- MySQL General Mailing List For list a

Re: problem with mysql-crashes

2003-07-23 Thread Thomas Seifert
Hi Lenz, thanks a lot for your reply! > Is that a self-compiled binary or one of ours? It are the MySQL-4.0.13-MAX-RPMs from your site. > Not very helpful. Does this occur under high load only? Yeah I know, otherwise I would have tried to generate a reproducible testcase with a given query or

stalled mysqld-processes?

2003-03-04 Thread Thomas Seifert
Hi folks, running mysql-4.0.x since the early versions without any problems, I had a problem 3 days ago. I'm not sure if its mysql-4.0.x-related but maybe anyone may shed a light on it. MySQL is running with the query-cache enabled (16 MB cache for it, 33% cache-hits). That day mysql got pretty

Re: fatal error

2002-11-30 Thread Thomas Seifert
compile php with mysql-support, i.e. configure --with-mysql and so on. If you are on a redhat system and using the installed apache-webserver, then there should be a package php-mysql*.rpm or similar which needs to be installed. Thats not a real mysql-problem. ;-) Thomas On Sun, 1 Dec 2002 07

Re: table_cache too high?

2002-11-20 Thread Thomas Seifert
thanks a lot for both replies. I just asked as this question was brought up with the post before mine. I will ask further off-list :-). Thomas On Wed, 20 Nov 2002 15:25:32 +0100 Thomas Seifert <[EMAIL PROTECTED]> wrote: > > and how on-the-fly? > > > Thomas > >

Re: table_cache too high?

2002-11-20 Thread Thomas Seifert
and how on-the-fly? Thomas On Wed, 20 Nov 2002 09:18:15 -0500 "Ken Menzel" <[EMAIL PROTECTED]> wrote: > Yes, you are correct and it can be worse because you have not > considered that there are some descriptors required by other processes > running. I suggest you increase your file limit to

Re: why is this slow?

2002-11-12 Thread Thomas Seifert
On Tue, 12 Nov 2002 10:24:34 +0800 Jaime Teng <[EMAIL PROTECTED]> wrote: > At 04:47 PM 11/11/2002 +0800, Thomas Seifert wrote: > >Are you using MySQL-3.23.x? > >AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). > >Maybe thats the cause? > > > >

Re: why is this slow?

2002-11-11 Thread Thomas Seifert
Are you using MySQL-3.23.x? AFAIK it doesn't use a key for ORDER BY (MySQL-4.x does). Maybe thats the cause? Thomas On Mon, 11 Nov 2002 16:41:50 +0800 Jaime Teng <[EMAIL PROTECTED]> wrote: > Hi, > > I have a mysql table: > > mysql> describe eventlog; > +-+--+ > | F

Re: [reidbryn@doctor.nl2k.ab.ca: Re: help]

2002-11-09 Thread Thomas Seifert
create the users again or whatever you had before. Thomas On Sat, 9 Nov 2002 09:38:32 -0700 "System Administrator a.k.a. The Root of the Problem" <[EMAIL PROTECTED]> wrote: > since my of my customers are reporting that they are getting: > > Search Results for 'T5Y1M4' > Access denied for user

4.0.5 estimate?

2002-10-28 Thread Thomas Seifert
Hi folks, as I am building a new db-server right now and would like to know if I should wait ... when is 4.0.5 due to arrive? ;-) Thanks, Thomas filter-fodder: sql, query -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. sur

Re: phpmyadmin (OT)

2002-10-25 Thread Thomas Seifert
I don't want to start a flame but where do take this from? Every security-hole in php has been fixed shortly after it was known. Its as secure as any other server-side scripting-language in the web. Thomas On Fri, 25 Oct 2002 10:40:32 -0500 "Ed Carp" <[EMAIL PROTECTED]> wrote: > PHP itself is

Re: need urgent help recovering after renistall (pleeeease !)

2002-10-06 Thread Thomas Seifert
Maybe you didn't specify the correct data-dir in my.cnf? Thomas sql,query On Sun, 6 Oct 2002 09:23:51 +0200 "jeroen" <[EMAIL PROTECTED]> wrote: > hello, > > I'm kindof a newbie with MySQL, and recently did something fairly stupid : I > installed a new system (I'm running on MacOSX, was 10.1.

Re: Mysql Error

2002-09-25 Thread Thomas Seifert
if I remember right, there is a php-mysql*rpm package for redhat which corrects this problem. Thomas On Wed, 25 Sep 2002 23:23:07 +1000 "Peter Goggin" <[EMAIL PROTECTED]> wrote: > The php is as installed from the redhat distribution for 7.3 from the Next > handbooks. Do I need to down load a

Re: Mysql Error

2002-09-25 Thread Thomas Seifert
it sounds more like the php-built has not been linked against the mysql-libraries. but before a close there should have been a "mysql_connect" which should bring up the same error. Thomas On Wed, 25 Sep 2002 21:39:51 +1000 "Peter Goggin" <[EMAIL PROTECTED]> wrote: > I have got apache and mysql

Re: Documentation question

2002-09-24 Thread Thomas Seifert
if you run more than one binary it will NOT use the same physical memory, even if it is the same binary. every programm you run uses its own memory for most parts. Thomas sql, query On Tue, 24 Sep 2002 16:35:21 +0200 Magnus Sundberg <[EMAIL PROTECTED]> wrote: > > Dear sirs, > > I have a smal

Re: transactions...

2002-09-22 Thread Thomas Seifert
On Mon, 23 Sep 2002 08:40:59 +0300 (EEST) Iikka Meriläinen <[EMAIL PROTECTED]> wrote: > On Mon, 23 Sep 2002, Daniel Kiss wrote: > > > Hi! > > > > At 00:56 2002.09.23._ -0300, you wrote: > > >Do I loose > > >too much performance using InnoDB tables in autocommit mode instead of > > >using MyISAM

Re: sum column in mysql

2002-09-18 Thread Thomas Seifert
SELECT *,sum(Duration) as durationsum from table1 WHERE condition should work, Thomas On Wed, 18 Sep 2002 10:32:07 +0300 "adi" <[EMAIL PROTECTED]> wrote: > > Hi, I have a table table1, with a column "Duration" time type(ex 00:12:30) > I want to make a sql selection: > SELECT * from table1 WH

mysql@lists.mysql.com

2002-09-13 Thread Thomas Seifert
as far as I know you have to start safe_mysqld as root! Thomas On Fri, 13 Sep 2002 12:29:30 +0200 hans schneidhofer <[EMAIL PROTECTED]> wrote: > hi, > have a simple question of about starting mysql : > staring with a book of mysql I should start mysql as the loggedin-user, which > is my case "

index_priv and creating indexes

2002-09-09 Thread Thomas Seifert
Hi folks, just wanting some headsup on the following question. How does the index_priv catch in at all? Does a missing index_priv also block me to create a table with indexes in the create-statement? Or does it only affect the later creating of indexes? Thanks in advance, Thomas sql, query

Re: Gui admin clients - security concern?

2002-09-06 Thread Thomas Seifert
for a gui running on your local system the ISP has to open a remote connection which is already security problem. Also the data-flow between your client and the server is not encrypted. Tools like phpMyAdmin run on the ISPs webserver with a local connection and so there is no problem with a remot

where is replication logged?

2002-08-21 Thread Thomas Seifert
Hi folks, I was just wondering, where I can see, which queries are used from the bin-log. I am using a setup with "...do-table" so I restricted it but I am not sure if all the queries are taken to update the tables. is there a log where I can see, what was done? I looked at the relay-log but my

Re: MySQL over NFS

2002-08-20 Thread Thomas Seifert
Isn't that what the MySQL-Replication is for? Thomas On Tue, 20 Aug 2002 08:07:24 -0500 "Brian Moon" <[EMAIL PROTECTED]> wrote: > This is an interesting idea. I would be a happy man if it would actually > work. My experiences with NFS would lead me to believe that this would not > help and co

Re: Persisten Connections

2002-08-14 Thread Thomas Seifert
w but only if you have different servers for webserver and database, but I never tested such a config. Thomas On Wed, 14 Aug 2002 11:14:33 -0400 Tod Harter <[EMAIL PROTECTED]> wrote: > On Wednesday 14 August 2002 09:54 am, Thomas Seifert wrote: > > I disagree entirely > &

Re: Persisten Connections

2002-08-14 Thread Thomas Seifert
it will reduce the load for sure! MySQL is very fast in opening and closing connections at least if the database-server and webserver are on the same machine. I don't know how it will perform on different machines. Thomas On Wed, 14 Aug 2002 14:40:31 +0100 "John Wards" <[EMAIL PROTECTED]> wrote

Re: MySQL eating all memory

2002-08-13 Thread Thomas Seifert
maybe too high sort-buffers and so on (in my.cnf) ? Thomas On Tue, 13 Aug 2002 22:02:42 +0200 <[EMAIL PROTECTED]> wrote: > Hi, > > mysql 3.23.51 is running on a Linux 2.4.18 box (4cpu, 2GB) with Apache 1.3.39. > The server is under load (~160 mysqld processes; 80-120 queries/second > shown by

How stable is v4? (was: Re: InnoDB vs. MyISAM on large number of tables?)

2002-08-09 Thread Thomas Seifert
On Thu, 8 Aug 2002 03:02:40 -0700 Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > btw: > > I did a quick benchmark with mysql4 and its query caching running with > > innodb. > > Quite impressive, the app run with double the number of pages per second as > > before. > > Excellent. MySQL 4.0.{2,3}

many tables in one database, impact on performance?

2001-06-11 Thread Thomas Seifert
database have some impact on the performance of mysql? Could it be, that it creates higher load on the server it is running? Thanks in advance, Thomas -- Thomas Seifert mailto:[EMAIL PROTECTED] - Before posting, please check

RE: How many Mysql PIDs ?

2001-06-09 Thread Thomas Seifert
Hi Bob, thas just a difference in the apache-config from caldera. That has nothing to do with mysql! Thomas - Original Message - Jeremy, Yeah I follow you and as a LInux user of 5 years I am accustomed to seeing multiple processes launched for the same executable but

RE: -bin.001 --- files?

2001-06-09 Thread Thomas Seifert
;http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscri

-bin.001 --- files?

2001-06-09 Thread Thomas Seifert
on (001 - 014). Some of them are really HUGE (300 MB i.e.) ... which is bigger than my whole database. Could someone tell me what this files are for? Thanks in advance and sorry for my bad english Thomas -- Thomas Seifert mailto:[EMAIL PROTECTED