Dear MySQL users,
MySQL 5.5.23 is a new version of the 5.5 production release of the
world's most popular open source database. MySQL 5.5.23 is recommended
for use on production systems.
MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the MySQL D
Wrapping even just selects around a transaction absolutely matters,
depending if you care about isolation.
Consider the following two clients running on the same mysql instance, w/
--transaction_isolation=serializable. Suppose we have the following innodb
table:
CREATE TABLE FOO (i INTEGER, j INTE
Hello
COMMIT statements may or may not force the database to call fflush() to flush
your double-write to disk. This may or may not affect your performance,
depending on your scale, traffic, and how much you're trying to squeeze your
hardware. If you're working on the borderline like I am, benc
hm - my servers generally have no swap or better said
only a 500 MB swap-file, they are all virtual machines
in a ESXi cluster
you really do not want a VM swapping
this leads in unusaeable performance
in my case the problem was another process eating up all memory
by user-mistake and my hint is t
I had this same problem with the OOM for a while. Very frustrating to have
to reboot a server to bring it back to life.
I found out the OOM only ran when the swap file was about 99% full. The
servers I had this problem on had 16GB and 24GB of ram, but only 2GB of
swap. I increased the swap on the
Am 13.04.2012 15:47, schrieb Mihamina Rakotomandimby:
> On 04/13/2012 03:17 PM, Reindl Harald wrote:
>> with one single command you can protect processes from get killed
>> i started to run this every 15 minutes to make sure it is also
>> active after restarts
>
> I understand your issue, but is
On 04/13/2012 03:17 PM, Reindl Harald wrote:
with one single command you can protect processes from get killed
i started to run this every 15 minutes to make sure it is also
active after restarts
I understand your issue, but isn'there a configuration way to just limit
the memory usage of MySQL
Hi
you have to see the reason in the mysql log file,
that is a file either in the datadir with .err extension or in the /var/log
directory.
tail the last 30 lines you will see the reason why it failed to start.
Claudio
2012/4/11 Prabhat Kumar
> did you check permission of file /var/run/mysqld/
the following may be useful for most server systems
OOM-killer acts if some process reclaims more and more
memory and the kernel randomly kills unimportant tasks
using hughe memory
in case of a running mysqld the classification "unimportant"
is nearly all time wrong and can cause hughe damage and
Thank you Baron, Much appreciated.
On Fri, Apr 13, 2012 at 11:32 AM, Baron Schwartz wrote:
> If you were not at the Percona Live MySQL Conference over the last few
> days, the keynote videos are recorded for your convenience. You can
> see them at http://www.percona.tv/
>
> Presentations will be
Thanks Baron!
very much appreciated!
Claudio
2012/4/13 Baron Schwartz
> If you were not at the Percona Live MySQL Conference over the last few
> days, the keynote videos are recorded for your convenience. You can
> see them at http://www.percona.tv/
>
> Presentations will be posted at http://
11 matches
Mail list logo