…when the database is cold, but uses less CPU time when the database is hot. I … be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work …datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. We ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows a results comparison… optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the list of transactions, its applicability is quite limited. Namely… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file…is about 28GB and the file upload size limit is 5GB. So, about 28GB was written …22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22 UTC …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… place a limit on amount of queries system can ran, for example if we have query which requires 1 CPU second and… to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc… The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…of double buffering and I can save the limited amount of file system cache I would …files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should…(precise) Kernel | 3.2.0-35-generic Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL …
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… performance bottlenecks as well as where CPU resources are spent. (Performance Schema does not accounts CPU usage directly but it is something… addition to monitoring it which I’m sure hosting providers, MySQL as a Service vendors will especially appreciate as currently they… able to limit memory usage by individual MySQL users or even track how much these users are using. Now as MySQL 5.6…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU core count. He looked for a balance between utilizing the hardware as much as possible, limiting the system… storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly authenticated:…@localhost on 38 Query select @@version_comment limit 1 User not correctly authenticated: 121227 8…: 0 CONNECTED_TIME: 464 BUSY_TIME: 96 CPU_TIME: 19 BYTES_RECEIVED: 62869617 BYTES_SENT:…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… the trigger is immediate and affects every transaction. Finally, MySQL has limited trigger support, some of which is the cause of the… to maintain materialized views. Most database servers have some spare CPU for binary log parsing. Run the setup script: This will….test_demo. This because the source table is `test`.`demo`. mysql> select * from flexviews.test_demo\G *************************** 1. row *************************** dml_type: 1…
Post: Speaking at Percona Live London 2012: Choosing Hardware for MySQL
November 19, 2012 By 4 Comments
… talk about ‘Choosing Hardware For MySQL‘. Of course, the most important hardware components will be covered: CPU, Memory, Network, Disk Subsystem and also the Cloud. I will try to help attendees better understand how MySQL uses hardware… random IO operations on disk, what scalability means for MySQL, what it’s limitations are and so on… Want more? Just attend…
