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
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
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
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
