June 20, 2013

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

May 30, 2013 By 6 Comments

…. In general, there is no ordering implied between events, because multi-threaded slave may put events in a different order on one… of events missing. Well, if the user is not using multi-threaded slave, perhaps the notion of “last executed” and “specific point…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

May 30, 2013 By 6 Comments

@Kristian: Good point. I haven’t tried GTIDs in combination with multi-threaded slave yet, as enabling GTIDs only has provided a few surprises. So this hadn’t come to my mind. @Shlomi: Fixed, thanks!

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

…(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using identical code to…

Filed Under: MySQL Tagged With: , , , ,

Post: Percona Playback 0.6 for MySQL now available

April 9, 2013 By 1 Comment

… feature introduces new –thread-pool-threads-count option, which can be used to specify the number of threads in the thread pool dispatcher plugin… to the MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query parsing has been improved. Bug fixed #1080648 (Vlad…

Filed Under: MySQL Tagged With: , , ,

Post: Galera Flow Control in Percona XtraDB Cluster for MySQL

May 2, 2013 By 5 Comments

… transactions that have been certified but not yet applied, so multi-node writing will not lead to inconsistencies, but that is… the effect of some large transaction briefly stalling an applier thread. However, it is possible to halt queue applying on any… the slaves with no writes coming from them. However, with multi-node writing, larger queues will make certification more expensive replication…

Filed Under: Insight for DBAs, Percona Live, XtraDB Cluster Tagged With: , , ,

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

April 17, 2013 By 2 Comments

… slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would lead to… crash. Bug fixed #1132974 (Seppo Jaakola). Conflicting prepared statements in multi-master use case could cause node to hang. This was… if found. Bug fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work…

Filed Under: MySQL, XtraDB Cluster Tagged With: , ,

Comment: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?

April 10, 2013 By 2 Comments

… your page. You product sounds pretty cool, especially with the multi-core encrypt threads.

Filed Under: Cloud and NoSQL, Insight for DBAs, MySQL, Percona Software Tagged With: , , , ,

Post: MySQL Limitations Part 1: Single-Threaded Replication

October 20, 2010 By 16 Comments

… the solution that’s least evil. Why isn’t there multi-threaded replication? I think that a) it’s not as easy… the replication events to the appropriate thread. A pool of threads on the replica, and a coordinating thread that hands work to each… to have to default to single-threaded as replication currently does, and only enable the multi-threaded behavior if the user configures it…

Filed Under: Insight for Developers, MySQL Tagged With:

Post: MySQL Limitations Part 4: One thread per connection

October 27, 2010 By 14 Comments

… way. Windows in particular has had excellent threading support practically forever; Linux has very good threading now, but that wasn’t always… 5000 connections open, you get 5000 threads in the server. That increases the overhead from thread scheduling, and potentially memory usage as… listed those as major limitations. And because MySQL is a multi-threaded database for Web usage that tends to be used in…

Filed Under: Insight for Developers, MySQL Tagged With:

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

… is done by the aggregator and therefore it is single-threaded. Merging includes some CPU-intensive operations such as ranking, ordering… FROM table } index idx1 { type = plain source = src1 } searchd { dist_threads = 0 # default } And now we want it to utilize 3… { type = distributed local = idx1p0 local = idx1p1 local = idx1p2 } searchd { dist_threads = 3 } And you’re done. Of course, you need to…

Filed Under: MySQL Tagged With: , , ,
« Older Posts