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
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 followin
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
Nope, it's not throttled by default but a bad set of INI settings can ruin
your day.
I also run MySQL locally on a laptop (with worse hardware figures than
yours) and I have achieved Access to MySQL conversion speeds of 2000-8000
records per second (depending on the physical size of the record
>
> Hi Shawn,
> I am using the MySQL ODBC driver to connect from our application to the
> MySQL database,
> The actual server setting are default stright from the origional install,
> I am running all this from my laptop localy (both MySQL and MS SQL tests),
> P4 2.8GHZ, and 512mb ram.
> its
Andrew stolarz <[EMAIL PROTECTED]> wrote on 08/18/2005 03:29:39 PM:
> 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
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