Re: Vista crashes
so why do you search a list of known bugs instead update your mysql? 5.5.8 is the FIRST ga version of 5.5 currently we have 5.5.16 no, i do not know if 5.5.16 is solving your problem but hwat i know is that the updates were bot relöeased just for fun Am 12.10.2011 06:28, schrieb Hal?sz S?ndor: I find that, when under Vista the MySQL daemon has been shut down, by giving the command start mysqld -b%CD% in the root directory where MySQL 5.5.8 (the version running on this computer) has been stored from an instance of command prompt with administrator authority issued by a user that lacks it (like an ordinary user s doing bare su in Unix) I make Vista crash with the blue-screen message process or task critical to system operation has been terminated or exited. The start is needed, also the administrator authority and the user that ordinarily lacks it. Of course, there is a Vista-bug here, but, also, surely a MySQL-bug. Where is there a list of known bugs? signature.asc Description: OpenPGP digital signature
Re: Index question
- Original Message - From: Tompkins Neil neil.tompk...@googlemail.com Thanks for the information. One final question in what ways should we use EXPLAIN EXTENDED statement to help improve our query performance. Explain is your friend. You should listen to it :-) It gives a nice idea of how the database interprets your query, so you can see where the bottlenecks are, for example what bits don't use indices or cause file sorts. The exact interpretation of it is an art, though, and there are many subtleties you only get by experience and reading documentation. It is not something that is quickly explained; it requires a good knowledge of how a database works on the inside. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Fwd: Large insert query gives MySQL server gone away
Do you have any recommendations as to what size this should be increased to ? On Tue, Oct 11, 2011 at 12:23 AM, Angela liu yyll2...@yahoo.com wrote: Yeah, I think adjusting max packet size may be helpful, remember change that value in both server and client -- *From:* Johnny Withers joh...@pixelated.net *To:* Neil Tompkins neil.tompk...@googlemail.com *Cc:* [MySQL] mysql@lists.mysql.com *Sent:* Monday, October 10, 2011 4:13 PM *Subject:* Re: Fwd: Large insert query gives MySQL server gone away Max packet size? On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: As per the subject we've a large insert query that gives up the error MySQL server has gone away when we try to execute it. Any ideas why ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
Re: Large insert query gives MySQL server gone away
as big as you largest query Am 12.10.2011 15:30, schrieb Tompkins Neil: Do you have any recommendations as to what size this should be increased to ? On Tue, Oct 11, 2011 at 12:23 AM, Angela liu yyll2...@yahoo.com wrote: Yeah, I think adjusting max packet size may be helpful, remember change that value in both server and client -- *From:* Johnny Withers joh...@pixelated.net *To:* Neil Tompkins neil.tompk...@googlemail.com *Cc:* [MySQL] mysql@lists.mysql.com *Sent:* Monday, October 10, 2011 4:13 PM *Subject:* Re: Fwd: Large insert query gives MySQL server gone away Max packet size? On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: As per the subject we've a large insert query that gives up the error MySQL server has gone away when we try to execute it. Any ideas why ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=joh...@pixelated.net -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
Re: Large insert query gives MySQL server gone away
But how do I calculate such size ? On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald h.rei...@thelounge.netwrote: as big as you largest query Am 12.10.2011 15:30, schrieb Tompkins Neil: Do you have any recommendations as to what size this should be increased to ? On Tue, Oct 11, 2011 at 12:23 AM, Angela liu yyll2...@yahoo.com wrote: Yeah, I think adjusting max packet size may be helpful, remember change that value in both server and client -- *From:* Johnny Withers joh...@pixelated.net *To:* Neil Tompkins neil.tompk...@googlemail.com *Cc:* [MySQL] mysql@lists.mysql.com *Sent:* Monday, October 10, 2011 4:13 PM *Subject:* Re: Fwd: Large insert query gives MySQL server gone away Max packet size? On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com wrote: As per the subject we've a large insert query that gives up the error MySQL server has gone away when we try to execute it. Any ideas why ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
Re: Large insert query gives MySQL server gone away
you must know how big your data are or take a testserver and play around with increase the value step for step - we are using 200M because it is only relevant for import dumps here what does not happen parallel and there is enough memory Am 12.10.2011 15:40, schrieb Tompkins Neil: But how do I calculate such size ? On Wed, Oct 12, 2011 at 2:38 PM, Reindl Harald h.rei...@thelounge.net mailto:h.rei...@thelounge.net wrote: as big as you largest query Am 12.10.2011 15:30, schrieb Tompkins Neil: Do you have any recommendations as to what size this should be increased to ? On Tue, Oct 11, 2011 at 12:23 AM, Angela liu yyll2...@yahoo.com mailto:yyll2...@yahoo.com wrote: Yeah, I think adjusting max packet size may be helpful, remember change that value in both server and client -- *From:* Johnny Withers joh...@pixelated.net mailto:joh...@pixelated.net *To:* Neil Tompkins neil.tompk...@googlemail.com mailto:neil.tompk...@googlemail.com *Cc:* [MySQL] mysql@lists.mysql.com mailto:mysql@lists.mysql.com *Sent:* Monday, October 10, 2011 4:13 PM *Subject:* Re: Fwd: Large insert query gives MySQL server gone away Max packet size? On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com mailto:neil.tompk...@googlemail.com wrote: As per the subject we've a large insert query that gives up the error MySQL server has gone away when we try to execute it. Any ideas why ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33 tel:%2B43%20%281%29%20595%203999%2033, m: +43 (676) 40 221 40 tel:%2B43%20%28676%29%2040%20221%2040 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm signature.asc Description: OpenPGP digital signature
RE: Vista crashes
-Original Message- From: Halász Sándor [mailto:h...@tbbs.net] Sent: Tuesday, October 11, 2011 9:28 PM To: mysql@lists.mysql.com Subject: Vista crashes I find that, when under Vista the MySQL daemon has been shut down There's your first two problems: [a] why are you running Vista. Period. [b] why are you running MySQL under windows and not a Unix flavor as the rest of the world does? ;-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org