ahh, sorry. missunderstood that. i've seen many places they've put the
data into memory disks. i've thought that's being done here also.
On Wed, 21 May 2008 19:33:56 +0200
Tomasz Pajor <[EMAIL PROTECTED]> wrote:
> > > How the filesystem is relevant when tables are in memory?
> > first, they so
> > How the filesystem is relevant when tables are in memory?
> first, they somehow have to be put into the memory
> second, for consistency (yeah, this word is missing from toysql-users'
> vocabulary) it has to write the data to the disk. otherwise you'd lose
> anything on a crash
http://dev.mysq
On Wed, 21 May 2008 19:03:55 +0200
Tomasz Pajor <[EMAIL PROTECTED]> wrote:
> > > > May I ask whether you are using innodb or myisam? both on
> > > > freebsd and Linux. And what filesystem are you using for
> > > > mysql's data files? UFS, ZFS or anything else?
> > >
> > > MySQL engine used is ME
> > > May I ask whether you are using innodb or myisam? both on freebsd
> > > and Linux. And what filesystem are you using for mysql's data
> > > files? UFS, ZFS or anything else?
> >
> > MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant.
> sure it is relevant. check my results
On Wed, 21 May 2008 16:45:07 +0200
<[EMAIL PROTECTED]> wrote:
> > May I ask whether you are using innodb or myisam? both on freebsd
> > and Linux. And what filesystem are you using for mysql's data
> > files? UFS, ZFS or anything else?
>
> MySQL engine used is MEMORY, filesystem is ufs, but it's
> May I ask whether you are using innodb or myisam? both on freebsd and Linux.
> And what filesystem are you using for mysql's data files? UFS, ZFS or anything
> else?
MySQL engine used is MEMORY, filesystem is ufs, but it's not relevant.
> IIRC there's some hack to reduce gettimeofday()'s preci
> I'm using mysql 5.1.24-rc in 5 separate jails.
>
> Question:
>
> 10 clients are pushing queries (10 separate machines). 2 clients to 1 mysql
> daemon. One client is performing an update on param_stat_short_level_1_0,
> second on param_stat_short_level_1_1.
>
> Each client needs to push 15000
May I ask whether you are using innodb or myisam? both on freebsd and Linux.
And what filesystem are you using for mysql's data files? UFS, ZFS or anything
else?
IIRC there's some hack to reduce gettimeofday()'s precision in advance to
enhance it's performance, that could also help a bit. Have you
Hello,
I'm using mysql 5.1.24-rc in 5 separate jails.
Question:
10 clients are pushing queries (10 separate machines). 2 clients to 1 mysql
daemon. One client is performing an update on param_stat_short_level_1_0,
second on param_stat_short_level_1_1.
Each client needs to push 15 queries
