I had problems with unions that result in large queries too.
I found that MySQL 4 was using Heap tables for Unions.
One can Increase the Heap Table size to help, but
What about alot of conncurrent users running unions?
This could eat up alot of memory.
Is there a switch to stop unions from using
You might try running queries seperately and check performance to see
if it Perl or mySQL
mike
Norris, Joseph wrote:
I am running mysql and apache on windows 2000. Everything is running
smoothly and then all of the sudden my perl scripts that have been running
just find are
Michael Grover wrote:
This simple query:
create temporary table mike select * from wy
union all
select * from ks;
will cause the following error:
[root@localhost:3306] ERROR 1114: The table '#sqla08_3_1' is full
what's wierd is I only have a #sqla08_3_0 table in my c:\winnt
I was wondering if anybody here knows the layout for a row in a static
MyISAM table file (*.myd).
The byte count at the begining of a row varies with the field count.
And the Header bytes I think tell MySQL what fields are Null?
I have been studying code in the myisam dir and the file
I ported several applications from Firebird 1.0 to MySQL 4.
The main things I ran into was little SQL Syntax differences, Stored
procedures, and
Triggers...
mike
Paul DuBois wrote:
At 13:40 -0700 5/11/02, Jeff Kilbride wrote:
MySQL
Paul DuBois
New Riders
Plus, he's here on
Well, My hat's off to MySql 4
I finally got around my slow query problem... :-)
Mysql has beat any other database I have used for this specific
purpose...
I wrote a quick little app to directly import records to the MYD file.
I then run myisamchk -r -q v:\Data\...\..\MyDataFile to
reindex
I have a dumb Question...
When I try to enter a Multiple line SQL statement like:
create table ZIPSTA2 (zip char(5), state char(2)) ;
create table ZIPSTATES (state char(2), zip char(5));
I get this error:
[root@localhost:3306] ERROR 1064: You have an error in your SQL syntax
near '; create
-
From: Michael Grover [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 6:59 PM
Subject: Multi Line SQL Statements
I have a dumb Question...
When I try to enter a Multiple line SQL statement like:
create table ZIPSTA2 (zip char(5), state char(2)) ;
create
oops I meant MySql c:\sql.txt
Jeremy Zawodny wrote:
On Wed, Apr 24, 2002 at 02:32:52PM -0400, vlady wrote:
Hi,
Setting an replication for the first time, I get the following error
message in my slave:
020424 13:59:28 Slave: connected to master
'[EMAIL PROTECTED]:3306',
