[Rt-devel] Upgrading a gigantic 3.4.4 database to 4.0?

[Ruslan Zakirov]

Lowering some mysql options helps as well. However, if you are going to use
this server for mysql and can give it more than 2gb then 64bits is your way.

Regards, Ruslan. From phone.
05.05.2011 3:13 пользователь "Alex Vandiver" <alexmv at bestpractical.com>
написал:
> On Wed, 2011-05-04 at 14:06 -0700, Jeff Albert wrote:
>> Thanks for the quick reply. MySQL's error log suggests it's failing to
>> allocate memory past about 2.5GB; I'll work with our DBAs to see what
>> we can do with MySQL in this area.
>
> This is likely because you're running a 32-bit kernel, and MySQL is
> unable to access more memory because of that. Running a 64-bit kernel
> will allow you to allocate more memory to MySQL.
>
>> Generally I'm curious about the feasibility of continuing to run a
>> single large instance of RT; presumably at some point the query times
>> will just become untenable (bringing up the query builder in our
>> existing 3.4 instance can take up to a minute even now). Would you
>> recommend separating into smaller instances, or a different approach?
>
> There are existing RT instances with terabytes of data. Proper tuning,
> indexing, and provisioning of your database will go a long way.
> - Alex
>
> _______________________________________________
> List info:
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-devel/attachments/20110505/7fc8b252/attachment-0001.html>