Tagged Questions
0
votes
1answer
54 views
Mysql commit sometimes takes minutes to finish
Ive been having this problem for over 1 week now. Ive allready gone though the similar problems other people had here on stackoverflow. Im running Mysql 5.6.10.
"query end" step very long ...
0
votes
1answer
19 views
Please help me understanding MySQL InnoDB Transactions
I'm trying to understand the locking mechanisms for InnoDB.
Let's say i have the following PHP script:
mysql_query('BEGIN;');
$a=mysql_query('SELECT id, status FROM testtable WHERE id=123 LIMIT 1 ...
0
votes
0answers
41 views
Is MySQL commit synchronous when executed from PHP PDO?
Using the PHP PDO interface to MySQL, suppose I have this code to end a transaction (assuming it was properly begun):
$pdo->query('commit');
When the function returns, have writes to the log ...
0
votes
0answers
57 views
MySQL second connection does not see committed change from first connection
I have a problem with a Grails based application that is connected to MySQL where there is a process that updates a record as part of a larger transaction. This process also kicks off a 2nd thread via ...
0
votes
0answers
67 views
I get last insert value but I don't see such a record in the table
I am having an issue with an insert statement. Once I process a query using PDO I display on my screen the last inserted id. it displays this number 4344484. But when I search for 4344484 in my table ...
1
vote
4answers
106 views
PHP: my page takes a very long time to load but does not time out. Are there too many queries at once or can my code be optimized?
This is the function I use to access the DB, theoretically maybe up 10-20 times in a do while loop, though right now I removed the loop so it only can do one db query at a time. Can this be optimized ...
1
vote
1answer
114 views
Does mysql_query commit everything
I am using mysql extension in php, I know it is deprecated as of PHP 5.5.0, but I have a lot of code allready written with the use of this extension.
It seems to me like mysql_query commits the query, ...
0
votes
0answers
128 views
Java MySQL calling commit() on a large EntityTransaction object failed
I have a large javax.persistence.EntityTransaction object, say ent, when I called the method commit() on this object (to insert a new record into my (MySQL) table:
ent.commit();
I got the quere ...
0
votes
1answer
155 views
Can MySQL commit fail if individual queries works? [duplicate]
Possible Duplicate:
Can a COMMIT statement (in SQL) ever fail? How?
Can a commit query fail if all queries within the transaction returned a working result?
I have a $ok = ...
0
votes
0answers
73 views
Software to backup mysql and commit to Bitbucket? [closed]
I am struggling to find a solution to enable automatic backup of a MySQL database and commit(and push) it to a bitbucket account?
Is there a piece of software which can do this, or will I need to ...
3
votes
1answer
123 views
Problems with “commit” after SQL INSERT with Python and SQL
I made a loop in Python that calls itself to repeatedly check for new entries in a database. On first execution, all affected rows are shown fine. Meanwhile, I add more rows into the database. On the ...
0
votes
2answers
115 views
how to use commit to save all query and if any one query failed no data should be save
I have an employee form.In that i have used tabbed pane to get four different tabs.But problem is that if i save data on first tab only it get saved in database. and before saving data on other tabs i ...
0
votes
1answer
63 views
Too many selects in a second - Mysql
I have a system that sends emails for me and my clients every day in the morning. This process is triggered automatically through access to my website, via an iframe.
Often, I receive the same email ...
0
votes
1answer
75 views
How to tell if error occured in MySQL client script
I can't discover how to tell if an error occurred in a MySQL client script (after a couple of hours googling and reading the MySQL docs. I would expect there would be something like an error flag or ...
0
votes
1answer
100 views
Max value from auto commit false table
My problem is i have set a table auto commit false. I need to get the max id from that table(the currently inserted value of auto increment id). But i am getting the id of the previous committed ...
