You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by benoit lair <ku...@gmail.com> on 2013/02/14 11:24:25 UTC

CS 4 Database integrity - mysql server performances

Hello,

I'm testing a cs 4 preproduction testing environment. I was asking me what
if mysql server go away or mysql server was not enough big for the cs mgmt
server requirements.

My mysql server has 2 Gb of ram, i ran the mysqltuner.pl and saw these
results :

[root@cloudstack-master-server ~]# ./mysqltuner.pl

 >>  MySQLTuner 1.2.0 - Major Hayden <ma...@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics
--------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.61-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics
-------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in InnoDB tables: 34M (Tables: 166)
[--] Data in MEMORY tables: 125K (Tables: 2)
[!!] Total fragmented tables: 166

-------- Security Recommendations
-------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics
-------------------------------------------------
[--] Up for: 55d 23h 4m 47s (175M q [36.356 qps], 120 conn, TX: 37B, RX:
16B)
[--] Reads / Writes: 90% / 10%
[--] Total buffers: 98.0M global + 18.6M per thread (350 max threads)
[!!] Maximum possible memory usage: 6.5G (353% of installed RAM)
[OK] Slow queries: 0% (0/175M)
[OK] Highest usage of available connections: 4% (15/350)
[OK] Key buffer size / total MyISAM indexes: 8.0M/92.0K
[OK] Key buffer hit rate: 99.6% (1K cached / 4 reads)
[OK] Query cache efficiency: 28.1% (14M cached / 52M selects)
[!!] Query cache prunes per day: 21931
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3M sorts)
[!!] Joins performed without indexes: 54279
[OK] Temporary tables created on disk: 0% (299 on disk / 3M total)
[OK] Thread cache hit rate: 70% (35 created / 120 connections)
[!!] Table cache hit rate: 1% (64 open / 3K opened)
[OK] Open file limit used: 0% (6/1K)
[OK] Table locks acquired immediately: 100% (17M immediate / 17M locks)
[OK] InnoDB data size / buffer pool: 34.1M/40.0M

-------- Recommendations
-----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Reduce your overall MySQL memory footprint for system stability
    Enable the slow query log to troubleshoot bad queries
    Adjust your join queries to always utilize indexes
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_size (> 32M)
    join_buffer_size (> 16.0M, or always use indexes with joins)
    table_cache (> 64)


Okay, i know i configured very too strongly certains buffers so theorically
i can override the physical capacity of this server.

But what about the query cache prunes per day ?
Other question, if i have connections aborted, is it dangerous for the cs
db integrity ?
Also if i reach the max connections ? Is ti dangerous too

What are the cases i must absolutely avoid in order to keep my cs db
integrity ?

Thanks for your answers.

Regards, Benoit Lair.

RE: CS 4 Database integrity - mysql server performances

Posted by Alex Huang <Al...@citrix.com>.
Specifically for the question of when max DB connections reach, CS will start to fail individual operations until DB connections are available again.  There are essential operations such as the cluster db ping that reserves their own db connections which is not supposed to fail.

--Alex

