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, tha
[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 th
[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', ...)
you do
INSERT INTO Table1 (...)
SELECT 'val1', 'val2', 'val3',
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 literal
[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 sta
[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, a
[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 n
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 DA
[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.9
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
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
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.
-
Bef
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 wi
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
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
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
(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 >= '20020201
[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 peo
>>alias mysql='mysql -u root -p"big_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:
http://www.mysql.com
Dennis Wu wrote:
> I have a table with a column defined as BLOB. However, when I dump
> this table using ./mysqldump, the dump file cannot be imported. Is
> that because a binary field cannot be dumped into a text file? Any
> solution if I really need to do the backup by dumping the table?
W
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 http://bugzilla.redhat.com/bugzilla/> for instructions.
So? Do what that says: go to ht
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
[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 lar
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
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
Venu wrote:
> Its possible with MyODBC Drivers to 'n' size. You can
> supply BLOB/CLOB data in pieces to desired size by
> making use of SQLParamData and SQLPutData APIs.
Does the MySQL wire protocol support this? Or is MyODBC emulating this by
reading and updating the entire blob after each p
[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 lar
[ 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
>
[ 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 o
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 ]
-
[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
[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.
--
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 ra
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 othe
Jim Lucas [jimmysql] wrote:
> But I am installing all the apps from the RPM's that came from Redhat.com
> and Mysql.com and with the Redhat CD. Now shouldn't these all work
> together?
Reasonable people would expect that, yes, but evidently the folks at Redhat
are not talking to the folks at
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
[ 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
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
proced
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 di
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 co
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 (
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 wind
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
htt
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 v
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 sys
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 IEEE75
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 a
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.s
> 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 (ha
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 th
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
ay Gabor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 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,
anywa
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
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 blu
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 de
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. Howe
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 re
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%"?
---
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 pro
David Ayliffe wrote:
> As subject what do I do if I want a field called (for example)
> Competition ID?
> I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
> avail.
> I have tried enclosing it in "quotes" and 'single quotes' but neither
> work. Can this be done?
I beli
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
no-silent",
etc. It's enough to implement these as long-form-only.
These changes 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
no-silent",
etc. It's enough to implement these as long-form-only.
These changes 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
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" "rando
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
e: Sat, 20 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.
Normal
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 me
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
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 v
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
> Believe me they knew what they where doing when they
> choose not to implement this.
"I'm glad I live in rags - thank goodness I don't have to worry about
washing my clothes!!".
Enforcing foreign keys in your application can be pretty darn expensive, and
painful:
* You have to have a way of
Though really, this shouldn't be done in this way at all (i.e. having to
rebuild mysql with some flag that has unknown potential other effects..)
It's OK to implement it in such a way that columns with not-NULL constraints
automatically get some default. What's wrong is in hard-coding an error if
The RPMs on the MySQL site don't seem to match RedHat's RPM layout at all -
the RedHat RPM can't be "upgraded" to the MySQL RPM (even the package names
are different - "mysql" in RedHat vs "MySQL" in the MySQL package).
The only thing you can do is:
* rpm -e `rpm -q -a | grep mysql`
* rpm --inst
umber has 17 digits, so
the string-to-number converter tries to get the 16-digit number 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 soo
ry distribution, 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
ng used tbl in the past, I
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 "range-c
lding locks, 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
85 matches
Mail list logo