mos wrote:
AMD Athlon 64X2 3800+ Dual Core S939 Manchester (2x512K cache)
AMD Athlon 64X2 4200+ Dual Core S939 Manchester (2x512k cache)
AMD Athlon 64X2 4400+ Dual Core S939 Toledo (2x1MB cache)
AMD Athlon 64X2 4600+ Dual Core S939 Manchester (2x512k cache)
I would think, as a blind guess,
[EMAIL PROTECTED] wrote:
If I understand the InnoDB engine correctly, I don't see how they could
speed it up unless they start tracking how many records belong to each
active version within a database.
But one thing you can do to speed it up somewhat is to do a
COUNT(PK_column) (rather
[EMAIL PROTECTED] wrote:
Well, Gordon, looks like you missed the thread. ;-)
Maybe, but his solution is actually pretty close to what the OP wanted
Instead of
INSERT INTO Table1 (...) VALUES ('val1', 'val2', 'val3', ...) something
you do
INSERT INTO Table1 (...)
SELECT 'val1',
Peter Brawley wrote:
Perhaps Oracle also has such a setting too. MySQL doesn't.
As a matter of fact, Oracle goes the other way in that if you store ''
into a VARCHAR field, it actually stores a NULL there. But it's
inconsistent in that doesn't consider a NULL varchar column to be = ''
(a
[EMAIL PROTECTED] wrote:
A runtime context, usually simply called a context, is a handle to a
an area in client memory which contains zero or more connections, zero
or more cursors, their inline options (such as MODE, HOLD_CURSOR,
RELEASE_CURSOR, SELECT_ERROR, and so on.) and other additional
[EMAIL PROTECTED] wrote:
CONTEXT USE Example:
Do *you* really understand what this feature is supposed to do? Can you
explain it to us in (low-level) detail?
No, MySQL doesn't have a feature like this.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Jon Hancock wrote:
However, I can't consider using it unless MySQL performs well.
Any ideas or personal experience with MySQL 4.1.x on Solaris 10?
Well, for one thing, your workload is unique, so the only way you can
make your decision *is* for you to actually *consider* it.
Install Solaris 10,
[EMAIL PROTECTED] wrote:
The second camp, as is described in the article, are more data-oriented.
This practice was created in the original days of databases and
programming design where ALL variables, including table names and field
names, were global and needed to be absolutely unique.
It's
Scott Hamm wrote:
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file.
Gosh, what's wrong with CSV files? Surely Access can export a classic
CSV file format with fields separated by commas and enclosed by ?
Then you can just use
LOAD
[EMAIL PROTECTED] wrote:
Is this correct?...how MySQL calculate this?...
Yes.
Std. Dev = Math.sqrt(sum((val[i]-avg)**2) / count(i));
Verified with a trivial program.
mysql select * from temp;
+--+
| cal |
+--+
| 00029.98 |
|
Gelu wrote:
3.Go to in /etc/init.d and make 2(two) symbolic link from mysqld script to
...
- K12mysqld - OS kill the daemon when shutdown.
- S12mysqld - OS start the daemon on boot.
...in rc3.d directory (if your OS boot on text mode) or rc5.d directory (if
your OS boot with
I tried setting a TIMESTAMP column (nullable, not first timestamp in that
table) in mysql 3.23.38) to NULL, but it seems to get the value
00. Is it not possible to set a timestamp column to NULL?
--
Shankar.
-
Shankar Unni wrote:
I tried setting a TIMESTAMP column (nullable, not first timestamp in
that table) in mysql 3.23.38) to NULL, but it seems to get the value
00. Is it not possible to set a timestamp column to NULL?
It's even worse: if you explicitly insert the value NULL
Paul DuBois wrote:
Feature you missed. Have a look here:
http://www.mysql.com/doc/D/A/DATETIME.html
Thanks. I wonder how I missed that.
Of course, the page lies somewhat: it says that if you omit the column in
an insert, it should get set to now(), but the following example shows it
Victoria Reznichenko wrote:
recu small problem. I have a table set up like so. It has a number of entries
recu that were added on a certain date, I use TIMESTAMP to keep track of the date.
recu mysql UPDATE deerfield SET version = '2.1' WHERE product = 'WinGate LITE';
recu and all of the
With MySQL 3.23.38:
If you have a TIMESTAMP column with zero values, then
SELECT ts from table;
returns
00
But
SELECT min(ts) from table;
returns
0
This causes the JDBC driver to fall over when getting the timestamp value
from this query. Isn't this a formatting
(Using mysql 3.23.38 - commercial version)
I have a table that has two indexes: one on just creationTime
(iv_alert_creation_ix), and one on (state, creationTime) (iv_alert_state_ix).
When I issue this query:
explain select uuid from iv_alert
where state = 1
and creationTime =
Steven Roussey wrote:
Any way to hint a particular index for a query?
From the manual (http://www.mysql.com/doc/J/O/JOIN.html)
Thanks. I missed that. Unfortunately, as I was afraid, this is a very
MySQL-specific way of doing it. But then, hints always are DB-specific, so
that's not too
[obfilter: mysql database]
Roger Baklund wrote:
* Benjamin Pflugmann
Think the other way around: If the other option is to have no floating
point type at all, a not perfect one may be good enough for many
cases.
I agree, to some extent, but a growing number of users are 'normal people',
alias mysql='mysql -u root -pbig_secret'
Another, more reliable way, is to use the long-form options and say
mysql --user=root --password=big_secret
--
Shankar.
-
Before posting, please check:
Robert La Ferla wrote:
/usr/include/bits/mathinline.h: In function `float log1pf (float)':
/usr/include/bits/mathinline.h:540: Internal error: Segmentation fault.
Please submit a full bug report.
See URL:http://bugzilla.redhat.com/bugzilla/ for instructions.
So? Do what that says: go to
Sinisa Milivojevic wrote:
Shankar Unni writes:
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working on that?).
When you are saying that there is no native Windows or OS X port, what
were you referring to ??
Oh
[redirecting to mysql list because of general interest]
Yoram Naim wrote:
Can some one send me a code sample (C , CPP )
How can I copy file data to MYSQL BLOB field
but not in one piece .
Is this even possible? If so, I'm sure that the JDBC driver could use such
a feature to stream large
Sinisa Milivojevic wrote:
Shankar Unni writes:
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working on that?).
When you are saying that there is no native Windows or OS X port, what
were you referring to ??
Oh
[redirecting to mysql list because of general interest]
Yoram Naim wrote:
Can some one send me a code sample (C , CPP )
How can I copy file data to MYSQL BLOB field
but not in one piece .
Is this even possible? If so, I'm sure that the JDBC driver could use such
a feature to stream large
Alok K. Dhir wrote:
That said, depending on your requirements, there are still compelling
reasons to choose PostgreSQL - subselects, triggers, user defined types,
etc.
And one big reason not: no native Windows port. Or Mac port (though that
has probably changed with OS/X - anyone working
[ database mysql query ]
Sinisa Milivojevic wrote:
On Fri, 01 Feb 2002 15:21:07 -0800
Steve Edberg [EMAIL PROTECTED] wrote:
...perhaps a NEAR function could be added; as a config file or
compile-time option, you could define an accuracy range. Say,
./config --with-epsilon=0.0001
This is
[ database query mysql ]
Jim Dickenson wrote:
Am I to assume that based on your response that one should never use a float
field type if you ever want to select the data?
No, that wasn't quite what he said.
You can certainly select on a float field, as long as you perform a
meaningful
Joel Wickard wrote:
why not run cygwin? I run postgres on my win2k box through cygwin. It
would be less resource intensive.
Or even better, run the native Windows port. It's quite a good one.
--
Shankar.
[ database table query sql ]
Michael Collins wrote:
Using MySQL 3.23.47, is the best data type for small currency float(4) ?
This is for prices of items in a shopping cart for example t-shirts.
What is the difference in using float vs decimal? I know I don't need
double.
Float has accuracy problems at large
[database,sql,query,table]
Mark Matthews wrote:
Or download version 2.0.11 released today which fixes that bug (as far as
I can tell):
Absolutely. Quick work, indeed. I've already switched over to 2.0.11 and
it's been smooth.
Thanks for the fantastic support!
--
Shankar.
[database,sql,query,table]
Shankar Unni wrote:
Float has accuracy problems at large ranges. A typical float has a fixed
number of so-called significant digits. For 32-bit IEEE floats, that's
about 6.
Of course, in the interests of fairness, I should note that typical doubles
(64-bit
Paul DuBois wrote:
I think that MM.MySQL used to be packaged as a tar file, but not is
distributed
as a JAR. Use the newer one, you'll be better off. And do as the filename
indicates: un-jar it. You'll end up with a directory that contains the
actual driver file plus a bunch of other
[ filter fodder: mysql database - is this case-sensitive?]
Erv Young wrote:
It seems to me that if AOL Time Warner had not only Netscape, but also
the whole Linux-Apach-MySQL-PHP brigade in their hands, they would
indeed have a powerful armamentarium for challenging Microsoft.
I am not
Bob Hall wrote:
We've requested a database from different companies, and specifically
said we wanted MySQL or PostgreSQL because of the open source angle
and we're a library.
One company offered MS SQL as the platform and said that they can later on
port it to MySQL. For this they wanted 18 000
Islam, Sharif wrote:
I had 3.23.41 installed. It came with Rh7.2. I had some mistakes in initial
start up . So I thought i would reinstall it. I downloaded the rpm for
3.23.47. And ran the rpm installation.
You got the 3.23.47 RPM from MySQL's site, I presume? That RPM is not an
upgrade
Is there any way to hex-dump a BLOB column using a Select statement on the
mysql command line?
The documentation for the hex() function says that
hex(abc)
should print
616263
But in fact it prints 0. (on 3.23.36 and 3.23.43, the two versions I have
installed - the former on RedHat
[ obfilter: mysql database ]
Sinisa Milivojevic wrote:
Cafetechno writes:
When The Stored Procedure Capability will be
included in mySQL
Take a look at myperl on http://freshmeat.net
Interesting start, of course.
What would be nice is to support a proper create or replace
Roger Baklund wrote:
hi there.. no solution from me, but I'm also interested in this type of
query (although I only want 1 for each lang)
If you only want one row for each lang you can do it using GROUP BY...
SELECT * FROM table GROUP BY lang
Whoa. Watch out. You can omit columns from a
Michael Widenius wrote:
Hi!
Brent Is there any way to detect the Operating System that a MySQL server is
Brent running on using SQL or DBI function calls only?
Sorry no. But this is would be a good thing to have and we shall add
this on our TODO.
Especially since MySQL has different
rc wrote:
anyone know why i'm getting these spam emails over this list
Because it had the magic word sql, which the filter checks..
--
Shankar.
-
Before posting, please check:
http://www.mysql.com/manual.php
Gary Wheeler wrote:
I've done a fool thing and changed the root password to mysql server, and
evidently miss typed, because now it will not let me in. How can I get back
into mysql to change this?? Please help as this is a production server!!
See the standard documentation page at
X-obligatory-filter-fodder: database,sql,query,table
Joe Ellis wrote:
i believe your talking about VNC.
http://www.uk.research.att.com/vnc/
Jack A. Fobel wrote:
I remember seeing a program awhile back that acts like pcanywhere or
terminal services, to connect to a linux or windows
Heikki Tuuri wrote:
Foreign keys do not work if you do an ALTER TABLE. I have to add a note to
the manual that they do not work even if you do an ALTER TABLE to the
referenced table.
Are you saying that you can't add columns to a table (to grow the schema
incrementally between software
Attila Soki wrote:
select round(9.065,2)
++
| round(9.065,2) |
++
| 9,06 |
++
why not 9,07 ??
Most C compilers today defer things like round() to the floating-point unit
on the CPU. Most CPUs these days implement IEEE754 as
Raymond Norton wrote:
error: failed dependencies:
MySQL conflicts with mysql-3.23.36-1
MySQL-server conflicts with mysql-server-3.23.36-1
Yeah, the MySQL rpms are incompatible with the mysql rpms (which are done
by RedHat). Apparently the two camps each think the other's file system
Rob@TH wrote:
Hmm still nothing :/
Any other possibilities?
[ Selecting a random entry from a database ]
Generally this is a hard problem. Ordering by rand() is really wasteful
because the DB has to select *all* entries, order them, and then pick one.
There are more efficient solutions
Bennett Haselton wrote:
NOT NULL doesn't mean that the column doesn't have a default, it just
means that the default is not null.
In other, more conventional (:-)), databases, NOT NULL means simply NOT
NULL, and implies nothing about defaults - that's a MySQL-ism. (Thus, a
NOT NULL
OK, so I'm on a slightly older version for this experiment (3.23.36)..
I tried restarting mysqld with the line
set=lower_case_table_names=1
in my my.cnf (on RedHat 7.1), and have a table called ipaddr in my
database (the files are ipaddr.frm, ipaddr.MYD and ipaddr.MYI). (I have
verified
sherzodR wrote:
Well, Paul, i think he means using source in an .sql script.
Yes you can, Shankar. I used it several times for several reasons :)
And u can envoke your sql script the same as you use your other
scripts.
[EXAMPLE]
[...]
-- in source.sql file:
source query.sql
# or
Who has set up the RPM packaging for the current MySQL-generated RPMs? It's
very different from the RedHat-generated packaging, and makes it impossible
to just upgrade the package in place.
Of course, one could just delete the RedHat package and then install the
MySQL-generated package, but
database,sql,query,table
I notice that source is only accepted at the *command line*. This means
that I can't source a script that sources another file.
I guess source is implemented in some special way that prevents it from
being recursively used?
Is there a way to do what I want (have
, November 15, 2001 11:16 PM
To: Shankar Unni
Cc: [EMAIL PROTECTED]
Subject: Re: About huge numbers
On Thu, 15 Nov 2001, Shankar Unni wrote:
Thank you for your answers.
Generally, you don't want to store currencies in floating point,
anyway,
and it's unfortunate that MySQL implements
Kristian Köhntopp wrote:
Bennett Haselton wrote:
The problem is, how would you add a new bus and a new driver to the
database? Whichever one is added first, you're going to get an error
because its counterpart doesn't exist yet, violating referential integrity.
I was under the impression
Gyulay Gabor wrote:
The problem is that I need to store numbers with lot more
than 16 decimal digits - e.g. 1234567890123456789012345.12
[...]
The reason is why we need this that there're several
currencies (like italian lire) which requires this kind of
precision.
Excellent answer from
Christan Andersson wrote:
lets say that I have this table.. articles(id,language,name,description)
what I would like to do is retrieve 1 row per unique id in the chosen
language
select * from articles where language='en';
that is quite simple, unfourtunally, not all articles have the
Christan Andersson wrote:
what I really want is the following..
let say that the table (id,language,name,description) where id,language is
the primary key so that 1 id can have several languages
the data in the database looks like this
1'en''blue circle''this is a blue '
1
Steve Meyers wrote:
There are no subselects in MySQL (yet). However, they're usually a bad
idea anyway, which is why it's never been such a big rush to get them in.
Sometimes (just sometimes), there is no way to do it except with a subselect.
For instance, we have a table where we get
Nguyen Trong Phuc wrote:
we can use subselect now with MySQL-Max version.
I think not. I know it failed with 3.23.43, when I tried it just now
(mysqld-max).
Regarding encrypt(), the manual does say that encrypt() returns NULL on
OSes where the crypt() function is not available. True.
Steve Meyers wrote:
The MySQL source is under the GPL. Any fork must also be under the
GPL. You may sell your forked MySQL, but you must also provide the
source code.
Is it really, now?
What are the rules about bundling now? If we distribute a (standalone)
copy of MySQL with our
DownloadFAST.com wrote:
[...] why don't you try PostgreSQL instead?
My understanding is it is much slower.
No kidding? Why don't you fork the PostGreSQL codebase and apply your
special assembly talents to speed it up by 50% or even 60%?
are actually fairly trivial to implement, and I would have
been glad to submit a patch for this, except that the Win32 port of MySQL
needs Visual C++ to compile, which I don't have access to.
Thanks much in advance,
--
Shankar Unni
are actually fairly trivial to implement, and I would have
been glad to submit a patch for this, except that the Win32 port of MySQL
needs Visual C++ to compile, which I don't have access to.
Thanks much in advance,
--
Shankar Unni
Paul DuBois wrote:
At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
I don't believe mysql.exe has ever beeped at me. What are you doing
when it beeps at you?
Whenever there's an
Dana Holt writes:
Can I automatically generate a random, unique, integer value
in a certain range when inserting data into a column using SQL?
Random? Like how random?
* Math.random() random? And still unique? That's really tough..
* Or just you don't care, but not sequential random?
* Or
Steve Meyers wrote:
In a previous message, I failed to mention one of the main reasons you
would NOT want to use a 500-character primary key. MySQL uses a key
buffer to keep as much index information in memory as possible. The
longer the key, the less info it can keep in memory, and
Steve Meyers wrote:
The problem is that he has it as a primary key, so he wants it to be
unique as well as indexed. The best solution (and MUCH MUCH MUCH
more efficient) would be to hash each of the four columns, and create
a primary key on that. Integer keys are much faster and
Oct 2001 14:51:20 -0700
From: Shankar Unni [EMAIL PROTECTED]
Organization: IntruVert Networks, Inc.
To: [EMAIL PROTECTED]
The mysql client program has this feature that if it's run with its
standard input not bound to a TTY, it automatically switches to batch
mode.
Normally, when Emacs runs
complains for all
of these table definitions that Specified key was too long. Max key length
is 500.
--
Shankar Unni.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
NUMBER(8,5). You'll need around 5 digits after the decimal point. (Think GPS
accuracy == 10 meters for high-grade, 100 m for dumbed-down civilian use. At
the equator, that's 0.9 or 0.0009 degrees respectively. At higher
latitudes, that'd be correspondingly less.)
If you value accuracy, DON'T
Mark Stosberg [EMAIL PROTECTED] writes:
Tonu, thanks for the explanation. I still prefer the way Postgres
handles it:
Mark= select * from t where c2 = null;
c1 | c2
---+
1 |
(1 row)
Postgres is incorrect in doing this. At least, it's way non-standard.
NULL is *NOT* a value. It's
Sinisa writes:
- timestamp is saved in datetime format
- first timestamp column is silently updated on each UPDATE
What this means, of course, is that when you want to deal with your own
TIMESTAMP data, you need to maintain some sort of sacrificial column (e.g.
LAST_UPDATED TIMESTAMP) that
closest
approximates the 17-digit number (in this case, rounding it up to
23.5).
(OK, the *real* nitpickers, back off :-). I'm just doing approximate math
here, dredging up ancient memories of life in compiler and CPU-land..)
--
Shankar Unni.
[EMAIL PROTECTED]
Uh, before you take his head off, consider that most people using MySQL are
not in a position to build MySQL themselves (or trust whatever comes out of
"./configure --whatever_options; make").
And the default binary distribution does not include BDB or InnoBase for any
platform (that's coming
stribution, since that seems to be built in a non-standard way
(i.e. instead of using configure, etc., it uses Visual C++ project files,
etc.)
--
Shankar Unni[EMAIL PROTECTED] (408) 434-8311
don't see any major conceptual problems with it. It's free, but needs some
elbow grease to get it to work..
A "tbl" reference is at
http://www.primate.wisc.edu/software/troffcvt/tbl.html.
--
Shankar Unni
[EMAIL PROTECTED]
I don't see implementation of "CHECK" CONSTRAINTS in the TODO list (e.g.
CONSTRAINT val_ck check (val = 0 and val =5)
Is this planned?
I do see FOREIGN KEY constraints on the 4.0 list, so there is a way to do
this kind of checking once this is implemented:
* Create an associated
, will it automatically roll them changes and free the locks
and unblock any other operations waiting on that lock?
Just checking.. Thanks!
--
Shankar Unni[EMAIL PROTECTED] (408) 434-8311
78 matches
Mail list logo