> -----Original Message-----
> From: Chiradeep Vittal
> Sent: Thursday, February 14, 2013 11:44 AM
> To: cloudstack-users@incubator.apache.org
> Cc: Alex Huang
> Subject: Re: CS 4 Database integrity - mysql server performances
> 
> +Alex since he is opinionated on this stuff.
> 
> In general CloudStack uses transactions and the framework ensures that
> cleanup happens if exceptions (expected or otherwise) are thrown. For
> long-running operations where locks are desired on a particular row,
> CloudStack does not use native row locking but uses a custom locking
> scheme. See here:
> http://support.citrix.com/article/CTX132018
> 
> 
> 
> On 2/14/13 10:46 AM, "benoit lair" <ku...@gmail.com> wrote:
> 
> >However, i already reached the max by default (100) which is not pretty
> >enormous.
> >
> >And i've seen in the manuals downloaded from cloudstack.org that the
> mysql
> >server should be configured with a max connections depending of
> differents
> >elements such as nodes, vms, networks (i don't remember which elemnt
> >exactly, but sure that there is a dependency of the configuration of mysql
> >according to the size of the deployment.
> >
> >So i need to cover the disaster scenarios in order to be sure to apply the
> >good disaster recovery procedures. Also i need to to be sure not to loss
> >datas acording to differents scenarios. The mysql server being the brain
> >of the cloud you build, it must absolutely keeping fully stable.
> >
> >Here are the reasons why i need to know if the code protect (transactions,
> >exception managing loss of connection or crash or querie out of the mysql
> >query cache) againt mysql failures.
> >
> >Si if there is still a doubt, so okay no problem, i will deploy a
> >redundant
> >solution and will consolidate my installation with per example a very big
> >cluster (lot of ram with an expensive configuration) under xcp covering
> >the
> >crash.
> >
> >Regards, Benoit.
> >
> >2013/2/14 Nik Martin <ni...@openfra.me>
> >
> >> I'm pretty sure the amount of connections to the DB is very low, even
> >>for a
> >> large scale CS deployment.
> >>
> >> Nik Martin
> >>
> >>
> >>
> >> On Thu, Feb 14, 2013 at 11:44 AM, benoit lair <ku...@gmail.com>
> >> wrote:
> >>
> >> > Per example, if i reach the max connections, does it will compromise
> >>the
> >> db
> >> > and so cs mgmt server ?
> >> >
> >> > 2013/2/14 benoit lair <ku...@gmail.com>
> >> >
> >> > > Okay guys,
> >> > >
> >> > >
> >> > > MariaDB would be an intersting alternative, but concerning the
> >>failures
> >> > > managements ? Cs code does protect the db integrity against mysql's
> >> > (oracle
> >> > > or mariadb one) failures ? Does cs manages transaction so anyway
> >>mysql
> >> > > crashes, i can go sleep  quietly, cs won't have a corrupted
> >>database (a
> >> > > missing record, or a insert not terminated belong 2  tables, so
> >>there
> >> > will
> >> > > missing a record so it will generating bugs (unrecoverable i mean)
> >>of
> >> the
> >> > > platform.
> >> > >
> >> > >
> >> > > Regards, Benoit
> >> > >
> >> > >
> >> > > 2013/2/14 Alexey Zilber <al...@gmail.com>
> >> > >
> >> > >> David,
> >> > >>
> >> > >> I have CS 3 running with MariaDB 5.2.  I'll have to test with CS 4
> >>and
> >> > the
> >> > >> latest MariaDB though.  A lot of the Oracle enterprise features
> >>are in
> >> > the
> >> > >> latest version.  Without the Oracle pricetag.  Personally I'd
> >>rather
> >> > >> support Monty then Ellison.  :)
> >> > >>
> >> > >> With CS 3, my management server is below minimum specs and still
> >>does
> >> a
> >> > >> decent job.  It's subjective though.
> >> > >>
> >> > >> -Alex
> >> > >> On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote:
> >> > >>
> >> > >> > On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <
> >> > alexeyzilber@gmail.com
> >> > >> >
> >> > >> > wrote:
> >> > >> > > CS should really switch to and recommend MariaDB instead of
> >> straight
> >> > >> > mysql.
> >> > >> > >
> >> > >> > > You will find your hardware goes much farther with it.
> >> > >> > >
> >> > >> > > -Alex
> >> > >> >
> >> > >> > While I am not personally a mysql fan, I'd love to hear your
> >> > >> > experiences with MariaDB and CloudStack.
> >> > >> >
> >> > >> > --David
> >> > >> >
> >> > >>
> >> > >
> >> > >
> >> >
> >>


Re: CS 4 Database integrity - mysql server performances

Posted by Chiradeep Vittal <Ch...@citrix.com>.
+Alex since he is opinionated on this stuff.

In general CloudStack uses transactions and the framework ensures that
cleanup happens if exceptions (expected or otherwise) are thrown. For
long-running operations where locks are desired on a particular row,
CloudStack does not use native row locking but uses a custom locking
scheme. See here:
http://support.citrix.com/article/CTX132018



On 2/14/13 10:46 AM, "benoit lair" <ku...@gmail.com> wrote:

>However, i already reached the max by default (100) which is not pretty
>enormous.
>
>And i've seen in the manuals downloaded from cloudstack.org that the mysql
>server should be configured with a max connections depending of differents
>elements such as nodes, vms, networks (i don't remember which elemnt
>exactly, but sure that there is a dependency of the configuration of mysql
>according to the size of the deployment.
>
>So i need to cover the disaster scenarios in order to be sure to apply the
>good disaster recovery procedures. Also i need to to be sure not to loss
>datas acording to differents scenarios. The mysql server being the brain
>of the cloud you build, it must absolutely keeping fully stable.
>
>Here are the reasons why i need to know if the code protect (transactions,
>exception managing loss of connection or crash or querie out of the mysql
>query cache) againt mysql failures.
>
>Si if there is still a doubt, so okay no problem, i will deploy a
>redundant
>solution and will consolidate my installation with per example a very big
>cluster (lot of ram with an expensive configuration) under xcp covering
>the
>crash.
>
>Regards, Benoit.
>
>2013/2/14 Nik Martin <ni...@openfra.me>
>
>> I'm pretty sure the amount of connections to the DB is very low, even
>>for a
>> large scale CS deployment.
>>
>> Nik Martin
>>
>>
>>
>> On Thu, Feb 14, 2013 at 11:44 AM, benoit lair <ku...@gmail.com>
>> wrote:
>>
>> > Per example, if i reach the max connections, does it will compromise
>>the
>> db
>> > and so cs mgmt server ?
>> >
>> > 2013/2/14 benoit lair <ku...@gmail.com>
>> >
>> > > Okay guys,
>> > >
>> > >
>> > > MariaDB would be an intersting alternative, but concerning the
>>failures
>> > > managements ? Cs code does protect the db integrity against mysql's
>> > (oracle
>> > > or mariadb one) failures ? Does cs manages transaction so anyway
>>mysql
>> > > crashes, i can go sleep  quietly, cs won't have a corrupted
>>database (a
>> > > missing record, or a insert not terminated belong 2  tables, so
>>there
>> > will
>> > > missing a record so it will generating bugs (unrecoverable i mean)
>>of
>> the
>> > > platform.
>> > >
>> > >
>> > > Regards, Benoit
>> > >
>> > >
>> > > 2013/2/14 Alexey Zilber <al...@gmail.com>
>> > >
>> > >> David,
>> > >>
>> > >> I have CS 3 running with MariaDB 5.2.  I'll have to test with CS 4
>>and
>> > the
>> > >> latest MariaDB though.  A lot of the Oracle enterprise features
>>are in
>> > the
>> > >> latest version.  Without the Oracle pricetag.  Personally I'd
>>rather
>> > >> support Monty then Ellison.  :)
>> > >>
>> > >> With CS 3, my management server is below minimum specs and still
>>does
>> a
>> > >> decent job.  It's subjective though.
>> > >>
>> > >> -Alex
>> > >> On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote:
>> > >>
>> > >> > On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <
>> > alexeyzilber@gmail.com
>> > >> >
>> > >> > wrote:
>> > >> > > CS should really switch to and recommend MariaDB instead of
>> straight
>> > >> > mysql.
>> > >> > >
>> > >> > > You will find your hardware goes much farther with it.
>> > >> > >
>> > >> > > -Alex
>> > >> >
>> > >> > While I am not personally a mysql fan, I'd love to hear your
>> > >> > experiences with MariaDB and CloudStack.
>> > >> >
>> > >> > --David
>> > >> >
>> > >>
>> > >
>> > >
>> >
>>


Re: CS 4 Database integrity - mysql server performances

Posted by benoit lair <ku...@gmail.com>.
However, i already reached the max by default (100) which is not pretty
enormous.

And i've seen in the manuals downloaded from cloudstack.org that the mysql
server should be configured with a max connections depending of differents
elements such as nodes, vms, networks (i don't remember which elemnt
exactly, but sure that there is a dependency of the configuration of mysql
according to the size of the deployment.

So i need to cover the disaster scenarios in order to be sure to apply the
good disaster recovery procedures. Also i need to to be sure not to loss
datas acording to differents scenarios. The mysql server being the brain
of the cloud you build, it must absolutely keeping fully stable.

Here are the reasons why i need to know if the code protect (transactions,
exception managing loss of connection or crash or querie out of the mysql
query cache) againt mysql failures.

Si if there is still a doubt, so okay no problem, i will deploy a redundant
solution and will consolidate my installation with per example a very big
cluster (lot of ram with an expensive configuration) under xcp covering the
crash.

Regards, Benoit.

2013/2/14 Nik Martin <ni...@openfra.me>

> I'm pretty sure the amount of connections to the DB is very low, even for a
> large scale CS deployment.
>
> Nik Martin
>
>
>
> On Thu, Feb 14, 2013 at 11:44 AM, benoit lair <ku...@gmail.com>
> wrote:
>
> > Per example, if i reach the max connections, does it will compromise the
> db
> > and so cs mgmt server ?
> >
> > 2013/2/14 benoit lair <ku...@gmail.com>
> >
> > > Okay guys,
> > >
> > >
> > > MariaDB would be an intersting alternative, but concerning the failures
> > > managements ? Cs code does protect the db integrity against mysql's
> > (oracle
> > > or mariadb one) failures ? Does cs manages transaction so anyway mysql
> > > crashes, i can go sleep  quietly, cs won't have a corrupted database (a
> > > missing record, or a insert not terminated belong 2  tables, so there
> > will
> > > missing a record so it will generating bugs (unrecoverable i mean) of
> the
> > > platform.
> > >
> > >
> > > Regards, Benoit
> > >
> > >
> > > 2013/2/14 Alexey Zilber <al...@gmail.com>
> > >
> > >> David,
> > >>
> > >> I have CS 3 running with MariaDB 5.2.  I'll have to test with CS 4 and
> > the
> > >> latest MariaDB though.  A lot of the Oracle enterprise features are in
> > the
> > >> latest version.  Without the Oracle pricetag.  Personally I'd rather
> > >> support Monty then Ellison.  :)
> > >>
> > >> With CS 3, my management server is below minimum specs and still does
> a
> > >> decent job.  It's subjective though.
> > >>
> > >> -Alex
> > >> On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote:
> > >>
> > >> > On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <
> > alexeyzilber@gmail.com
> > >> >
> > >> > wrote:
> > >> > > CS should really switch to and recommend MariaDB instead of
> straight
> > >> > mysql.
> > >> > >
> > >> > > You will find your hardware goes much farther with it.
> > >> > >
> > >> > > -Alex
> > >> >
> > >> > While I am not personally a mysql fan, I'd love to hear your
> > >> > experiences with MariaDB and CloudStack.
> > >> >
> > >> > --David
> > >> >
> > >>
> > >
> > >
> >
>

Re: CS 4 Database integrity - mysql server performances

Posted by Nik Martin <ni...@openfra.me>.
I'm pretty sure the amount of connections to the DB is very low, even for a
large scale CS deployment.

Nik Martin



On Thu, Feb 14, 2013 at 11:44 AM, benoit lair <ku...@gmail.com> wrote:

> Per example, if i reach the max connections, does it will compromise the db
> and so cs mgmt server ?
>
> 2013/2/14 benoit lair <ku...@gmail.com>
>
> > Okay guys,
> >
> >
> > MariaDB would be an intersting alternative, but concerning the failures
> > managements ? Cs code does protect the db integrity against mysql's
> (oracle
> > or mariadb one) failures ? Does cs manages transaction so anyway mysql
> > crashes, i can go sleep  quietly, cs won't have a corrupted database (a
> > missing record, or a insert not terminated belong 2  tables, so there
> will
> > missing a record so it will generating bugs (unrecoverable i mean) of the
> > platform.
> >
> >
> > Regards, Benoit
> >
> >
> > 2013/2/14 Alexey Zilber <al...@gmail.com>
> >
> >> David,
> >>
> >> I have CS 3 running with MariaDB 5.2.  I'll have to test with CS 4 and
> the
> >> latest MariaDB though.  A lot of the Oracle enterprise features are in
> the
> >> latest version.  Without the Oracle pricetag.  Personally I'd rather
> >> support Monty then Ellison.  :)
> >>
> >> With CS 3, my management server is below minimum specs and still does a
> >> decent job.  It's subjective though.
> >>
> >> -Alex
> >> On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote:
> >>
> >> > On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <
> alexeyzilber@gmail.com
> >> >
> >> > wrote:
> >> > > CS should really switch to and recommend MariaDB instead of straight
> >> > mysql.
> >> > >
> >> > > You will find your hardware goes much farther with it.
> >> > >
> >> > > -Alex
> >> >
> >> > While I am not personally a mysql fan, I'd love to hear your
> >> > experiences with MariaDB and CloudStack.
> >> >
> >> > --David
> >> >
> >>
> >
> >
>

Re: CS 4 Database integrity - mysql server performances

Posted by benoit lair <ku...@gmail.com>.
Per example, if i reach the max connections, does it will compromise the db
and so cs mgmt server ?

2013/2/14 benoit lair <ku...@gmail.com>

> Okay guys,
>
>
> MariaDB would be an intersting alternative, but concerning the failures
> managements ? Cs code does protect the db integrity against mysql's (oracle
> or mariadb one) failures ? Does cs manages transaction so anyway mysql
> crashes, i can go sleep  quietly, cs won't have a corrupted database (a
> missing record, or a insert not terminated belong 2  tables, so there will
> missing a record so it will generating bugs (unrecoverable i mean) of the
> platform.
>
>
> Regards, Benoit
>
>
> 2013/2/14 Alexey Zilber <al...@gmail.com>
>
>> David,
>>
>> I have CS 3 running with MariaDB 5.2.  I'll have to test with CS 4 and the
>> latest MariaDB though.  A lot of the Oracle enterprise features are in the
>> latest version.  Without the Oracle pricetag.  Personally I'd rather
>> support Monty then Ellison.  :)
>>
>> With CS 3, my management server is below minimum specs and still does a
>> decent job.  It's subjective though.
>>
>> -Alex
>> On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote:
>>
>> > On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <alexeyzilber@gmail.com
>> >
>> > wrote:
>> > > CS should really switch to and recommend MariaDB instead of straight
>> > mysql.
>> > >
>> > > You will find your hardware goes much farther with it.
>> > >
>> > > -Alex
>> >
>> > While I am not personally a mysql fan, I'd love to hear your
>> > experiences with MariaDB and CloudStack.
>> >
>> > --David
>> >
>>
>
>

