Thanks Suresh but I find it very difficult to implement it :-
Suresh Kuna wrote:
Try this out:-)
Below are the steps to generate a deadlock so that the behaviour of a
deadlock can be illustrated:
-- 1) Create Objects for Deadlock Example
USE TEMPDB
Is I have to create temdb database as be
TRAN (or TRANSACTION) will apply an implicit lock on the table which remains
until the TRAN is commit or rollback
subsequent DML statements on that same table will be forced to wait UNTIL the
TRAN is commit or rollback
when the statement for the second update on the same table comes along there
ANN: Advanced Data Generator 2.5.2 released
Dear ladies and gentlemen,
Upscene Productions is happy to announce the next
version of their test data generator tool:
"Advanced Data Generator 2" (v2.5.2)
A fast test-data generator tool that comes with a library
of real-life data, can generate data
Hi,
I have a situation where the box with a mysql server will not boot. But
I can boot it from a CD and browse the hard drive and I can mount
partitions so files and data are accessible. I want to somehow take the
Mysql DB structure and content, copy it, and move it to a bootable
working unit. Nor
Lee,
You will need to take the datadir directory, typically found under
/var/lib/mysql/
It would also be a good idea to grab your configuration file from
/etc/mysql/my.cnf or /etc/my.cnf (ubuntu tends to be the former).
Once transplanted into your new server remember to check that the
permission
Install a same version of MySQL and copy all datadir, watch for privileges
on dir.
On old disk find /etc/my.cnf and find the 'datadir' parameter, that all you
must copy where the new instance has its own datadir.
Claudio
On Jun 16, 2011 7:51 PM, "leegold" wrote:
> Hi,
>
> I have a situation wher
Just a little side note,
The table engine needs to be InnoDB or the transaction will not have effect,
The behavior may differs also according to the isolation level,
That will apply a lock on all records because no where is specified, which
its not very common.
Regards,
Claudio
On Jun 16, 2011 8:
Sveta Smirnova at Mysql just confirmed this bug in 5.5.13:
http://bugs.mysql.com/45670
On Wed, Jun 15, 2011 at 5:38 PM, Claudio Nanni wrote:
> No worries!
>
> I think I would have figured that out!
>
> I'll feedback you tomorrow.
>
> Thanks again
>
> Claudio
>
> 2011/6/15 Hank
>
>> Oops... big
Hello there,
I request you to give your commends on the following,
1. We have planned to cipher our table name and filed name [the necessary data
will be ciphered with predefined functions with 'key']
2. This cipher functions will be our own code
3. Using these functions we can mange the applic
- Original Message -
> From: "Bennett Haselton"
>
> Do you happen to know the answer to my other problem -- if I have
> TEXT and BLOB columns but all my other columns are fixed-length, can
> I still get the benefit of faster lookups resulting from fixed-length
> rows, if each row just c
- Original Message -
> From: "Vikram A"
>
> My question is, DO i face any negative project management problems by
> doing this? Pleas share your experience on this aspect and commend
> our idea.
Seems... a bit pointless, no? If someone has access to the database, they can
still see the
Sir,
I agree, its impossible to do manual look ups. But our aim is to avoid the use
of DB with out code. Also we have ensured, 'secret data is encrypted using some
functions with key'.
I shall follow both encode i.e, 1) filed and table name, 2) data level? Or
only data level is enough by hav
12 matches
Mail list logo
