Hi Guys,
I need a help, as i am new to mysql and i want to create a batch file that can
truncate table and Load (LOAD DATA INFILE) one .csv file which is generated
every 2min into that table.
I have created one batch file where i can only able to login into databse,
further my commands are not
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 develope
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: http://
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 over
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
structu
Hmm, that makes sense. I should have thought of that. Thanks!
On Fri, Aug 7, 2009 at 12:32 PM, Johnny Withers 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 (0.00 sec)
> m
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
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 admini
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 5.1.
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 storage.
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 di
11 matches
Mail list logo
