Hi Peter, all,
let me just concentrate on the NFS aspect:
Peter Chacko wrote:
[[...]]
Another question is , whats the general experience of running MySQL
servers on NFS shares ?
I would *never* use NFS storage for any DBMS (except for some testing):
NFS access is slower than local disk
Hi Jorg,
I really appreciate your help sharing your experience/thoughts.
Yes, i fully concur with you, NFS is not designed for Databases. But
you know there are Distributed SAN file systems (that use Direct IO to
the SAN) are serving databases like DB2 in many installations for
shared
Hey folks. I'm getting some weird behaviour out of Auto_increment.
If I enter a attempt to INSERT a row into a table with a UNIQUE index,
where the insert would violate uniqueness of existing data, I'm seeing
the auto_increment increase even though the insert fails.
The server in question is
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
It will also update the auto_increment column when you ROLLBACK a failed
insert:
mysql USE test;
Database changed
mysql SELECT * FROM t1\G
Empty set (0.00 sec)
mysql DROP TABLE t1;
Query OK, 0 rows affected (0.06 sec)
mysql
mysql CREATE TABLE t1(
- id INT UNSIGNED NOT NULL AUTO_INCREMENT,
Hmm, that makes sense. I should have thought of that. Thanks!
On Fri, Aug 7, 2009 at 12:32 PM, Johnny Withersjoh...@pixelated.net wrote:
It will also update the auto_increment column when you ROLLBACK a failed
insert:
mysql USE test;
Database changed
mysql SELECT * FROM t1\G
Empty set
I am creating surveys for our website and want store questions and answers
in a database. I found a tutorial that was useful, however it only gave
structure for a single question with one answer. My surveys need to be more
comprehensive than a poll question, and so I need some help with the
I always accepted that NFS was unacceptably slow for database access, until I
actually tested it. Turns out that with lots of RAM and properly tuned caches,
you're optimizing for minimal IO anyway. A good file server will have massive
amounts of IO OPS. On top of that if you're using GigE
Hi Gavin,
I am interested in the things you made for the optimization. Can you share
with us such things?
Thanks a lot,
--
Banyan He
Network System Security Infrastructure
Mail: ban...@rootong.com
Blog: http://www.rootong.com/blog
LinkedIn: http://www.linkedin.com/in/banyanhe
Website:
And NFS is becoming better and better with the adoption of 10GbE, and
NFSoRDMA ...i am sure at that point no body will complain about NFS
performance for databases. And for a parallel database access, pNFS is
also shaping up well. As NFS creators are now owned by ORACLE who
themselves have
10 matches
Mail list logo