tag:blogger.com,1999:blog-18337119.post488134436522007498..comments2024-01-22T07:09:30.574-05:00Comments on MySQL Consulting and NoSQL Consulting: MySQL DBA: Getting Best out of MySQL on SolarisUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-18337119.post-4260307831439995442008-12-16T19:14:00.000-05:002008-12-16T19:14:00.000-05:00For John uses a "REAL DBMS" - you have a misunders...For John uses a "REAL DBMS" - you have a misunderstanding on what a multi-threaded application is capable of. MySQL absolutely is capable of having multiple threads run simultaneously, by using multiple CPUs. I have had it scale far beyond the single thread throughput on 16 and 32-CPU systems. It may not scale linearly, but <BR/><A HREF="http://blogs.sun.com/allanp/entry/mysql_performance_optimizations" REL="nofollow"><BR/>we are working on that</A>.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-45880672021573365482008-03-19T05:07:00.000-04:002008-03-19T05:07:00.000-04:00They did some probes inhouse. They integrated with...They did some probes inhouse. They integrated with Chime (graphical tool) which allows you to look for MySQL IO wait time, InnoDB index scan, system calls, table scans etc. Start MySQL and fire off Chime and watch for goodness.<BR/><BR/>- Is the chime integration with mysql done inhouse? I downloaded and installed Chime and Mysql 6 (which has probes) but i didn't find any Chime MySQL integration.Katanafxhttps://www.blogger.com/profile/06405879012283000919noreply@blogger.comtag:blogger.com,1999:blog-18337119.post-50159528232906992792007-12-06T12:08:00.000-05:002007-12-06T12:08:00.000-05:00And what about SunFire T2000 server? One processor...And what about SunFire T2000 server? One processor and 32 threads :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-88472683514533585852007-11-08T15:05:00.000-05:002007-11-08T15:05:00.000-05:00Thanks for the information!!! I wanted to know how...Thanks for the information!!! I wanted to know how did you get the thread information??like thread 9 is a master thread or thread 10 is a single handler thread. Also, could you please let me know in detail about threads such as 7,8,9 and 10, which is unclear to me as what exactly they do???Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18337119.post-88449428179048929322007-05-20T13:57:00.000-04:002007-05-20T13:57:00.000-04:00MySQL does NOT use more than one CPU core regardle...MySQL does NOT use more than one CPU core regardless of version, hardware, or OS. It's a single process multi-threaded application, so if you're running only mysql on a 4 way box or a 2 way dual core box, you've wasted about 8 grand<BR/><BR/>If you want a DBMS that uses multiple processors and uses them efficiently, use PostgreSQL, SQL server, Oracle, Sybase, or some other REAL DBMSAnonymousnoreply@blogger.com