Re: Question about MySQL
Hi all! First of all, please excuse the typo I made in my posting. I had written There may be some merit to this in a specialized setup (NAS systems - I'm not convinced of them, but don't claim expert knowledge about them), and of course meant SAN, not NAS systems. As regards NFS: Peter Chacko wrote: 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 developed technology like direct NFS, NFS and Database storage will be great buddies in future. thanks On Fri, Aug 7, 2009 at 11:37 PM, Gavin Toweygto...@ffn.com wrote: 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 few hops, then it's really not slower than local disks. I immediately agree that NFS becomes faster due to technical progress, like any other part of computing. But however clever you optimize your NFS setup (including the network, the servers, ...), you always have the additional latency of the network and the NFS server (compared to the local disk). Remember: Database performance is not only about throughput, it is also about latency. So NFS can only be slower than a local disk, never the same turnaround time, let alone faster (assuming equal disks and machines, of course). Whether that is *too* slow is another question - depending on your software, your workload, and your hardware it may be fast enough. However, my main objection against using NFS for database storage is not performance, it is complexity: If your database server does not use local disks but NFS, then the network between the database server and the NFS server as well as that server suddenly become essential components for your database setup. As any component may fail, you increase the risk to your DB. You may reduce the individual risk by selecting better hardware, dual controllers, dual cabling, mirrored machines, ... as much as you like, the result will still be higher complexity and higher risks than if you had applied similar enhancements to your database server and its local disks. Remember: benchmark and test your assumptions! Agreed. Regards, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com (+49 30) 417 01 487 Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Install mysql-workbench bug
I am installing mysql-workbench- oss-5.1.16. tar.gz on Linux and I hit this bug during ./configure cannot find install-sh or install.sh I checked and the file install-sh is in the directory ... /mysql-workbench- oss-5.1.16. I have also installed a lot of other software in the server without running into this problem. Thanks!
does ado/myodbc not support blob data insert in vc6?
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk and GetChunk Methods Example (VC++) http://msdn.microsoft.com/en-us/library/ms676103(VS.85).aspx The connection to mysql server was changed by following: _bstr_t strCnn(DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;DATABASE=test; USER=root; PASSWORD=111;OPTION=3;); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
error 135
Hi All, why do i have this error. i have recently setup a mysql cluster, i now have around 60 tables on it. when i create a new one, it gives me this error. ERROR 1005 (HY000): Can't create table './mydb/#sql-3e87_24c9a5d.frm' (errno: 135) any idea? TIA! Regards Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: error 135
This might help http://dev.mysql.com/doc/refman/5.0/en/repair.html Carlos On 8/10/2009 11:51 PM, Ron wrote: Hi All, why do i have this error. i have recently setup a mysql cluster, i now have around 60 tables on it. when i create a new one, it gives me this error. ERROR 1005 (HY000): Can't create table './mydb/#sql-3e87_24c9a5d.frm' (errno: 135) any idea? TIA! Regards Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: error 135
Hi, Is this the same for ndbcluster engine? Note that error 135 (no more room in record file) and error 136 (no more room in index file) are not errors that can be fixed by a simple repair. In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy but, currently i dont have the table yet, i'm just trying to create a new table and i get that message? any clue? TIA. Regards Ron Carlos Proal wrote: This might help http://dev.mysql.com/doc/refman/5.0/en/repair.html Carlos On 8/10/2009 11:51 PM, Ron wrote: Hi All, why do i have this error. i have recently setup a mysql cluster, i now have around 60 tables on it. when i create a new one, it gives me this error. ERROR 1005 (HY000): Can't create table './mydb/#sql-3e87_24c9a5d.frm' (errno: 135) any idea? TIA! Regards Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org