Problem s MySQL a velkou zatezi.

[Tomas Randa]

Diky za popostrceni spravnym smerem.

Ty 2GB vyuzite nejsou..
MySQL je standardni instalace z portu, bezi pod uzivatelem mysql.
ulimit pod timto userem:

$ ulimit -a
cpu time               (seconds, -t)  unlimited
file size           (512-blocks, -f)  unlimited
data seg size           (kbytes, -d)  524288
stack size              (kbytes, -s)  65536
core file size      (512-blocks, -c)  unlimited
max memory size         (kbytes, -m)  unlimited
locked memory           (kbytes, -l)  unlimited
max user processes              (-u)  5547
open files                      (-n)  11095
virtual mem size        (kbytes, -v)  unlimited
sbsize                   (bytes, -b)  unlimited

mam tam neco nastavit jinak?

Diky Tomas Randa


Jiri Calda wrote:

> Tomas Randa wrote:
>
>>
>> #1041 - Out of memory; check if mysqld or some other process uses all 
>> available memory; if not, you may have to use 'ulimit' to allow 
>> mysqld to use more memory or you can add more swap space
>
>
> Dve otazky. Jak je to s vyuzitim pameti? Je z tech 2GB vyuzito vse, 
> neni, co?
> Jak jsou na tom systemove limity? Jako co bezi ten mysqld? A jaky 
> limit ma ten uzivatel?
> (ulimit -a)
>
> Jirka