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:
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
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
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
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
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]
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 various
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
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
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
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 more
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)
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
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!
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 graphical
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
梁增辉 [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 solve that you
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
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 GLOBAL
[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 minimum.
- 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
-
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
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 out
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..
snip
Here is the Select:
mysql select f1.fc_package from svcs_filecontrol f1 where f1.fc_id in (
- *select max(f2.fc_id) from
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.
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
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
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 uses it.
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
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)
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
-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
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:
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,
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 nothing else?
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
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
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
know if
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 PROTECTED]
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 board add
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 a
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
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
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
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
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
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
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
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
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
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
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 '|'
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
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
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 am
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, so from
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 writing
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 am using MySQL
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 OS and
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.
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
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
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 Ferguson
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
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
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]
67 matches
Mail list logo
