Ben Dinnerville wrote:
You have a redundant clause in your query - the distinct is not needed when
you are doing a group by on the same field ('Call Svr Tag ID') - not sure
how the optimiser in MySQL will handle this. In some RDBMS's the duplicate
clause will be optimised down to 1 clause, so you
Hello,
Teh other day I posted an annoncement about my new web site
www.SQL-Scripts.Com . It is a place were you can find SQL scripts for
database system. You can even lodge your own scripts and help someone out
there.
I have started a monthly contest on the site now. The first people to lodge
The indexes were listed at the bottom of the original post.
Woops, didnt see that far down, should have scrolled a little further :)
What is needed, I expect, is a
multi-column index on those 2 columns:
ALTER TABLE 31909_859552
ADD INDEX Tag_Created (`Call Svc Tag ID`, `Journal Create
Hello, Me and a few others are developing om linux boxes running MySQL 5.0.0. We often
create users with different access rights on our development boxes and then it often
occours problems with users when our programs goes into production. I would like to
find a common user enviroment for our
Ben,
- Original Message -
From: Ben Dinnerville
Sent: Monday, April 19, 2004 1:49 AM
Subject: RE: Slow Query Question - Need help of Gurus.
snip
Then try again:
SELECT `Call Svc Tag ID`,
Count(*) as counter,
`Journal Create Date`
FROM 31909_859552
WHERE
Zhang Yu [EMAIL PROTECTED] wrote:
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name id #, which is used by many
queries in Access. My
hi all
I have installed mysql and I created an users call lrmt and password
is lrmt.
So from command line(mysql -u lrmt -p lrmt) i can enter to mysql with out
any problem and also with mysql -u root -p socket.
I used this command to give permission to user
GRANT ALL ON database.* TO
thanx for all the replies.
i found the solution with a single select and update, it was a simple
update(how did i miss tht???)
but what if i want to do a compelete transaction with row level locking
in consideration, as thr can be time lag between the queries(select and
update) so a row level
I hate to say this, but you may want to look into FileMaker if you
don't know a lot about databases and programming. You'll be able to get
things up to speed a lot quicker and other users would be able to learn
it fairly easily to help you out. I often use FileMaker to prototype a
database and
hi - Ive posted this before but not had a satisfactory solution...
Im trying to load spatial data as OGC WKT into a geometry field but a number of rows
consistently fail. I can se no reaspn for this other than their length - does anyone
know what the size limit for insertion into a geometry
Is the key_buffer_size server variable useful for
tuning databases that only have innodb tables or do I
need to use the innodb_buffer_pool_size variable for
this?
Thx,
Tripp
__
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital
Hi,
Apologies in advance for the large post but I've tried to explain my problem
as much as I can.
I'm having load issues with my InnoDB server and am not sure what I should
try to resolve this problem.
The machine is redhat Linux 7.2 with dual processors, 4GB ram and about 32GB
disk space.
The
Ben Dinnerville wrote:
snip
Note that sorting by the count can't use an index, so it will be slower
than if you had ordered by `Call Svc Tag ID`.
This is something that will need testing. Ordering on a varchar(255) column
(call svc tag ID) is going to be a lot more inefficient than ordering on
Hello everyone,
Sorry for the delay in responding but I had to be out of town for the last
4 days and didn't have access to my mail.
Here is a recap for those who are just joining:
I have multiple branch locations that need to have their transactions
rolled up into a common statistics database.
Which filesystem is better for a MySQL server? I can't see the difference between
them.
All I need is a LFS that will handle a MyISAM table above the 4GB size level.
Running Linux 2.4 (or can install the latest ver if necessary) on 32 bit Intel
platform.
My Linux books says XFS is the
Is there a way to log authentication failures against the mysqld by
source IP and username attempted?
--
Mark P. Hennessy [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name id #, which is used by many
queries in
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get
At 15:26 -0400 4/18/04, Stormblade wrote:
Thanks for the explaination. Heh I should have realized that. varchars are
probably implemented as null terminated strings and so they need an extra
byte for the terminating char (Null or otherwise).
They're stored as a length byte + string contents.
Yeah
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name id #, which is used by many
queries in
At 0:11 +0200 4/19/04, Gerd JuppJacke wrote:
Hello,
I need fast help. My .frm-files are deleted on MyIsam MySQL. The other two
files types (myd and myi) of each table are still there but the frm-files
are deleted. The database does not work any more.
How can i reconstruct the database with the
At 0:11 +0200 4/19/04, Gerd JuppJacke wrote:
Hello,
I need fast help. My .frm-files are deleted on MyIsam MySQL. The other two
files types (myd and myi) of each table are still there but the frm-files
are deleted. The database does not work any more.
How can i reconstruct the database with the
At 15:26 -0400 4/18/04, Stormblade wrote:
Thanks for the explaination. Heh I should have realized that. varchars are
probably implemented as null terminated strings and so they need an extra
byte for the terminating char (Null or otherwise).
They're stored as a length byte + string contents.
Yeah
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get
Chad Attermann [EMAIL PROTECTED] wrote:
I am using HIGH_PRIORITY in my SELECTs to force queries to take predcedence over
updating
due to replication. I have recently implemented UNION in some of my queries to
optimize
queries like WHERE table1.column1=something OR
Marek Lewczuk [EMAIL PROTECTED] wrote:
Hello,
when do you plan to release 4.1.2 version ?
It will be released in several weeks.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___
Hello!
I have a simple query on a table of about 1,000,000 records... The table is
optimized and the query is pretty simple at this moment... something like
this
select id,name,desc,cat,date from table where cat='12'
however I need to order the results by date desc... I have indexes on both
the
When trying to start mysqld I get the following error
#safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/safe_mysqld: line 275: 32649 Segmentation fault $NOHUP_NICENESS
$ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
$USER_OPTION
Hi,
I'm currently running some instances of 4.0.18. I read the following in the docs:
Beginning with MySQL 4.0.3, many server system variables are dynamic and can be set
at runtime using SET GLOBAL or SET SESSION. You can also select their values using
SELECT.
But when I look at the
4.0.18 is the latest 4.0.x release.
4.0.3 4.0.9 4.0.10 4.0.18
4.0.3 != 4.0.30
-Original Message-
From: Lou Olsten [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 1:44 PM
To: [EMAIL PROTECTED]
Subject: Getting an older version of MySQL
Hi,
I'm currently running some
Huh as in production ?
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 5:52 AM
To: [EMAIL PROTECTED]
Subject: Re: when 4.1.2 release
Marek Lewczuk [EMAIL PROTECTED] wrote:
Hello,
when do you plan to release 4.1.2 version
Ah Ha! Thanks!!!
Lou
- Original Message -
From: Chris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 19, 2004 5:14 PM
Subject: RE: Getting an older version of MySQL
4.0.18 is the latest 4.0.x release.
4.0.3 4.0.9 4.0.10 4.0.18
4.0.3 != 4.0.30
-Original
Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have scripts that you use why not
lodge
Sorry no subject on the last email
Hello,
Announcing the release of a new web site : www.SQL-Scripts.com
At www.SQL-Scripts.Com you can find a collection of SQL Scripts for many
different database system. Using our search system you can find scripts
that you need quickly and simply. If you have
Hello.
I have installed binary version for aix 5.2 from www.mysql.net and when i try to
compile cyrus-sasl with mysql support it don't find mysqlclient libraries.
I use --with-mysql=/usr/local/mysql/ to build but i get:
checking for mysql_select_db in -lmysqlclient... no
configure: WARNING:
On Sun, 18 Apr 2004 14:18:40 -0500, Paul DuBois wrote:
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that
Does anyone know of an open source tool like Torque or Hibernate for
Java that can generate C++ classes rather than Java? We're starting a
project with a mySQL backend that involves both a C++ part and a Java
part. I've searched high and low for such a tool/library and haven't
been able to find
Don Dachner wrote:
Which filesystem is better for a MySQL server? I can't see the difference between them.
All I need is a LFS that will handle a MyISAM table above the 4GB size level.
Running Linux 2.4 (or can install the latest ver if necessary) on 32 bit Intel platform.
My Linux
Can you start it with strace running and see where it fails? I suspect its
an issue with finding the group file. If this is the cause you will need to
build mySQL yourself.
Btw please send arch / version / system hardware spec.
--
DVP
-Original Message-
From: Mozzi [mailto:[EMAIL
Use JFS, unless your database server is going to have many many (on the
order of 10K) small tables use Reiser.
JFS hands down is faster for various mixed environments of reading / writing
/ random access etc.
--
DVP
-Original Message-
From: Daniel Kasak [mailto:[EMAIL
At 7:11 +1000 4/20/04, electroteque wrote:
Huh as in production ?
Surely you jest. 4.1.1 was an alpha release. It's unlikely
that 4.1.x would go straight to production-level in a single
step. I believe that 4.1.2 will also be an alpha release.
That said, I encourage you to go ahead and try it
-Original Message-
From: Marvin Wright [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 8:55 AM
To: [EMAIL PROTECTED]
Subject: InnoDB Load Problem
Hi,
Apologies in advance for the large post but I've tried to explain my
problem
as much as I can.
I've read the
At 17:55 -0400 4/19/04, Stormblade wrote:
On Sun, 18 Apr 2004 14:18:40 -0500, Paul DuBois wrote:
At 13:30 -0400 4/18/04, Stormblade wrote:
On Sun, 18 Apr 2004 12:17:00 -0400, Michael Stassen wrote:
Stormblade wrote:
Hey all,
I'm currently converting a SQLServer 2000 database over to
I'm not actually getting an error. I'm simply unable to access any of my
databases while logged in as [EMAIL PROTECTED] I'd like to change this and
specify what account is used to establish a connection. How and where do I
make this change in MySQL?
Thanks
-Original Message-
From: Egor
hi..
i am trying to create this table:
CREATE TABLE rnjresort_events (
Id int(25) NOT NULL auto_increment,
Type enum('Annual','OneTime') binary NOT NULL default 'Annual',
StartDate varchar(200) binary NOT NULL default '',
EndDate varchar(200) binary NOT NULL default '',
Name
At 19:09 -0400 4/19/04, Andy B wrote:
hi..
i am trying to create this table:
CREATE TABLE rnjresort_events (
Id int(25) NOT NULL auto_increment,
Type enum('Annual','OneTime') binary NOT NULL default 'Annual',
StartDate varchar(200) binary NOT NULL default '',
EndDate varchar(200) binary
On Mon, 19 Apr 2004 17:36:50 -0500, Paul DuBois wrote:
Sorry if I wasn't clear. One of the things you wanted to do was have
a column that is set automatically to record-creation time when the
record is created, but not updated automatically when the record is
updated later. You will be
At 9:45 -0700 4/19/04, Emmett Bishop wrote:
Is the key_buffer_size server variable useful for
tuning databases that only have innodb tables or do I
need to use the innodb_buffer_pool_size variable for
this?
The buffer controlled by key_buffer_size is used only
for MyISAM and ISAM tables.
--
Paul
At 20:23 -0400 4/19/04, Stormblade wrote:
On Mon, 19 Apr 2004 17:36:50 -0500, Paul DuBois wrote:
Sorry if I wasn't clear. One of the things you wanted to do was have
a column that is set automatically to record-creation time when the
record is created, but not updated automatically when the
Ok. Love MySQL and I will be using it for my personal use and recommending
it to clients as a lower cost alternative. I've only been using it for a
very short time but there one major gripe I have with it and I believe it's
just a design thing.
MySQL seems to put the burden of error checking and
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using 4.0.18.
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using
On one database, I keep seeing similar errors related to the key file for
the different tables.
1034 Incorrect key file for table:
Can't read key from filepos: 672768
error 5 when fixing table
Can't copy datafile-header to tempfile, error 9
How do I diagnose if the database file structure is
On one database, I keep seeing similar errors related to the key file for
the different tables.
1034 Incorrect key file for table:
Can't read key from filepos: 672768
error 5 when fixing table
Can't copy datafile-header to tempfile, error 9
How do I diagnose if the database file structure is
On Mon, 19 Apr 2004, Stormblade wrote:
Ok. Love MySQL and I will be using it for my personal use and recommending
it to clients as a lower cost alternative. I've only been using it for a
very short time but there one major gripe I have with it and I believe it's
just a design thing.
MySQL
On Mon, 19 Apr 2004 20:17:38 -0700 (PDT), Marc Slemko wrote:
On Mon, 19 Apr 2004, Stormblade wrote:
Ok. Love MySQL and I will be using it for my personal use and recommending
it to clients as a lower cost alternative. I've only been using it for a
very short time but there one major gripe I
Does any one knows how to store and retrieve files in blob columns using
VB .Net with ByteFx?
FBR
57 matches
Mail list logo