windows 8 - Shutting down mysqld in Cygwin -

-

how supposed shutdown mysqld faster cygwin (without killing process in task manager) , prevent these errors?

this how started it:

$ /usr/bin/mysqld_safe & [1] 4440  chloe@xps ~ $ 130809 17:27:09 mysqld_safe logging '/var/lib/mysql/xps.err'. chown: invalid user: `mysql' 130809 17:27:10 mysqld_safe starting mysqld daemon databases /var/lib/mysql

when try shut down, prints forever , won't respond ^c:

$ /usr/sbin/mysqld.exe shutdown 130809 17:29:26 [warning] setting lower_case_table_names=2 because file system /var/lib/mysql/ case insensitive 130809 17:29:26 [note] plugin 'federated' disabled. 130809 17:29:26 innodb: innodb memory heap disabled 130809 17:29:26 innodb: mutexes , rw_locks use gcc atomic builtins 130809 17:29:26 innodb: compressed tables use zlib 1.2.7 130809 17:29:26 innodb: initializing buffer pool, size = 128.0m 130809 17:29:26 innodb: completed initialization of buffer pool innodb: unable lock ./ibdata1, error: 11 innodb: check not have mysqld process innodb: using same innodb data or log files. 130809 17:29:26  innodb: retrying lock first data file innodb: unable lock ./ibdata1, error: 11 innodb: check not have mysqld process innodb: using same innodb data or log files.

it pretends shut down after 3 minutes of printing errors repeatedly, doesn't shut down because still in task manager , ps list. don't think should take long.

130809 17:31:06 [note] /usr/sbin/mysqld: shutdown complete

i tried 

$ mysqladmin shutdown

but appears hang.

i know user found how shutdown mysql, had same issue , first hit on google.

the trick add host as ip address , user on command (if used localhost host, command hang up).

 mysqladmin.exe -h 127.0.0.1 -u root shutdown

@chloe there few of scenarios might not work. 2 common think if mysql bound different ip or if it's bound different port (the other scenarios if mysql not using tcp, 1 of other transport protocols).

so, example, after run mysqld_safe & , mysql starts, when run command netstat can see it's listening , on default port 3306

$ netstat -an | grep 3306

i hope helps!

edit

if mysql not running, you'll need provide connection timeout (--connect-timeout=n) default mysqladmin waits forever connect server. example, if mysql not running

$ mysqladmin.exe -h 127.0.0.1 -u root --connect-timeout=5 shutdown  mysqladmin: connect server @ '127.0.0.1' failed error: 'can't connect mysql server on '127.0.0.1' (4)' check mysqld running on 127.0.0.1 , port 3306. can check doing 'telnet 127.0.0.1 3306'

here, command waits 5 seconds before giving up. point of view, doesn't make sense waits forever, that's default mysql picked :s.


Comments

Post a Comment

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

-
this svg contains rect overflows svg element: <svg id='svg' width='10' height='10'> <rect x='-10' y='-10' width='30' height='30'/> </svg> chrome 28 , opera 12 return getboundingclientrect() svg element width , height of 10. firefox 23 reports width , height of 30. correct? jsfiddle the relevant spec cssom , delegates svg spec if svg element not "have associated css layout box". haven't found definition of "having associated css layout box", correct result seem hinge on definition, getbbox returns 30x30 rect in browsers. this firefox bug fixed now, fix in firefox nightlies , should make through firefox 33 released on 14 october 2014. see bug 530985 details.
Read more

gcc - Calling fftR4() in c from assembly -

-
i trying asm fft implementation www.embeddedsignals.com work. running make gives error: undefined reference fftr4(short*, short*, int) at top of asm have .syntax unified .thumb .global fftr4 .type fftr4, %function and there #define's associate c functions arguments registers followed macros fftr4 function uses. after that, fftr4 called .thumb_func fftr4: stmfd sp!, {r4-r11, lr} mov tmp0, #0 // bit reversed counter mov tmp1, #0 .word 0xf3a2fa92 //rbit r3,r2 //rbit r,n lsl r,#3 and c code follows: void fftr4(short *y, short *x, int n); short x[512]; short y[512]; int i; void loop() { (i=0;i<512;i++) x[i]=0; (i=0;i<512;i=i+8) { x[i+0]=16384; x[i+2]=16384; x[i+4]=-16384; x[i+6]=-16384;} fftr4(y, x, 256); serialusb.println(y[128]); serialusb.println(y[129]); serialusb.println(y[384]); serialusb.println(y[385]); // expected results: //y[128]is 8191; y[129] -8190 y[...
Read more

.htaccess - Matching full URL in RewriteCond -

-
i'm trying block post access site (and return 403), except 2 ip's , 1 url ( http://mydomain.com/about-us/contact-us/ ). here's have: rewritecond %{request_method} post rewritecond %{remote_addr} !=1.2.3.4 rewritecond %{remote_addr} !=4.3.2.1 rewritecond %{request_uri} !^http://mydomain.com/about-us/contact-us/$ rewriterule ^ / [f] these rules allowing access ip properly, contact page still not accessible. i'm not sure i'm using request_uri correctly? i've tried variations relative urls rewritecond %{request_uri} !^/about-us/contact-us$ , rewritecond %{request_uri} !^/about-us/contact-us/$ without luck. what doing wrong please? it looks me rule on file name specific. if relax bit, should work. made few other esthetic tweaks. give try: rewritecond %{request_method} post rewritecond %{remote_addr} !^1.2.3.4 rewritecond %{remote_addr} !^4.3.2.1 rewritecond %{request_uri} !about-us/contact-us rewriterule ^ - [f]
Read more