Dear Akshay,
ASFIK, normal selects are always non-locking read and they do not put any
locks.
Select..., Select..where..,Select where..between
Does above select statement will use next-key locking and/or gap locking?
I dont think so.
Please correct me if I am wrong.
Bes
Ping !! :)
On Mon, Sep 1, 2014 at 8:27 AM, Ajay Garg wrote:
> Hi all.
>
>
> We have replication set-up, where we cater to HUUGEE amounts of data.
> Since quite some time, we have been facing issues wherein the slave
> lags behind master quite a lot.
>
>
> So, yesterday we were able to setup paral
* Rajeev Prasad [2014-09-01 17:55]:
> I have a column in a table which is epoch time including milliseconds.
>
> e.g. = 1409304102153
>
>
> now i want to display all fields in the table but this field as: "2014-8-29
> Fri 09:21:42: GMT" (whatever comes in )
>
>
> and i am not findi
I have a column in a table which is epoch time including milliseconds.
e.g. = 1409304102153
now i want to display all fields in the table but this field as: "2014-8-29 Fri
09:21:42: GMT" (whatever comes in )
and i am not finding anything on web about how to do that.
can anyone help
when i run the application like this: http://mywebsite.com/phpMyAdmin/index.php
on the home page it shows i am using old version:
"Version information: 3.4.3.1, latest stable version: 4.2.7.1"
but i have latest phpmyadmin installed (see below) why is it not appearing?
MySQL client version is 5.5
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 value inside
> >