From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
What is going slower, INSERT / UPDATES or SELECTS?
Complex SELECTs
CHAR should make for quite efficient processing, since to a
large degree nobody cares what's in there: it just slams the
data in, or does a simple byte-by-byte comparison.
[EMAIL PROTECTED] wrote:
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
What is going slower, INSERT / UPDATES or SELECTS?
Complex SELECTs
CHAR should make for quite efficient processing, since to a
large degree nobody cares what's in there: it just slams the
data in, or does a simple
I run CHECK commands against all tables nightly. Our dataset is
small, so it's quick easy; for large and/or static datasets daily
might be impractical. However, if you don't run CHECK regularly, you
don't know your data is good, and it's possible you might have
corruption for a long time
I'll second what Chris said, which is that all the joined columns
should be of the same type for speed.
Also, your substring and LIKE comparisons are going to be problematic,
as those are string operations, not numeric, and MySQL is having to
convert all the decimal values to strings before
10061 means actively refused. Maybe check your event log around the same
time to see if mysql died?
On 27/10/06, mos [EMAIL PROTECTED] wrote:
Since installing MySQL 5.0.24 on Windows XP, once or twice a week I'll get
an error message Can't connect to MySQL server on 'localhost' (10061)
Socket
A DECIMAL data type would probably be faster than a CHAR when doing
arithmetic, and an integer type would be faster yet. I don't know about
JOINs on indexed columns. I also don't know about substring and LIKE
operations with DECIMAL types, but they should be a lot faster with CHAR
than with
Hi,
I'm trying to load some data from a primary MySQL DB into a VMware image
for RD purposes.
Instead of doing a mysqldump of nearly 10G of data, I would like to just
select a subset of it and load it into the VMware image.
I'm facing a snag with regard to NULL values.
I've tried doing
$mysql
Ow Mun Heng wrote:
Hi,
I'm trying to load some data from a primary MySQL DB into a VMware image
for RD purposes.
Instead of doing a mysqldump of nearly 10G of data, I would like to just
select a subset of it and load it into the VMware image.
man mysqldump
You will find it supports a where
On Oct 25, 2006, at 5:32 PM, Dan Buettner wrote:
My understanding of what is happening here is this:
The 'rows' column of EXPLAIN output is an estimate of how many rows
MySQL thinks it will likely have to examine in a table to get your
answer. When there's an index, it will hopefully be able
On Fri, 2006-10-27 at 11:16 -0500, Gerald L. Clark wrote:
Ow Mun Heng wrote:
Hi,
I'm trying to load some data from a primary MySQL DB into a VMware image
for RD purposes.
Instead of doing a mysqldump of nearly 10G of data, I would like to just
select a subset of it and load it into
In the last episode (Oct 27), David Hillman said:
On Oct 25, 2006, at 5:32 PM, Dan Buettner wrote:
My understanding of what is happening here is this:
The 'rows' column of EXPLAIN output is an estimate of how many rows
MySQL thinks it will likely have to examine in a table to get your
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have a trigger on it, I'd like to iterate
through
Hello,
Originally I had this long explanation of what I'm doing and why I'm
asking this question but I thought I'd just cut to the chase and ask...
For a db that doesn't get a lot queries is there much of a performance
difference between BLOB and VARCHAR(255)?
Thanks,
Chris.
--
MySQL General
On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote:
MySQL is just giving you as much information as it can without
actually
running the query. It knows how it will go about running the query
(so
type is known absolutely), but it doesn't know exactly what it
will get
(so rows is only a guess).
On Fri, 27 Oct 2006, Ferindo Middleton wrote:
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have
Chris, it should be noted that a BLOB is binary data, not character
data like VARCHAR. BLOBs will act differently in terms of
case-sensitivity for example. The TEXT data type might be more what
you're looking for.
See http://dev.mysql.com/doc/refman/5.0/en/blob.html
for some more info on BLOB
In the last episode (Oct 27), David Hillman said:
On Oct 27, 2006, at 11:50 AM, Dan Nelson wrote:
MySQL is just giving you as much information as it can without
actually running the query. It knows how it will go about running
the query (so type is known absolutely), but it doesn't know
Hi,
Initially i thought it solved the problem but then i realized that the
encoding done by PERL and this mysql function is different.I compated and
found that the difference is in a new line , in this function the encoded
output is all in one line and the same done via PERL via MIME::Base64
Tej Kohli, Software
http://www.tejkohlifund.com
http://www.tej-kohli-foundation.com
http://www.tejkohlimagazine.com
http://www.tej-kohli-magazine.com
http://www.tejkohli-news.com
http://www.tejkohlionline.com
http://www.tejkohli-online.com
http://www.tejkohlitoday.com
Today noted entrepreneur
Glenn Kawesch
Dr. Kawesch is the surgical director of Kawesch Lasik--one of Southern
California's most experienced refractive surgery facilities. We have been
specializing in refractive surgery since 1989 and have completed
approximately 25,000 procedures.
Dr. Kawesch attended medical school at
Hi,
just wondering if there a quick way to determine the # of rows in a
mysql table.
I know I can do a count(*) but that would entail a table scan etc.
I found out that I can do the query into the information_schema table,
however, I don't get a consistent reading.
executing it multiple times,
On Saturday 28 October 2006 05:34, Ow Mun Heng wrote:
Hi,
just wondering if there a quick way to determine the # of rows in a
mysql table.
I know I can do a count(*) but that would entail a table scan etc.
I found out that I can do the query into the information_schema table,
however, I
On Sat, 2006-10-28 at 05:44 +0300, George-Cristian Bîrzan wrote:
On Saturday 28 October 2006 05:34, Ow Mun Heng wrote:
Hi,
just wondering if there a quick way to determine the # of rows in a
mysql table.
I know I can do a count(*) but that would entail a table scan etc.
I found
23 matches
Mail list logo