Re: threads in cleaning up mode

Can it be a consequence of slow disk also? Best Regards, Geetanjali Mehra Senior Database Administrator On Tue, Apr 5, 2016 at 10:50 AM, geetanjali mehra < mailtogeetanj...@gmail.com> wrote: > Thanks to everyone for response. Any other views from any one is always > welcome. >

Re: threads in cleaning up mode

Thanks to everyone for response. Any other views from any one is always welcome. Best Regards, Geetanjali Mehra Senior Database Administrator On Mon, Apr 4, 2016 at 7:51 PM, shawn l.green wrote: > > > On 4/2/2016 10:36 AM, geetanjali mehra wrote: > >> Hi to all, >>

threads in cleaning up mode

| 8 | Also, please let me know that whether cleaning up mode of threads and history list length are correlated. Anty help? Best Regards, Geetanjali Mehra Senior Database Administrator

commands out of sync, you can't run this command now'

issue, so that above error disappears permanently? Is it a database issue or application side issue? Best Regards, Geetanjali Mehra Senior Database Administrator

Re: Changing storage engine in dump file.

have restored all the things back by restoring mysqldump file as it was. Best Regards, Geetanjali Mehra Senior Database Administrator On Thu, Aug 13, 2015 at 10:31 PM, Singer Wang wrote: > Depending on the version of MySQL and InnoDB engine, the max key length > can be 3072 for InnoDB..

Re: Changing storage engine in dump file.

Thanks everyone for their reply. Best Regards, Geetanjali Mehra Senior Database Administrator On Wed, Aug 12, 2015 at 7:07 PM, Reindl Harald wrote: > > Am 12.08.2015 um 15:07 schrieb geetanjali mehra: > >> I am in the process of creating a new slave. On my master, there

Changing storage engine in dump file.

Hi, I am in the process of creating a new slave. On my master, there is a mix of innodb and myisam tables. I want all my tables to be created in innodb on slave. I have planned to change the value of storage engine from innodb to myisam in dump file itself using sed . Running that dump file on t

Re: Starting mysql 5.7.7

Have u executed mysql_install_db? On 15-May-2015 1:31 pm, "Jørn Dahl-Stamnes" wrote: > Hello, > > I have reinstalled a test server after a disk crash. I upgraded from an > older Fedora Core (don't > remember the version) to Fedora Core 21. > > Then I installed Mysql 5.7.7 from RPM. I'm able to st

Binary log in 5.6

=1040103520 ### @2='new' But, above record do exist in db1.xyz table on slave. Still, replication error on slave says: can't find record. Any idea on this. Best Regards, Geetanjali Mehra Senior Database Administrator

Re: mysqldump with single-transaction option.

So, in case of * NOT Innodb * storage engine, say MyISAM, will this dump be of any useful? Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Consultant and Database Security Specialist On Tue, Oct 7, 2014 at 11:55 AM, yoku ts. wrote: > Hello, > > If you use any *N

Re: mysqldump with single-transaction option.

Mehra Senior Oracle and MySQL DBA Corporate Consultant and Database Security Specialist On Tue, Oct 7, 2014 at 6:22 AM, shawn l.green wrote: > Hello Geetanjali, > > On 9/23/2014 7:14 AM, geetanjali mehra wrote: > >> Can anybody please mention the internals that works when we u

mysqldump with single-transaction option.

ement is issued, the backup operation may stall until those statements finish. After that, the dump becomes lock-free and does not disturb reads and writes on the tables. Can anyone explain it more? Please. Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Consultant and Da

PAM authentication plugin

for user 'user1'@'localhost' (using password: YES) [root@host1 ~]# Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Consultant and Database Security Specialist

Re: next-key lock

Thanks to all, Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Thu, Sep 4, 2014 at 2:36 PM, Akshay Suryavanshi < akshay.suryavansh...@gmail.com> wrote: > Hi Geeetanjali, > > I retried the scenario you mentione

Re: next-key lock

it is locking a row with id=6, the value immediately before the gap. Can you explain me the same? When I tried the same scenario with unique index, this is what I got from another session: mysql> insert into new values(20,'jjj'); (hang) mysql> insert into new values(6,'jjj

Re: next-key lock

p lock on complete table. The scenario is working fine only when I made c1 primary key. After making c1 primary key, I am able to insert value higher than 30. Can you please try the same scenario at your end? Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and

Re: purge thread

Could you please put some more light on it? Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Thu, Aug 28, 2014 at 2:09 AM, shawn l.green wrote: > Hello Geetanjali, > > > On 8/26/2014 1:16 AM, geetanjali mehra wrote:

Re: next-key lock

. Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Fri, Aug 29, 2014 at 11:46 AM, Akshay Suryavanshi < akshay.suryavansh...@gmail.com> wrote: > Geetanjali, > > There is a difference between next-key locking, gap lock

Re: fragmentation in innodb index

Thanks to all, Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Fri, Aug 29, 2014 at 11:59 AM, Hartmut Holzgraefe wrote: > On 08/29/2014 08:15 AM, geetanjali mehra wrote: > > But after doing *optimize table*, the val

Re: fragmentation in innodb index

data_free is still the same. If there is no change in the value of data_free, then what *optimize table* does here? Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Thu, Aug 28, 2014 at 2:21 AM, shawn l.green wrote: > He

Re: next-key lock

Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist On Thu, Aug 28, 2014 at 2:26 AM, shawn l.green wrote: > > > On 8/26/2014 1:12 AM, geetanjali mehra wrote: > >> Hello to all, >> In repeatable read isolation level, whe

purge thread

I want to understand how to tune innodb_max_purge_lag <http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_max_purge_lag> when history list length is high. Could anyone explain me. Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Train

fragmentation in innodb index

Hello to all, I want to know whether my innodb index is fragemented. Is it possible to know? Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist

next-key lock

any value below the range. I am unable to understand this. Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist

Re: blob data types

Is it possible to move blob data type values out of table and keep it in separate page, keeping BLOB the part of the table. Geetanjali Mehra Oracle and MySQL DBA Corporate Trainer On Mon, May 26, 2014 at 3:26 PM, Reindl Harald wrote: > > Am 26.05.2014 11:40, schrieb geetanjali mehra:

blob data types

I want to know where does MyISAM and innodb stores its BLOB data ; inside the table or outside the table. I tried to understand BLOB using MySQL online docs but failed. Geetanjali Mehra Oracle and MySQL DBA Corporate Trainer

Re: New to MySQL

this command is very safe. On Mon, Mar 3, 2014 at 7:49 PM, Johan De Meersman wrote: > - Original Message - > > From: "geetanjali mehra" > > Subject: Re: New to MySQL > > > > use > > rpm -i --replacefiles MySQL-server*.rpm > > While that w

Re: Install mysql server using RPM

ot lose it when you install a newer RPM. > > when i checked /var/lib i found non for mysql,Any idea?? > > Thank you very much in advance. > > Best Regards, > Rabe > -- Geetanjali Mehra Oracle DBA Corporate Trainer Koenig-solutions Moti Nagar,New Delhi

Re: New to MySQL

> > From: "Asma rabe" > > > Subject: Re: New to MySQL > > > > > > so,Is it recommended to install RPM bundle which has compatlibs, > MySQL > > > serveretc rather than installing the server only? > > > > The Server should suffice;