List:Cluster« Previous MessageNext Message »
From:Subodh Nair Date:June 16 2010 11:17am
Subject:RE: MySQL cluster- migrating from WIndows to Linux
View as plain text  
Hello Geert,


This handle count is noticed in the task manager against the process mysqld
in the SQL node of the cluster.
I have also monitored this count by adding a counter for this process in
windows performance monitor.


****************************************************************************
****************************************************************








"(W. Europe Daylight Time)(-120)"" Processor Time"	"Handle Count"	"IO
Data Operations/sec"	"IO Other Bytes/sec"	"IO Write Bytes/sec"



"06/14/2010 03:00:32.126"	"4.6875600007680092"	"193347"	"0"
"322035.33953997504"	"0"
"06/14/2010 03:00:42.125"	"6.7188360011008141"	"193348"	"0"
"332346.05763422028"	"0"
"06/14/2010 03:00:52.125"	"1.0937640001792024"	"193353"	"0"
"45392.508526953425"	"0"
"06/14/2010 03:01:02.125"	"0.15625200002560033"	"193355"
"1.8994816480483387"	"6149.6218219156563"	"0"
"06/14/2010 03:01:12.125"	"12.187656001996826"	"193356"	"0"
"799533.48881605838"	"0"
"06/14/2010 03:01:22.125"	"1.7187720002816036"	"193359"
"3.0018187650463171"	"23113.404127103633"	"0"
"06/14/2010 03:01:32.125"	"4.8438120007936103"	"193360"	"0"
"279761.57689365523"	"0"
"06/14/2010 03:01:42.125"	"5.4688200008960113"	"193361"	"0"
"370781.25950540788"	"0"
"06/14/2010 03:01:52.125"	"0.93751200015360203"	"193366"	"0"
"42414.537525903324"	"0"
"06/14/2010 03:02:02.124"	"0.62500800010240132"	"193334"
"2.7029572208416117"	"6567.885718065023"	"0"
"06/14/2010 03:02:12.124"	"10.781388001766423"	"193353"
"0.1000117929388718"	"780372.51800239366"	"0"
"06/14/2010 03:02:22.124"	"2.1875280003584048"	"193356"
"2.9994744203693702"	"40417.017972151152"	"0"
"06/14/2010 03:02:32.124"	"3.9063000006400084"	"193357"	"0"
"361735.67414032947"	"0"
"06/14/2010 03:02:42.124"	"6.8750880011264144"	"193358"	"0"
"886188.46852090897"	"0"
"06/14/2010 03:02:52.124"	"0.93751200015360203"	"193363"	"0"
"40594.869839470754"	"0"
"06/14/2010 03:03:02.124"	"0.31250400005120066"	"193365"
"1.9009661400040454"	"13033.12390671721"	"0"
"06/14/2010 03:03:12.139"	"10.140535415077961"	"193384"	"0"
"792222.01567559526"	"0"
"06/14/2010 03:03:22.139"	"1.7187720002816036"	"193387"
"3.0000604712674224"	"21491.233191971307"	"0"
"06/14/2010 03:03:32.139"	"4.2188040006912084"	"193388"	"0"
"312642.70480338141"	"0"
"06/14/2010 03:03:42.139"	"7.5000960012288163"	"193389"	"0"
"474862.75765942514"	"0"
"06/14/2010 03:03:52.139"	"0.62500800010240132"	"193394"	"0"
"41303.62925076027"	"0"
"06/14/2010 03:04:02.138"	"0.15625200002560033"	"193397"
"2.7016371676932902"	"7066.2821030555615"	"0"
"06/14/2010 03:04:12.138"	"11.406396001868824"	"193398"	"0"
"799018.56073413952"	"0"
"06/14/2010 03:04:22.138"	"1.0937640001792024"	"193402"
"3.9961783016824799"	"25188.211548877298"	"0"
"06/14/2010 03:04:32.138"	"4.6875600007680092"	"193403"	"0"
"309200.93613806099"	"0"
"06/14/2010 03:04:42.138"	"5.9375760009728129"	"193404"	"0"
"372012.40870729444"	"0"
"06/14/2010 03:04:52.138"	"0.62500800010240132"	"193409"	"0"
"42037.274838884616"	"0"
"06/14/2010 03:05:02.138"	"0.46875600007680102"	"193395"
"9.5057581551431358"	"13696.896956051824"	"3417.7703295286742"
"06/14/2010 03:05:12.783"	"10.274772257500532"	"193414"	"0"
"773442.20657238178"	"0"
"06/14/2010 03:05:22.164"	"1.998696103960339"	"193417"
"2.9956730840223753"	"36961.613068362742"	 
****************************************************************************
****************************************************************

Thank you ,

Best Regards,
 
Subodh
 
ARS | Software Engineering Pvt Ltd – Subodh Nair, System Admin
131-135, Nila, Technopark, Trivandrum-695581; Tel: +91 0471 2527155, Ext
112; Mob: 9995007988- Web: www.arssoftware.com

-----Original Message-----
From: Geert.Vanderkelen@stripped [mailto:Geert.Vanderkelen@stripped] 
Sent: Wednesday, June 16, 2010 4:38 PM
To: Subodh Nair
Cc: Matt.Montgomery@stripped; cluster@stripped
Subject: Re: MySQL cluster- migrating from WIndows to Linux

Hello Subodh,

On Jun 16, 2010, at 12:59 , Subodh Nair wrote:
..
> We have a mysql-5.1.34 ndb-7.0.6 5 node cluster installed in a data center
> running mission critical applications. The cluster is installed on windows
> 2003 64 bit servers.
> It has been noticed that the handle count for the mysqld process nodes in
> the two SQL nodes increases gradually (around 4 to 5 handles every 10
secs)
> and within 10 days reaches very high numbers like 2,00000 and more. Only


What 'handle'-count is that? Can you say which one exactly?
Where do you see this?

-Geert

-- 
Geert Vanderkelen, MySQL Senior Support Engineer
Sun Microsystems GmbH     Sonnenallee 1, D-85551 Kirchheim-Heimstetten

Geschaeftsfuehrer: Jürgen Kunz                          HRB MUC 161028



Thread
[Fwd: RE: MySQL cluster- migrating from WIndows to Linux]Matthew Montgomery25 Mar
  • RE: MySQL cluster- migrating from WIndows to LinuxMatthew Montgomery25 Mar
    • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
      • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
        • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
          • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
            • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair16 Jun
              • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen16 Jun
                • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair24 Jun
                  • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen24 Jun
                    • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair25 Jun
  • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair29 Mar
    • RE: MySQL cluster- migrating from WIndows to LinuxStewart Smith29 Mar
      • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair29 Mar
        • RE: MySQL cluster- migrating from WIndows to LinuxAndrew Morgan29 Mar
          • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair31 Mar
            • Re: MySQL cluster- migrating from WIndows to LinuxGeert Vanderkelen31 Mar
              • RE: MySQL cluster- migrating from WIndows to LinuxSubodh Nair31 Mar