Hi All,
Is it possible to change or create any database on a specific location.
I want to specify a db path at runtime.
Thanks in advance.
--
Regards,
Manasi Save
Artificial Machines Pvt Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
It's been in mysql for at least 7 years.
http://ebergen.net/wordpress/2009/04/11/longest-beta-ever-myisamchk-parallel-recover/
On Thursday, September 10, 2009, Rob Wultsch wrote:
> myisam_repair_threads
>
> "If this value is greater than 1, MyISAM table indexes are created in
> parallel (each i
Hi John,
If judicious transformation of data makes it easier to do the queries you want,
then you should consider it. ETL isn't a common acronym in the database world
just because we like three letters =) Though it depends on how often you're
doing this, if it's one-off then it's probably not
>-Original Message-
>From: Gavin Towey [mailto:gto...@ffn.com]
>Sent: Wednesday, September 16, 2009 7:34 PM
>To: John Meyer; mysql@lists.mysql.com
>Subject: RE: Datediff function
>
>Hi John,
>
>You can't use aggregate function in the WHERE clause, because they aren't
>evaluated until after
John Meyer wrote:
I'm trying to pull up a list of users who haven't tweeted in 7 or more
days, and I'm trying to use this statement:
SELECT USER_NAME, MAX(TWEET_CREATEDAT) FROM USERS NATURAL JOIN TWEETS
WHERE DATEDIFF(NOW(),MAX(TWEET_CREATEDAT)) > 7
But it says "invalid group function". How
Johan De Meersman wrote:
On Thu, Sep 17, 2009 at 3:46 AM, John Meyer wrote:
Alternatively, you can skip the A_ID and have a compound key of USER_ID and
A_NUMBER on the ASSOC_NUMBERS table. I prefer the A_ID, though.
Note that this would be marginally faster, because all your data is i
Hey,
Currently, afaik, when you update a table, MySQL will flush all query
cache entries for that table. I've heard that work was ongoing to
change this behavior to only the affected rows, but I can't seem to
find much information on it.
Does anyone know the status of this ?
Thx,
Johan
--
That
On Thu, Sep 17, 2009 at 3:46 AM, John Meyer wrote:
> Alternatively, you can skip the A_ID and have a compound key of USER_ID and
> A_NUMBER on the ASSOC_NUMBERS table. I prefer the A_ID, though.
Note that this would be marginally faster, because all your data is in
the index, so you don't need to
Dear MySQL users,
MySQL Server 5.4.2-beta, a new version of the popular Open
Source Database Management System, has been released.
Bear in mind that this is a beta release, and as with any
other pre-production release, caution should be taken when
installing on production level systems or system
