…posts on MySQL‘s unsolved severe limitations. I mean limitations that… servers get more and more CPUs and CPU cores…MySQL replication. Problem: you end up with an idle standby server… primary, one per database; one replication process per binary log…-purpose enough. Solution 2) has potentially complex …
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server…MySQL mysql> select forum_id as f from sptest order by author_id desc limit 10; +———+ | f | …=1; Empty set (2.70 sec) MySQL mysql> select max(author_id)…of rows per second (this is on rather outdated CPU I used for…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…pretty well in the MySQL manual here. Put …status\G” from the master. 2. SQL thread The second process…CPU thread. Note this assumes that there is no other activity happening on the server… it is reads that are limiting replication performance, not writes…. much more IO operations per second even with a…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… multiple cores becomes increasingly important as their number per CPU just keeps doubling. It is also rather … “Gotches” while many of them come from MySQL limits at the time when Innodb was first …2 SATA drives so they are far from optimal for server grade IO subsystems. These are for MySQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…CPU resources may be wasted. It should come to hundreds of thousands spin rounds per…; hex 61202020202020202020; asc a ;; *** (2) TRANSACTION: TRANSACTION…MySQL thread id 8079, query id 728899 localhost root Sending data select sql_calc_found_rows * from b limit…: waiting for server activity Number…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… limit, merging it to a neighbor is tried */ #define BTR_CUR_PAGE_COMPRESS_LIMIT (UNIV_PAGE_SIZE / 2)…flush and a checkpoint happens more than once per second. PZ: Not what this answers question exactly… CPU bound and you’re scaling out you can get better performance by using couple of MySQL Servers…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…CPU 3.40GHz. InfoBright (ICE) version: 5.1.14-log build number (revision)=IB_3.2_GA_5316(ice) MonetDB version: server…limited and I had to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql…per years +——+———+ | year | c1 | +——+———+ | 1989 | …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…per connection in average? This leads to the next question c. Can we have a limit…328 processes: 326 sleeping, 2 running, 0 zombie, 0 stopped CPU states: cpu user nice system …mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…have a server with 16GB of RAM which will be dedicated for MySQL with large…efficient value these days. From CPU standpoint 2*Dual Core CPUs seems to do …if you’re using innodb_file_per_table and a lot of …with current Innodb Scalability Fixes having limited concurrency helps. The actual number may…
Post: Effect of adaptive_flushing
December 4, 2009 By 5 Comments
… ~2GB of uncheckpointed data. mysql> SHOW INNODB STATUS\G …. And what about CPU, load average, and …this system near its limitations so I am…system is using 2 SSD’s for…per second == shorter lifetime, and so a shorter SSD lifetime is a negative side effect of enabling adaptive flushing on this server…
