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
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
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
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
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
>
>
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
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?
> >
>
>
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
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
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
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
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.
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
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
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
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
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
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 "
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
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
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
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
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
>
&
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
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
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}
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
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
;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
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
30 matches
Mail list logo