Hello, I did a complete new install on another machine but this time I selected the dedicated server option during the first setup, reran the same process and its going about 3 times faster then it did before.. so it looks like I am on the right track! the current sizes I have for the following are: whats the ideal setup for these? key_buffer_size = 37748736 myisam_max_sort_file_size = 48234496 bulk_insert_buffer_size = 8388608 any other sugestions where to look? many thanks everyone, Andrew
On 8/18/05, Brent Baisley <[EMAIL PROTECTED]> wrote: > > MySQL is not limited in anyway if you don't have a license. The > default install is not optimal for the hardware you are running it > on. The default parameters are set pretty low so as not to monopolize > your system. If you are doing a big insert, you should adjust the > appropriate buffers (key_buffer_size, myisam_max_sort_file_size, > bulk_insert_buffer_size) . M$ SQL is kind of optimized out of the > box. MySQL allows you to really fine tune the database to fit your > needs, right down to using difference table types for your data. > Don't expect good performance by just installing and running. You > would actually want to set certain variables to one value for your > bulk insert and then change them for normal use. > > > > On Aug 18, 2005, at 3:29 PM, Andrew stolarz wrote: > > > Hi folks, > > I just downloaded MySQL 4.1 to see if its a go ahead with our > > application, > > I am doing a tranfser from our current datafile to MySQL, its > > taking about > > 45 min to do this process.. > > when I do the same process and transfer to a M$ SQL server, it > > takes about > > 2 min max. > > is the 4.1 of mySQL that I downloaded throttled somehow until I > > purchase > > the license for it? > > many thanks > > Andrew > > > > -- > Brent Baisley > Systems Architect > Landover Associates, Inc. > Search & Advisory Services for Advanced Technology Environments > p: 212.759.6400/800.759.0577 > > >