We have executed a number of benchmarks using the thread pool
to
see how it operates in various workloads. A thorough study on
this
can be found in Dimitri's blog here.
Optimal number of active connections is the number of active
connections
needed to achieve the best throughput for the MySQL Server. For
an InnoDB
workload this is usually around 32-128 active connections.
From all our benchmarks we've seen that the performance of the
thread pool
when operated with less than the optimal number of active
connections is
about 1-3% slower than without thread pool since the behaviour is
the same
and the thread pool adds a little bit more overhead. More or less
all of
this overhead is to handle KILL query correctly.
When …
Due to some bad planning from my side, I failed to realize that I
only had 30 minutes for my presentation at Percona Live in London
on October 25, instead of the orginally planned 45 minutes. My
bad! So I had to rush through the presentation, and I still had a
bunch of slides I still wanted to show. To compensate for this,
and for your reference, here are all my slides on Cloud Computing
from the conference:
/Karlsson
The thread pool have three information schema tables. These are
TP_THREAD_STATE,
TP_THREAD_GROUP_STATE and TP_THREAD_GROUP_STATS.
The TP_THREAD_STATE table contains one row per thread that is
currently
maintained by the thread pool. This row contains only interesting
information
if the thread is actively executing a statement. In this case it
contains information
how many 10 milliseconds slots the query has consumed, if the
thread is blocked by
some event, the event is listed. Both of those information items
are current state
and will change for each new query.
The TP_THREAD_GROUP_STATE table contains one row per thread
group. It contains
information about number of threads of various types. The first
type is consumer
threads, this is a thread not used for the moment, at most 1 such
thread will
exist at any point in time. This is the next thread to use if …
In addition to the very successful MySQL Developer Day we held last week in London, and to the upcoming MySQL Roadshow in Germany, Oracle’s MySQL team is participating to and running more events in Europe!
1. LinuxCon Europe 2011:
Santo Leto from our top-notch MySQL technical support team will be talking about “What’s New in MySQL 5.6” on Friday at 4.45 pm. Don’t miss his talk if you’re around!
Also not to miss…Oracle’s MySQL Evening Reception on Thursday. Come get the details and your invitation at the Oracle booth.
You’ll find more information about Oracle’s overall presence at LinuxCon Europe in …
[Read more]We are happy to see that Percona Server/XtraDB and XtraBackup are raising popularity and to keep excitement we want to have more features and more performance fixes! If you are experienced software engineer and feel strong enough to hack InnoDB/XtraDB code we invite you to join our development team to work on the following (but not limited to) problems:
- Fix InnoDB flushing problems, e.g: http://www.mysqlperformanceblog.com/2011/09/18/disaster-mysql-5-5-flushing/
- Fix InnoDB index locking
- Figure out InnoDB adaptive locking issue, e.g: http://www.mysqlperformanceblog.com/2010/02/25/index-lock-and-adaptive-search-next-two-biggest-innodb-problems/
- Make …
In addition to the very successful MySQL Developer Day we held last week in London, and to the upcoming MySQL Roadshow in Germany, Oracle’s MySQL team is participating to and running more events in Europe!
1. LinuxCon Europe 2011:
Santo Leto from our top-notch MySQL technical support team will be talking about “What’s New in MySQL 5.6” on Friday at 4.45 pm. Don’t miss his talk if you’re around!
Also not to miss…Oracle’s MySQL Evening Reception on Thursday. Come get the details and your invitation at the Oracle booth.
You’ll find more information about Oracle’s overall presence at LinuxCon Europe in …
[Read more]With the recent cyber attacks and breaches with data from large organizations including Sony, is your MySQL data safe? What are the best practices for securing and administering your MySQL environment? In this presentation we will cover the essential steps for better MySQL security. We will also cover the different installation and administration tasks necessary to ensure your data is managed.
Presenter: Ronald Bradford
Schedule: Insight Out DB Showcase. October 2011 …
I work for a real estate website and we are running out of
property numbers for some of our listings. Many moons ago logic
in the code stated that listing types. For example
a Commercial listing or Residential listing ID start
with a different digit. Residential listings start with
a '1' and Commercial listings start with a '5' for
example.
Putting aside that logic for a second, we are in a situation
whereby our Commercial listings are now in the range of
599000. Meaning we only have a few new listings before, according
to the 'business' here, the world ends. (As the numbers will
rollover to 600000 and the hard coded numeric logic in the code
will blow up and cause a fire in the datacenters we run).
So the thoughts are to re-set the Auto Increment
value appending a few zeros to keep the logic of the
listing starting with a '5'. The change SQL is …
I was at Percona Live London 2011 these past two days. Very interesting conference. Good work Peter & team — you’ve managed to gather a good 300+ people at one venue in London. So full was the venue, that during today morning’s keynote I had to sit in the spillover room and miss out on Peter calling out my name :-) (no, Stewart and I were not drinking at 9am!)
Gave my session titled Why MariaDB? (slides). Pleasantly realized that there were many new faces. Better still, everyone has heard of MariaDB in the room. More interestingly is that a bunch of people are now also using MariaDB in production!
Had to rush through the last few …
[Read more]
And this was a great event! I'm at Heathrow catching a severely
delayed flight back home to Stockholm now. Before I board the
flight, I just letting you know that my slides will be on-line in
a very short time.
It was great to meet you all there, and Percona does a great job
of organizing these conferences and keeping the eco-system alive
and kicking!
Thanx Peter Z and the whole Percona crew!
/Karlsson