Posted
by Marcin
on Stack Overflow
See other posts from Stack Overflow
or by Marcin
Published on 2010-03-23T12:55:01Z
Indexed on
2010/03/30
10:53 UTC
Read the original article
Hit count: 377
Hi guys,
I would like to know whether is there an option to detect locked tables in mysql or no. I mean locked by LOCK TABLE table WRITE/READ command ?
cheers,
Marcin
© Stack Overflow or respective owner
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
I tried everything till now:
sudo apt-get remove mysql-server mysql-client mysql-common
sudo apt-get purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
and even more commands...
But whenever I am trying to locate mysql. I get a no. of files related to mysql
command:
shell>>…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Mysql was started:
/usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
but when I'm trying to do something:
ERROR 1548 (HY000) at line 1: Cannot…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin.
As far as I can tell, the only copy of MySQL…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Can't start mysql with:
sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
120222 13:40:48 mysqld_safe Starting mysqld daemon with databases…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive lock then that UPDATE statement will need to wait until the SELECT statement releases its shared locks…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a couple questions concerning Update (U) locks and Exclusive (X) locks.
1) Am I correct that an 'X' lock is put on a resource when the resource is about to get updated?
2) I'm a little fuzzy on U locks. Am I correct that a U lock is applied when a resource is read and SQL Server thinks it…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
In android 2.1, if we enable pattern lock, then the screen lock (slide to unlock) is not displayed and if pattern lock is disabled then screen lock is enabled again. Can someone point me out the java file in framework and the function where this happens. I mean when the screen is about to get…
>>> More
as seen on Simple Talk
- Search for 'Simple Talk'
Today's post will explore why the current ways to communicate between threads don't scale, and show you a possible way to build scalable parallel programming on top of shared memory. The problem with shared memory Soon, we will have dozens, hundreds and then millions of cores in our computers…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am using in my code at the moment a ReentrantReadWriteLock to synchronize access over a tree-like structure. This structure is large, and read by many threads at once with occasional modifications to small parts of it - so it seems to fit the read-write idiom well. I understand that with this…
>>> More
