Use a 48-to 64 bit int. When you print or
calculate, divide by 10^12. It's called fixed-point arithmetic.
-steve
P.S.
Ignore the funny guy talking about the commas, he's never been
outside his country.
-Original Message-
From: Vasoczki Ferenc [mailto:[EMAIL PROTECTED]]
Sent:
I'd buy it!
-steve
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 7:23 PM
To: [EMAIL PROTECTED]
Subject: Really good idea on Performance Tuning???
I sent a reply back to JW about his problem on performance tuning and came
up with I thought a
What is the best source of information about
performance tuning MySQL? I saw that Jeremy's proposed
book was to include a lot of coverage on this topic --
are there other sources? Is the online doc the best
place so far?
--- Mike Wexler [EMAIL PROTECTED] wrote:
I don't think this will work.
At 12:22 PM 1/30/2002 -0600, you wrote:
I sent a reply back to JW about his problem on performance tuning and came up with I
thought a really good idea. But there weren't any bites so I thought I start it on a
new thread.
I'd like to point out that I'm pretty sure you sent the reply to me
At 02:34 PM 1/30/2002 -0600, Emily Kelley wrote:
In the process of searching for a dynamic database solution for a work
project I have just begun reading about MySQL. So far this looks like a
very promising choice for us but I have one extremely basic question that I
hope someone will kindly
Egor Egorov ([EMAIL PROTECTED]) writes:
Ed,
Monday, January 28, 2002, 11:26:44 PM, you wrote:
EC Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on
EC a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the
EC box, mysql will start, but
The manual is really a wonderful read - anyway:
char() 255 bytes
varchar() 255 bytes
text() 65535 bytes
-Original Message-
From: Emily Kelley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject:
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: mutiple-column index and sorting (DESC)
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
William,
What should be understood is that MySQL's implementation of AUTO_INCREMENT
requires a particular/different
philosophical view: that first the 'primary row' is to be stored, then the
AUTO_INCREMENT data captured, and
finally the dependent row is stored (in the second table) - a
P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote
MySQL and Perl for the Web?
Just wondering.
I believe so, yes.
=but he tends to hide/blend into the woodwork!?
=dn
-
Before posting, please check:
Hi. Resubmitting a post...
Basically, my question is if you have defined an INT NOT NULL AUTO_INCREMENT id field
in a table,
and you want to load a data file into the table using the LOAD DATA INFILE command,
must you also
put the ids in the data file? Thanks.
Eurico
Oh I see.
Since I really need this DESC badly, is it sensible to
add a 3rd column that keeps its values in reverse
order(say, SomeBigInt - value of col2) ? Then create
an index on (col1,col3) and use it without the DESC.
The website does about 10 times more reading than
updating the table. There
Hi!
Heikki == Heikki Tuuri [EMAIL PROTECTED] writes:
Heikki Hi!
Heikki This is a bug in the MySQL layer of code. I am sending a carbon copy of this
Heikki email to Monty.
cut
I am using Mysql 4.0.1 alpha for Windows, my table are all on InnoDB, when
I connect
to
mysql server using C API
On Wed, 30 Jan 2002, Eurico de Sousa wrote:
Date: Wed, 30 Jan 2002 16:56:24 -0500
From: Eurico de Sousa [EMAIL PROTECTED]
To: mysql post [EMAIL PROTECTED]
Subject: Re: Batch load of data problems
Hi. Resubmitting a post...
Basically, my question is if you have defined an INT NOT NULL
On Thu, 31 Jan 2002, DL Neil wrote:
Date: Thu, 31 Jan 2002 21:28:04 -
From: DL Neil [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: next insert id (slightly OT)
William,
What should be understood is that MySQL's implementation of
Hi Steve,
On Thu, 2002-01-31 at 06:35, Steve Rapaport wrote:
I'd buy it!
That is possible too:
- MySQL Training (http://www.mysql.com/training/)
- MySQL Support (http://www.mysql.com/support/)
- MySQL Consulting (http://www.mysql.com/consulting/)
See, the manual and sample cnf files
Hi,
I try to link ACCESS 97 to MySQL (3.23.43-max-nt), both on a Windows2000
Service Pack 2 Intel PC (Toshiba Satellite) with MyODBC.
It is working fine but for some tables ACCESS show their contents correct
in the beginning and after half a minute an ODBC ERROR occurs:
ODBC call failed
and
That is possible too:
- MySQL Training (http://www.mysql.com/training/)
- MySQL Support (http://www.mysql.com/support/)
- MySQL Consulting (http://www.mysql.com/consulting/)
However, it will never be a substitute for manual tuning. Good database
performance more than simply the result of a
Hi all,
I've been looking at the performance of mysql using innodb tables and I've
noticed that I can get a huge benifit by setting
innodb_flush_log_at_trx_commit = 0. The documentation warns me that I can
loose a couple of seconds of transactions in system crash if I do this.
It seems like a
On Wed, Jan 30, 2002 at 03:06:36PM -0800, Joseph Drozdik wrote:
Hi all,
I've been looking at the performance of mysql using innodb tables
and I've noticed that I can get a huge benifit by setting
innodb_flush_log_at_trx_commit = 0. The documentation warns me that
I can loose a couple of
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: about innodb_flush_log_at_trx_commit
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
I downloaded a precompiled version of MySQL 4 for Linux and I'd like
to try it out. Anyone had success getting both running? What did you
have to edit in the startup and config scripts?
TIA
-
Before posting, please check:
At 18:21 -0500 1/30/02, Lee, Andrew wrote:
I downloaded a precompiled version of MySQL 4 for Linux and I'd like
to try it out. Anyone had success getting both running? What did you
have to edit in the startup and config scripts?
I used different settings for the following configure options:
Hello,
do you have a procmail recipe which will catch ALL the messages to
this list and put them in one folder? Even CCs, reply's, whatever?
I follow several lists, and this is one of the only two that I
can't come up with a working recipe for.
TIA
mweb
data,
On Wed, Jan 30, 2002 at 06:21:29PM -0500, Lee, Andrew wrote:
I downloaded a precompiled version of MySQL 4 for Linux and I'd like
to try it out. Anyone had success getting both running?
Yes.
What did you have to edit in the startup and config scripts?
Used different port numbers and
On Thu, Jan 31, 2002 at 12:33:28AM +0100, Marco Fioretti wrote:
do you have a procmail recipe which will catch ALL the messages to
this list and put them in one folder? Even CCs, reply's, whatever?
I follow several lists, and this is one of the only two that I
can't come up with a
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: OT: procmail recipe for this list?
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
Hi all,
I've just upgraded from a tarball MySQL (3.23.33) to an RPM (MySQL
3.23.47-1).
Along the way, somewhere, MySQL seems to have lost it's ability operate as a
transaction server!
I know this as I use Zope to connect to MySQL, and it's now giving me the
following error:
Error Type:
Title: ³×À̹ö ¸ÞÀÏ
È«¼øÅ (javahong) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: Anyone running MySQL 4 and MySQL 3.23 on the same box?
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã
On Thu, Jan 31, 2002 at 12:06:52AM -, Greg Conway wrote:
I've just upgraded from a tarball MySQL (3.23.33) to an RPM (MySQL
3.23.47-1).
Along the way, somewhere, MySQL seems to have lost it's ability
operate as a transaction server!
I know this as I use Zope to connect to MySQL,
Hello, everybody:
I have updated the filter on this list again to adjust for the new kind of
spam we've been getting. Two things I've changed are:
* fixed bug that did not ban attachments if Multipart was captilized - this
should stop the naver.com flood
* reduced the good words list to
I ask this here because it seems this topic is not covered in any faq (or
I don't find it):
Is it possible to have mysql listening in 2 unix sockets (diferent path)
at the same time ?
I use postfix, and the socket should be in a specific directory inside
/var/spool/postfix, but at the same
Hi folks,
Having MyODBC Woes, and just cant get it working with
unixODBC (odbc datasource manager). So far I have
tried building it using the
./configure --with-unix)DBC=/usr/local
--with-mysql-sources=/usr/loacal/mysql
I have aslo installed the rpms as well and can they do
not work. Have used
On Wed, Jan 30, 2002 at 10:05:39PM +, peaw peaw wrote:
Oh I see.
Since I really need this DESC badly, is it sensible to add a 3rd
column that keeps its values in reverse order(say, SomeBigInt -
value of col2) ? Then create an index on (col1,col3) and use it
without the DESC.
Yes, that
On Wed, Jan 30, 2002 at 10:35:21AM -0500, Keith C. Ivey wrote:
We're currently using MyISAM tables for everything. Are there
circumstances in which the InnoDB table type would be better even if
we're not going to use commit/rollback, or are transactions the only
advantage of InnoDB?
At 1:05 + 1/31/02, Julián Muñoz Domínguez wrote:
I ask this here because it seems this topic is not covered in any faq (or
I don't find it):
Is it possible to have mysql listening in 2 unix sockets (diferent path)
at the same time ?
I use postfix, and the socket should be in a specific
For folks that are having trouble with clean shutdown on OS X, try using
mysqladmin -u root -ppw flush-tables
before shutting down mysql.
I hadn't had a shutdown problem in a week then this evening I got the
dreaded pid file hang at shutdown and had to use kill -9.
The only thing I did
Wow! thanks for the responses!
Here is what I think you are mostly asking for... I have run mysqladmin
variables to get this.
Regards,
Greg.
+-+-
In the last episode (Jan 30), Jeremy Zawodny said:
On Wed, Jan 30, 2002 at 08:11:53PM -0600, j.urban wrote:
I've had good results with the following as well:
:0
* ^List-ID: mysql.mysql.com
mysql-list
That will miss replies which are sent to the list an CC'd to you.
The list copy
I found out why my LOAD DATA INFILE did not work.
The editor I was using translated the tabs I entered to spaces. That's why my load
data infile didn't work!
I used the following command to load the data successfully:
load data infile test.dat replace into table persons fields terminated by '
Below I have two queries. They both should do the same thing but the foreign
key syntax is a little different. The first query fails, though some queries
with foreign key clauses work sometimes, and the second one just works.
Am I right in thinking the syntax for both these queries mean the same
Try this:
select key_col, min(name), max(date_col)
from my_table
group by key_col ;
You could use max(name) instead of min(name) also, although
since the names can be misspelled, I don't see why it would matter
which name is displayed.
s.s.
On Wed, 30 Jan 2002
Hi all there,
I am a fresher to mysql.
I want to know how to create a table with an autoincrement field in that
along with a name field with the varchar datatype.
Thank you.
Regards,
Charitha.
-
Before posting, please
Check out:
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
Gurhan
-Original Message-
From: Charitha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 10:51 PM
To: [EMAIL PROTECTED]
Subject: Help me to create a table with autoincrementing field
Hi all there,
I am a
I appear to be having an error with the following update that I am
submitting to my database. I am using mysql's DATE_FORMAT function to pull
the date out and insert in a user friendly form. Upon submission of the
modified data, I use the below SQL to update the table information.
Everything is
Dear MySQL community,
I am new MySQL user. I want to migrate a M$ SQL Server
database to MySQL in a Linux box. Since table names in
MySQL@Linux is case sensitive, I am having troubles
connecting to the server via ODBC from a Windows box.
I search the documentation and find that I may be able
to
Linux for PS2 is being released in Europe in May this year:
http://www.scee.com/corporate/pressreleases.jhtml
Who's going to be the first to get MySQL to compile on PS2. ;-)
~mark.
-
Before posting, please check:
Hi all,
My Database on Linix. Can I establish a ADO Connection to work with PHP and
MySQL on Linux.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I think a better question would be why ;-)
It's not that I don't love my PS2 I just don't see it as a very good
database machine you know ;-)
Mark Maunder wrote:
Linux for PS2 is being released in Europe in May this year:
http://www.scee.com/corporate/pressreleases.jhtml
Who's going to
hi,
I have run the script mysql_install_db --with-innodb. then I am getting
the
mysqlshow variables like have_innodb;
+---+---+
| Variable_name | Value |
+---+---+
| have_innodb | YES |
+---+---+
Hi,
i am developing a software on linux platform and Mysql Ver 11.13 Distrib
3.23.36, for redhat-linux-gnu (i386) as the backend and i would like to know
if MySQL( any version like previous one or the latest version), either of
versions supports STORED PROCEDURE, TRIGGERS and also VIEWS? if it
What would I do if there are InnoDB tables ?
--
Dimitry
Wednesday, January 30, 2002, 9:31:09 PM, Paul DuBois wrote:
At 11:10 -0800 1/30/02, JC wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm kind of interested to find if there is a way to rename a database
with something like the
101 - 152 of 152 matches
Mail list logo