Re: CS 4 Database integrity - mysql server performances

Posted by benoit lair <ku...@gmail.com>.
Okay guys,


MariaDB would be an intersting alternative, but concerning the failures
managements ? Cs code does protect the db integrity against mysql's (oracle
or mariadb one) failures ? Does cs manages transaction so anyway mysql
crashes, i can go sleep  quietly, cs won't have a corrupted database (a
missing record, or a insert not terminated belong 2  tables, so there will
missing a record so it will generating bugs (unrecoverable i mean) of the
platform.


Regards, Benoit

2013/2/14 Alexey Zilber <al...@gmail.com>

> David,
>
> I have CS 3 running with MariaDB 5.2.  I'll have to test with CS 4 and the
> latest MariaDB though.  A lot of the Oracle enterprise features are in the
> latest version.  Without the Oracle pricetag.  Personally I'd rather
> support Monty then Ellison.  :)
>
> With CS 3, my management server is below minimum specs and still does a
> decent job.  It's subjective though.
>
> -Alex
> On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote:
>
> > On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <al...@gmail.com>
> > wrote:
> > > CS should really switch to and recommend MariaDB instead of straight
> > mysql.
> > >
> > > You will find your hardware goes much farther with it.
> > >
> > > -Alex
> >
> > While I am not personally a mysql fan, I'd love to hear your
> > experiences with MariaDB and CloudStack.
> >
> > --David
> >
>

