Per Jessen wrote:
> It happened agaIn this morning, but slightly different:
>
> [snip]
> thd=0x7fe0140c7e00
> Attempting backtrace. You can use the following information to find
> out where mysqld died. If you see no messages after this, something
> went terribly wrong...
> Cannot determine threa
>
> Thanks for the response, Peter.
> Yeah, I am aware of this to find it for the tables. However I require to
> find the creation time of a database..
>
> Thanks,
> Uma
>
>
> On 6/3/09, Peter Brawley wrote:
>>
>> >Is there any method to find the CREATION DATE of an EXISTING database and
>> >tab
We outputted the bin log using the following command:
mysqlbinlog -v --base64-output=DECODE-ROWS oo-mysql1-bin.87
We then looked in this file and found some odd things. For example
there is the below insert statement:
### INSERT INTO panel.history
### SET
### @1=-182667600 (4112299696)
##
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
information_schema.tables.create_time for tables.
PB
Uma Bhat wrote:
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or new
Hi all !
Is there any method to find the CREATION DATE of an EXISTING database and
tables in MySQL 5.0 or newer versions?
Thanks,
Uma
I just noticed a horrible thing.
I have a query (report) that can take 15 minutes or more to generate with
mySQL. We have > 500 Million rows. This used to be done in real time when we
had less rows, but recently we got a big dump of data that shot it up.
So, noticing via myTop the query taking
On June 2, 2009 04:13:31 pm Nathan Sullivan wrote:
> Ray,
>
> You can use the results of a query in a join with something like:
>
> select tmp.id, t1.id
> from (some_query_selecting_id) as tmp
> join t1 on t1.id=tmp.id
>
>
> Hope that helps.
>
>
> Regards,
> Nathan Sullivan
Thanks Nathan,
I think
Ray,
You can use the results of a query in a join with something like:
select tmp.id, t1.id
from (some_query_selecting_id) as tmp
join t1 on t1.id=tmp.id
Hope that helps.
Regards,
Nathan Sullivan
-Original Message-
From: Ray [mailto:r...@stilltech.net]
Sent: Tuesday, June 02, 2009 4
On June 2, 2009 03:14:36 pm Ray wrote:
> On June 2, 2009 10:44:48 am Peter Brawley wrote:
> > Ray,
> >
> > >I want a query that will provide one record per event with all times
> > > included. feel free to answer RTFM or STFW as long as you provide the
> > > manual section or key words. ;)
> >
>
On June 2, 2009 10:44:48 am Peter Brawley wrote:
> Ray,
>
> >I want a query that will provide one record per event with all times
> > included. feel free to answer RTFM or STFW as long as you provide the
> > manual section or key words. ;)
>
> Can be done with a pivot table. Examples under "Pivot
I'm trying to resolve a frustrating replication problem with my databases.
The master contains a number of schema, only using Innodb tables.
Updates happen regularly, usually using bulk inserts of the form
INSERT ... ON DUPLICATE UPDATE. Data is mostly numbers. The missing
queries contain no non
Benching
Somebody knows why 4.1 is faster than 5.0 mysql versions
Ing. Jaime Fuentes R.
997500459
2421905-2423252
Enviado desde mi BlackBerry de Claro.
-Original Message-
From: Brent Baisley
Date: Tue, 2 Jun 2009 12:32:39
To: Ray
Cc:
Subject: Re: Question about query - can this be d
>> [JS] So far as I know, Windows supports mount points but not symbolic
>> links.
>
>You are correct Jerry, Windows does not support symbolic links but for
>MySQL purposes you can create an .sym file containing the full path to
>the
>new location and MySQL will read the file and look in the specif
Ray,
I want a query that will provide one record per event with all times included.
feel free to answer RTFM or STFW as long as you provide the manual section or
key words. ;)
Can be done with a pivot table. Examples under "Pivot tables" at
http://www.artfulsoftware.com/infotree/queries.p
On Tue, Jun 2, 2009 at 11:52 AM, Ray wrote:
> Hello,
>
> I've tried the manual and google, but I am not even sure what to call what I
> want to do.
>
> simplified data example:
> I have a table of start and end times for an event, and an id for that event
> in a table. each event may occur multipl
Boosting Performance With MySQL 5.1 Partitioning
http://forge.mysql.com/wiki/Boosting_Performance_With_MySQL_5.1_Partitioning
This Thursday (June 4th, 14:00 UTC), Giuseppe Maxia will give a MySQL
University session on Boosting Performance With MySQL 5.1 Partitioning.
Giuseppe is leading the Commun
Hello,
I've tried the manual and google, but I am not even sure what to call what I
want to do.
simplified data example:
I have a table of start and end times for an event, and an id for that event
in a table. each event may occur multiple times, but never more than 5 times
and rarely more th
Thx john !! i can use this :)
-Ursprüngliche Nachricht-
Von: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
Gesendet: Dienstag, 2. Juni 2009 17:10
An: Jerry Schwartz
Cc: john.dais...@butterflysystems.co.uk; 'Foo JH';
schackenb...@termindoc.de; mysql@lists.mysql.com
Betreff: RE: AW
>
>
>>-Original Message-
>>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
>>Sent: Tuesday, June 02, 2009 6:30 AM
>>To: Foo JH
>>Cc: schackenb...@termindoc.de; mysql@lists.mysql.com
>>Subject: Re: AW: creating databases in different folders
>>
>>MySQL represents each database by
>-Original Message-
>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
>Sent: Tuesday, June 02, 2009 6:30 AM
>To: Foo JH
>Cc: schackenb...@termindoc.de; mysql@lists.mysql.com
>Subject: Re: AW: creating databases in different folders
>
>MySQL represents each database by means of
>From the sound of things, apart from using symbolic links, all MySQL
databases MUST reside within the same data root folder.
Some further questions:
1. On the *NIX, *BSD platform, do you guys locate the databases in diff
folders and link it back to the data root on production systems?
2. If I we
Guten Tag
http://dev.mysql.com/doc/refman/5.0/en/recovery-from-backups.html
Das heißt, können wir den Bediener mit a anstellen
--Maschinenbordbuchsortierfach Wahl, die eine Position auf einer
anderen körperlichen Vorrichtung von der spezifiziert, auf der das
Datenverzeichnis liegt. So, die Masch
John Daisley wrote:
> MySQL represents each database by means of a database directory located
> within the data directory. You can move a database directory to a location
> outside the datadirectory and replace it with a symlink.
Thanks for the tip John, esp. the detailed steps to take. It sounds
s
You might try and hack something together using NTFS juction points.
Unadvisable though, and probably unsupported.
Walter
On Mon, Jun 1, 2009 at 9:00 PM, Foo JH wrote:
> Hi all,
>
> I'm using MySQL 5.0 on Windows 2003.
>
> Problem background: We use the same server for different applications.
>
MySQL represents each database by means of a database directory located
within the data directory. You can move a database directory to a location
outside the datadirectory and replace it with a symlink.
Moving a database directory is very simple. Just follow these steps. (I
think you said you wer
I think, that will not work with one database daemon. Then you have to
install for every database one daemon ;)
-Ursprüngliche Nachricht-
Von: Foo JH [mailto:jhfoo...@extracktor.com]
Gesendet: Dienstag, 2. Juni 2009 11:49
An: schackenb...@termindoc.de
Cc: mysql@lists.mysql.com
Betreff: R
Hi,
Benedikt Schackenberg wrote:
You can configure it in the my.cnf file: there you can set the data
directory.
Thanks for the quick reply.
My concern is that setting the data directory puts ALL databases in that
folder. What I plan to do is to put databases in separate folders.
Is that po
Benedikt Schackenberg wrote:
> You can configure it in the my.cnf file: there you can set the data
> directory.
Thanks for the quick reply.
My concern is that setting the data directory puts ALL databases in that
folder. What I plan to do is to put databases in separate folders.
Is that possible
You can configure it in the my.cnf file: there you can set the data
directory.
-Ursprüngliche Nachricht-
Von: Foo JH [mailto:jhfoo...@extracktor.com]
Gesendet: Dienstag, 2. Juni 2009 05:00
An: mysql@lists.mysql.com
Betreff: creating databases in different folders
Hi all,
I'm using My
29 matches
Mail list logo
