Stephen A. Cochran Lists wrote:
I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
The list is typically the way to order a string.
You are most likely to get meaningful suggestions to solve the mystery
if you include the table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 26 Sep 2005, Alex S Moore wrote:
> Has the md5sum been updated for the tarball (tar.gz) download?
>
> I tried two sites and got the same size file, i.e,. 19209618 bytes, but the
> md5sum does not agree.
Yes, the MD5 checksum and the GPG
Hi,
I guess it is a stupid simple question:
I have seen the following error in the log files:
DBI connect('database=[database]','[username]',...) failed: #08004Too many
connections at /[path_to_script] line 12
I have taken a look in my.cnf but I couldn't find some settings for
increasing the po
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 23 Sep 2005, Jasper Bryant-Greene wrote:
> Thing is, even though I get that error, the server keeps running and
> accepting other connections and responding to queries fine.
Probably because the mysqld_safe wrapper script has restarted i
[quote]
Linux
The Linux release is not available right now but we are already
working on the port.
[/quote]
raz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jason Ferguson wrote:
> The data is split into about 60 files, average file size of 5 MB (varying
> from 1 to 10 MB). Since there are many files, I'm trying to minimize the
> required work (if there was just one consolidated file, no problem).
>
> Jason
Hi Jason
If it's not too late (aren't tim
Hi Sandhya,
Have you checked the permissions? The error message is System error: 13
= Permission denied. Is your PHP/Apache user able to connect via the
socket? Try connecting as
$ su -c "mysql -u -p"
and see what happens.
Regards
David Logan
Database Administrator
HP Managed Services
1
Hello,
I have recently installed FC3 and now I have
PHP(4.4.9) and MYSQL(3.23) which got installed along
with FC3.
I'm able to connect to MYSQL from command prompt.
But the problem fires when I do the same from a PHP
script. The error I get is "Can't connect to local
MySQL server through socket
'
I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
1
10
11
12
13
14
15
2
3
4
5
6
7
8
9
I'm sure this is a simple one, but I haven't found an answer in the
archives.
Thanks,
Steve
--
MySQL General Mailing List
For list archiv
I have replication set up. Is it OK to alter one of the slaves and add
several indexes ? It did seem to work, but I'd like to be sure.
Thanks,
Balazs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Then you are in for quite a lot of editing work. I've done it a lot
myself. Don't expect your project to be easy. Look for automated ways to
edit the data according to your needs and the actual table structure.
Bob Cochran
Jason Ferguson wrote:
The data is split into about 60 files, average
You'll have to edit your input file. There will always be instances
where some field is quirky and you need to fix it/them/entire rows.
Don't expect the input file to be perfect.
I'd also suggest that you have a test database on a test machine that is
devoted entirely to getting your tables se
The data is split into about 60 files, average file size of 5 MB (varying
from 1 to 10 MB). Since there are many files, I'm trying to minimize the
required work (if there was just one consolidated file, no problem).
Jason
On 9/26/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
>
> Jason Fergu
Jason Ferguson wrote:
Many thanks for the earlier response to why LOAD DATA INFILE wasnt working
for me. However, another problem has appeared.
In the file I am reading, 2 of the fields are SUPPOSED to be float values.
However, in several places, they are set to "UNKNOWN". This seems to cause
LO
Many thanks for the earlier response to why LOAD DATA INFILE wasnt working
for me. However, another problem has appeared.
In the file I am reading, 2 of the fields are SUPPOSED to be float values.
However, in several places, they are set to "UNKNOWN". This seems to cause
LOAD to abort.
Is there a
Is there any doc looking at benchmarks of a database which is populated
entirely with fixed length char compared to variable character lengths?
I know using char is preferred over varchar when it comes to speed. Is
there any available benchmarks available?
Pointers where would be appreciated.
--
On Monday, 26 September 2005 at 9:29:32 +0200, mark carson wrote:
> Joeffrey Betita wrote:
>> hi
>> do you have any idea why the mysql process is 99.9 percent? when i click
>> one hyperlink it takes more than 1 minute to load the page. thank you very
>> much.
>
> Most readers in this list expect
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:
> Jasper Bryant-Greene wrote:
>> I have a stored procedure defined as follows:
>>
>> ...
>>
>> Sometimes when I execute this stored procedure ... I get the error
>> "Lost connection to MySQL server during query".
>>
>> I
In the last episode (Sep 26), Kishore Jalleda said:
> I know there was an earlier post regarding "sort aborted" error
> after upgrading to 4.1.14 from 4.0.xxx, I am getting this error too,
> and it never occured to me before, I found out the query which is
> doing this,
>
> mysql error: Error wr
Okay, now I get it. I was using the 4.1 series. Looks like an upgrade is in
order.
Jason
On 9/26/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
>
> Robert L Cochran wrote:
> > http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
>
> There's a lot to read there for one small paragraph, s
I've been over that page before posting, with no luck. It might be an
obvious error in syntax, but I can't figure it out.
Jason
On 9/26/05, Robert L Cochran <[EMAIL PROTECTED]> wrote:
>
> http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
>
> Bob Cochran
>
>
> Jason Ferguson wrote:
>
> >I
Robert L Cochran wrote:
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
There's a lot to read there for one small paragraph, so from the above link:
"Before MySQL 5.0.3, the column list must contain only names of columns
in the table being loaded, and the SET clause is not supporte
http://mirror.tomato.it/mysql/doc/mysql/en/load-data.html
Bob Cochran
Jason Ferguson wrote:
I am attempting to import a large file with data in this format:
1923158|GA|1996 Olympic Yachting
Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|-
81.08389Savannah
With this command:
I am attempting to import a large file with data in this format:
1923158|GA|1996 Olympic Yachting
Cauldron|park|Chatham|13|051 |320446N|0810502W|32.07944|-
81.08389Savannah
With this command:
LOAD DATA LOCAL INFILE 'C:\\PHP\\FL_DECI.txt'
INTO TABLE locations2
FIELDS TERMINATED BY '|'
LINE
Jasper Bryant-Greene wrote:
No way. You should *never* use floating-point types for currency if
you care about precision. You'll experience all sorts of weird
rounding and comparison errors. See [1] for more information.
DECIMAL would suit your needs better -- from [2]: "The DECIMAL and
NUME
Chris,
>What's a good (or best) field type for money or
>currency data. Mysql doesn't have a MONEY type for
>structure, so what would I have the best luck with?
Someone suggested double, but with big sums that can give you rounding
errors. Try DECIMAL.
PB
--
No virus found in this outg
Daniel Kasak wrote:
Chris Ripley wrote:
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
double
No way. You should *never* use floating-point types for currency if you
care about precisi
Chris Ripley wrote:
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
double
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
Thanks,
Chris
Chris Ripley
[EMAIL PROTECTED]
KOZE Radio
__
Yahoo! Mail - PC Magazine Editors'
Raz wrote:
Dan,
The download pages are not set up yet, so try the below ftp link:
ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-noinstall-1.0.2-alpha-win32.zip
ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-noinstall-1.0.2-alpha-win32.zip.md5
The ftp site doesn't allow dir
Lenz Grimmer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 5.0.13, a new version of the popular Open Source Database Management
System, has been released. The Community Edition is now available in source
and binary form for a number of platforms from our download pages at
http:
Sujay Koduri wrote:
we are converting our oracle DB to MySQL DB. One problem i see is that the
abg row length in MySQL is much higher compared to that of Oracle. In
oracle it is around 180 bytes and in MySQL it is around 686 bytes. So as a
result, MySQL is taking more space to store the same numb
Hi All,
I know there was an earlier post regarding "sort aborted" error after
upgrading to 4.1.14 from 4.0.xxx, I am getting this error too, and it never
occured to me before, I found out the query which is doing this,
SELECT * FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (delet
Jeff wrote:
Each row in the table takes around 600 bytes, taking every
thing into consideration and assuming every field is used to
its maximum bytes. But the major portion of this 600 bytes
are composed of varchar's (100 + 150 + 50 + 16 + 50 + 20 +
9..) Out of these 400 bytes we generally use
I did check the binlog and saw that the command ran along with the
timestamp. Is there a way to figure out who ran the command?
[EMAIL PROTECTED] wrote:
Clyde Lewis <[EMAIL PROTECTED]> wrote on 09/26/2005 02:44:40 PM:
Guys,
Our production database had a table that was suddently dropped "
Hi,
2005/9/26, Peter Brawley <[EMAIL PROTECTED]>:
> Claire,
>
> >I want to check if a column exists in a table before I
> >do an alter table to add it. How do I do this in
> >mysql? Thanks.
other solution, do your query in all case and check for the return
error (if any).
mysql> alter table
Jim McAtee wrote:
Is this a "release candidate" as the version in your message subject
would imply, or is it an actual "release", as your message states? Or
does MySQL AB even bother to differentiate the two?
- Original Message - From: "Lenz Grimmer" <[EMAIL PROTECTED]>
To: <[EMAIL PR
Clyde Lewis <[EMAIL PROTECTED]> wrote on 09/26/2005 02:44:40 PM:
> Guys,
>
> Our production database had a table that was suddently dropped "a
> mystery". I need to find out if there is a way to find the user account
> that performed this function. No one is taking ownership and I need to
>
Hey all,
Any one with any experience with using solid state disks and or ram
disks to store mysql data/tmp directoies/logs? How much performance
gain do you think I would see? We have a very high write/read database
using myisam tables. We are unable to migrate to other table types
because of co
Was this not clear enough or did you fail to read the entire message? Just
curious.
"This is the first published release candidate (previously known as "gamma
release") in the 5.0 series. All attention will continue to be focused on
fixing bugs and stabilizing 5.0 for the upcoming production
Scott Hamm <[EMAIL PROTECTED]> wrote on 09/26/2005 02:21:38 PM:
> > On 9/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> > Scott Hamm <[EMAIL PROTECTED]> wrote on 09/26/2005 01:59:52 PM:
> >
> > > How do I set Index to enforce that ONLY 1 QAID can own that order
number,
> > > but
"release candidate" is just an alias for 'gamma version' of the s/w released
from MySQL AB. What he said is that MySQL first gamma version has been
released in the 5.0 series. Till now it is in beta phase.
sujay
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Tuesday
Is this a "release candidate" as the version in your message subject would
imply, or is it an actual "release", as your message states? Or does
MySQL AB even bother to differentiate the two?
- Original Message -
From: "Lenz Grimmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: ;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 5.0.13, a new version of the popular Open Source Database Management
System, has been released. The Community Edition is now available in source
and binary form for a number of platforms from our download pages at
http://dev.mysql.com/downlo
Guys,
Our production database had a table that was suddently dropped "a
mystery". I need to find out if there is a way to find the user account
that performed this function. No one is taking ownership and I need to
know if there is a way to find out.
Thanks in advance
--
MySQL General Mai
bruce wrote:
hi...
i've got a question/problem that i can't seem to figure out. it should be
simple/straightforward.
i'm creating a test tbl
id int
t1 timestamp
when i do a 'select * from tbl' i get what looks like a default date/time
format in the timestamp column.
i do a, (from mysql)
'ins
hi...
i've got a question/problem that i can't seem to figure out. it should be
simple/straightforward.
i'm creating a test tbl
id int
t1 timestamp
when i do a 'select * from tbl' i get what looks like a default date/time
format in the timestamp column.
i do a, (from mysql)
'insert into tbl
Scott Hamm <[EMAIL PROTECTED]> wrote on 09/26/2005 01:59:52 PM:
> How do I set Index to enforce that ONLY 1 QAID can own that order
number,
> but nothing else?
>
> For example:
>
> QAID [order] ErrorType
> 11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one
QAID
> number us
How do I set Index to enforce that ONLY 1 QAID can own that order number,
but nothing else?
For example:
QAID [order] ErrorType
11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one QAID
number uses it.
11223 123456789 19 'VIOLATED cannot have same ErrorTypes -> UNIQUE INDEX
(QA
Claire,
>I want to check if a column exists in a table before I
>do an alter table to add it. How do I do this in
>mysql? Thanks.
If you are using MySQL 5.0, query information_schema.columns
(http://dev.mysql.com/doc/mysql/en/columns-table.html) for the table and
column. Otherwise use SHOW COL
OK, I am ready to get flamed. I have done so much stuff wrong on this
MySQL server that it finally came back to bite me. I've learned my
lesson and hopefully someone here will find it in their heart to help me.
I have a database which is updated quite often, running from a web
server. There
Dyego Souza Dantas Leal wrote:
Hello Guys,
I'm using the 5.0.12 version of MySQL PRO on AMD64 3000+ with 1 GB of
ram and using the InnoDB Tables..
Here is the Select:
mysql> select f1.fc_package from svcs_filecontrol f1 where f1.fc_id in (
-> *select max(f2.fc_id) from svcs_filecontr
Justin,
>I don't have any experience with stored procedures and find the
>Documentation in the MYSQL manual a bit sketchy or maybe I am just
>miss reading it. Can any one point me to some documentation that
will
>help with fully understanding Stored Procedures?
>What I am trying to migrate
I want to check if a column exists in a table before I
do an alter table to add it. How do I do this in
mysql? Thanks.
Claire
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL Genera
- Hi and Welcome to -
LASSO TIPS FOR MYSQL: 2.9
I'm your host, M i l e s.
First and foremost, a good place for you to start with Lasso is the
following 5 things:
The FIRST LASSO TIPS FOR MYSQL
-> http://www.listsearch.com
<[EMAIL PROTECTED]> wrote on 09/26/2005 11:50:11 AM:
>
> Hi,
>
> When running a process which is a part of my apllication,
> mysqld.exe is using 90%-95% of cpu utilization. Here I used mysqld for
> starting the mysql server. For other processes in the application, CPU
> utilization is very
On Sun, Sep 25, 2005 at 03:56:46PM -0500, Peter Brawley wrote:
> Jim,
>
> If you really want to return the result in a variable, declare a user
> var in the client, declare an OUT var in the SP, have the SP SELECT INTO
> it, and pass the user var to the SP in the call:
>
> SET @x=0;
> SET GLOBA
Hi,
When running a process which is a part of my apllication,
mysqld.exe is using 90%-95% of cpu utilization. Here I used mysqld for
starting the mysql server. For other processes in the application, CPU
utilization is very minimum. I used optimization (for order by, select
and like) in buil
"梁增辉" <[EMAIL PROTECTED]> wrote on 09/26/2005 09:24:11 AM:
> mysql，您好！
>
> I can't find any information about - How to create database
> link in MySQL. Can YOU help me please.
>
> 致
> 礼！
>
>
> 梁增辉
> [EMAIL PROTECTED]
> 2005-09-26
What problem are you trying to
I don't have any experience with stored procedures and find the
Documentation in the MYSQL manual a bit sketchy or maybe I am just miss
reading it. Can any one point me to some documentation that will help with
fully understanding Stored Procedures?
What I am trying to migrate out of my progra
Daniel,
MySQL AB recently purchased such a tool, DB Designer, rechristened it
MySQL Workbench, & just released an alpha version for Windows.
>You're kidding? I thought I'd seen the last of DB Designer.
>Where can we get it? I checked out the dev section of
>the website and looked under graphic
Hi,
You cannot.
A future version of MySQL 5 will probably allow that, but not currently.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http
mysql，您好！
I can't find any information about - How to create database link in
MySQL. Can YOU help me please.
致
礼！
梁增辉
[EMAIL PROTECTED]
2005-09-26
mysql，您好！
I can't find any information about - How to create database link in
MySQL. Can YOU help me please.
致
礼！
梁增辉
[EMAIL PROTECTED]
2005-09-26
Hello Guys,
I'm using the 5.0.12 version of MySQL PRO on AMD64 3000+ with 1 GB of
ram and using the InnoDB Tables..
Here is my table:
CREATE TABLE `svcs_filecontrol` (
`fc_id` int(10) unsigned NOT NULL auto_increment,
`fc_us_id_lockby` int(10) unsigned default NULL,
`fc_lbl_id` int(10) un
Hi James,
If you want to configure a relay replication server, i.e. make the
replication to pass data from slave to another slave as A->B->C you need to
start B with --log-bin and --log-slave-updates.So check that
log-slave-updates has been included in your my.cnf file.
You can read mor
Hi,
Intend on the following replication scenario:
A -> B -> C
A is replicating to B no problem.
B was copied to C.
C was ordered to begin replicating from B, but saw no updates
Checked on B, and although mysql 'show variables' states binary logging
in 'ON', no updates are being written to the
C.R. Vegelin wrote:
Hi All,
Does anyone know how to use the format() function in such a way that is
displays numbers right justified.
For example, see the following query, where I want no decimal places:
SELECT 123456.789 AS X, FORMAT(123456.789, 0), FORMAT(123456.789, 0)+0;
The 1st column is n
Hi All,
Does anyone know how to use the format() function in such a way that is
displays numbers right justified.
For example, see the following query, where I want no decimal places:
SELECT 123456.789 AS X, FORMAT(123456.789, 0), FORMAT(123456.789, 0)+0;
The 1st column is normally displayed as 1
"Peter Brawley" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Shaun,
>
> >We have a database that keeps track of days worked and days taken off by
> >staff. All days worked / taken off are held in a table called Bookings.
> >Staff work on Projects and each project will have variou
Dan,
Forgot to say, re. MySQL Workbench - this may be a useful source of info:
http://forums.mysql.com/list.php?113
Raz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dan,
The download pages are not set up yet, so try the below ftp link:
ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-noinstall-1.0.2-alpha-win32.zip
ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-noinstall-1.0.2-alpha-win32.zip.md5
HTH
Raz
--
MySQL General Mailing List
For li
Joeffrey Betita wrote:
hi Jasper
the linux distribution is redhat 9, mysql-4.0.15a-log, apache-2.0.47, php-4.3.3 etc.
just clicking one hyperlink and searching for any item.
OK, would you mind providing the SQL query that's being executed when
you click that hyperlink?
You see, MySQL doesn'
Hi
Most readers in this list expect OS and MySQL server information etc
before responding.
In our experience this is usually caused by poor SQL query construction
e.g. large result set e.g. x million rows and/or index choice, database
table design and/or MySQL server setup.
Turn-on logging
Joeffrey Betita wrote:
do you have any idea why the mysql process is 99.9 percent?
No.
when i click one hyperlink it takes more than 1 minute to load the
page. thank you very much.
Maybe if you provided some details then someone would be able to help
you. We're not psychic. What programming
hi
do you have any idea why the mysql process is 99.9 percent? when i click
one hyperlink it takes more than 1 minute to load the page. thank you very
much.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23/
76 matches
Mail list logo
