That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil wrote:
Hello Everyone,
I am a newbie using innodb.
How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update
two tables
that are located in two different databases. Would a single START
TRANSACTION be sufficient ?
Any help would be appreciated.
TIA
Mos
On Tue, Oct 27, 2009 at 7:51 AM, Bryan Cantwell wrote:
> I notice that issuing a reboot or shutdown -r now command, (in Linux) that
> the 'service mysql stop' is never run... it just seems to catch the sig 15
> and does its own shutdown...
> I have scripted in the stop section of my init script t
Signal 15 is pretty much equal to a regular shutdown, except that if your
shutdown script doesn't run, you may be left with lockfiles, pidfiles and
the like.
A crash would most likely be visible in the logfile, and even if it isn't
(machine loses power), your log should show innodb running a recov
Dear Steve,
On 27.10.2009, at 16:19, Steve Edberg wrote:
Or you could do an ALTER TABLE afterwards to add appropriate
indexes. And are you familiar with the EXPLAIN command to help
optimize queries/decide what indexes to add?
Thanks for this! I have added indicies with ALTER TABLE.
And usi
Socket connections do not use tcp (meaning localhost)
Remote hosts use tcpip
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi All,
Any body can explain the difference between socket connection and tcp/ip
connection.
Thanks,
Krishna
At 3:29 PM + 10/27/09, Olga Lyashevska wrote:
On 27.10.2009, at 15:11, Steve Edberg wrote:
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a
few).
On 27.10.2009, at 15:11, Steve Edberg wrote:
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a few).
I have been trying to use CREATE VIEW statement, w
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a few).
I have been trying to use CREATE VIEW statement, which works fine,
except for the fact that fields
Dear all,
I run a query and I try to save results as a table. On the results of
this first query I want to run yet another query (perhaps a few).
I have been trying to use CREATE VIEW statement, which works fine,
except for the fact that fields are not indexed because as I
understand it ind
I have an environment where upon boot of a machine I need to know if
mysql shutdown nicely or if it crashed.
How can I know for sure which was the case so that I can take action if
needed?
I notice that issuing a reboot or shutdown -r now command, (in Linux)
that the 'service mysql stop' is nev
Hi
thanks for your reply.
i found the problem, the problem was due to maintenance activity IT team
rebooted the machine but they didn't start the mysql server after reboot.
i executed mysqld with root credit. i got the below output but still the
cursor not return to prompt
bash-2.03# /usr/local
13 matches
Mail list logo