The temp-tables tag has no wiki summary.
3
votes
0answers
205 views
Why are runtimes different for a table including a primary key versus a table with a clustered unique index added after population
When I create a temporary table with a PK defined from the outset like this I get great performance in subsequent joins on that key:
create table #temp (
field1 int not null
field2 int ...
1
vote
0answers
45 views
Why is this query creating 300+ temporary tables in Mysql?
SHOW global STATUS LIKE '%tmp%';
set @UID = 132;
set @param2 = 'cde';
set @param3 = 20130331;
set @param4 = 'C';
select p.id, p.column44, p.column42, ue.column35, u.id, p.column43, p.column45, ...
1
vote
0answers
114 views
TMD auto create
I used mysql as part of a project and found it to be a very practical tool.
I have a question about mysql in regards to how it creates temporary table types TMD in /var/lib/mysql/. This partition ...
1
vote
0answers
54 views
Map records to a time interval
I have two tables:
SamplesTbl contains samples every 5 seconds of a bike ride
RxTbl contains the prescribed stages and other values of a bike ride
SamplesTbl
SamplesID int
SessionNum int
StageNum ...
0
votes
0answers
278 views
Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL
I started the process of inserting returned results to another table. The query groups the rows in respect of indexed IDs. This causes 149,000,000 rows to be decreased to 460,000 rows.
The query ...
