Re: [MySQL] innodb_file_per_table / apple workers and logic

2011-11-30 Thread Shawn Green (MySQL)
Hello all, On 11/30/2011 16:46, Reindl Harald wrote: Am 30.11.2011 19:13, schrieb Karen Abgarian: Hi inline there. On 30.11.2011, at 0:16, Reindl Harald wrote: Most people do not expect a gas tank to shrink once the gas is consumed...right? WHO THE FUCK is comparing computers with

Re: [MySQL] innodb_file_per_table / apple workers and logic

2011-11-30 Thread Reindl Harald
Am 30.11.2011 19:13, schrieb Karen Abgarian: > Hi inline there. > > On 30.11.2011, at 0:16, Reindl Harald wrote: > >> >>> Most people do not expect a gas tank to shrink once the >>> gas is consumed...right? >> >> WHO THE FUCK is comparing computers with a gas tank? > Well, I do. I even

Re: [MySQL] innodb_file_per_table / apple workers and logic

2011-11-30 Thread Karen Abgarian
Hi inline there. On 30.11.2011, at 0:16, Reindl Harald wrote: > >> Most people do not expect a gas tank to shrink once the >> gas is consumed...right? > > WHO THE FUCK is comparing computers with a gas tank? Well, I do. I even managed to do it without using foul language. Forgot to

Re: Global Variables

2011-11-30 Thread Johan De Meersman
- Original Message - > From: "Stdranwl" > > So then no use of setting 3G sort buffer in my.cnf untill system will > take a rebot? > I was in the impression that 10M will be used and it will be > scratched to 3G whenever required as same is set globally? No, you've got it the wrong way ro

Re: Global Variables

2011-11-30 Thread Stdranwl
So then no use of setting 3G sort buffer in my.cnf untill system will take a rebot? I was in the impression that 10M will be used and it will be scratched to 3G whenever required as same is set globally? On Wed, Nov 30, 2011 at 10:22 PM, Paul DuBois wrote: > The session value (10M in your case) w

Opentaps database

2011-11-30 Thread Stdranwl
Did anybody from group get a chance to work on opentaps' DB ... It will be great help if some config changes and optimization tricks, somebody can suggest me keeping in mind 64G RAM?

Re: Global Variables

2011-11-30 Thread Stdranwl
Ok it is fine . but I just wanted to to know on following: Let say sort_buffer_size is set 10 M and Globally it is set 3G so how it will be used? On Wed, Nov 30, 2011 at 8:47 PM, Paul DuBois wrote: > > On Nov 30, 2011, at 4:04 AM, Stdranwl wrote: > > > Hi > > I can see different values when

Re: help needed restoring crashed mysql

2011-11-30 Thread Reindl Harald
Am 30.11.2011 07:02, schrieb Hal?sz S?ndor: > 2011/11/29 23:19 +0100, Reindl Harald > MY only luck is that i recognized this years ago after PLAYING > with innodb and so i started with "innodb_file_per_table=1" from > the begin with the first production database > > And are then

Re: help needed restoring crashed mysql

2011-11-30 Thread Hal�sz S�ndor
2011/11/29 23:19 +0100, Reindl Harald MY only luck is that i recognized this years ago after PLAYING with innodb and so i started with "innodb_file_per_table=1" from the begin with the first production database And are then the table-files in the directories with "frm", or in

Re: Global Variables

2011-11-30 Thread Rik Wasmus
> > DO NOT REPLY OFF-LIST > > Also, do not shout :-) Ugh point taken, but why are you still replying to him off-list? Keep inboxes clean! ;) -- Rik Wasmus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Global Variables

2011-11-30 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > > DO NOT REPLY OFF-LIST Also, do not shout :-) > the difference is "set" or "set global" Same for show, and 'show variables' is implicitly the same as the clearer 'show session variables'. > global is what would be used if the thread doe

Re: [MySQL] innodb_file_per_table / apple workers and logic

2011-11-30 Thread Johan De Meersman
Allright, that will do, I think? This is a MySQL mailinglist, let's not have it devolve into vendor rants. The defaults may or may not be sensible, but they're documented, and there's as much to say for sensible defaults as there is for not changing defaults between releases. Let's leave it at

Re: Global Variables

2011-11-30 Thread Reindl Harald
DO NOT REPLY OFF-LIST i do not understand what is unclear you can set variables per sql and my.cnf most of them, not all the difference is "set" or "set global" global is what would be used if the thread does not change it the same as in php set a value per "php.ini" or ".htaccess" Am 30.11.20

Re: Global Variables

2011-11-30 Thread Reindl Harald
Am 30.11.2011 11:04, schrieb Stdranwl: > Hi > I can see different values when I run show global variables like > . && show variables like .? could any body please > revert me on the scope and how they works? a global variable is global and for all threads set without global i

Global Variables

2011-11-30 Thread Stdranwl
Hi I can see different values when I run show global variables like . && show variables like .? could any body please revert me on the scope and how they works?

Re: help needed restoring crashed mysql

2011-11-30 Thread Reindl Harald
Am 30.11.2011 03:13, schrieb Karen Abgarian: > The concept is not difficult to explain. Most people do not expect a gas > tank > to shrink once the gas is consumed...right? yes, but the hard-disk is the gas tank and the data are the gas and yes, normally everybody would expect after deleting