Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ChoiSaehoon schrieb: I tried it, then it gives the following error message mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls z*' doesn't exist) What does 'ls' mean? (as in linux command 'ls'?) you have to use the ` sign, not the ' Uwe :) Date: Sun, 19 Apr 2009 08:53:36 -0500 Subject: Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*) From: jlyons4...@gmail.com To: saeho...@hotmail.com CC: mysql@lists.mysql.com try something like: mysqldump -u(user) -p (db-name) `ls z*` (filename) 2009/4/19 ChoiSaehoon saeho...@hotmail.com Is there a way to dump only specific tables starting with a certain character? For example, I only want to dump tables starting with the character 'z'. The following doesn't work. mysqldump -u(user) -p (db-name) z* (filename) Do I have to use regular expression here? Please help thanks in advance. _ MSN 메신저의 차세대 버전, Windows Live Messenger! http://windowslive.msn.co.kr/wlm/messenger/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com _ 강력해진 보안성, 아웃룩을 닮아 편리해진 기능들로 무장한 Windows Live Hotmail! 지금 로그인해 보세요! http://www.hotmail.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIVAwUBSes1W0JXG7BUuynnAQJWExAAuzKonpnWPeynnFyvodfGYSP1p9A5ybC6 Azi0j4iGk237HlJ8I8OKh+aBsQGnykzGEQ5eE4xAAaL7bocFlYjHkvaIAhqxzg7c /ZaS9j8k+sGrteAsiA1y8fTj4L3uzLJP+0+crm1yKGKO8Jl9BKxqWl+x3Di6XMYF 1R8OdgBDY1mClUZEqbbBtm0pOs6N/SGcLGyiZNH5xEyRrnXbrh24WY0OQov5pDPj T2G0vC2GpZOZEN1qQeJp5G2ZZ+8gPvZhW+cMElvLNVF3aWkWyd/hEFIxG0cBZ/cR afcreK3AcnAP80ng8150cFN+y5nMR5GExqPDx1j91s9zdW7poMjZiRZKjAOMSqJv Aj+m/MitxGECTOIrCiYo9kP5CyzT6LIng9jyqiNCNR3L2T4sx/LgpLvap+ynwsmz kbqBaLcuPwzCW2f5eIYsfrh5lJMoF86GjTshbFnXXk/EN4etcjTTuFJMiNqPjqvy jonw0b1S17qHRJJPSfLvgk0NEWOB6tYQQuVcWyZyEb0TamfHP04Vdbe9NIKexU04 gafSM5pOBed4DfCsy6qaO9jstrJGMVQlZxxbDzgvsDazMmyh9lTwtup+5TGmxk+I e7HziEFBun8sf1BhDfwm1CJfAQs28lkuD4KctV3DuKyXYqDBftEr0fguxCtqNCtJ 0dTcSkPFzKU= =jim1 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ChoiSaehoon schrieb: Thanks Uwe, I used ` now. It says ls: z*: no such file or directory exists You need to use the path full qualified, e.g. ls /var/lib/mysql/db/z*, or wherever your mysql installation live. then, when I enter the password it dumps all the tables. (instead of tables starting with 'z') Yes, I'm a newbie. (I didn't know to use ` instead of '...) But please help me. Plz tell me what I've done wrongly this time. :) Date: Sun, 19 Apr 2009 16:29:48 +0200 From: m...@kiewel-online.ch To: saeho...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ChoiSaehoon schrieb: I tried it, then it gives the following error message mysqldump: Can't get CREATE TABLE for table 'ls z*' (Table '(db-name).ls z*' doesn't exist) What does 'ls' mean? (as in linux command 'ls'?) you have to use the ` sign, not the ' Uwe :) Date: Sun, 19 Apr 2009 08:53:36 -0500 Subject: Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*) From: jlyons4...@gmail.com To: saeho...@hotmail.com CC: mysql@lists.mysql.com try something like: mysqldump -u(user) -p (db-name) `ls z*` (filename) 2009/4/19 ChoiSaehoon saeho...@hotmail.com Is there a way to dump only specific tables starting with a certain character? For example, I only want to dump tables starting with the character 'z'. The following doesn't work. mysqldump -u(user) -p (db-name) z* (filename) Do I have to use regular expression here? Please help thanks in advance. _ MSN 메신저의 차세대 버전, Windows Live Messenger! http://windowslive.msn.co.kr/wlm/messenger/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com _ 강력해진 보안성, 아웃룩을 닮아 편리해진 기능들로 무장한 Windows Live Hotmail! 지금 로그인해 보세요! http://www.hotmail.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIVAwUBSes1W0JXG7BUuynnAQJWExAAuzKonpnWPeynnFyvodfGYSP1p9A5ybC6 Azi0j4iGk237HlJ8I8OKh+aBsQGnykzGEQ5eE4xAAaL7bocFlYjHkvaIAhqxzg7c /ZaS9j8k+sGrteAsiA1y8fTj4L3uzLJP+0+crm1yKGKO8Jl9BKxqWl+x3Di6XMYF 1R8OdgBDY1mClUZEqbbBtm0pOs6N/SGcLGyiZNH5xEyRrnXbrh24WY0OQov5pDPj T2G0vC2GpZOZEN1qQeJp5G2ZZ+8gPvZhW+cMElvLNVF3aWkWyd/hEFIxG0cBZ/cR afcreK3AcnAP80ng8150cFN+y5nMR5GExqPDx1j91s9zdW7poMjZiRZKjAOMSqJv Aj+m/MitxGECTOIrCiYo9kP5CyzT6LIng9jyqiNCNR3L2T4sx/LgpLvap+ynwsmz kbqBaLcuPwzCW2f5eIYsfrh5lJMoF86GjTshbFnXXk/EN4etcjTTuFJMiNqPjqvy jonw0b1S17qHRJJPSfLvgk0NEWOB6tYQQuVcWyZyEb0TamfHP04Vdbe9NIKexU04 gafSM5pOBed4DfCsy6qaO9jstrJGMVQlZxxbDzgvsDazMmyh9lTwtup+5TGmxk+I e7HziEFBun8sf1BhDfwm1CJfAQs28lkuD4KctV3DuKyXYqDBftEr0fguxCtqNCtJ 0dTcSkPFzKU= =jim1 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=saeho...@hotmail.com 강력한 폴더 공유 기능과 무료 문자 메시지, 오프라인 쪽지 보내기 기능까지! MSN 메신저의 차세대 버전, Windows Live Messenger! http://windowslive.msn.co.kr/wlm/messenger/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIVAwUBSetE9UJXG7BUuynnAQLWXQ/6AhduBZHFSrfsyhmaK0yRjjy6H6+fWZ0s cUfCANJlGbkP1RW6VpMVeF6U2o8xDBcs7m4OLOfLckT5/Lf+RX7AFj9T9T++3oPd DMGZzHEAStApcD0yvYqDPi5Mc88aPUdBaJyNbhc1Ufs+8M42T5sGkqfPWjB5r4Co REdKFt+6JC7VlIBGNn0EdVYA554IQ+93WJus5p9IGk+k5YS5NNBzDiF38SNRszco 2qH9b7I3FP8nxYnlWbpbNdVb0WC5RRk8HojpOE1X+jSJKcWqiebjC+ayVkAytgKL zZUxcmBmQjf2lRpbMatpR2YV1TZKLkWu6nMCfdYFtK/ggxrA23riIbvehjibXRIJ JdLSUp49EWUSx9Fk3DrsuDHiXyZy0mhcEanmBNU5jQSspq6pseYWXDoQUBW1TXY1 i9fs0nItaI+dXZcyvcMbYDRXsttuPUrfzB9lEQORPK2d7htxnsCRZtL0vcMmV8b7 yGVkirLyL4+6RlSnEfGk0lxb+Hi6MgVvOJ2V1J46A0pF6Pab+Mwi0+RoQ3YcLdPI OaWsVGelx+gKsY1szB7kYq2mfHcN+L0Hcdh+6U06+Y2SvJgavVn57sBTislBPfds fl3DfDdHayBFDI2IyrpLPuvq7Zug1Raj4pc8SyMswVeN0MWI4akxl77+hVTeKfrS UYxuDNNhrSc= =OFKv -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
binlog question
Hi, is it possible to have separated binlogs for each mysql-db? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: binlog question
Michael Dykman schrieb: No, I'm afraid not. So, how it's possible to replicate one specific db? I have 4 db's writing into binlog. I need only one of them at client site. After the successful setup of the replication I get errors on client site like no such table, no such database etc... Thanks, Uwe - michael dykman On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel m...@kiewel-online.ch wrote: Hi, is it possible to have separated binlogs for each mysql-db? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: binlog question
Baron Schwartz schrieb: So, how it's possible to replicate one specific db? I have 4 db's writing into binlog. I need only one of them at client site. After the successful setup of the replication I get errors on client site like no such table, no such database etc... On the slave side, use --replicate-wild-do-table=db.% I would stay away from any of the do-db or ignore-db settings. Can you explain, why? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL runs on 16-cores server
Moon's Father wrote: Thank you very much. Could you tell me what is IIRC? If I remember correctly. HTH, Uwe On Fri, Apr 10, 2009 at 8:24 PM, Uwe Kiewel m...@kiewel-online.ch wrote: Moon's Father wrote: Hi. If the server has 16 cores, how to set parameters to make MySQL runs well. IIRC is mysqld multi threaded - so if you have parallel queries, mysqld will spam multiple threads across multiple cores. HTH, Uwe -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL runs on 16-cores server
Moon's Father wrote: Hi. If the server has 16 cores, how to set parameters to make MySQL runs well. IIRC is mysqld multi threaded - so if you have parallel queries, mysqld will spam multiple threads across multiple cores. HTH, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
[Fwd: Re: Is it a bug or my mistake in server configuration?]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This mailing list has a stupid configuration. Pressing the answer button, the message goes to the sender not to the list :-( - Original-Nachricht Betreff: Re: Is it a bug or my mistake in server configuration? Datum: Mon, 10 Nov 2008 18:36:34 +0100 Von: Uwe Kiewel [EMAIL PROTECTED] An: Alexey Vlasov [EMAIL PROTECTED] Referenzen: [EMAIL PROTECTED] Alexey Vlasov schrieb: open files (-n) 1024 just a shot to the blue: can you count your open files with lsof? HTH, Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJJGHG8AAoJEEJXG7BUuynnycwP/1SB9O7u8toxRYcRbctfwbdV EnycPRk9k2meEEWEFNCqr/lQr3qzZL9BEj8HrMUnSqOSgkKKFS/XeqkIsUK+BZzp 2lV6zjD+wAtlM++O5BYYlQZ1JRgtk6rEkf+qWYQvRqbGOuQsSZ9UBqb7trUhbumF 7GsygytsUhT9aDmOlHoanlQ0VDQl+QvxKMVgtyu78s3CR7tMihSVxGdfC0A5Ws02 mlGdhxs/BgQsKuuSjLFar8Ok+Ad8g+lYhz5a2Tf8JTidYOBx1SAJoXC4R5MpRipp AUwfcMe3w7VaNZ47L+Sh20hYyQpYDCNiyBX371uMWE7Yizbm6ddDd1JZ3jkv8NdL N/9uLLLu14OIkYbC5TYJT84F9WlmvDtQiLTIl71LYjlPQdlEHsPs65+I5Pdmvt5V 0MfC2Weob0JUmzNBV/x03XfSUbEvXaScTdJa+DEV5+QNEnxxlRP45QVow+kfLMkQ gB7jvFfIkpjhUsfkaofH83f8wBGXT1AD257blb8X/M1lkLpWjh81xsBFDmfKacXt xu4St/VW59GESPbQaIkU5lcm/d/e93wY3xNIYtxnPsZ50pGv6PCszdI8N7Uu5UHQ KrYXO8G8Bi4unI9i1bfPSJUyfFErWGesiqYopydt5idvyfPJA9E2aKtqTXqHfDc9 m0XjbWeBv2JXC8R04byE =vQC5 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is it a bug or my mistake in server configuration?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Curtis Maurand schrieb: I've been having the same trouble in a Xen virtual machine. After about an hour and a half, mysql will be consuming 100% of cpu. There is nothing wrong with the tables. I'm assuming its a dynamic vs. fix amount of memory available to mysql. I'm guaranteed x amount of ram, but that might get reduced due to server load. I'm assuming mysql doesn't like having ram taken away from it and get into a tizzy about it. I've been forced to restart mysql hourly in order to get smooth operation. You are dealing with the impact, not with the reason. It can only be a workaround. Did you have a look at you machine regarding paging activity? Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJJGHNwAAoJEEJXG7BUuynnZLwP/j2DaZ4ffqvQDXJm9xhpR8RR IX/X4eycsa42PAGCmvRkD10WgxTzTdIBA8euNX56sY8nS9GWanUzrBJ2fzmb6BKF Ype1HnyQfBjktTlAnb/WMZ0GfwTyL9+xPcD22lpaDSp4wlPvCq11TWMBDHC7HO3s 7VIMz44FTrgeiuNFOCv5ZPLRY1yIonJm7aJpUOdJE329zQmkkECOi7E0dQTGH9hi F5MWaymhIG4OrULiVbo+rBTzAhzHRYE7pv7y/q07vVLLpJ4mIM/9gBVS+p5ovrZE yskucJyvoMx9YUNx22iSUp5NhoA67RS2Ov5y1JdeVeKzFGIsxRziYx2BNXWJo+zl iY8XI5bcB2rx9wbmDqA413MyM/EdLlNmAUbwc4QnzIQLf7+cJ2u93FiZ0gtsNjWb d/r+thxO6EpOlnrkt9vn4pe9Rjp/7KYAOSTJz+FG2CP9fkpnrArMSoegDIZFxE6T s3NLmD5pPMdl1piwL5488F4f+AYuH5UNiZTOvbMr6NnQ9WL5LB1mDjRF+4/+BiW7 9nyfr7XcIdMWlED9dNR0fXU9rnbhi/ZOJhJbMFMKJaPPmZW6+cd7G5yqBe3UOGAd 3JD2IVPIz2NkpI1kGo4XnqxdAZS2/MXavDTVB+1tMOjMSkkJN5bkwRitZai9rb3Z Ca2df0HdK0T7tIC1Kxmq =5Xsj -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Andy Shellam schrieb: This mailing list has a stupid configuration. Pressing the answer button, the message goes to the sender not to the list :-( Hint - use Reply to All - it's not specific to this mailing list. :-) It dosn't make sense to the a reply to the list and the sender. The described procedure works fine at other mailing lists... -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJJGHZ5AAoJEEJXG7BUuynnwFEQAJYxmcj886VULbzqY11cIm27 gCBC1B5eJetycUbFBnJhJew7yes8dbgHXIm6xpY79A0pX0O4+Gf4cyaYI42y2MHV K3DDaWbZkWJRnpihtW3We6k9CX5u+tufx/eejx+o2Yq+uPpmU/BeG7pC/r/YDkMu kZ/MLMZSRswD/mmRNHWixu2TT6iYEdrreeSmV1LGCwUirqaG1fDx/jxc6HvkdcmC XofeipmjPLdOMZ+Mr2xTYwo5jWXekx1Ynp6vV8PJacFgl/Hw8/LJk0FU+Nt8J5Kv 1P2UGqQ3bxGaTyiGNyqK3ZQIDUw1d1tHWP7wTEkNYs18GlXaX7xtACtqlZUG3zxN qtfHtT5Ksvn//7WoiNG6t4wY56pkgIiitOhwVmBydqok5zw7uHaRgpiykc8jEV5N rh7CtuuPPpVtauU4gI5lLvDNF1MQ+53srNeLx63UNTIABsu0IPtaISNDuspg6o2V Fq5nxWi9K07GdwAPRjoarZ+wVNtG8xaO90tz8EaMUqLu1fLvcU3168j4oYfQ/oR7 ePGTUtzTP26uTMqZ/O5uPn+eirz0j2s4P28EvwSGflYZPKAyi3AfNlDeGwB4XWbP 2VUKPPLHVqvMpwFKUTlfCrrY2bPl6ESEycDSD3DROW5uZbZlc0hMJ1NAK5XQQVTR cDvOtAG4Ku1NO3tE+P22 =gf+z -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [Fwd: Re: Is it a bug or my mistake in server configuration?]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Daisley schrieb: Hit 'Reply to All' instead of reply. Is is okay for you the have your answers twice? If I post to a list, I read that list. So there is no need to have the ansers at the list and in my inbox Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJJGHcCAAoJEEJXG7BUuynnKeIQAM0rb4PPOwIxwYClPNMUvTPN chqL8Lpo9FmRdWaJof5TqguruXDhPyK8xLeH+XBKPa7d952BNqRCFdtBLIHsmtQk GE7Z51E5puFWlKfZA9QC909juVNMPcKleTO0OCyHmhVX5NtazdVnrB4NR2RB0wFQ IIKiwBOH0id+YipyT1S3wOy8oo1DkA46u5NX4AIp66J3JDl642k+tvyQyGP05fzq 47PuCRI0FK7e6+xUHj3eNScJQXNkr4hJWkGi92suFgPGchKYBjWCBDbJUoNNl/rb QcpHOmC5TfUw1CCveb7CM6k8r10RNC02Q8BJTWKeYsc9PfR+lOdWLS7C/+nZjBr2 1rwZTYblAqOtzbokVvtQsPVol7b+hCiKZ5y8CGC+gmrr9GF0z/YHnspHnKiIDTS3 4IHMvVtZpjJu31S9Ywrsp7urQ947w32yM0vsCF2gxhCMV8gdZPoFBEwAyjx2mKDP JDEQ8eF5YQ18QEAEVoGgFHhQEsgup6OmbbQi415116pEiFCbJURkQLss9Qq7Cay4 2UHLuwkus6oEiC8Go1OPv67ZQ++0+lB9cd7GLZdBL1vwHLtzPRExBYLFp7ygP4yh +r6TqwmoUUNYwIRdFLcOcE8jMhqlAlwONmASWgkVsV8UzopSEKWjcI8EYoravqH1 3iA04LVzUbVnttppgbdB =RNS0 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to create a trigger
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have 2 databases: production_db and test_db. Both databases have the same tables. Now, I want to do as follows: If a new record is inserted to the production_db interst the same recort into the test_db. I am pretty sure, it's a case fo a trigger, but I don't know how to difine it. Thanks, Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJJBDhNAAoJEEJXG7BUuynnJscQAMyQlA8Goq4nVKWrBOyjpMaI rB77YW6cTuNO7HLRcLVwTfNgtjowDGyeOKVjFxEAjZxMzwFdC4Kr+OXYb5sy+dIF LznzPwHSrSXwyEOHJXBmw57uk68oR/08XTp23m1Zcl6SY0L4cpdjnlVpfFkJcSR5 1mas874EGbjhM4XBBtaYhZofqz6fxoLthvBNIK4xv/RawVHcPoHa8ZUhOIitJkDS iXGF0dE+FrRJK4C8GBPPttX0RHys4+uQCAlyDPjRN9xPh+0iqg5rI2uwLiK9yWgh 8H18MDEed+l8cbMiP/Mdnb4uTPZ+qlTBV/BVn/Q9kgQSMY3wg1drqEIfFsuiLLp8 fqm+6P+Jsz9nZamjQ1g8DCw83c3AKbM9NkeW0Ywe1Y+BiGPsSVyHAu7fSYfvy7B2 K8Rj/rDIgvxIUOpQFQdpXzX+xE1U1xsmW/3DyLSXLxg5JysPfMnVocw1Nca8HVoW kCYOgC+fmlc9UAJevPhB0LjmCXvgn2O1eMGLEd3Ya31fp1QdXN1QoqTTqVurQLWM Qw+TRwWy//1Hip6lj8NALvDlWKQRWcQCR48oDQw+sgKNexu/rqHUKXZnBoo/Ndq2 eXNNY8P3BPlq0Pcxl7sGDyjBnnYXGmbmaz3TNmir5PXf3MDwTRldGQIhdfoc5Nw7 xKxCltGbCepsAQEp0sLz =z18P -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Rotate regular log file only
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Olaf Stein schrieb: Hi all Is it possible to rotate just the regular (--log) log file? I am not sure if it will be safe, but maybe with logrotate and for /var/log/mysqld.log the copytruncate option for logrotate. If I do flush-logs I have to tell my slaves that (at least I have done so in the past, maybe I don't and the slves realizes by itself?) I think so, b/c I've never told my slaves... HTH, Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJJAKK3AAoJEEJXG7BUuynntkkP/R5IiZWpafUfQqR+hVUax9at NV8YKfUIz8J1QLrT7cWOEqpuliABP0P6AOS06Tmm4t2ve15BJ1fwxRqHiHEem9BE 7nb1AuQDlGW+qTOVpzJqj2H8b5SARdLoKswTisT0Yz++NDj3WQxVM/UIKotwRnLH edDHSrfjPl+38TmlmGP7/3ZYA2gEAKosgYGrax6bHtSnrw2pfDq6BaXvEwXABAHc aCE6P3DKGr4Ycs2Xlc49IkPHgE6/+SNM9MqVAs83OgxNZK5+c474YdJl7i5hfth1 8RKMPweQgBtYRT3vfrvJdfzg2Wg75pJv1RwkKiGofaAjBmO9y93iNkE57pNXq3sd eWFZR5YcPA+3+GCnAvOMcjzytISlpxNNic235qaYSuoNDMV1rukxSYNpH62kzQPH V3gTKuZcjWYWasa0Y6ylSBWywSOnfc49n0mVdXeoHb7CpIQn3jwCtRG2+UCZUM1W O4U5+bKgXERqqwjNS5sk9SNmq5gQAKYU4IsDZwZcyFY7t/XEHwB3+bCVnm1y4V/s Fzin0FoAIbqm9VzALzTs5YUkWzoSzniGepIBrZR0PO98sDxOlDFUESpYnFj8oNap wjM/5P0tgbw99lIsLAMy7+FdPIlSssWxq+LFC4dR6o+pzVrYjFjoRg3MdYn9ein8 svOEP/N79cK5pPZJpDyY =cN1H -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Sort by Array
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Keith Spiller schrieb: Hi Guys, I'm trying to sort by a particular order: SELECT * FROM tablename WHERE id='5' OR id='9' OR id='25' OR id='34' what about ... WHERE id in (5, 9, 25, 34) ... ORDER BY id(5, 34, 9, 25) like the others said Can anyone tell me the proper syntax to accomplish this task? Thanks for your help. Keith Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJI/5MmAAoJEEJXG7BUuynnkQAQAIfGGw+KpMukrwZcGEO39W+7 kBYpKqGlEWKSO1fWQNWDoXFACzhJP/gnBaBqHjVxe80rkuKFukfpA0+yZ0GBERUN boNq+qiHG5Cr5DTHyQ/FQg5vQj5sO4V+iR5yBjUxYzpGPGPpNB2PHAeV1MorOTBX MfJJpRmK+oT60rE4kpsTzozpk31si5kVU7QW/Z3tGLQlyYcldEBLvBMjO9iS9uFF OmFbcRcA3goRjKiIV7B9Ps17rnFneezYD8WXlamxl5hf0/fih5xf/iIBKdpmvtZO iaMM/HkrCVllWFOTxOfXBTLSDBlQPi8NjGiqJ5DUYD0KvrSPF8nrSZdqJUMlcl33 25tYUzM4mp/AxszGqtD5R/USVFecWKz1sF3UVjIDN/1cSvLN+Eq+S1cGGsFImsgl CZaXW7crGPZyu2DvnrXp74btCMf0y/N6etT6xiQArl2R0YjiDncHcmASH+VmmTwR W9XIX5mIaAEKz8bsQXZKZ9Vb2Mbf5oz4cD3DH2rNfQSDK6zL4qcpbylhLwOJMX+W DR43GaIkJuv/myjfDK1Q+clBoaI13OB13TaagGOC6nHZTFGTg6aurVXq2uWCOG4r G7l7HdrnQwO8VbmjiGYVI6w/mLl7/dBUwhkIJhOgbeqJMYTMMrS5x3si/Y8W2iz5 qNJ16hL29Rd8XlIRdG8W =wRny -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can not start slave after slave crash
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, my replication slave crashed. Now, I am unable to restart with following error message: 081021 21:34:21 [Note] Slave SQL thread initialized, starting replication in log 'log.000129' at position 28457291, relay log '/video/mysql/mysqld-relay-bin.000331' position: 10541803 081021 21:34:21 [ERROR] Slave: Query caused different errors on master and slave. Error on master: 'Table '%-.64s' already exists' (1050), Error on slave: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1' (1064). Default database: 'firewall'. Query: 'CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY INVOKER VIEW `drops_udp` AS ', Error_code: 0 081021 21:34:21 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'log.000129' position 28457291 Does the master or the slave have an error? What do I have to do to fix this issue? Thanks, Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQIcBAEBAgAGBQJI/i9vAAoJEEJXG7BUuynnhd4P/39swMU29YkQ0h8xsarH5GPu dYWFsIp0weR4E2VBvuc4HfA1pGLttnpw02Ru2MQkeA4OhT5V7naZhPxj0p0tjI5S WCsUf+CcW1lSqAuhmDAvGO7T/Cv+cCnzDqhj+mQKwrPJwRSj3ZomdicXM3C1mPL6 d2w6F8q4ez2ntaeiSIc53l9t0n8aIkExmGRyJztGaPqOiLF19K3kJ3U9VD2lD4FQ yZtcmWLCSapiS+HvsjueAVe3VxDKFqzYKCZjD30yhTeGWtdDt2COHj35BeUkK98y mxPQAu6fymLB2C35Ry68QpTeKGkKUxGElsHt2JxOKHYVWnnbpS6YnxVk0n42vImv bg6wUkAj2jFbJyfFuMNWm4oEIUZb5uzTNAnBJp60RpE6kTfkOM51PhakPfPzcaKZ IFmI2nhuplGnhPzbAT4Oxj1Y8OQqswgQUqqFJnyEZbiT8pFA4Gk6mkksrLr7TtJF GG02sdtLT2wAMfW/8txN90seZeB8l6KQc+hPcn/Q5WwP7cunsUQkzcL4XtikCtzs H5B/RZGPt7dxQvmDFKhYSGGSB86+JoTScvIggYkeDpugKClR/M6+sn8n4Sxd+uMT sxwJoTlx2dr6GkO/6qbCjfS6yCKaVGdvOWKKjoABoLPpnmOUdaYKuIOrLnmj7vTl jXNJA46FFmRn0zElV/Ea =N9cq -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query Cache questions
Hi, I have two questions regarding the query cache: 1. What is the difference between query_cache_limit and query_cache_size? mysql show variables like '%query_cache%'; have_query_cache | YES | query_cache_limit| 1048576 | query_cache_min_res_unit | 4096 | query_cache_size | 20971520 | query_cache_type | ON | query_cache_wlock_invalidate | OFF | 2. Would an increase of the query cache size bring a positive effect to the performance? mysqlshow status like '%Qcache%'; Qcache_free_blocks | 414 | Qcache_free_memory | 17000952 | Qcache_hits | 228827 | Qcache_inserts | 731980 | Qcache_lowmem_prunes| 0| Qcache_not_cached | 70644| Qcache_queries_in_cache | 3042 | Qcache_total_blocks | 6584 | 3. How can I calculate a query cache hit rate? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Cache questions
Bard Aase schrieb: On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel [EMAIL PROTECTED] wrote: Hi, I have two questions regarding the query cache: 1. What is the difference between query_cache_limit and query_cache_size? query_cache_limit is the maximum size of a single resultset in the cache. If your query results in a bigger resultset it will never get into the cache even if its room for it in the cache itself. query_cache_size is the maximum amount of data that may be stored in the cache. Do you talk about all usable cache memory for all resultsets? Thanks, Uwe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql logfile configuration
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi @all, ich have configured in /etc/my.cf as follow: [...] log=/var/log/mysqld.log [...] Now, mysqld writes every query to the log file. How can I avoid the queries in the log file? I want to see any action done by mysql, but not the queries. Thx, Uwe -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSAh3Hds3frmum9swAQIZbgf7B40LUiqjZchb2fyefyy9mNjxEIeM/ftt tBVIjnrVVesyJo6FZJdZo3tlfNh3hkrrNIqTbR6Dy5P2sDRZ+4GIyMs+MEX9A4dw NBjaMoj648HyQivjomJYe0vwWBKF+UmTM2qOsQEQi1AArJtg33mBGTNOA++6HigX TpVGkn991+AyTUt+JYXDXOyHOjaLoSz/AhWSjvz5kM5lgyZPcssDKWVDzWDAOtrO KTnYsby59+ctK3h61tkAecJeAElZq0JnMlalJlwXnIbcolGcO59Z/gC0U80VMYyf kGdRzHbegCVd+r2M1haLdk6Ygunk/3KQa/GW+gqhuYjRMpCcudJqkw== =el3Y -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: only myisam storage engine
Ananda Kumar schrieb: Hi All, i set the skip-innodb in my.cnf, but when i do the below, it still shows some default values assigned to innodb parameters, can i avoid this as there is some amount of memory allocated to innodb, and i dont what that. I want all resource to allocated to only myisam. Please let me know how i can achive this. maybe compile mysql without innodb support mysql show variables like '%innodb%'; +-+--+ | Variable_name | Value| +-+--+ | have_innodb | DISABLED | | innodb_additional_mem_pool_size | 1048576 | | innodb_autoextend_increment | 8| | innodb_buffer_pool_awe_mem_mb | 0| | innodb_buffer_pool_size | 8388608 | | innodb_checksums| ON | | innodb_commit_concurrency | 0| | innodb_concurrency_tickets | 500 | | innodb_data_file_path | | | innodb_data_home_dir| | | innodb_doublewrite | ON | | innodb_fast_shutdown| 1| | innodb_file_io_threads | 4| | innodb_file_per_table | OFF | | innodb_flush_log_at_trx_commit | 1| | innodb_flush_method | | | innodb_force_recovery | 0| | innodb_lock_wait_timeout| 50 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_arch_dir | | | innodb_log_archive | OFF | | innodb_log_buffer_size | 1048576 | | innodb_log_file_size| 5242880 | | innodb_log_files_in_group | 2| | innodb_log_group_home_dir | | | innodb_max_dirty_pages_pct | 90 | | innodb_max_purge_lag| 0| | innodb_mirrored_log_groups | 1| | innodb_open_files | 300 | | innodb_rollback_on_timeout | OFF | | innodb_support_xa | ON | | innodb_sync_spin_loops | 20 | | innodb_table_locks | ON | | innodb_thread_concurrency | 8| | innodb_thread_sleep_delay | 1| +-+--+ On 4/2/08, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, Thanks a lot for you reply. Will do this setup. regards anandkl On 4/2/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi, Enter in my.cnf file [mysqld] skip-bdb skip-innodb Regards Rakesh -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 9:59 AM To: MySql Subject: only myisam storage engine Hi All, We have a linux box running debain, with 8 cpu and 8 GB RAM, we want only myisam engine to be running on this. So, should i not setup any innodb parameters or is there any other way to have only myisam engine running on this machine, please let me know. regards anandkl The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]