Atle Veka wrote:
Anyone have any experience to share about running mysql on a linux tmpfs
(using memory)?
tmpfs is swappable. I would use ramfs which is not swappable.
For us it's worked out pretty well and is normally operating lightning
fast compared to an identical SCSI based system. Howev
Andrey Dmitriev wrote:
> All,
>
> We are using group_concat but there seems to be some sort of display
> limit.
> Is there are a way to unset or increase it?
>
> Thanks,
> Andrey
>
You can change the maximum length by setting the group_concat_max_len
system variable to a higher value which is
Dominic Baines wrote:
> After a pretty long time I have returned to being a mysql DBA again after
> spending a lot of time with Oracle and MSSQL.
>
> I have several databases that I need to to work on, all various source builds
> from 4.1.16 to 4.0.20 and the average database contains some 200 o
MAS! wrote:
> does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works even
> for a cached result?
>
> this is my scenario, (I'm using MyIsam tables)
>
> thread 1:
> LOCK TABLE foo WRITE;
>
> thread 2:
> SELECT * FROM foo ;
> (locked)
>
> thread 1:
> UNLOCK TABLES;
>
> thread 2:
> res
