Hi,
I was checking MySQL performance ... Sometimes my database could be working
slow. I have some queries that spend 9-10 seconds updating some columns by
primary key. I'm not sure if is a data base problem ...
Moreover, I have checked tuning scripts and appear these variables.
Good sentence!
- Original Message -
From: Antonio Fernández Pérez antoniofernan...@fabergroup.es
Subject: Re: Doubts tuning MySQL Percona Server 5.5
I was checking MySQL performance ... Sometimes my database could be working
slow. I have some queries that spend 9-10 seconds updating some columns
I'm missing something rather essential in your mail... are you actually
experiencing performance problems, or are you just looking at variables and
randomly deciding you don't like their value?
Always remember the golden rule: if it ain't broken, don't fix it.
On July 4, 2014 8:00:31 PM
Hi list,
I have some doubts adjusting some MySQL variables.
I have checked MySQL status and maybe I should to increase some variables
...
For example:
InnoDB log waits is 103; innodb_log_buffer_size is 8M -- Maybe the next
best value could be 16M?
Table cache hit rate is 12%; Open_tables is
Grant emailgr...@gmail.com wrote:
I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should
change any settings. I'm using mysql with a website on the same
server so I have skip-networking, and I increased key_buffer and
innodb_buffer_pool_size from 16M to 256M. Everything else
Good advice, all of it. What hasn't been said and should be noted: in
most cases, the bottleneck is the queries themselves. You will
generally get a lot more boost from tuning those than from any
configuration tweaking (excepting the pathological cases).
- michael dykman
On Thu, Feb 9, 2012
your
favourite performance graphing tool and ensure we have good graphs available
for all the most important key performance indicators that you can think of.
The more graphs, the easier it gets to spot bottlenecks and understand
root-causes of performance issues.
2. Monogamy
Tuning MySQL
Am 07.02.2012 00:55, schrieb Grant:
I'm running mysql on Gentoo with 4GB RAM and I'm wondering if I should
change any settings. I'm using mysql with a website on the same
server so I have skip-networking, and I increased key_buffer and
innodb_buffer_pool_size from 16M to 256M. Everything
Hello,
I have a mysql server where thousands of users connect. I configured max
connections but i didn't found how to configure concurrent raunning threads.
When i do show status, always RUNNING THREADS=1, even several threads are
pending.
How to change this please ?
Anyone can help me
If you are talking about MyISAM tables, in my.cnf you can set the
thread_concurrency=x
where x=2*# of CPU's
but this unfortunately only works on Solaris and not on Linux. It may work
on Windows, I'm not sure.
InnoDb has their own innodb_thread_concurrency variable that you can see
the value
]
Envoyé : mardi 8 septembre 2009 17:21
À : mysql@lists.mysql.com
Objet : Re: Tuning mysql concurrent running threads
If you are talking about MyISAM tables, in my.cnf you can set the
thread_concurrency=x
where x=2*# of CPU's
but this unfortunately only works on Solaris and not on Linux. It may work
hi all,
i developed a programm which needs my external mysql database server. now i
have to transfer a lot of data and i have todo a lot of select queues. how
can i tune that, so that it would be faster? in my monitoring system i saw,
that CPU load is 0, the only thing thats working when my
Jürgen Ladstätter wrote:
hi all,
i developed a programm which needs my external mysql database server. now i
have to transfer a lot of data and i have todo a lot of select queues. how
can i tune that, so that it would be faster? in my monitoring system i saw,
that CPU load is 0, the only
Scott Haneda wrote:
Unless I am totally off base here, the mysql docs tell very little in
regards to how to performance tune mysql.
So far I have found this article to help:
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3
But it still leaves me with a ton of
One of our engineers first installed MySQL on one of our Sun boxes
which was doing nothing more than MySQL... It seems we also put it on
the server and turned it on... it behaved very badly. Essentially
when we started to investigate MySQL and find out if we could use it
we discovered that
Hello.
I can tell, I have no my.cnf file in place, so there must be some default
Create your own and the appropriate value for the table_cache. See:
http://dev.mysql.com/doc/mysql/en/option-files.html
http://dev.mysql.com/doc/mysql/en/program-variables.html
Instead of your cron job, I suggest http://codenode.com/mysqlreport
The mysqlreport documentation (http://codenode.com/mysqlreportdoc)
is a pretty baseline introduction to comprehending server performance
via a mysqlreport report, and a little bit about what you can do for
certain issues.
Unless I am totally off base here, the mysql docs tell very little in
regards to how to performance tune mysql.
So far I have found this article to help:
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3
But it still leaves me with a ton of questions.
For starters, and
Are there any tools for finding hot spots in one's database? My screen
scraper is maxing out my CPU. I'm thinking I might need some secondary
indexes in some of my tables. I have a lot of two column tables consisting
of integer primary key and varchar in the second column. I repeatedly search
the
Here are two ways to find the queries:
1) 'SHOW FULL PROCESSLIST\G' in the mysql client and taking note of what
queries seem to be taking the most time
2) enable update logging and slow query logging
When you have gathered a list of queries that you want to look into
optimizing, run [in the
If you can, I recommend installing mytop
(http://jeremy.zawodny.com/mysql/mytop/) - it has helped me immensely to
identify which particular queries are putting the heaviest load on the
server.
I have a lot of two column tables consisting
of integer primary key and varchar in the second
I have a quad processor server, with 4 gigs of memory. It is only
running MySQL right now and seems really slow. Can someone give me a few
suggestions on optimizing My.cnf file for this system. We are running
mysql-standard-4.0.23-pc-linux-i68, on it. Here is the my.cnf file
# The
-Original Message-
From: Eric Gunnett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 11, 2005 9:36 AM
To: mysql@lists.mysql.com
Subject: Tuning MySQL
I have a quad processor server, with 4 gigs of memory.
It is only running MySQL right now and seems really slow. Can
matt ryan wrote:
There is a perl script that comes with MySQL called mysqldumpslow.
You can just run it on your slow log and it will output summary
statistics about the slow log.
I saw that in the docs, but I definitly dont want to install perl on a
production server, I never looked to see
Michael Sleman [EMAIL PROTECTED] wrote:
key_buffer = 384M
Try to enlarge this up to, say, 1G and check it out how that helps.
sort_buffer_size = 2M
You may want to enlarge this as well.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
My 5 cents... tuning the MySQL database config file is half a solution.
In my experience optimizing the application code and table/index
structure delivers performance results.
Michael Sleman wrote:
Hello,
We're running 1 web server (apache 2 php) / 1 dedicated DB server
(MySQL
I agree with Matthew. A database is a lot like a car. You can have a
well-built, high-powered vehicle that could do 200mph while still carrying
15 people (good hardware + good tuning) but if you drive it off-road,
alone, and in second gear (bad table structure, poor index coverage, poor
SQL
I went over your data. This is what I noticed first:
| Select_full_join | 0|
| Select_full_range_join | 0|
| Select_range | 1|
| Select_range_check | 0|
| Select_scan | 301 |
What command will provide this data?
--
This is part of the results of a SHOW STATUS command. See one of the
earlier posts for the full list of his settings.
Read These For More:
http://dev.mysql.com/doc/mysql/en/SHOW.html
http://dev.mysql.com/doc/mysql/en/SHOW_STATUS.html
Hmm
I'm guessing my stats arent too good, lots of full table scans, but this
is to be expected, my users can query any table by any column, and I
cant index all column combinations
Variable_name
Value
Resend, firefox did not send the way it looked when I typed it!
I'm guessing my stats arent too good, lots of full table scans, but this
is to be expected, my users can query any table by any column, and I
cant index all column combinations
Variable_name Value
Select_full_join
From: http://dev.mysql.com/doc/mysql/en/Server_status_variables.html
Key_reads
The number of physical reads of a key block from disk. If Key_reads is
big, then your key_buffer_size value is probably too small. The cache miss
rate can be calculated as Key_reads/Key_read_requests.
I've found the slow query log is useless to me, it's 50 meg right now.
Is there a tool that will identify common querys? I could probably
come up with some sql's if I load it into a table, but it would take
quite a while to sort out.
I posted a request on the mysql bugtraq to move it to a
Hi,
On Thursday, July 22, 2004, at 01:42 PM, matt ryan wrote:
I've found the slow query log is useless to me, it's 50 meg right now.
Is there a tool that will identify common querys? I could probably
come up with some sql's if I load it into a table, but it would take
quite a while to sort
There is a perl script that comes with MySQL called mysqldumpslow.
You can just run it on your slow log and it will output summary
statistics about the slow log.
I saw that in the docs, but I definitly dont want to install perl on a
production server, I never looked to see if I could do it
Hello,
We're running 1 web server (apache 2 php) / 1 dedicated DB server
(MySQL 4.0.20-standard) and are experiencing serious performance issues
on the DB during some load testing.
Hardware on both
Dual Xeon 2.8GHz, 2GB RAM
The database size is a little under 1 GB.
Naturally, we started
Hello,
I need some help tuning mysql. I'm running 3.23.58-Max-log on a Red Hat
Linux Enterprise server with 1 gig of memory and 4 cpus. The database is
used by a web application which runs on a separate machine. The performance
is not so good. Can anybody tell me if my configurations
The schema in question needs a redesign (dynamic row format, contains
two BLOB columns) but I was wondering if anyone has written up some
guidelines for general data warehouse configuration of MySQL 4.0 --
Google has not turned up anything useful.
An example table has 2.1M rows and is 365MB in
In the last episode (Jun 03), Dossy said:
The schema in question needs a redesign (dynamic row format, contains
two BLOB columns) but I was wondering if anyone has written up some
guidelines for general data warehouse configuration of MySQL 4.0 --
Google has not turned up anything useful.
On 2004.06.03, Dan Nelson [EMAIL PROTECTED] wrote:
Consider multicolumn indexes; if you always SELECT field1 from table
where field2=blah, creating an index on (field2,field1) will let mysql
bypass table lookups completely.
Our typical queries look something like:
SELECT level1, level2,
Hi Dan,
- Original Message -
From: Dan Nelson
Sent: Thursday, June 03, 2004 12:34 PM
Subject: Re: Tuning MySQL 4.0.20 for large full table scans
[snip]
Not sure what can be done about making it not go straight to tmpdir
with a BLOB column in the SELECT clause, though. Probably
On Friday 06 December 2002 01:11, Qunfeng Dong wrote:
Hi,
I wish to tune our MySQL Server Parameter to increase
the speed of Join. I was trying to do a simple join
with two tables. One is big (~2,500,000 records); the
other one is small. The current join seems to take
forever to finish even
Thanks! I copied
/usr/share/doc/mysql-server-3.23.49/my-huge.cnf into
/etc/my.cnf and restarted mysqld from
/etc/rc.d/init.d/mysqld
but it's not improving anything.
my join query is very simple
select count(B.columnb) from B left join A on
B.columnb = A.columna.
Both columna and columnb are
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Qunfeng Dong wrote:
Thanks! I copied
/usr/share/doc/mysql-server-3.23.49/my-huge.cnf into
/etc/my.cnf and restarted mysqld from
/etc/rc.d/init.d/mysqld
but it's not improving anything.
my join query is very simple
select count(B.columnb) from B
Hi,
I wish to tune our MySQL Server Parameter to increase
the speed of Join. I was trying to do a simple join
with two tables. One is big (~2,500,000 records); the
other one is small. The current join seems to take
forever to finish even on the indexed attribute.
I am trying to learn from
I wish to tune our MySQL Server Parameter to increase
the speed of Join. I was trying to do a simple join
with two tables. One is big (~2,500,000 records); the
other one is small. The current join seems to take
forever to finish even on the indexed attribute.
I am trying to learn from
Hi, All.
How can I add additional characters (Ukrainian alphabet) to the source code
for parse?
Thanks, Nick.
database,sql,query,table,handler,compile,ChangeSet
-
Before posting, please check:
On Wed, 27 Nov 2002 11:53:25 +0200
Nick Kostirya [EMAIL PROTECTED] wrote:
Hi, All.
How can I add additional characters (Ukrainian alphabet) to the source
code
for parse?
Thanks, Nick.
database,sql,query,table,handler,compile,ChangeSet
Just add a charset.
Take a look at
hi,
do you have hints/documents for me were to find information about mysql
server tuning (not table/index optimizing, but memory-tuning etc).
thx!
regards
Sönke Ruempler
top concepts Internetmarketing GmbH
--
http://www.topconcepts.com
I have a fairly decent server who is handling lots of connections, but very
simple SQL and I am looking for tuning advice. I have a pretty high number
of simultaneous connections and the box is showing a few signs of stress,
that I want to address before they become a problem. Any help will be
Vien Huynhle writes:
I am getting this error in my log files from mysql
(Got timeout reading communication packets)
I'm starting safemysql with the variables
-O key_buffer=16M -O sort_buffer=1M -O back_log=200
cut
Hi Vien,
Please increase the 'net_write_timeout' and
I am getting this error in my log files from mysql
(Got timeout reading communication packets)
I'm starting safemysql with the variables
-O key_buffer=16M -O sort_buffer=1M -O back_log=200
mysql show status
- ;
+--+--+
| Variable_name|
52 matches
Mail list logo