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' mysql@lists.mysql.com
Sent: Tuesday, February 01, 2005 9:20 PM
Subject: Problem with
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
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
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?
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
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
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 the
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.
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:
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 [EMAIL
-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:
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
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
mysql
when click mysql.exe on $home\bin ,the report err is
D:\Program Files\mysql\binmysql
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
please help me
zhanghjun
[EMAIL PROTECTED]
2005-02-02
--
MySQL General Mailing List
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 2006: MySQL
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
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: woensdag
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
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: Gleb
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 to
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
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
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
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
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 are the
same:
SELECT s1 FROM
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
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
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
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
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
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
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
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
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
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
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...
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
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
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
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
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
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
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]
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-
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
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
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 solution
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 disappeared, and
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
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...
given
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:
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
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
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 question is:
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
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
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
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 out of
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
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
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
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
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
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
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
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
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 MODE. That case
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
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 PM
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
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
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:
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'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 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
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
-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
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
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
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
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:
81 matches
Mail list logo