Hi,
tuning-primer send me some infos, I'll try this night some parameters to see :)
thanks
Nicolas
http://www.shivaserv.fr
Le 27 mars 2012 à 16:23, Jérôme Blion a écrit :
> On Tue, 27 Mar 2012 13:10:02 +0200, Nicolas wrote:
>> I tried, but no changes..
>>
>> Mysqltuner give it for "performanc
On Tue, 27 Mar 2012 13:10:02 +0200, Nicolas wrote:
> 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 /
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 pe
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
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
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 rec
> don't worry for your responses :)
>
> where are you ? I'm in france
>
Pittsburgh, PA, USA.
John
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
__
> If it's pollen, a good dustmask/halfmask works far better than any drug
> available - and the only side effect is looking a little odd. You'll usually
> notice the change within 15 minutes.
>
I may try this at home. At work I will have to tough this one out..
John
-
don't worry for your responses :)
where are you ? I'm in france
Nicolas
http://www.shivaserv.fr
Le 26 mars 2012 à 19:32, Alan Brown a écrit :
> On 26/03/12 17:21, John Drescher wrote:
>
>> BTW, Please excuse me for being very short on the replies today. I am
>> not feeling at all well today.
On 26/03/12 17:21, John Drescher wrote:
> BTW, Please excuse me for being very short on the replies today. I am
> not feeling at all well today. The pollen / changing whether has made
> it very difficult to breathe.
If it's pollen, a good dustmask/halfmask works far better than any drug
availabl
> On Mon, Mar 26, 2012 at 12:09 PM, Nicolas wrote:
>> good idea ! i'll try it asap and let you know.
>>
BTW, Please excuse me for being very short on the replies today. I am
not feeling at all well today. The pollen / changing whether has made
it very difficult to breathe.
John
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
---
good idea ! i'll try it asap and let you know.
Nicolas
http://www.shivaserv.fr
Le 26 mars 2012 à 17:20, John Drescher a écrit :
>> What do you want to say by "tune my database server" ?
>>
>
> Look into mysql guides for improving database performance. By default
> most distributions optimize
> What do you want to say by "tune my database server" ?
>
Look into mysql guides for improving database performance. By default
most distributions optimize their databases for machines with a
ridiculously low amount of ram like 32MB. Yes even in 2012 I see
my.cfg files that are optimized for 32 M
What do you want to say by "tune my database server" ?
On Mon,
26 Mar 2012 10:57:21 -0400, John Drescher wrote:
>> Is it normal that
the request is very long or is it a bug ? Server is with Xeon 2Ghz
CPU.
>
> Neither. You need to tune your database server.
>
> John
--
Nicolas
http://w
> Is it normal that the request is very long or is it a bug ? Server is with
> Xeon 2Ghz CPU.
>
Neither. You need to tune your database server.
John
--
This SF email is sponsosred by:
Try Windows Azure free for 90 days C
Hi,
I made a base job, on a server which have above 200.000
files. After, I made a full backup for trying deduplication. The backup
works well and create a full backup with a big deduplication (above
90%).
But, at the end of the backup, normally bacula show a status
message, but the console
17 matches
Mail list logo
