2010/8/5 Rob Wultsch :
> 2010/8/5 Евгений Килимчук :
>> When OOM-killer kill mysqld, I had a critical corrupted tables. My database
>> is a very big. I think Apache with cgi-scripts not critical process in this
>> story. And sshd is a real true.
>>
>
> OOM is configurable via the proc filesystem vi
2010/8/5 Евгений Килимчук :
> When OOM-killer kill mysqld, I had a critical corrupted tables. My database
> is a very big. I think Apache with cgi-scripts not critical process in this
> story. And sshd is a real true.
>
OOM is configurable via the proc filesystem via /proc//oom_adj .
You can set t
On Thu, Aug 5, 2010 at 5:07 PM, Daevid Vincent wrote:
> Driving to work today, I had an epiphany thought, but wanted to see if
> anyone could prove my theory or not.
>
> We currently have some tables that are approaching 1 BILLION rows (real
> Billion, with nine zeros, not that silly six zero vers
Daevid Vincent wrote:
I'm wondering if we had the foresight to create the tables, and then tack
on extra "dormant" columns of various common types, such as:
Nothing beats empirical evidence. Why don't you try it and find
out (and report back)!
--
MySQL General Mailing List
For list archives:
Driving to work today, I had an epiphany thought, but wanted to see if
anyone could prove my theory or not.
We currently have some tables that are approaching 1 BILLION rows (real
Billion, with nine zeros, not that silly six zero version). Trying to do an
"ALTER" on them to add a column can someti
When OOM-killer kill mysqld, I had a critical corrupted tables. My database
is a very big. I think Apache with cgi-scripts not critical process in this
story. And sshd is a real true.
6 августа 2010 г. 0:09 пользователь Johan De Meersman
написал:
> You don't want to mess with OOM too much - you r
You don't want to mess with OOM too much - you risk it killing off other
useful/critical things, like SSH daemons, the Apache root, what have you.
Add more memory to the box or split the webserver off to another system, I'd
say.
2010/8/5 Евгений Килимчук
> I can't write my config parameters no
On Mon, Aug 2, 2010 at 8:35 PM, Johnny Withers wrote:
>
> Now when i run the same show table status command, the comment field says:
> InnoDB free: 6144 kB
>
> Is that telling me that I only have 6MB of storage left even though I
> increased the table space by 8GB?
>
I seem to recall - but am o
I can't write my config parameters now.
5 августа 2010 г. 23:02 пользователь Евгений Килимчук
написал:
> Mysql used 5GB (buffers + 400 connections) of memory, but CGI-script some
> time made heavy load when used many memory and used SWAP. OOM-killer must
> kill new cgi-forks, wich use many memory
Mysql used 5GB (buffers + 400 connections) of memory, but CGI-script some
time made heavy load when used many memory and used SWAP. OOM-killer must
kill new cgi-forks, wich use many memory, but it kill mysqld and sshd.
2010/8/5 Walter Heck - OlinData.com
> It would be a lot better to make sure y
It would be a lot better to make sure your server doesn't turn
OOM-psycho on you. The most common case of this happening is that you
have set the memory-settings in your my.cnf in such a way that it
allows MySQL to use more memory then you have available. Could you
post your my.cnf here by chance?
Hello!
I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs. MySQL use
75% (100% = 8GB) of memory. When cgi programs use more than 25% of memory
and all SWAP file (8GB), kernel run OOM-Kiler wich kill mysqld procces.
I use:
echo "0" > /proc/sys/vm/swappiness - This allows to reduce
Hi all, thanks for the feedback. Good information for me to work with :-)
The server in this case is a stand alone with nothing more then CentOS and
MySQL
5.1.44 on it. The drives are sas 10K rpm drives. The problem I see is that
when you stress test the server (typically by running loads of
Have you double checked the hardware? Are you using 5400rpm drives, or 15k
rpm drives? I/O bottlenecks are common, if you can't read the data fast
enough, then it will definitely be slower, and appear to have more issues
that it really does. If the client can't/won't change/alter the code, th
Hi Nunzio, all!
I cannot give specific hints, not being a MySQL tuning expert, but I
repeat my general question:
Nunzio Daveri schrieb:
> Hello Gurus :-) I was running a simple load generator against our 16GB Dual
> Quad core server and it pretty much came down to it's knees within two hours
15 matches
Mail list logo
