…. How 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… localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last errno 0 # Users user # Query_time distribution # 1us # 10us…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…| Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit,…IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. …10%. Sequential write results were a bit more interesting. With WT (write-through) cache enabled…
Post: Quick look at Ubuntu 6.06
June 13, 2006 By 3 Comments
… workload is CPU-bound and allows to compare CPU / OS if we are using the same version of MySQL. So I used MySQL 5… results (in transactions per sec, more is better): InnoDB threads Ubuntu 6.06 Suse 10.0 Suse/ Ubuntu ratio 1 478.66 536….30 357.09 1.04 MyISAM threads Ubuntu 6.06 Suse 10.0 Suse / Ubuntu ration 1 466.13 429.89 0…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
… opened in MySQL and although I told them this was not optimal, I had no solid arguments to present. More than once… = 32768 The desktop is running Ubuntu 10.04, has 8GB of RAM and a Core i5 CPU (dual core with HT enabled… CPU load on the laptop was never above 10%. I also hacked a bit the “run_mysql.sh” script to allow more processing…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…function of MySQL. For the benchmark, I used an old PII 350 MHz computer, I think for such CPU bound benchmarks, … up to the point, around 6.4MB where no more sort merge pass are required and then, the time …21-generic-pae #32-Ubuntu SMP Fri Apr 16 09:39:35 UTC 2010 i686 GNU/Linux MySQL: 5.1.41-…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 139 Comments
….86 Ghz Cpu – while nothing else is happening. The large table has 2 indexes on it and totals 3 GB – more than the ram in the machine – this done on Ubuntu 10. Is this normal – for…). MySQL works so fast on sume things, that I wonder if I have a real problem in my Ubuntu OS or Mysql 5…
