I tried, but no changes..
Mysqltuner give it for "performance" :
-------- Performance Metrics
-------------------------------------------------
[--] Up for: 2h 40m
21s (171K q [17.787 qps], 23 conn, TX: 31M, RX: 22M)
[--] Reads /
Writes: 0% / 100%
[--] Total buffers: 572.0M global + 2.7M per thread
(151 max threads)
[OK] Maximum possible memory usage: 987.2M (49% of
installed RAM)
[OK] Slow queries: 0% (1/171K)
[OK] Highest usage of
available connections: 1% (2/151)
[OK] Key buffer size / total MyISAM
indexes: 256.0M/130.9M
[OK] Key buffer hit rate: 99.3% (2M cached / 16K
reads)
[OK] Query cache efficiency: 56.9% (95 cached / 167 selects)
[OK]
Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 9%
(2 temp sorts / 21 sorts)
[!!] Temporary tables created on disk: 28% (11
on disk / 38 total)
[OK] Thread cache hit rate: 91% (2 created / 23
connections)
[OK] Table cache hit rate: 74% (52 open / 70 opened)
[OK]
Open file limit used: 8% (99/1K)
[OK] Table locks acquired immediately:
100% (237 immediate / 237 locks)
[!!] Connections aborted: 8%
On Tue,
27 Mar 2012 11:55:41 +0200, Jérôme Blion wrote:
> On Tue, 27 Mar 2012
10:28:01 +0200, Nicolas wrote:
>
>> Oups, I made a mistake on my conf,
parameters are not on [mysqld]... On Tue, 27 Mar 2012 09:45:54 +0200,
Nicolas wrote:
>>
>>> Hi, I try to optimize mysql with some infos find
on the web, but that not better :s For the backup, it take 11 min to
save datas, but 1 hour to update mysql table... My my.cnf : [mysqld]
datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql #
Disabling symbolic-links is recommended to prevent assorted security
risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid query_cache_size=32M
tmp_table_size=256M max_heap_table_size=256M thread_cache_size=4
table_cache=512 key_buffer_size=256M On Mon, 26 Mar 2012 12:13:28 -0400,
John Drescher wrote:
>>>
>>>> On Mon, Mar 26, 2012 at 12:09 PM,
Nicolas wrote:
>>>>
>>>>> good idea ! i'll try it asap and let you
know.
>>>> Also its best if you can have the database on a different
raid than the storage or put the database on an SSD. John M.
Drescher
>>> -- Nicolas http://www.shivaserv.fr [1] [2]
>
> Hello,
>
>
Each database server is different.
> If you want to perform some tuning,
you can help yourself with
> tuning-primer.sh + mysqltuner.pl.
> They
provide good metrics to start with. If you are facing table
> locking
issue, perhaps you should migrate to InnoDB (if you use Mysql
> 5.1,
use the InnoDB Plugin, not the embedded one)
>
> HTH.
> Jérôme Blion
(Lyon, France)
>
>
------------------------------------------------------------------------------
>
This SF email is sponsosred by:
> Try Windows Azure free for 90 days
Click Here
> http://p.sf.net/sfu/sfd2d-msazure [2]
>
_______________________________________________
> Bacula-users mailing
list
> Bacula-users@lists.sourceforge.net [3]
>
https://lists.sourceforge.net/lists/listinfo/bacula-users [4]
--
Nicolas
http://www.shivaserv.fr [5]
Links:
------
[1]
http://www.shivaserv.fr
[2] http://p.sf.net/sfu/sfd2d-msazure
[3]
mailto:Bacula-users@lists.sourceforge.net
[4]
https://lists.sourceforge.net/lists/listinfo/bacula-users
[5]
http://www.shivaserv.fr
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
