… I see here is that this is an 8-core machine, two quad-core processors at 2GHz. I also know some things about… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up till… meaningless. On the other hand, pinging can be a serious performance problem. Not really for the server, since it’s a cheap…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…. PZ: memlock already works – it is global MySQL Server option, though it may have problems on Linux if you lock very large… has typically had problems scaling on multicore boxes. The new quad core CPUs from AMD and Intel means that 8-core boxes are going… you’re scaling out you can get better performance by using couple of MySQL Servers on single node. You can make them…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…Linux AS release 4 (Nahant Update 4) 2 Ñ… Quad Core Intel XEON cpu family : 15 model : 6 model name :…cache size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM / …solve this problem, I do not know Oracle plans about. It is also interesting to check PBXT performance on …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…performance gain there might be. HT: I guess the log writes themselves are much more a problem… HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-). At the…Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…performance>. The next,
Comment: Innodb Performance Optimization Basics
March 30, 2009 By 70 Comments
… the data. Our server is Quad Dual Core 4GB Ram, Server 2003 and using MySQL 5.0. Query cache size … cache helps a lot but one of the problems I am facing is somewhat similar as discussed above…is increasing rapidly. I have got hold of High Performance MySQL but any hints where should I be looking …
Comment: MySQL random freezes could be the query cache
March 27, 2009 By 23 Comments
… the data. Our server is Quad Dual Core 4GB Ram, Server 2003 and using MySQL 5.0. Query cache size … cache helps a lot but one of the problems I am facing is somewhat similar as discussed above…is increasing rapidly. I have got hold of High Performance MySQL but any hints where should I be looking …
