Jochem van Dieten wrote:
Also, let's not mistake the means for the goal. Using indexes is just
a way to solve it and there may be other fixes. The goal is to improve
performance.
no.. using indexes is THE way to fix it :)
I don't want a subquery scanning all 700 million rows in my table wh
Thanks Simon:
That was marvelous!!!. It have done the job!!!. I was hours trying to solve
it and it was such a simple thing :-).
I am very grateful with you and with the list.
Best regards,
Alvaro.
PD: You are the best guys!
- Original Message -
From: "Simon Garner" <[EMAIL PROTECTED]
I am still trying, and I have run the EXPLAIN function over the query and I
have received the following result:
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY tbl_f4Granjas index FK_ProjectHolderId 255 5 (null)
2 DEPENDENT SUBQUERY NULL NUL
Alvaro Cobo wrote:
Hi guys:
I am here again asking for your generous and wise advise:
I have a table (tbl_f4Granjas) with the information of some farms, their whole land extension (field: GraExtUPA) and the portion of the land they are managing in an agro-ecological way (field: GraExtPredio).
Hi guys:
I am here again asking for your generous and wise advise:
I have a table (tbl_f4Granjas) with the information of some farms, their whole
land extension (field: GraExtUPA) and the portion of the land they are managing
in an agro-ecological way (field: GraExtPredio).
What do I need i
wrap it in ``
e.g. `keys`
James Black wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a db named keys, and when I tried to do
grant select,insert,update,delete on keys.* to [EMAIL PROTECTED]
I get an error, about SQL syntax near 'keys.*'.
Should this work?
I am using mysql 5.0.6
The original message was received at Fri, 10 Jun 2005 11:50:24 +0900 from
wowtv.co.kr [63.206.78.8]
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
The speed of the drive will have a lot to say on how long the queries run.
You haven't said anything about what type of master you have, OS, mysqld
version, etc, but I would assume that your server is much much faster
(faster drives, more memory, faster bus, ...).
Are both your mysql daemons confi
The lists.mysql.com services will be offline for maintenance during
parts of this coming weekend starting at 15:00 PDT (22:00 GMT) on
Friday, June 10.
Any mails you send during this time and mails to you from the lists will
all still be delivered, but with some possible delays.
Everything should
Hello,
I have a segmentation fault using MySql with PHP/ODBC on Linux.
I do a query with exec and I get a segmentation fault in "my_SQLPrepare".
If I use the isql command line, all works fine.
Is it a MySql problem or a Php problem?
Thank you.
Santino Cusimano
--
MySQL General Mailing List
Hello.
Are you sure that your queries don't lock each other? I didn't heared
about such odbc behavior.
>Hello,
>
>We have a little problem using the MySQL ODBC driver, when we have 2 users
>accessing simultaneously to our web application MySQL (or more so ODBC)
>waits for one
Hello.
There's a lot of complains that usually slave is far behind
the master. However, the distance between them usually is not so large.
Could it be that your laptop much is weaker or not that tuned compared to the
server, and the same operation takes more time? As I know replication
thre
On 6/9/05, [EMAIL PROTECTED] wrote:
>
> Okay, so I understand the idea about one field being the "creation" time, and
> the other being the "last modified" time (which a particularly pedantic
> application might regard as being one-and-the-same, at time of
> first-creation) and so I see you might
> http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html
>
> > Absolutely brilliant document *g* ...
> >
> > So now, it makes a difference if it's the first TIMESTAMP column,
> > if it's running in MaxDB mode, if it has a defaulf of NULL (which will
> > be silently changed), if it has no default, a
Chris Knipe wrote:
Hi,
We've just upgraded (via FreeBSD Ports) our one database from 4.1.11
to 4.1.12, and we are being hit by
http://bugs.mysql.com/bug.php?id=10674 - only on certain queries,
using rather large temp tables.
Now, from what I understand, there is a 4.1.12-1 available? Wher
On 6/9/05, Martijn Tonies wrote:
http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html
> Absolutely brilliant document *g* ...
>
> So now, it makes a difference if it's the first TIMESTAMP column,
> if it's running in MaxDB mode, if it has a defaulf of NULL (which will
> be silently changed), if
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have a db named keys, and when I tried to do
grant select,insert,update,delete on keys.* to [EMAIL PROTECTED]
I get an error, about SQL syntax near 'keys.*'.
Should this work?
I am using mysql 5.0.6 and 4.1.7.
Thanx.
- --
"Love is mutual self-gi
> You can have any number of timestamp columns, but only one of them can
> be set to autoupdate. As of 4.1 you are not limited to this being the
> 1st one in the table and CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(), or
> NOW() can be used in the DEFAULT. Read
>
> http://dev.mysql.com/doc/mysql/en/times
On Wed, 8 Jun 2005 [EMAIL PROTECTED] wrote:
> A long time ago when I was doing support for Lotus Notes, I was told that
> the customer who 'complains' about legitimate bugs may be the most valuable
> type of customer of all. This is because they care enough to vent. Who
> knows how many unhappy c
I'm missing something, here; what earthly good is there, in having two fields
in the same tuple being created so that they both automatically store exactly
the same data... and if it was valuable, is there no way of more reliably
building this behaviour into the external application?
Okay, so I
You can have any number of timestamp columns, but only one of them can
be set to autoupdate. As of 4.1 you are not limited to this being the
1st one in the table and CURRENT_TIMESTAMP, CURRENT_TIMESTAMP(), or
NOW() can be used in the DEFAULT. Read
http://dev.mysql.com/doc/mysql/en/timestamp-4-1.
Jeff Smelser wrote:
On Thursday 09 June 2005 01:26 pm, George L. Sexton wrote:
Another limitation in MySQL is that you can only have one timestamp column
with a default of CURRENT_TIMESTAMP.
How many friggin times do I have to say that this is not an issue with 4.1 and
above? Which, BTW,
On Thursday 09 June 2005 01:26 pm, George L. Sexton wrote:
> Another limitation in MySQL is that you can only have one timestamp column
> with a default of CURRENT_TIMESTAMP.
>
How many friggin times do I have to say that this is not an issue with 4.1 and
above? Which, BTW, is production mysql..
On 6/9/05, Bartis, Robert M (Bob) wrote:
>
> Its an email alias. You're asking for help from people you don't even know.
> You should therefore present your needs clearly and concisely. You should
> expect there to be questions. You should expect to not always get timely
> information. you sho
On 6/9/05, Roger B.A. Klorese wrote:
>
> If you're the first person this has bothered
He isn't, search the bugbase. (Including reports that are closed
because it is documented, without providing a fix, workaround or even
recategorizing as feauture request.)
> and if the limitations don't provid
[snip]
...minimal level of common decadency...
[/snip]
heh.
I am minimally decadent!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Folks...please
This has really degraded. I seriously think its time everyone sign up for charm
school or better yet share these emails with your grandmother who will more
than likely crack you all upside your head and knock some minimal level of
common decadency into you all.
Its an email alia
On Thursday 09 June 2005 12:42, George L. Sexton wrote:
> On Thursday 09 June 2005 12:31, you wrote:
> > George L. Sexton wrote:
> > >You obviously don't understand the limitations of timestamps.
> >
> > You obviously don't understand how ineffective leading with an insult is.
My mistake.
> > If
George L. Sexton wrote:
You obviously don't understand the limitations of timestamps.
You obviously don't understand how ineffective leading with an insult is.
If you're the first person this has bothered, and if the limitations
don't provide inconsistency with a standard -- just with ot
Eric Bergen <[EMAIL PROTECTED]> wrote on 06/09/2005 12:56:59 PM:
> How about something like this:
> mysql> select @t := now();
> +-+
> | @t := now() |
> +-+
> | 2005-06-09 09:55:49 |
> +-+
> 1 row in set (0.00 sec)
> mysql> inse
If my compiler would validate the SQL Statements and ensure that they were
perfect, then I wouldn't have a problem at all.
However, since no developer tool that I have ever used (and I've used a lot of
different ones) does compile time validation of SQL syntax, that's pretty
much out of the que
You obviously don't understand the limitations of timestamps.
Another limitation in MySQL is that you can only have one timestamp column
with a default of CURRENT_TIMESTAMP.
It's not an issue I don't know. It's an issue I'd like to see fixed so that I
can list MySQL as a supported database alon
On 6/9/05, Keith Ivey wrote:
> I'm a little surprised that case-sensitivity is such a big deal. What sort of
> programmers randomly vary their capitalization from one occurrence of an
> identifier to the next
Inconsistencies in the capitalization aren't necessarily introduced by
a programmer. Esp
²d!M¡Oª*éè¼yî’´Çç焘a42ã¼ùX’ªk£Þà¸y’÷L¨?$×
ñÃu?"%Ý£®,®3.T%]ÜžÜsø‰&Mzþ
kˆl‹U«‹…G]‚u12ŶüžÏ~?g?:äRNKèø룉n„Ë3E,#Ô— UñtW(h3 ßw;Ä™RHîd
Š¿kwZÀclO²“"“\Ïä“™XÏç… Ï¼¼«Ê "W²ì“×|÷!aŽ OùíôÆkºöµ—z'²[g(t/…ó±^û›O6¿vþûešrÅ
ñïK—>:³â[ap½ó$744í‰Yeq,J£Ê§æjþòxÏŸ
ËçEGø)Ê?³qŽ²G¥«ÐV{Àž;£œ?'¨”F¶2Õ´4O]6Ѩ„‰“BHÚPU
;M5Ï
This is the weirdest thread I've ever seen. I've never seen so many seques
used in a thread
Agreed.
However, if you read the entire thread you have learned more in ONE location
about timestamps, default values, creating tables, other RDBMS types,
interoperability, contribution to the open
I'm a little surprised that case-sensitivity is such a big deal. What sort of
programmers randomly vary their capitalization from one occurrence of an
identifier to the next, and wouldn't people who are so non-detail-oriented be
making a lot of typos as well?
--
Keith Ivey <[EMAIL PROTECTED]>
How about something like this:
mysql> select @t := now();
+-+
| @t := now() |
+-+
| 2005-06-09 09:55:49 |
+-+
1 row in set (0.00 sec)
mysql> insert delayed into t set t = @t;
Query OK, 1 row affected (0.00 sec)
mysql> select *
On Thursday 09 June 2005 11:47 am, George Sexton wrote:
> I'm working in that direction. I first posted to the regular mysql list,
> and then I posted again to the internals list. I guess the next step is to
> talk to the MySQL people.
We answered you I thought.. Whats the issue you dont know?
J
This is the weirdest thread I've ever seen. I've never seen so many
seques used in a thread
All we need now is for someone to post a question about configuring
Tomcat to work with Microsoft SQL Server.
To get back to the spirit of the original post, I personally wouldn't
use subqueries
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 09, 2005 10:34 AM
> To: George Sexton; mysql@lists.mysql.com
> Subject: RE: Seriously.. When are we going to get subqueries?!
>
> [snip]
> > 1. Join the development work.
> I tried contributing
[snip]
> 1. Join the development work.
>
I tried contributing over at the Tomcat project and really just got
abused
by the team there.
[/snip]
That is unfortunate, but cannot be held against the MySQL team, can it?
[snip]
> B. Find a product more suitable to your needs.
My issue is that shops
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 09, 2005 8:30 AM
> To: George Sexton
> Cc: mysql@lists.mysql.com
> Subject: RE: Seriously.. When are we going to get subqueries?!
>
> If you are
> not pleased with MySQL you have some options.
>
On Thu, 9 Jun 2005, Philippe de Rochambeau wrote:
> Hello,
>
> is there a way to switch from emacs binding to the vi binding in mysql?
>
The mysql client should pick up your .inputrc settings. 'man readline' for more
info.
-r
--
MySQL General Mailing List
For list archives: http://lists.my
On 6/9/05, Jeremiah Gowdy wrote:
> >
> > Does this seem to break SQL / application logic in some fashion?
>
> >Not worse then it is currently broken :)
> >
> >According to the SQL standard CURRENT_TIMESTAMP, which in MySQL is a
> >synonym for NOW(), is supposed to have a value that does not change
I am proposing that when a query is received by MySQL, a timestamp could
be taken immediately, and that timestamp could travel with the query until
it is actually processed. For delayed inserts, the query would still sit
in the insert queue, and it would still say NOW(), but when the query
fin
Hi everybody.
Is it normal that, after a massive number (300.000) of INSERTs on the
master server (that however did not take more than some minutes), my
laptop that acts as a slave needs hours to catch up? The logfile was
almost instantly transferred, but the INSERTs at the slave server seem
to re
On 6/9/05, Jeremiah Gowdy wrote:
>
> I am proposing that when a query is received by MySQL, a timestamp could be
> taken immediately, and that timestamp could travel with the query until it is
> actually processed. For delayed inserts, the query would still sit in the
> insert queue, and it wo
- Original Message -
From: "Jeff Smelser" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 09, 2005 7:50 AM
Subject: Re: INSERT DELAYED and NOW()
On Thursday 09 June 2005 09:39 am, Jeremiah Gowdy wrote:
I am proposing that when a query is received by MySQL, a timestamp could
be
taken imm
On Thursday 09 June 2005 09:39 am, Jeremiah Gowdy wrote:
> I am proposing that when a query is received by MySQL, a timestamp could be
> taken immediately, and that timestamp could travel with the query until it
> is actually processed. For delayed inserts, the query would still sit in
> the inse
Hello,
We have a little problem using the MySQL ODBC driver, when we have 2 users
accessing simultaneously to our web application MySQL (or more so ODBC)
waits for one query to finish before executing the second query. Its quite
annoying when a few users try to use the application!
Its a MyS
I'm wondering if anyone else has run into this issue.
We are logging from a real-time telecom application (we have callers on the
phone that are being handled by threads that are logging to MySQL), and because
of the nature of that application, we use INSERT DELAYED. There are multiple
compute
[snip]
Well, Oracle, DB2, SQL Server, Access, PostgreSQL, and Sybase SQL
Anywhere
all do this. I looked at my copy of "A Guide to The SQL Standard" by
Chris
Date. It pretty plainly states that DEFAULT allows niladic (no argument)
functions. Its about time MySQL stopped complaining about things bein
[snip]
Not true. Triggers are in the SQL specification. They are a legitimate
feature with specified expected behaviour. A hack is only implementing
function returns as default field values on timestamps, rather than
handling all field types in a unified way and allowing them to be set to
the r
Jay Blanchard wrote:
[snip]
Well, George, you never mentioned that this was your problem. And you
would run into the same problem, given your definition above,
regardless
of database (unless the database product has a hack to account for it,
I am not aware of any).
Not true. PostgreSQL c
[snip]
> Well, George, you never mentioned that this was your problem. And you
> would run into the same problem, given your definition above,
regardless
> of database (unless the database product has a hack to account for it,
I
> am not aware of any).
Not true. PostgreSQL can do it. If you want t
On Thu, 09 Jun 2005 14:28:56 +0100
Gordan Bobic <[EMAIL PROTECTED]> wrote:
> My understanding was the timestamp fields were only set when the
> record is created. They are not changed when the record is
> modified.
http://dev.mysql.com/doc/mysql/en/timestamp-4-1.html
"The first TIMESTAMP column
[snip]
> 1)Why can't I declare a datetime field with DEFAULT NOW()
4.1 has options to default timestamps on update/inserts or both..
[/snip]
Cool, I didn't know that. I should have read the docs more closely this
morning.
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
On Wed, 8 Jun 2005 21:57:25 -0600
"George Sexton" <[EMAIL PROTECTED]> wrote:
> I think MySQL has a little ways to go yet before I would
> subjectively call it best.
ok.
> I posted twice to the list with questions about porting my
> application that runs on (SQL Server, Oracle, PostgreSQL, Sybase
Hello Kirk,
> Is anyone familiar with how to dump a database from Microsoft sequel
server
> to mysql? I know nothing about Microsoft products and am looking for a
> utility or similar to do the conversion. Maybe Microsoft has something
> built in? Although I doubt it.
You might want to try ou
Jay Blanchard wrote:
[snip]
The issue with timestamp is this:
You can only have one timestamp with a default of the current date.
My app has two fields in one table
Created_datedatetime default now()
Last_update datetime default now()
This doesn't work with timestamp because t
On Wednesday 08 June 2005 10:57 pm, George Sexton wrote:
> 1)Why can't I declare a datetime field with DEFAULT NOW()
4.1 has options to default timestamps on update/inserts or both..
Jeff
pgp2pHd6mM2jF.pgp
Description: PGP signature
[snip]
The issue with timestamp is this:
You can only have one timestamp with a default of the current date.
My app has two fields in one table
Created_datedatetime default now()
Last_update datetime default now()
This doesn't work with timestamp because timestamp doesn't suppor
Look at the EMS family of MySQL products. They have a data pump utility that
works to move data from lots of sources to MySQL.
Also, Borland has a data pump utility packaged with their development tools.
There's also a utility called DBScriptor that works well to migrate data.
Dave
-Ori
The issue with timestamp is this:
You can only have one timestamp with a default of the current date.
My app has two fields in one table
Created_datedatetime default now()
Last_update datetime default now()
This doesn't work with timestamp because timestamp doesn't support two
c
Hi,
We've just upgraded (via FreeBSD Ports) our one database from 4.1.11 to
4.1.12, and we are being hit by http://bugs.mysql.com/bug.php?id=10674 -
only on certain queries, using rather large temp tables.
Now, from what I understand, there is a 4.1.12-1 available? Where is the
source? It
I think MySQL has a little ways to go yet before I would subjectively
call it best.
I posted twice to the list with questions about porting my application
that
runs on (SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere, MS Access,
and
DB2) to MySQL. No one on the mysql list, or the internals
[snip]
I think MySQL has a little ways to go yet before I would subjectively
call
it best.
I posted twice to the list with questions about porting my application
that
runs on (SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere, MS Access,
and
DB2) to MySQL. No one on the mysql list, or the intern
Philippe de Rochambeau wrote:
> My version of mysql creates all sorts of xxx-bin.xxx files in the
> /var/lib/mysql directory. I regularly remove the oldest files for space
> purposes.
>
> What exactly are these files and what is the proper way to manage them?
>
> Thanks.
>
> Philippe
>
>
>
As I can't provide steps to reproduce the crash, I decided to mail my
problem to this list. If this isn't the correct list, sorry. And sorry if
this message comes twice as for some reason the mail bounced back twice
already.
Anywho, I'm running mysql-standard-4.1.12-pc-linux-gnu-i686 (statical
My version of mysql creates all sorts of xxx-bin.xxx files in the
/var/lib/mysql directory. I regularly remove the oldest files for space
purposes.
What exactly are these files and what is the proper way to manage them?
Thanks.
Philippe
--
MySQL General Mailing List
For list archives:
Hello,
is there a way to switch from emacs binding to the vi binding in mysql?
Thanks.
Philippe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
In your previous letter you wrote that you had MySQL 4.0.22. Upgrade
to the latest release 4.1.12 (4.0.24). It is possible that your ibdata
files won't be readable by this version. So you should initialize a
new database. If you have important data you should go to:
http://dev.mysql
Hello.
On my mysql-5.0.6 instance foreign key constraint from your example
works. What output does the following statement produce:
show variables like 'have_innodb';
"Jan Bartholdy" <[EMAIL PROTECTED]> wrote:
> Dear All, I have two tables entity1 and entity2; the second one should
>
Hello.
Here is the answer from Ingo:
"It is even worse. The old index stays in place, but will never be used
again. ENABLE INDEX creates a new index from scratch. See Bug#4692 -
DISABLE/ENABLE KEYS waste a space."
roi h <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Another question, to
Here the contents of my privileged tables:
mysql.db table for dtk10mv after
GRANT UPDATE (status_dtk10) on tim.tk25no_meld to 'dtk10mv'@'localhost':
- db: -
- host: -
- user: Select_priv: Y
- tables_priv: Table_name: tk25no_meld; Table_priv: - ; Column_priv: Update
- columns_priv: Table_name: tk2
smime.p7m
Description: S/MIME encrypted message
On 6/9/05, Kevin Burton wrote:
> Jeff Smelser wrote:
>>
>> Thats funny.. looks like it will be added to 5.1.. Dunno why they
think fixing
>> it is adding a feature..
>
> WOW! That's just insane! This seriously has to be fixed in 5.0 or sooner...
Chill out man. It is not like it is returning the
Thanks guys it worked!!! I really appreciate your help.
this is the one that worked:
SELECT u.UserID
FROM Users u
LEFT JOIN BuddyList bl
ON u.userID = bl.buddyID AND bl.userID = '$userid'
WHERE u.isactive =1
AND bl.userID is null
and u.UserID != '$userid';
Michael
> Or put the members alphabetically in the enum definition in the first
> place ...
Better yet - drop the ENUM al together :-)
Use a lookup table.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upsc
Ed Pauley II wrote:
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers
serve two very busy web sites with multiple applications accessing th
Or put the members alphabetically in the enum definition in the first
place ...
--
felix
On 09/06/2005, Eric Bergen wrote:
> It's not a bug at all. You just hit one of the features of enum :)
>
> If you want to order alphabetically as you describe cast the enum
> name to a string like this se
I would say this is not a bug. You declared an enum for the column. So
therefore it sorts in enum order. Makes perfect sense. To me MySql is
working correctly. If it did not sort an enum in the order declared for
the enum then i would be annoyed. Enums are not strings.
Declare the column a
82 matches
Mail list logo
