List:General Discussion« Previous MessageNext Message »
From:Manuel Arostegui Date:February 12 2014 1:08pm
Subject:Re: DBA: please review my.cnf [for Java Hibernate application] and
give suggestions
View as plain text  
2014-02-12 12:32 GMT+01:00 Lukas Lehner <weblehner@stripped>:

> Hi Antonio
>
> all tables use InnoDB. The size is 27 GB (not yet in prod). I guess in prod
> it will be fast 80GB.
>

Depending on how your application is going to use MySQL resources you will
need to tweak some things (and not only MySQL).
If it is going to be CPU bound, IO bound etc...there are different scenarios

Anyways, some general things to take a look at:

- Use file per table if possible. This won't give you extra performance,
but it will be good if you run into disk spaces issues or for future table
migrations.
- Make sure you have trx_commit and sync_binlog disabled (make sure you
understand what this means and what problems you could have during an un
expected crash)
- If you're expecting lot of temporary tables (filesorts), make sure tmpdir
runs over a fast disk.
- Use NUMA memory handling
- Make sure you test different disk schedulers (depending if you have RAID
and which kind of it) and see how they perform.
- You might want to take a look to smp irq affinity and see how it could
impact in your system.

Manuel.

Thread
DBA: please review my.cnf [for Java Hibernate application] and give suggestionsLukas Lehner12 Feb 2014
  • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsAntonio Fernández Pérez12 Feb 2014
    • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsAdarsh Sharma12 Feb 2014
      • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsLukas Lehner12 Feb 2014
    • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsLukas Lehner12 Feb 2014
      • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsAntonio Fernández Pérez12 Feb 2014
      • Re: DBA: please review my.cnf [for Java Hibernate application] andgive suggestionsManuel Arostegui12 Feb 2014