Re: CS 4 Database integrity - mysql server performances

Posted by Alexey Zilber <al...@gmail.com>.
David,

I have CS 3 running with MariaDB 5.2.  I'll have to test with CS 4 and the
latest MariaDB though.  A lot of the Oracle enterprise features are in the
latest version.  Without the Oracle pricetag.  Personally I'd rather
support Monty then Ellison.  :)

With CS 3, my management server is below minimum specs and still does a
decent job.  It's subjective though.

-Alex
On Feb 14, 2013 11:10 PM, "David Nalley" <da...@gnsa.us> wrote:

> On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <al...@gmail.com>
> wrote:
> > CS should really switch to and recommend MariaDB instead of straight
> mysql.
> >
> > You will find your hardware goes much farther with it.
> >
> > -Alex
>
> While I am not personally a mysql fan, I'd love to hear your
> experiences with MariaDB and CloudStack.
>
> --David
>

Re: CS 4 Database integrity - mysql server performances

Posted by David Nalley <da...@gnsa.us>.
On Thu, Feb 14, 2013 at 10:07 AM, Alexey Zilber <al...@gmail.com> wrote:
> CS should really switch to and recommend MariaDB instead of straight mysql.
>
> You will find your hardware goes much farther with it.
>
> -Alex

While I am not personally a mysql fan, I'd love to hear your
experiences with MariaDB and CloudStack.

