Of course, all engineering is balancing the trade-offs.
The maximum positive value of a BIGINT is 9223372036854775807, which
suggests that it can store any 18 digit value accurately, which perhaps
solves the problem. BIGINT, like DOUBLE, requires 8 bytes storage, so
you are neutral in that regard
I stand corrected.. I thought I recalled that the IEEE for double
precision offered 18 digits of accuracy (been years since I looked at
it) but a little research shows me 15.
- michael dykman
On Wed, 2005-02-02 at 14:02, Roger Baklund wrote:
> Michael Dykman wrote:
> [...]
> > The MySQL impleme
The easiest route is to use mysqldump with the --no-data option. it
will dump the full schema info including feign keys, etc.
-- michael dykman
On Wed, 2005-02-02 at 13:31, Dan Stromberg wrote:
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old w
> -Original Message-
> From: Dathan Pattishall [mailto:[EMAIL PROTECTED]
> Sent: donderdag 3 februari 2005 1:21
> To: Mark; mysql@lists.mysql.com
> Subject: RE: Relationship between 'table_cache' and 'max_connections'
>
> Max_connections relates to table_cache because they both use
> desc
Table_cache is a pool of file descriptors held open, so the over head of
opening table is not necessary since the open is cached.
Max_connections relates to table_cache because they both use
descriptors. Thus at least the sum of the 2 is used by mySQL to set the
ulimit of file descriptors higher
I hope someone can clarify the relationship between 'table_cache' and
'max_connections' (I use MySQL 4.0.23). The manual says:
"table_cache is related to max_connections. For example, for
200 concurrent running connections, you should have a table
cache size of at least 200 * N, where N i
>i'm not sure who the original poster was
I'm Fasani, I work in a spanish telecommunications company on the
statistics department as a DBA/developer. I'm on this list because we
use mysql for the online statistics and I'm always reading this when I
have some free time.
Thanks all who commented on
I had written a windows app using the C api that used
the embedded server for 4.0.18, and it worked fine. Now I am trying to upgrade
to 4.1.9, and it is not working. When I hit the statement mysql_real_connect,
it gpf's. This behaviour is the same as what I experience when I try to run the
I put something out on the general forum. Perhaps I could try the
general list. Thanks for your help.
Joe Garry
Software Engineer
US Biometrics
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 02, 2005 4:09 PM
To: Joe Garry
Cc: [EMAI
Yep, you seem to have a good handle on the authentication issue. Have you
tried compiling a DEBUG version and tracing through the code? Maybe you
can catch the GPF when it happens and figure out what's messing up. Since
it's failing early (during a connection) this should be rather easy to
capt
Always include the list in your responses. It will get you more results
faster than if you have to wait on just me. - Shawn
- Forwarded by Shawn Green/Unimin on 02/02/2005 04:53 PM -
"Ferhat Bingol webmail " <[EMAIL PROTECTED]> wrote on 02/02/2005
03:55:36 PM:
> Hi,
>
> This is a mode
I guess this should be a reminder to everyone that your out of office
replies should not go to mailing lists :)
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
> -Original Message-
> From: Homam S.A. [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 02, 2005 2:56 P
This is the reply I got when I posted the same message
last week. I checked the list for hours and my message
didn't show up. This is why I assumed it never made
it. I have no idea what this auto-reply is saying. I
tried the AltaVista bablefish with Spanish. It was the
closest, but it gave me garbl
"Ferhat Bingol webmail " <[EMAIL PROTECTED]> wrote on 02/02/2005
03:31:00 PM:
> Hi all,
>
> I have case like this.
>
>
> 200312211750 14.65 0 14.65 14.65 6
> 200312211800 118.9 119.41 14.65 697.17
> 200312211810 1324.1 122.6 697.17 1502.3 2
>
> Last field is MOD
This tells the optimizer to do a table scan. If you used INNODB it's
already sorted by the primary key since INNODB supports clustered
indexes. Doing a table scan on innodb is very slow due to it's MVCC
control.
It's going to take a long time.
DVP
Dathan Vance Pattishall http://www.fri
Hi all,
I have case like this.
20031221175014.65 0 14.65 14.65 6
200312211800118.9 119.41 14.65 697.17
2003122118101324.1 122.6 697.17 1502.3 2
Last field is MODE. That case is at the middle of the database. But
these 3 are continues tripel.
When MODE=''
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Homam S.A. [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 02, 2005 11:50 AM
> To: mysql@lists.mysql.com
> Subject: Why does dropping indexes takes such a long time?
>
> I have a non-pr
Homam S.A. wrote:
I have a non-primary-key index on a large MyISAM
table, and dropping the index takes a long time, in
addition to maxing out the CPU utilization in its
final 1/3 interval.
Why is that?
You asked the question last week, and several people answered.
Do you think the answer has chang
Hi,
I have a simple query with an ORDER BY clause, and it's taking forever
to run on this table. I hope i've included all relevent information...it
might just be one of the4 server variables which need adjustment.
the query is
SELECT SubmitId from BINDSubmit ORDER BY SubmitId
SubmitId is the pri
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old webmaster has disappeared, and a new webmaster has been
hired. She needs to know the schema of the database.
>
> So my question is: Is there a way of querying MySQL not for values of
fields, but rat
I have a non-primary-key index on a large MyISAM
table, and dropping the index takes a long time, in
addition to maxing out the CPU utilization in its
final 1/3 interval.
Why is that?
In MS SQL Server for example, dropping the index is
almost instantaeous, unless it's clustered and you
have other
Dan
Please try MYdbPAL for MySQL - www.it-map.com. It is FREE, and you can
reverse-engineer the schema; view, model, forward engineer etc.
Tim Hayes
-Original Message-
From: Dan Stromberg [mailto:[EMAIL PROTECTED]
Sent: 02 February 2005 12:31
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECT
I'd do something like 'mysqldump -d foo'; the -d option only dumps the
table defs.
> -Original Message-
> From: Dan Stromberg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 02, 2005 12:31 PM
> To: mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Subject: Pulling a database schema ou
On Wed, Feb 02, 2005 at 10:55:41AM -0800, Bruce Douglas wrote:
> balazs...
>
> cool... makes sense. then if that's the case, share away how's
> the weather over in fl. i noticed on your site that you guys are fairly
> small, makes for a good environment when getting work done!
One thing I d
Keith Ivey wrote:
Roger Baklund wrote:
Galen wrote:
I've got a huge table going, and it's storing a load of numeric data.
Basically, a percentage or single digit rank, one or two digits
before the decimal and fifteen after, like this:
6.984789027653891
39.484789039053891
[snip]
You should not us
Michael Dykman wrote:
[...]
The MySQL implementation also supports this optional
precision specification, but the precision value is used only to
determine storage size.
Right. This means you can not have 15 decimals precision using DOUBLE:
mysql> use test
Database changed
mysql> create table dtest
Dan Stromberg <[EMAIL PROTECTED]> wrote on 02/02/2005 01:31:17 PM:
>
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old webmaster has disappeared, and a new webmaster has
> been hired. She needs to know the schema of the database.
>
> So my questi
We have implemented a system which uses 'swappable' in-memory data,
binary trees and hashtables to do things like:
o Return 'best' possible route from one person to another based on
weight of relationships between links
o Return 'shortest' possible route from one person to another
o Return total p
balazs...
cool... makes sense. then if that's the case, share away how's the weather
over in fl. i noticed on your site that you guys are fairly small, makes for a
good environment when getting work done!
how does your app compare to ryze or linkedin, regarding the underlying
networking en
If you want to do raw writes to the disk device yes you can. This option is
available with innodb. Search on www.innodb.com it should be in section 15 (or
11 I forgot) of the innodb manual.
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: J
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Bruce Douglas [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 02, 2005 10:20 AM
> To: Dathan Pattishall
> Cc: mysql@lists.mysql.com
> Subject: RE: Social Networking querys
>
> dathan...
>
Roger Baklund wrote:
Galen wrote:
I've got a huge table going, and it's storing a load of numeric data.
Basically, a percentage or single digit rank, one or two digits before
the decimal and fifteen after, like this:
6.984789027653891
39.484789039053891
[snip]
You should not use FLOAT, it is an
You mean "show databases", "show tables" and "describe $table_name" for
every table in the database ?
Balazs
On Wed, Feb 02, 2005 at 10:31:17AM -0800, Dan Stromberg wrote:
>
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old webmaster has disappe
On Wed, Feb 02, 2005 at 10:19:45AM -0800, Bruce Douglas wrote:
> dathan...
>
> given that you work at friendster, aren't you kind of restricted from
> commenting on how one would go about creating/implementing this kind of
> system??
I thought about this too when describing my company's soluti
On Wed, 2005-02-02 at 12:46, Roger Baklund wrote:
> Galen wrote:
> > I've got a huge table going, and it's storing a load of numeric data.
> > Basically, a percentage or single digit rank, one or two digits before
> > the decimal and fifteen after, like this:
> >
> > 6.984789027653891
> > 39.48
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question is: Is there a way of querying MySQL not for values of
fields, but rather for t
dathan...
given that you work at friendster, aren't you kind of restricted from
commenting on how one would go about creating/implementing this kind of system??
if you aren't and you have information to share, then we'd appreciate hearing
it!!!
regards,
bruce
-Original Message-
From
Is it possible to use for example /dev/hdc directly as my innodb
database file? Is it worth?
Thanks,
Joao.
mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: Balazs Rauznitz [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 02, 2005 9:06 AM
> To: listsql listsql
> I work at a social networking company. We store the social
> network as an edge
Matt Babineau wrote:
> Ok I installed PHP 4.3.10 and it still has not fixed the problem. If I
> remove the SQL_CALC_FOUND_ROWS from the query, it works no problems! This
> is
> very strange behavior!
Not really that strange, I think...
While you might want to read this:
http://us4.php.net/manual
nick...
just from curiousity.. is the code that you've alluded to available for public
play. or is it yours/your company's?
thanks
bruce
-Original Message-
From: Nick Arnett <[EMAIL PROTECTED]>
Sent: Feb 2, 2005 9:08 AM
To: listsql listsql <[EMAIL PROTECTED]>
Cc: mysql
Subject: Re: S
Galen wrote:
I've got a huge table going, and it's storing a load of numeric data.
Basically, a percentage or single digit rank, one or two digits before
the decimal and fifteen after, like this:
6.984789027653891
39.484789039053891
What is the most efficient way to store these values? I will be
we're going to need this kind of functionality as we're starting to architect
an app that will be a kind of hybrid between a directory listing and
ryze/linkedin, so we're going to need the ability to do the foaf/node links. we
were actually hoping that someone had already produced a kind of 'ope
On Wed, Feb 02, 2005 at 09:20:28AM -0800, Bruce Douglas wrote:
> hi...
>
> i'm not sure who the original poster was... but, there is also an open source
> app (yogurt) that claims to be used to deal/implement a version of a foaf
> system, much like okurt/google. i'm not sure how the underlying '
During a lengthy stint at a major provider of financial data, I came
across this concept generic modelling.. The idea was to have one tables
of 'things' and a second one of 'relationships'.. In concept, it's a
very powerful and elegant idea, but it tends to be recursion-heavy.
Depending on what
hi...
i'm not sure who the original poster was... but, there is also an open source
app (yogurt) that claims to be used to deal/implement a version of a foaf
system, much like okurt/google. i'm not sure how the underlying 'special sauce'
is implemented, but it might be worth checking out...
le
Peter Brawley wrote:
is, there is some method to iterate in this relation to avoid joining
the table in itself each time ?
Exactly the problem with trying to model an anything-goes network, a
"world of ends", in a relational model of a directed graph. I think
you need an XML layer in there, eg
listsql listsql wrote:
Since I read about Foaf [ http://www.foaf-project.org/ ], I become
interested with Social Networking,
What you're doing is often called link analysis -- searches on that term
may yield more for you to chew on. There are software tools and
visualization tools for answerin
On Wed, Feb 02, 2005 at 04:47:31PM +0100, listsql listsql wrote:
> Since I read about Foaf [ http://www.foaf-project.org/ ], I become
> interested with Social Networking, and readed a lot about it.
> I 've been playing as well with mysql and join querys to represent
> network's of people. As I made
is, there is some method to iterate in this relation
to avoid joining the table in itself each time ?
Exactly the problem with trying to model an anything-goes network, a
"world of ends", in a relational model of a directed graph. I think you
need an XML layer in there, eg see
http://iswc2004.s
Since I read about Foaf [ http://www.foaf-project.org/ ], I become
interested with Social Networking, and readed a lot about it.
I 've been playing as well with mysql and join querys to represent
network's of people. As I made some queries in google and didn't came
with a lot interesting info about
> > I am trying to connect to my mysql server through an SSH tunnel.
> > On the server, I have a local instance of mysql running, but one of the
> > hosted domains needs to access another remote mysql server. For security,
> > I want to connect to the remote server via an ssh tunnel.
> > I am crea
Hi folks,
Been doing a lot of noodlin' and googlin' yesterday and today, and
thought I found the problem... but alas!
To recap:
I just installed MySQL 5 on a freshly updated FC3 box. I initially was
getting this error:
[EMAIL PROTECTED] ~] /usr/bin/mysqld_safe
Starting mysqld daemon with databa
On Wednesday 02 February 2005 15:39, Richard Curtis wrote:
> I am trying to connect to my mysql server through an SSH tunnel.
> On the server, I have a local instance of mysql running, but one of the
> hosted domains needs to access another remote mysql server. For security,
> I want to connect to
> I am trying to connect to my mysql server through an SSH tunnel.
> On the server, I have a local instance of mysql running, but
> one of the hosted
> domains needs to access another remote mysql server. For
> security, I want to
> connect to the remote server via an ssh tunnel.
> I am creating
Richard Curtis wrote:
I am trying to connect to my mysql server through an SSH tunnel.
On the server, I have a local instance of mysql running, but one of the hosted
domains needs to access another remote mysql server. For security, I want to
connect to the remote server via an ssh tunnel.
I am cr
matt_lists <[EMAIL PROTECTED]> wrote on 02/02/2005 08:50:16 AM:
> Jay Blanchard wrote:
>
> >[snip]
> >
> >
> >>>No, it isn't ignored...it just returns a FALSE for the IN statement
> >>>
> >>>
> >[/snip]
> >
> >More info
> >
> >"The word IN is an alias for = ANY. Thus these two statements a
I am trying to connect to my mysql server through an SSH tunnel.
On the server, I have a local instance of mysql running, but one of the hosted
domains needs to access another remote mysql server. For security, I want to
connect to the remote server via an ssh tunnel.
I am creating the tunnel usin
Hi,
I'm running quite a large database - mostly inserts (4-5 million rows a day)
and an occasional select to generate some report based on the inserted data
which works very well.
Once a month I need to generate a larger number of reports. The SELECT queries
are optimized quite well but some of
> Is there any documentation where I can find a list of
> all connection related error/error codes returned by
> MySQL?
OS error codes :
http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html
Server error messages :
http://dev.mysql.com/doc/mysql/en/error-handling.html
---
Tom Crimm
Hello,
Is there any documentation where I can find a list of
all connection related error/error codes returned by
MySQL?
Regards,
Karam
__
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
MySQL General Mai
On Wednesday 02 February 2005 14:11, Michael Satterwhite might have typed:
> mysqldump backs all of the tables up in alphabetic order, including the
> table create statements. The problem is that if foreign keys exist on
> the tables, the reload will not work unless the backup file is hand
> edited
And
max_allowed_packet = 16776192
David
Hi,
my interactive_timeout variable is
interactive_timeout 3600
Thanks !
David
Hello.
I've asked you about interactive_timeout, not wait_timeout.
Mark <[EMAIL PROTECTED]> wrote:
>> -Original Message-
>> From: Gl
mysqldump backs all of the tables up in alphabetic order, including the
table create statements. The problem is that if foreign keys exist on
the tables, the reload will not work unless the backup file is hand
edited to insure that tables depended upon are created first. Is there a
way around t
Hi,
my interactive_timeout variable is
interactive_timeout 3600
Thanks !
David
Hello.
I've asked you about interactive_timeout, not wait_timeout.
Mark <[EMAIL PROTECTED]> wrote:
>> -Original Message-
>> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
>
>> Sent: w
Jay Blanchard wrote:
[snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
[/snip]
More info
"The word IN is an alias for = ANY. Thus these two statements are the
same:
SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2);
SELECT s1 FROM t1 WHERE s1 IN(SELE
Hello.
I've asked you about interactive_timeout, not wait_timeout.
Mark <[EMAIL PROTECTED]> wrote:
>> -Original Message-
>> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
>> Sent: woensdag 2 februari 2005 12:46
>> To: mysql@lists.mysql.com
>> Subject: Re: help please : ERROR 2
mysql，您好！
when click mysql.exe on $home\bin ,the report err is
"D:\Program Files\mysql\bin>mysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) "
please help me
致
礼！
zhanghjun
[EMAIL PROTECTED]
2005-02-0
I know it's not quite the same, but I recently upgraded 2 FC2 boxes
from MySQL3.23.xx to MySQL4.0.23 simply by using (as Gleb suggested) :
rpm -U mysql*
I had downloaded the following rpm files from the MySQL site :
Linux x86 RPM downloads
---
Server
Thanks for your reply,
I have a query where I select all table names where the table name has PID_1
in i.e.
SHOW TABLES LIKE '%PID_1%';
However there may be cases where I need to search for tables where the table
name is PID_1 or PID_2. Do you another way I might be able to do this?
From: "Gabriel
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: woensdag 2 februari 2005 12:46
> To: mysql@lists.mysql.com
> Subject: Re: help please : ERROR 2006: MySQL server has gone away
>
> Hello.
>
> What's the value of the interactive_timeout system variable? See:
>
Because it does not know REGEXP... only LIKE patterns...
% Matches any number of characters, even zero characters
_ Matches exactly one character
Taake a look in chapter 13 "String Comparison Functions".
Gabriel PREDA
- Original Message -
From: "shaun thornburgh" <[E
Hello.
Not enough information to make a conclusion. Please, send us
information about MySQL and operating system versions, contents
of your configuration file, output of the following statements:
show processlist;
show variables;
show status;
Log the slow queries. See:
http://d
Hello.
What's the value of the interactive_timeout system variable? See:
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
http://dev.mysql.com/doc/mysql/en/gone-away.html
"Marois, David" <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: iso-8859-1, 19
Hello.
> the Add/Remove Packages (and the manual RPM command) both failed on
> multiple dependencies,
rpm has --force and --nodeps flags and you can
use -U instead of -i. See:
man rpm
> little fingers and tried removing all the MySQL files manually. I think
> I got them all except th
Hi,
The syntax for show tables from the manual is:
SHOW [FULL|OPEN] TABLES [FROM db_name] [LIKE 'pattern']
so whay doesnt the following query work:
SHOW TABLES LIKE REGEXP 'PID_[0-9]+';
Thanks for your help
Shaun
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
050201 02:54:05 mysqld started
050201 2:54:05 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operati
Hi!
I'm looking for the syntax diagram for MySQL and can't find it. I have
downloaded the entire MySQL manual as one html page and searched it for the
definition of where_definition and I cant find it. Could somebody please
point me to a location where the complete syntax diagram can be found?
/T
MySql 4.0.14
We tried to convert MyISAM table format to INNODB
format, it took forever to finish the process, someone
intervened and killed the process through Task
Manager.
Now can't run Mysqld-nt, running it with the --console
reports the followings. Your help is appreciated.
Microsoft Window
You could use
DECIMAL(17,15) - but it will take you 17+2bytes per record...
but you could split the number in 2 parts
before the DOT . because you have 2 number use TINYINT- takes 1 byte
BIGINT - takes 8 bytes
So
A quick look at the PHP site...
http://www.php.net/manual/en/faq.databases.php#faq.databases.upgraded
Regards, Jigal.
- Original Message -
From: "Matt Babineau" <[EMAIL PROTECTED]>
To: "'MySQL General'"
Sent: Tuesday, February 01, 2005 9:20 PM
Subject: Problem with SELECT SQL_CALC_FOUN
81 matches
Mail list logo
