My problem is the following and I thank you in advance on any help
offered. Show Innodb Status shows that my DB server has no free
buffers. What is the significance of this, what causes this, and how
bad is it?
Here is the relevant part of the output of that command:
BUFFER POOL AND MEMORY
--
Thanks for the message. I should rephrase - the data set is millions of
rows, but the tables are indexed, and an EXPLAIN looks like it is using
indexes effectively. The query produces the exact same results both
times (with and without LOCKing). Is there a reason that by calling the
query vi
On Tue, 27 Apr 2004, Scott Switzer wrote:
> Hi,
>
> I am having a difficult time with a query. My environment is MySQL
> v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel).
> Basically, I am running a query of the form:
>
> INSERT INTO temp_tbl
> SELECT c1,c2...
> FROM t1,t2,t3,t4
> WHE
Hi,
I am having a difficult time with a query. My environment is MySQL
v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel).
Basically, I am running a query of the form:
INSERT INTO temp_tbl
SELECT c1,c2...
FROM t1,t2,t3,t4
WHERE ...
It is a very complex query, which looks at millions
On Wed, Dec 26, 2001 at 04:23:46PM -0600, Philip Molter wrote:
> Are there guides out there for configuring these things? What is
> a "big enough" log file? Honestly, on a lot of stuff, I'm just
> guessing, but it takes a lot of time to fiddle with values, clean
> out the database, and then shov
Weaver
Bozeman, Montana
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 26, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: Re: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking
question
Walt,
thank you for the test!
>This post
Philip,
>On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
>: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
>: per second would not be possible. Did the table fit in the buffer pool of
>: InnoDB or the SGA of Oracle? Did you commit each insert individuall
On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
: per second would not be possible. Did the table fit in the buffer pool of
: InnoDB or the SGA of Oracle? Did you commit each insert individually in
: InnoDB
Walt,
thank you for the test!
>This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle
>comparison testing with you guys. In addition, I have a question about
>locking mechanisms in InnoDB which I'll ask at the end of the post.
>
>I've been comparison testing MyISAM, InnoDB,
This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle
comparison testing with you guys. In addition, I have a question about
locking mechanisms in InnoDB which I'll ask at the end of the post.
I've been comparison testing MyISAM, InnoDB, and Oracle for the past two
weeks or
10 matches
Mail list logo
