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.
>
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 <shawn.l.gr...@oracle.com>
wrote:
>
>
> On 4/2/2016 10:36 AM, geetanjali mehra wrote:
| 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
that above error
disappears permanently? Is it a database issue or application side issue?
Best Regards,
Geetanjali Mehra
Senior Database Administrator
Thanks everyone for their reply.
Best Regards,
Geetanjali Mehra
Senior Database Administrator
On Wed, Aug 12, 2015 at 7:07 PM, Reindl Harald h.rei...@thelounge.net
wrote:
Am 12.08.2015 um 15:07 schrieb geetanjali mehra:
I am in the process of creating a new slave. On my master
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 w...@singerwang.com wrote:
Depending on the version of MySQL and InnoDB engine, the max key length
can be 3072 for InnoDB
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
Have u executed mysql_install_db?
On 15-May-2015 1:31 pm, Jørn Dahl-Stamnes sq...@dahl-stamnes.net 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.
'
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
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. yoku0...@gmail.com wrote:
Hello,
If you use
Mehra
Senior Oracle and MySQL DBA Corporate Consultant and Database Security
Specialist
On Tue, Oct 7, 2014 at 6:22 AM, shawn l.green shawn.l.gr...@oracle.com
wrote:
Hello Geetanjali,
On 9/23/2014 7:14 AM, geetanjali mehra wrote:
Can anybody please mention the internals that works when we use
,
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 Database Security
Specialist
)
[root@host1 ~]#
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Consultant and Database Security
Specialist
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 mentioned, however I am getting
.
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 Database Security
Specialist
, this is what I got from
another session:
mysql insert into new values(20,'jjj');
(hang)
mysql insert into new values(6,'jjj');
ERROR 1062 (23000): Duplicate entry '6' for key 'idx1'
Here it is locking 20 , but not 6.
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Trainer
.
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 locking and locking
reads
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 shawn.l.gr...@oracle.com
wrote:
Hello Geetanjali,
On 8/26/2014 1:16 AM, geetanjali mehra
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 hart...@skysql.com
wrote:
On 08/29/2014 08:15 AM, geetanjali mehra wrote:
But after doing *optimize table
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 shawn.l.gr...@oracle.com
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 shawn.l.gr...@oracle.com
wrote:
On 8/26/2014 1:12 AM, geetanjali mehra wrote:
Hello to all,
In repeatable read isolation level, when we issue
and 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
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
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 Trainer and Database
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
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 h.rei...@thelounge.netwrote:
Am 26.05.2014 11:40, schrieb
etc rather than installing the server only?
The Server should suffice; the Bundle is merely a convenient way to
download ALL the RPMs in one go.
--
Unhappiness is discouraged and will be corrected with kitten pictures.
--
Geetanjali Mehra
Oracle DBA Corporate Trainer
Koenig
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
, this command is very safe.
On Mon, Mar 3, 2014 at 7:49 PM, Johan De Meersman vegiv...@tuxera.bewrote:
- Original Message -
From: geetanjali mehra mailtogeetanj...@gmail.com
Subject: Re: New to MySQL
use
rpm -i --replacefiles MySQL-server*.rpm
While that will work, it really
29 matches
Mail list logo