You have also 3000 * 7 millions columns to left joins to x,y,.. others tables.
And you use myisam. this will certainly be a big update problem.
I suggest you to transform your query into :
1. select using the left joins to see first the number of rows to be updated
2. according to this number th
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 prob
At 04:35 PM 6/15/2005, you wrote:
Mathias,
Here's the query:
UPDATE customer_indicator INNER JOIN
customer_listing_pref
ON customer_listing_pref.customer_id =
customer_indicator.customer_id
AND customer_listing_pref.store_id =
customer_indicator.store_id
AND customer_listing_pref.store_id = @OL
Mathias,
Here's the query:
UPDATE customer_indicator INNER JOIN
customer_listing_pref
ON customer_listing_pref.customer_id =
customer_indicator.customer_id
AND customer_listing_pref.store_id =
customer_indicator.store_id
AND customer_listing_pref.store_id = @OLD_STORE_ID
LEFT JOIN contact_log ON
sorri it's tmp_table_size.
mysql> show variables like '%table%';
++--+
| Variable_name | Value|
++--+
| innodb_file_per_table | OFF |
| innodb_table_locks | ON |
| lower_case_table_names | 1|
| max
Mathias,
Thanks for the reply. I couldn't find a server
variable named "max_temp_table_size" but I did find
one named "max_heap_table_size". Is that what you
meant? BTW, I forgot to mention that I'm using MySQL
4.0.20. Could it be that this variable that you
mention is only in later versions?
Bas
hi,
seems to be a temp table (sybase notation).
see 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.
>
Hello.
There are some tips at:
http://dev.mysql.com/doc/mysql/en/mysql-cluster-faq.html
See also:
http://dev.mysql.com/doc/mysql/en/mysql-cluster-db-definition.html
>We have the following problem.
>
>Cluster means "table 'TABLENAME' is full"
>
>We have 11076890 rows in this
Well, it will NOT let me add more ibdata files:
Any ideas??
Thanks, Spiros
Here is hostname.err
(On a 2GB RAM, 2x1000 CPU, )
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 3 7
That's what I thought at first as well. But my tmp_table_size is set to 64MB
and I used the --big-tables option just to be sure.
Also, show table status says the size is well below 64MB:
Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length
tmp| HEAP | Dyn
[EMAIL PROTECTED] wrote:
> Hello,
>
> I keep getting this:
>
> insert into tmp select * from ascend_log_2001_08_25;
> ERROR 1114: The table 'tmp' is full
>
> tmp is a heap table
There is a size limit to temp tables. See:
http://www.mysql.com/doc/F/u/Full_table.html about increasing the allowed s
On Fri, Mar 16, 2001 at 10:48:59PM +0900, Cho Bum Rae wrote:
> I tried to query below,
> "select src_ip, byte, packet from table group by src_ip order by bytes desc limit 10"
>
> Then DB said, "ERROR 1114: The table 'SQL2997368_0' is full."
>
> What is problem?
>
It really helps to search the l
"Ralf R. Kotowski" wrote:
>
> Ok I get a table is full error...
>
> So how/where do I set the tmp_table_size ? or the BIG_TABLES
> option so that its started that way at system start-up?
>
> from what I gather the Big_Tables option writes ALL tmp tables to
> disk, is that correct? so I should u
13 matches
Mail list logo
