That's impossible to say with the limited information you've provided; however,
try this script for some basic tuning suggestions. It should make sure you're
not doing anything crazy:
https://launchpad.net/mysql-tuning-primer
Regards,
Gavin Towey
-Original Message--
Hi all,
I have a MySQL server with 1.7 GB of RAM, Some of the tables in my database use
MyISAM and others use InnoDB
Do you think the following mysql configurations are Ok? or should I change
something?
innodb_buffer_pool_size =712M
innodb_additional_mem_pool_size =20M
innodb_log_buffer_size =8
bruce a écrit :
Hi..
Fairly new to mysql, in particular tuning.
I have a test mysql db, on a test server. I've got a test app that runs on
multiple servers, with each test app, firing/accessing data from the central
db server.
the central server is on a 2GHz, 1GMem, 100G system. MySQL is the b
Hi..
Fairly new to mysql, in particular tuning.
I have a test mysql db, on a test server. I've got a test app that runs on
multiple servers, with each test app, firing/accessing data from the central
db server.
the central server is on a 2GHz, 1GMem, 100G system. MySQL is the basic app.
the remo
with persistent connections and PHP, you can easily trip over your own
connections.
- Original Message -
From: "Gregory T Pelle" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, September 12, 2006 12:50 PM
Subject: MySQL tuning advice
Hello,
I am looking for some advice regardi
I highly recommend Jeremy Zawodny's "High Performance MySQL"
from O'Reilly.
Dan
On 9/12/06, Gregory T Pelle <[EMAIL PROTECTED]> wrote:
Hello,
I am looking for some advice regarding the tuning of a dedicated MySQL
database server.
The machine in questions is a Dell 2850 with dual Xeon procs a
Hello,
I am looking for some advice regarding the tuning of a dedicated MySQL
database server.
The machine in questions is a Dell 2850 with dual Xeon procs and 4GB of
memory running FreeBSD 6.1. Its sole purpose in life is to run the
MySQL 5.0.x database engine serving out databases to mult
> - Original Message -
> From: "Deluxe Web" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Monday, February 28, 2005 11:44 AM
> Subject: Re: Mysql tuning - server Crash 1
>
> > Hi
> > I understand.. I should switch to debian :)
Max,
- Original Message -
From: "Deluxe Web" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 28, 2005 11:44 AM
Subject: Re: Mysql tuning - server Crash 1
Hi
I understand.. I should switch to debian :)
but in the meantime what about the in
p://www.innodb.com/order.php
>
> - Original Message -
> From: "Deluxe Web" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Monday, February 28, 2005 9:13 AM
> Subject: Re: Mysql tuning - server Crash 1
>
> > In my .err. file
rom: "Deluxe Web" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 28, 2005 9:13 AM
Subject: Re: Mysql tuning - server Crash 1
In my .err. file I have
key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=652
m
Donny,
- Original Message -
From: ""Donny Simonton"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, February 28, 2005 2:00 AM
Subject: RE: Mysql tuning - server Crash 1
Heikki,
I sent this to a few friends of mine who work on fedora quit
essage-
> > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, February 27, 2005 2:58 PM
> > To: mysql@lists.mysql.com
> > Subject: Re: Mysql tuning - server Crash 1
> >
> > Max,
> >
> > - Original Message -
> > From: &q
is currently down.
>
> Oh well.
>
> Donny
>
> > -Original Message-
> > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, February 27, 2005 2:58 PM
> > To: mysql@lists.mysql.com
> > Subject: Re: Mysql tuning - server Crash
s using mysql. But the site they sent me which
shows fedora beating all of them is currently down.
Oh well.
Donny
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Sunday, February 27, 2005 2:58 PM
> To: mysql@lists.mysql.com
> Subject: Re: M
Max,
- Original Message -
From: "Deluxe Web" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 27, 2005 2:17 PM
Subject: Re: Mysql tuning - server Crash 1
Hi Heikki,
http://lists.mysql.com/mysql/180583
http://lists.mysql.com/mysql/180581
Runn
ons, and row level locking for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
> tables
> http://www.innodb.com/order.php
>
>
> - Original Message -
> From: "Deluxe Web" <[EMAIL PROTECTED]>
> Newsgroups: mailing.d
://www.innodb.com/order.php
- Original Message -
From: "Deluxe Web" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 12:05 PM
Subject: Mysql tuning - server Crash 1
Hi there,
I have a problem with mysql. I have an application ba
Hi there,
I have a problem with mysql. I have an application basically to track
clicks to my website and last night it crashed. Can you have a look
aty my situation?
I run a server with 2GB RAM and a XEON processor!
Thank you.
- Max -
error log
-
InnoDB: Warning: a long semaphore wait:
--Thre
show status (now)
+--+--+
| Variable_name| Value|
+--+--+
| Aborted_clients | 1|
| Aborted_connects | 2|
| Bytes_received | 18819744 |
| Bytes_sent | 67675629 |
|
"Eko Budiharto" <[EMAIL PROTECTED]> wrote:
> I would like to study about how to tuning mysql for the best
> performance. I am looking for any books about it, so I can study about
> it offline.
> I am looking forward to a favorable reply from you. Thank you.=20
High Performance MySQL by Jeremy Zaw
You may want to take a look at "High Performance MySQL" by Jeremy D.
Zawodny and Derek J. Balling (http://www.oreilly.com/catalog/hpmysql).
- glenn
On Aug 9, 2004, at 10:42 AM, Eko Budiharto wrote:
Hi,
I would like to study about how to tuning mysql for the best
performance. I am looking for any
I've just made it through the MySQL Certification Study Guide and have
found it to have pretty good coverage of tuning as well as other
subjects. There are probably more in-depth sources available, but it
might be a good place to start.
- Dan-o
On Aug 9, 2004, at 12:42 AM, Eko Budiharto wrote:
Hi,
I would like to study about how to tuning mysql for the best
performance. I am looking for any books about it, so I can study about
it offline.
I am looking forward to a favorable reply from you. Thank you.
Regards,
Eko Budiharto
24 matches
Mail list logo
