…, my problems are, the mysql process always use 1 cpu core at 1 time and it used 100% of the cpu resource. I’am not sure… are my server ‘TOP’ status, as you can see cpu4 use 100% usage while others like at idle state. top – 18:27…, 276k used, 4096256k free, 6326856k cached PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND 11395 mysql 16 0 100 39700…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
…every second MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound … Basically as soon as you have more than 100 rows analyzed by the query and these rows…) also becomes very important – if Innodb tables are used having simply auto_increment id on messages …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
…, the CPU load on the laptop was never above 10%. I also hacked a bit the “run_mysql.sh” script to allow more processing threads (100) instead of the max … am curious as to where MySQL is spending its time, I am planning to use profiling tools to identify …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…Sysbench should run completely in memory and use a lot of CPU resources but none of disk IO…this test system. It is worth to note MySQL actually uses midpoint insertion for its buffer pool replacement policy…about 325 req/sec for sysbench and some 100 seconds for mysqldump which is a dramatic …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… might be planned to be changed or not 100% correct but anyway you might find it interesting…. find good or bad would base of my MySQL use with existing applications – if you design new applications… so we can forget about spinlocks wasting CPU time on single CPU boxes without much of the gain….
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
… 2 reads and 1 write. Using memcached combined with MySQL we ended up nearly getting a 10X …, MySQL gets hammered. This type of thing happens a lot. For example an application is CPU bound… this app. What is very interesting is accessing 100% of the data in memcached gives very similar …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…that executing pt-query-digest can be pretty CPU and memory consuming, so ideally you would want…can use to gather more data about the underlying tables involved and the query execution plan used by MySQL….0 # Boolean: # Filesort 100% yes, 0% no # Tmp table 100% yes, 0% no # Tmp table on 100% yes, 0% …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model… 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin,… on https://launchpad.net/perconatools), with 100 Warehouses (about 9.5GB datasize). The … in memory is one we use…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… all queries. I think the problem that engine can use only single cpu/core is getting significant limitation for them. For query… time is better) Conclusions InfiniDB is doing just great using available CPU cores full IO bandwidth reading from disk. You can see… scalability on InfiniDB’s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html SSB…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… of RAM which we used for testing. Even though box had 8 cores it is little use for MySQL as only one query… are frequently used for these kind of queries, and there is also no query parallelization which would allow MySQL to use CPUs and… for MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half of system CPU…
