MySQL ODBC Connector - (Solved) Re: Unbelieveable with 4 Gbytes

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

(Solved) Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350

Ady Wicaksono

2006-02-28, 8:28 pm

Thanks.....

Since i use Innodb, i decrease the value of all variables affected
myisam table

Thx

joce@presence-pc.com wrote:

>Lowering your sort_buffer and read_buffer to 512K should help (there are
>allocated for each connection, and (12+12)*910 is a lot more than what
>your system can handle).
>And if you really want to take advantage of your 4GB with MySQL, switch to
>a 64 bits system :)
>
> Jocelyn
>
>
>
>
00M;/data4/ibdata13:2000M;/data4/ibdata14:2000M;/data4/ibdata15:2000M;/data4/ibdata16:2000M;/data5/ibdata17:2000M;/data5/ibdata18:2000M;/data5/ibdata19:2000M;/data5/ ibdata20:2000M;[colo
r=darkred]
>
>
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links