DROP USER command is the only command to remove any user and its
association from all other tables.
Cheers
On Fri, Dec 2, 2011 at 8:22 AM, Reindl Harald wrote:
> ALWAYS
> start with "select * from mysql.user where user='mail_admin' and host like
> '\%';"
> and look what records are affected
Many thanks, I wanted to finalized on RAM requirement for one of my server
so do we have any calculation method to choose intial RAM?
On Fri, Dec 2, 2011 at 12:06 AM, Reindl Harald wrote:
>
>
> Am 01.12.2011 18:56, schrieb Stdranwl:
> > Hi, will it help to use swap memory on MYS
Hi, will it help to use swap memory on MYSQL's VM. We are in planning to
use 10GB RAM and 10 GB as swap on a perticular server? thanx
ase) will be used for queries issued in
> that session.
>
> On Nov 30, 2011, at 9:38 AM, Stdranwl wrote:
>
> > 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?
> &
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?
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
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?
