The ideal setup is based on your data and access patterns to that
data. Read these two pages to get a start:
http://dev.mysql.com/doc/mysql/en/server-parameters.html
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
By understanding what each variable does, you'll know which one to
change. Getting the optimal value will require testing and the limits
of your hardware (i.e. RAM).
On Aug 18, 2005, at 5:43 PM, Andrew stolarz wrote:
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
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