--David

Re: CS 4 Database integrity - mysql server performances

Posted by Alexey Zilber <al...@gmail.com>.
CS should really switch to and recommend MariaDB instead of straight mysql.

You will find your hardware goes much farther with it.

-Alex
On Feb 14, 2013 6:24 PM, "benoit lair" <ku...@gmail.com> wrote:

> Hello,
>
> I'm testing a cs 4 preproduction testing environment. I was asking me what
> if mysql server go away or mysql server was not enough big for the cs mgmt
> server requirements.
>
> My mysql server has 2 Gb of ram, i ran the mysqltuner.pl and saw these
> results :
>
> [root@cloudstack-master-server ~]# ./mysqltuner.pl
>
>  >>  MySQLTuner 1.2.0 - Major Hayden <ma...@mhtx.net>
>  >>  Bug reports, feature requests, and downloads at
> http://mysqltuner.com/
>  >>  Run with '--help' for additional options and output filtering
> Please enter your MySQL administrative login: root
> Please enter your MySQL administrative password:
>
> -------- General Statistics
> --------------------------------------------------
> [--] Skipped version check for MySQLTuner script
> [OK] Currently running supported MySQL version 5.1.61-log
> [OK] Operating on 64-bit architecture
>
> -------- Storage Engine Statistics
> -------------------------------------------
> [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
> [--] Data in InnoDB tables: 34M (Tables: 166)
> [--] Data in MEMORY tables: 125K (Tables: 2)
> [!!] Total fragmented tables: 166
>
> -------- Security Recommendations
> -------------------------------------------
> [OK] All database users have passwords assigned
>
> -------- Performance Metrics
> -------------------------------------------------
> [--] Up for: 55d 23h 4m 47s (175M q [36.356 qps], 120 conn, TX: 37B, RX:
> 16B)
> [--] Reads / Writes: 90% / 10%
> [--] Total buffers: 98.0M global + 18.6M per thread (350 max threads)
> [!!] Maximum possible memory usage: 6.5G (353% of installed RAM)
> [OK] Slow queries: 0% (0/175M)
> [OK] Highest usage of available connections: 4% (15/350)
> [OK] Key buffer size / total MyISAM indexes: 8.0M/92.0K
> [OK] Key buffer hit rate: 99.6% (1K cached / 4 reads)
> [OK] Query cache efficiency: 28.1% (14M cached / 52M selects)
> [!!] Query cache prunes per day: 21931
> [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3M sorts)
> [!!] Joins performed without indexes: 54279
> [OK] Temporary tables created on disk: 0% (299 on disk / 3M total)
> [OK] Thread cache hit rate: 70% (35 created / 120 connections)
> [!!] Table cache hit rate: 1% (64 open / 3K opened)
> [OK] Open file limit used: 0% (6/1K)
> [OK] Table locks acquired immediately: 100% (17M immediate / 17M locks)
> [OK] InnoDB data size / buffer pool: 34.1M/40.0M
>
> -------- Recommendations
> -----------------------------------------------------
> General recommendations:
>     Run OPTIMIZE TABLE to defragment tables for better performance
>     Reduce your overall MySQL memory footprint for system stability
>     Enable the slow query log to troubleshoot bad queries
>     Adjust your join queries to always utilize indexes
>     Increase table_cache gradually to avoid file descriptor limits
> Variables to adjust:
>   *** MySQL's maximum memory usage is dangerously high ***
>   *** Add RAM before increasing MySQL buffer variables ***
>     query_cache_size (> 32M)
>     join_buffer_size (> 16.0M, or always use indexes with joins)
>     table_cache (> 64)
>
>
> Okay, i know i configured very too strongly certains buffers so theorically
> i can override the physical capacity of this server.
>
> But what about the query cache prunes per day ?
> Other question, if i have connections aborted, is it dangerous for the cs
> db integrity ?
> Also if i reach the max connections ? Is ti dangerous too
>
> What are the cases i must absolutely avoid in order to keep my cs db
> integrity ?
>
> Thanks for your answers.
>
> Regards, Benoit Lair.
>