Some months ago, I wrote a MySQL user-defined procedure (based on
sql_analyse.cc). It works well (has survived a test of 200M queries):
however, at the moment, I'm reviewing the code and trying to make it
more robust. As part of this, I'm trying to send error messages back to
the mysql client, and
Hi,
I'm currently experimenting with Cluster for the first time (using mysql
4.1.8 under Red Hat 9.) I've set up a combined manager and API node, and
three storage nodes. It all seems to be working fine (I can create
tables using "ENGINE=NDB" and see all three storage nodes from within
the ndb_mgm
eed to know
how long the event header is, and this is defined by the format
version!)
Help and ideas would be greatly appreciated, and apologies if I'm
missing something.
--
Peter Duffy <[EMAIL PROTECTED]>
Supanet Ltd.
--
MySQL General Mailing List
For list archives: h
In recent versions, you can do "select count(distinct theCol) ..." (I'm
actually running one at this moment!!)
On Mon, 2002-03-04 at 09:34, Rob wrote:
> Given a table with some non-unique column theCol, what is the most efficient
> way to count the number of different values in theCol? I guess
Hi Monty,
Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>
> Sinisa> Peter Duffy writes:
> >> Hi Sinisa,
> >>
> >> My problems are within the mysqlclient and
Hi Monty,
Michael Widenius wrote:
>
> Hi!
>
> I have a small comment to this.
>
>
> Note that you will get crashes in the DBUG package if you call any
> MySQL function inside a thread that hasn't called mysql_init() or
> mysql_connect().
>
> If you want to use MySQL functions in threads that
Hi Sinisa,
Sinisa Milivojevic wrote:
>
> Peter Duffy writes:
> > Hi Sinisa,
> >
> >
> > Do you know of any which are specifically accessed by multi-threaded
> > client applications via ODBC? (If so, I'd really like to know, so that I
> > can try t
Hi Sinisa,
Sinisa Milivojevic wrote:
> As an example, mysql server is a multi-threaded program and when
> compile --with-debug it uses DBUG function.
I know. As I said, one of my main problems is that MyODBC does not have
a --without-debug option.
>
> There are literally thousands and thousan
I realise that this issue is very specialised, and I'm not sure which
mailing list would be best to host a thread based on it, so I'm posting
it here to start with: I'm happy to move it to another mysql list if
someone would like to suggest one.
Over the last year, I've been working on a multi-th
database table sql query
OK, here's where I've got to.
1) After fiddling about with fdisk, disk geometry and kernel boot parms,
I've managed to define a partition which
appears to lseek as exactly 1000M (this was fairly horrible: if anyone
wants to replicate this step, I'll go over the process,
Christian Jaeger wrote:
>
> Just to the record: I've written a small program too, and it reports
> correct sizes for normal disk devices under both linux 2.2 and 2.4,
> as long as the partition sizes don't exceed the 2GB limit (I don't
> have large file support, since I use debian potato with jus
Hi,
In the InnoDB section of the MySQL manual, it mentions that InnoDB can
be used with raw disks, rather than data files. I've been trying to get
this to work under Linux (RedHat 6.2), but so far without success.
I installed a new slave disk on the second IDE bus, brought up the
system and veri
12 matches
Mail list logo
