Re: MySQL SMP Question
Hi, On Linux this feature is available in 2.6 through system calls. See: http://www.linuxjournal.com/article.php?sid=6799 On Windows it is also available at least as function calls See: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ dllproc/base/multiple_processors.asp On Solaris you have a command psrset available from Solaris 2.6 that will do the trick. See: http://www.platform.com/services/support/services/Procset.asp Rgrds Mikael 2004-05-26 kl. 11.40 skrev : Hi. We need to bind mysql-server process to a specific processor on dual pentium iii machine. Is it possible? Ilia. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Mikael Ronstrm, Senior Software Architect MySQL AB, www.mysql.com Clustering: http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html http://www.eweek.com/article2/0,1759,1567546,00.asp
Re: MySQL Cluster - queries execute with 6.60sec delay when one DB node is dead
Hi, This behaviour is due to a bug (#3657) which has been solved and the fix is on its way out. Rgrds Mikael 2004-05-19 kl. 13.35 skrev Maciek Dobrzanski: Hi, I have configured MySQL Cluster on two machines with 2 DB nodes (NoOfReplicas = 2) and 2 MySQL API nodes, one of each node type on both systems. The config is almost the same as the one of 2-node demo. The cluster is working fine as long as all DB nodes are operational, but if one of them is gone (i.e. I shut it down), all queries that are sent to the MySQL API nodes seem to hang for about 6.60sec before they are actually executed. As soon as the dead DB node becomes available again, everything starts to work as it supposed to. If one of DB nodes is dead: mysql SELECT * FROM t; ++---+ | id | name | ++---+ | 2 | test2 | | 1 | test1 | ++---+ 2 rows in set (6.60 sec) with all DB nodes working: mysql SELECT * FROM t; ++---+ | id | name | ++---+ | 2 | test2 | | 1 | test1 | ++---+ 2 rows in set (0.00 sec) It looks like MySQL is waiting for the dead node to respond, gets timed out after about 6 seconds and then requests the answer from the other node. I did not find anything in the Administrator Guide that would say about such behaviour, which makes the cluster rather useless in case of a node crash. Any ideas how to fix it? Regards, Maciek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com Clustering: http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html http://www.eweek.com/article2/0,1759,1567546,00.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NDB Cluster configuration
Hi, It sounds as if you if you have some problem with the configuration file. Have you introduced the second computer and its hostname into the configuration file? Also the node on the second computer need to refer to this second computer. If your problem continue please attach the configuration file. Rgrds Mikael 2004-05-11 kl. 02.43 skrev J Brian Ismay: I am trying to setup an NDB Cluster database for testing purposes. I have no problems getting things to work when all of my DB and API nodes are located on one machine. I run into trouble when I try to have one machine run the management server, a db node, and an API node, while the second machine runs another db node. The db node on the second machine appears to talk to the management node and seems to start properly, but the mgmtclient never shows it as actually being a part of the cluster. The same behavior is observed when trying to start an API node on a second machine. Can anyone help? J Brian Ismay [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com Clustering: http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html http://www.eweek.com/article2/0,1759,1567546,00.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
