I am using MySQL 4.0.17 on QNX 6.2.1b.
I have noticed this in the last couple of days. There were two MySQL
clients running: one since 1:30 that morning; one at 1:30 the previous
morning. These are "reset master" commands we issue from cron to clean up
the transaction logs.
This morning I tried
On 02 Nov 2004 18:27:52 +0100, Harald Fuchs <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>,
>
>
> >> Maybe you should explain what you're trying to achieve, not what you
> >> think how to do it.
>
> > Sure. I am using MySQL to store packets for transmission. I want to
> > send the
On 02 Nov 2004 11:11:46 +0100, Harald Fuchs <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>,
>
> I guess this is an oversimplification. Often you can use a single SQL set
> operation instead of a loop. Your example would probably be the same as
>
> UPDATE packet
> SET timestamp
I am using the C API with MySQL 4.0.17 on QNX 6.2.1b.
I want to update the rows that are returned as I get them. Is this
possible. Here's a simplified version of what I am trying to do:
query = "select seqNo, priority from packet where timestamp < now() -
interval 15 second order by priority de
Never mind. I installed MySQL from a different location and now it
works.
...Stephen
> -Original Message-
> From: Stephen Rasku [mailto:[EMAIL PROTECTED]
> Sent: September 23, 2004 9:32 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL client hangs
>
>
> I am run
I reformated the hard
drive and reinstalled. In order to install, I copied the
/usr/local/mysql directory from a working system.
Stephen Rasku
Tantalus Systems Corp.
Your Power. Your Data. One Wireless Network.
T: 604-299-0458 x220 F: 604-451-4111
www.tantalus.com
--
MySQL General Mailing List
Originally I had developed this application for the Berkeley DB but they
wanted an outrageous amount of money for licencing since we were using
transactions. Memory and disk weren't really constraints when I
re-developed it. Time and cost were constraints though and MySQL was
the fastest thing I
I just looked into this. It looks like HEAP tables don't support the
BLOB field type and we are using it.
...Stephen
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Jul 30, 2004 6:19 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: Installing MySQL Databases
Flash drives have a limited number of writes that can be done before the
drive starts to fail:
http://www.kingston.com/tools/bits/bit17.asp
http://www.diskonkey.com/documents/Performance_reliability.pdf
(Look under "Flash Reliability")
If I can write the database to a RAM
Our customers are running MySQL 4.0.17 on QNX 6.2.1.
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive. We want to
install the database on the RAM disk on startup and save it to flash on
shutdown.
There are two datab
10 matches
Mail list logo
