On Monday, June 07, 2004 20:23, Justin Swanhart wrote
>> It can only ever return one row from table b, for
>> each row on table a, due
>> to the contents that is stored in table b. The
>> table contains in excess of
>> a million records. What happens as a result of the
>I assume that you have m
Hello all,
Thank you to everyone who assisted me.
I'm wondering about my theory around the between as posted previously.
Can anyone provide further insights regarding that theory?
Kind regards
Emmanuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
On Monday, June 07, 2004 19:09, Michael Stassen wrote;
> This doesn't quite make sense. You seem to say that several rows
> will match
> but then you say only one will. It must be one or the other.
> Perhaps I've
> misunderstood you.
Firstly, Micheal thank you for your assistance; I'll elaborat
On Monday, June 07, 2004 07:54, Jeff Smelser wrote;
> On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote:
> > I've looked in several books and searched Google but cannot get a way of
> > doing this. It seems Oracle has a 'FIRST' in their select
>
Daniel Kasak wrote on Tuesday, June 08, 2004 00:38;
> Emmanuel van der Meulen wrote:
>
> >Hello all,
> >
> >Does anyone have an estimate of when MySql 4.1 will be released for
> >production.
> >
> >MySql.cm says soon.
> >
> >Please advise,
Hello all,
Does anyone have an estimate of when MySql 4.1 will be released for
production.
MySql.cm says soon.
Please advise, would that likely be weeks/months?
Kind regards
Emmanuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
Hello all,
I see a similar question was asked before, but it was not answered. I hope
someone can assist me.
My query uses two tables. The query selects one row on table b for each row
on table a, but uses between in the select.
It can only ever return one row from table b, for each row on tabl
Hello Monty,
With your help I'm getting the understanding I was looking for, thank you.
On 27 January 2002 23:23, Michael Widenius wrote;
> Hi!
>
> >>>>> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes:
>
>
>
> >>
manuel van der Meulen [mailto:[EMAIL PROTECTED]]
> Sent: 21 January 2002 22:57
> To: MySQL General List
> Subject: MySQL 3.23.46 -> 4.01
>
>
> Hello all,
>
> Could someone please advise what is further required to upgrade
> from 3.23.46 -> 4.0.01. Here are the steps I
rds
Emmanuel
> -Original Message-
> From: Michael Widenius [mailto:[EMAIL PROTECTED]]
> Sent: 21 January 2002 00:44
> To: Emmanuel van der Meulen
> Cc: MySQL General List; MySQL Java List
> Subject: RE: Understanding throughput with JDBC
>
>
>
> Hi!
>
Hello all,
Could someone please advise what is further required to upgrade from
3.23.46 -> 4.0.01. Here are the steps I followed;
1. Download mysql-4.0.1-alpha-win.zip
2. unzipped
3. ran set-up & installed into d:\mysql-4.0.1\
4. start mysql-max with a bat file, maxstart and this is what ha
Hello all,
When downloading the pdf manual, I do not get sections;
6.9.1 How The Query Cache Operates
6.3.6.2 Miscellaneous Functions (or there is a 6.3.5.2 Miscellaneous
Functions) but its different)
Could someone please advise how the manual sections obtained by serching on
topics and the dow
Hello all,
I've been with MySQL for approx. a month now and have asked assistance with
several things, and;
I'm overwhelmed and acknowledge MySQl and the people of the mailing lists.
Thank you.
Kind regards
Emmanuel
-
Before
ROTECTED]]
> Sent: 21 January 2002 00:44
> To: Emmanuel van der Meulen
> Cc: MySQL General List; MySQL Java List
> Subject: RE: Understanding throughput with JDBC
>
>
>
> Hi!
>
> >>>>> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]>
Hello Dave,
Thank you. This works.
Kind regards
Emmanuel
> -Original Message-
> From: Adrian Monea [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2002 15:08
> To: 'Emmanuel van der Meulen'
> Cc: [EMAIL PROTECTED]
> Subject: RE: Understanding throughput with
Hello Nick,
Does ROWNUM exist in MySQL?
Kind reagrds
Emmanuel
> -Original Message-
> From: Nick [mailto:[EMAIL PROTECTED]]
> Sent: 19 January 2002 20:41
> To: Shankar Unni
> Cc: [EMAIL PROTECTED]
> Subject: [OT] Re: Understanding throughput with JDBC
>
>
>
> > With Oracle, the *only*
Hello Mark,
Thank you for the note and feedback. BTW, it was not over a network. Both
on local PC. So all the time went into building the resultset in memory.
I'm surprised at the time that takes.
Further to why I'm desirous to do this query, twofold. One I get the record
count (rows in the
rom: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: 19 January 2002 16:25
> To: Emmanuel van der Meulen
> Cc: [EMAIL PROTECTED]
> Subject: Re: Understanding throughput with JDBC
>
>
>
> ----- Original Message -
> From: "Emmanuel van der Meulen" <[EMAIL PROTE
Hello Jeremy,
Thank you for keeping correspondence.
Kind regards
Emmanuel
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2002 08:22
> To: Emmanuel van der Meulen
> Cc: [EMAIL PROTECTED]
> Subject: Re: Version 4 Schedule RE
Hello all,
Could anyone please assist me to understand this. I want to understand
where the time is going to and whether there is something I can do about it,
with the following query when using JDBC;
Here is the table declaration;
CREATE TABLE Memberships ("EMAIL CHAR(60) NOT NULL,
Hello all,
On 19 January 2002 09:28, Jeremy Zawodny wrote;
>
> On Sat, Jan 19, 2002 at 09:22:38AM +0200, Emmanuel van der Meulen wrote:
> > Hello all,
> >
> > To both above topics there have been answers, thank you, but these
> > answers are not clear at all.
&g
t;
> As Monty recently mentioned: if you mean "stable" as "well tested
> and suitable for production uses" - this is true for almost every
> MySQL version, even for alpha
> ones. :-)
Again this talks about the stability and approach, not the timing.
---
Hello all,
Is there a roadmap for MySQL releases, and in particular when it the eta for
4.1?
Kind regards
Emmanuel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello all,
Please advise location of the toc.
Kind reagrds
Emmanuel
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: 10 January 2002 16:59
> To: Rick Emery
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: Jeremy's MySQL Book
>
>
> On Thu, Jan 10, 2002 at 08:32:03AM
> Sent: 31 December 2001 16:34
> To: Emmanuel van der Meulen
> Cc: MySQL General List
> Subject: RE: Multiples instances of MySQL
>
>
> On Mon, 2001-12-31 at 14:01, Emmanuel van der Meulen wrote:
> > Hello Martin,
> >
> > [snip]
> > > Ok. Try to
Hello Martin,
[snip]
> Ok. Try to explicitly set the host on the command line:
>
> eg: mysqladmin -h 127.0.0.1 -P 2000 .
>
>
> Note that you should use the ip address of your host or its network
> name. Using 'localhost' won't do what you want.
I include commands of two instances which I
Hello Sammy & Martin,
Thank you for your notes and assistance.
** Martin;
> Try using the -S option to select the instance via the Unix domain
> socket rather than the port number (assuming this is a Unix
> installation).
** Sammy;
> use --socket instead of -P would solve your problem.
>
> with
Hello all,
I'm in a spot, I'm managing to successfully run several instances of MySQL,
say on port=3306 and port=3308.
When I use shutdown, the instance which started first shuts down.
To shutdown the instance started on port 3306, I use;
mysqladmin -P 3306 -u root -p2000 shutdown
And to shutd
Hello Roger;
[snip]
> * Emmanuel van der Meulen
> > I'm certain InnoDB is 100% safe. My concern is probably
> related to being
> > unfamiliar with MySQL/InnoDB. However, I take Heikki's point of
> > the access impact of DEV on PROD - never thought of tha
Hello Heikki,
Note, this is a duplicate posting - erroneously posted against 'General
database questions'.
Thank you very much for this note and your valued assistance.
I have the different instances of MySQL running with your proposal to add
the lot to
a bat file.
And yes, if such a option as
Hello Roger,
[snip]
> Yes, but is there really a big difference as long as the data is
> on the same
> disk & computer? I would keep PROD on a separate physical
> machine...
Yes, either on a separate physical machine or a different HDD (to curtail
costs, I'd first go for HDD).
> If the
> databa
Hello Heikki,
Thank you very much for this note and your valued assistance.
I have the different instances of MySQL running with your proposal to add
the lot to
a bat file.
And yes, if such a option as you propose exists, others would possibly get
multiple instances / my.cnf files working more
Hello Tony,
Thank you for your note and assistance.
However, I'm stuck on a particular point;
I use Win2k Pro; struggling with 3rd option below, 'server-specific
options', for multiple instances; MySQL does not see the \mysql\data\my.cnf
options file, for some reason it only sees c:\winnt\my.i
Hello Roger,
[snip]
> > Roger, I attempted adding additional space with a new file under
> > innodb_data_file_path as follows;
> > Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M
> > After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M
> > Stopped and restarted MySQL, but
Hello all,
Could someone please advise, what is the procedure to start and run more
than one instance of MySQL?
Kind regards
Emmanuel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
Hello Roger,
Thank you for your note and feedback. With your assistance and reading up
on InnoDB, I'm getting closer. Further inline;
On 29 December 2001 22:21, Roger Baklund wrote;
[snip-1]
> I think you would need to restart the mysqld server daemon, but
> this is very
> fast, and can be
Hello Roger,
Thank you for your note and replies. Please see my further points inline;
On 29 December 2001 16:21, Roger Baklund wrote;
> * Emmanuel van der Meulen
> > 1. Assuming the website grows very large with high volumes and
> a database
> > exceeds disk space, please
Hello all,
I have several questions in general since I recently started using MySQL.
>From the manual I cannot find where these questions are covered. I hope
someone can assist me.
Firstly though, if this is not the correct mailing list for my questions,
please advise correct one.
Secondly, t
Hello all,
I have several questions in general since I recently started using MySQL.
>From the manual I cannot find where these questions are covered. I hope
someone can assist me.
Firstly though, if this is not the correct mailing list for my questions,
please advise correct one.
Secondly, t
39 matches
Mail list logo