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
CREATE TABLE dbo.foo (col1 INT)
INSERT dbo.foo SELECT 1
CREATE TABLE dbo.bar (col1 INT)
INSERT dbo.bar SELECT 1
-- 2) Run in
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
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
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.
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
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 leeg...@fastmail.fm wrote:
Hi,
I have a
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
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 claudio.na...@gmail.comwrote:
No worries!
I think I would have figured that out!
I'll feedback you tomorrow.
Thanks again
Claudio
2011/6/15 Hank
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
- Original Message -
From: Bennett Haselton benn...@peacefire.org
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
11 matches
Mail list logo