Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Michael Dykman
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

Re: Req. suitable .cnf file for Server used by 2000 users daily

2009-10-28 Thread Jeetendra Ranjan
mysql is successfull in login with same user and password but when the same user and password is given at mysqltuner end it always shows the same error [!!] Attempted to use login credentials, but they were invalid. Thanks Jeetendra Ranjan SynapseIndia

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
Michael, Does MySQL support multi-db transactions? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum:

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Ye Yuan
Looks to me we should use XA transaction syntax instead. Check this: http://dev.mysql.com/doc/refman/5.0/en/xa.html Thanks, YY 2009/10/28 Martijn Tonies m.ton...@upscene.com Michael, Does MySQL support multi-db transactions? With regards, Martijn Tonies Upscene Productions

ANN: Free Database Workbench 3.4.1 Lite released

2009-10-28 Thread Martijn Tonies
Upscene Productions releases a new version of Database Workbench Lite There are editions available for MySQL, Firebird and InterBase. What is Database Workbench? Database Workbench Pro is a cross database development environment for database administrators

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
Ah, works for InnoDB I see. Nice. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum:

Open Tables

2009-10-28 Thread sangprabv
I saw so many open tables in my server, is it dangerous? And if I execute flush tables what does it impacts to the open tables? Thx. Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Open Tables

2009-10-28 Thread Martin Gainty
Will Generally this means you need to look at the schema design of your database system If you are running a simple contact Database for Mom and Pop store and you have connections to 100 tables open then you would want to take a more serious look at the schema you are using to merge

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Paul DuBois
If all the tables are InnoDB, XA isn't needed. It doesn't matter whether all tables are in the same database. On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote: Ah, works for InnoDB I see. Nice. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Michael Dykman
There seems to be some confusion about 'multi-db'.Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
There seems to be some confusion about 'multi-db'.Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out

help with group by

2009-10-28 Thread Adam Williams
I've written a helpdesk ticket problem and am working on the statistics module. I'm having problems with group by. For instance, I want to get the count of the number of different problem types, by how many were solved by each person. This is my statement: mysql select distinct

Re: help with group by

2009-10-28 Thread Michael Dykman
try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by, problem_type On Wed, Oct 28, 2009 at 12:05 PM, Adam Williams awill...@mdah.state.ms.us wrote: I've written a helpdesk

Re: help with group by

2009-10-28 Thread Adam Williams
works perfectly, i didn't know you could use multiple columns in the group by. thanks a bunch! Michael Dykman wrote: try this: select accepted_by, problem_type, count(*) from form where problem_type is not NULL AND problem_type != 'Test' AND accepted_by is not null group by accepted_by,

Server just hangs when executing a query

2009-10-28 Thread Mayuran Yogarajah
We had a bit of a scare yesterday when one of our scripts just hung indefinitely. We nailed it down to a query in the script. When we executed the query manually, it hung as well. We ended up having to restart MySQL which for some reason fixed it. Some background: We're running MySQL 4.0.25.

How to Backup the Database using Script

2009-10-28 Thread Ganeswar Mishra
Hi Everyone, I am trying to backup a database regularly, without using Administrator tool in mysql, Can anyone help to write a scipt regarding backup database. -Thanks in Advance Ganeswar