Howdy all,
I've noticed some strange behavior with the way that
mysql is choosing indexes with a particular query I'm
trying to optimize.
First off, I'm using MySQL 4.0.24 on MAC OSX.
I've got a table that I'm searching on based upon a
set of preferences. From one query to the next the set
of
max_temp_table_size
Mathias
Selon Emmett Bishop [EMAIL PROTECTED]:
Howdy all, I have a question about a SQL statement
that I'm trying to execute. When I execute the
statement I get the following error: The table
'#sql_bd6_3' is full.
What does this mean exactly?
Thanks,
Tripp
|
| table_type | InnoDB |
| tmp_table_size | 9437184 |
++--+
8 rows in set (0.00 sec)
What are :
show create table toto;
the count(*) ?
the query ?
Mathias
Selon Emmett Bishop [EMAIL PROTECTED]:
Mathias,
Thanks
Mike,
Thanks for the insight. The sent table has about 7
million records. The other tables involved have tens
of thousands of records or there abouts. Not your 100
million size but certainly worth exploring.
Thanks again,
Tripp
--- mos [EMAIL PROTECTED] wrote:
Tripp,
This problem
Howdy all, I have a question about a SQL statement
that I'm trying to execute. When I execute the
statement I get the following error: The table
'#sql_bd6_3' is full.
What does this mean exactly?
Thanks,
Tripp
__
Yahoo! Mail Mobile
Take
Howdy all,
Quick question about Analyze table. I just deleted 3+
million records from a table that gets a lot of insert
activity throughout the day. It seems like now would
be a good time to run optimize table and/or analyze
table. I saw in the docs that analyze table puts a
read lock on the
Howdy all,
is it possible to force a field to be NOT NULL but not
have any default value (I.E the insert statement must
explicitly provide data for the field in question)?
Cheers,
Tripp
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best
I looked around and didn't see documentation of MySQL
error codes. I did find a short list of INNODB codes
but nothing comprehensive. Is there such a page?
Thanks,
Tripp
__
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
Heikki,
We're using MySQL 4.0.20. Here's the full output:
=
041207 8:33:26 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 15
seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation
Foreign keys, transactions, and row level locking
for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB
which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: Emmett Bishop [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent
Howdy all,
We're having concurrency problems with a table in our
database and I'm not sure if I'm interpreting the
following chunk of output from SHOW INNODB STATUS
correctly.
From what I gather, the row could not be inserted
because the table was locked. I think that this insert
was a victim
Howdy all,
quick question about how INNODB handles locks. If
autocommit is off and I perform a select statement
without then issuing a commit, will INNODB remove any
read locks that it issued? I would assume that the
locks would be removed when the statement finished.
Just want to verify that
Howdy all,
I've got a series of tables that are used to store a
user's session information. The main table is a very
simple table that stores a GUID and a last access
data-time value. All other tables use the guid as a FK
back to this main table.
The main table's schema is as follows:
CREATE
I need to snag a copy of MySQL 4.0.20 for Windows. Is
there somewhere on the MySQL I can grab older
versions?
Thanks,
T
__
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
MySQL General Mailing List
For
Howdy all,
We have a set of tables in a database that maintain
session information of users of a website. Each user's
session is identified by a GUID that we generate when
they login. As the users perform various operations
records are inserted/updated/deleted from these
session tables. Some of
Howdy all,
I got this error while running a routine mysqldump
last night: Error 2013: Lost connection to MySQL
server during query when dumping table `contact_log`
at row: 41245
I didn't find any good information on this error at
mysql. Is there a page there that lists all error
codes? I found
Howdy all,
Quick question about foreign keys. If I have a
database with foreign keys setup, then drop one of the
tables (which is referenced by many of the others) and
re-add the table, will the existing FKs work?
I'm seeing errors in SHOW INNODB STATUS under the
LATEST FOREIGN KEY ERRORS
You're making the assumption that he's using 4.1.x. He
didn't state which version he's using so your solution
may be of no use to him.
-- T
--- Matt Warden [EMAIL PROTECTED] wrote:
On Fri, 06 Aug 2004 13:17:42 -0400, Michael Stassen
[EMAIL PROTECTED] wrote:
You need a LEFT JOIN:
And I have a table like this
click send on accident?
A
Don't leave me hangin'!!
-- Tripp
--- Claire Lee [EMAIL PROTECTED] wrote:
I have a table like this
name price type
A
__
Do you Yahoo!?
New and Improved Yahoo! Mail -
Paul,
What about the case where column A is a foreign key?
In that case would you be forced to keep the index on
column A or could you use the A,B index since A is the
left most prefix?
Tripp
--- Paul DuBois [EMAIL PROTECTED] wrote:
At 19:26 -0700 7/7/04, John Mistler wrote:
I am not
Howdy all. If this isn't the right listserv for this
question, my appologies.
What I'd like to do is set up a graph under the
Health section of the mysql administrator so that I
can easliy keep tabs on the INNODB Buffer pool.
The problem is that I don't know which variables to
use to calculate
Quick question. In general, is it better to create
compound primary keys or use an auto increment field
to uniquely identify each record?
--T
__
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25ยข
Howdy all,
I've got a few questions about the table cache and the
tmp_table_size.
First off, a little background info. The server has
been running now for 193 hours. I've got 3 GB of RAM
on my box and I'm running RH linux. The MySQL
installation is version 4.0.13.
After taking a look at Show
Arun,
Unfortunately, that link contains the exact same info
as does the mysql.com page. There's almost no
explaination there of what any of the output means.
I'm sure that it's really useful stuff but I don't
have a starting point. Can someone point me in the
right direction (a book or website)
Howdy all,
Quick question about what I'm seeing in the BUFFER
POOL AND MEMORY section...
I've configured the innodb_buffer_pool_size to be 128M
and when I do a show variables like 'innodb%' I see
| innodb_buffer_pool_size | 134217728 |
So that looks good. However, I see the
Is the key_buffer_size server variable useful for
tuning databases that only have innodb tables or do I
need to use the innodb_buffer_pool_size variable for
this?
Thx,
Tripp
__
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital
I ran into this problem when I installed 4.0.18. All
of the tables in my database are INNODB and the
REPLACE statement was failing on tables that had
foreign key constraints. I just rolled back to 4.0.16
and the problems went away. Not much of a solution,
but it's buying me a little time. Will I
Howdy all,
I've got a query which selects the count all listings
that meet meet a customer's search criteria. In
addition, there is a sent table that keeps track of
which listings have already been sent to that
customer. There are roughly 30,000 listings and 1.2
million sent records. As is stands
Vadim,
if I'm not mistaken, you can't set a variable then use
it in the same statement.
See http://dev.mysql.com/doc/mysql/en/Variables.html
A little ways down the page...
The general rule is to never assign and use the same
variable in the same statement.
-- Tripp
--- Vadim P. [EMAIL
Ginger,
can't speak to the log file issue but check out this
link for the dynamic server variables:
http://dev.mysql.com/doc/mysql/en/Dynamic_System_Variables.html
Best O'luck,
Tripp
--- Ginger Cheng [EMAIL PROTECTED] wrote:
Hello, MySQL gurus,
Sometimes the 'local' option of 'load
Howdy all,
I am having trouble configuring my server parameters
with my.cnf because there seems to be several mysql
server instances (mysqld processes) running on my
linux box. What I would like to do is bump up the
innodb_buffer_pool_size on the server to 512M (the box
has 3GB of RAM). The
31 matches
Mail list logo
