Re: MySQL insert performance

2005-11-11 Thread Matthew Lenz
what does the JDBC code look like that your using to do the inserts? On Fri, 2005-11-11 at 13:56 -0800, Dhiren Bhatia wrote: > Any ideas on how I can optimize this? Thanks. > > On 11/9/05, Dhiren Bhatia <[EMAIL PROTECTED]> wrote: > > > > This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) wi

database design

2005-10-03 Thread Matthew Lenz
anyone using openoffice:base to design mysql db's? back when I tried it earlier this year it wasn't able to define relationships which made it pretty much useless as a time saving tool. -Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

Re: Backup / Restore database with foreign keys

2005-09-29 Thread Matthew Lenz
i think you can use -K on your mysqldump and it'll put the hints in there for the mysql command to use as well - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: Sent: Thursday, September 29, 2005 7:45 PM Subject: Backup / Restore database with foreign keys Greetings

Re: default my.cnf vs huge.cnf nearly same performance with sql-bench/run-all-tests

2005-09-12 Thread Matthew Lenz
ueries on various > large indexes causing > MySQL to really use its key_buffer, then there would be a more > noticeable difference > between a 16M key_buffer and 384M. > > -Daniel > > Matthew Lenz wrote: > > > so the sql-bench stuff doesn't push the mysqld to

Re: default my.cnf vs huge.cnf nearly same performance with sql-bench/run-all-tests

2005-09-11 Thread Matthew Lenz
so the sql-bench stuff doesn't push the mysqld to its limits? - Original Message - From: "Daniel" <[EMAIL PROTECTED]> To: "Matthew Lenz" <[EMAIL PROTECTED]> Cc: "mysql" Sent: Sunday, September 11, 2005 1:12 PM Subject: Re: default my.cn

Re: default my.cnf vs huge.cnf nearly same performance with

2005-09-10 Thread Matthew Lenz
- Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> Hello. huge.cnf example. What about that thread_concurrency setting in huge.cnf.. it doesn't seem to show up in a 'show variables' when using it.. is it deprecated? In the manual it is meant that thead_concurrency is use

default my.cnf vs huge.cnf nearly same performance with sql-bench/run-all-tests

2005-09-09 Thread Matthew Lenz
infact .. the default debian config (some of these are just explicit defaults but this is what debian provides): [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 basedir = /usr datadir