[Building Sakai] Sakai 2.8.1 and MySQL 5.5?

Wed Feb 8 13:15:46 PST 2012

I stringy recommend using innodb-plugin. This comes with the Mysql 5.1 distribution, and causes no change in semantics. However it gives better and more predictable performance. You just shut down forcing a slow shutdown (

SET GLOBAL innodb_fast_shutdown=0;

then shutdown normally

edit my.cnf to add

ignore_builtin_innodb
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so

for Unix or Linux. The line is slightly different for Windows. Start normally. The data/HOSTNAME.err file should show the version of the plugin, e.g.

120101  6:10:23  InnoDB: highest supported file format is Barracuda.
120101  6:10:24 InnoDB Plugin 1.0.17 started; log sequence number 480687578254

I would make sure to update to the most recent 5.1 before doing this.

As long as you don't set any other options or do any other plugin-specific stuff, you can still move back to the built-in version.

On Feb 8, 2012, at 12:02 PM, Walters, Cynthia (cmw6s) wrote:

> Thanks, everyone, for the clarifications on this point.
> 
> UVa currently plans to stay with MySQL 5.1 for our upgrade to Sakai 2.8.1.  
> Cindy @ UVa
> 
> ________________________________________
> From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Mark J. Norton [markjnorton at earthlink.net]
> Sent: Tuesday, February 07, 2012 4:23 PM
> To: sakai-dev at collab.sakaiproject.org
> Subject: Re: [Building Sakai] Sakai 2.8.1 and MySQL 5.5?
> 
> The table sakai_person_t  is present in my local database instance.
> 
> On 2/7/2012 4:09 PM, Steve Swinsburg wrote:
>> Yes, some tables were not being created properly (SAKAI_PERSON_T), but you won't know that unless you use the tools that require them (or can catch the error in catalina.out as it flies past).
>> If people running 5.5 could check that table exists, that would be great. There has been work done to resolve this particular issue so hopefully it should be ok. It would be great to get support for this version as this question does come up every now and then.
>> 
>> cheers,
>> Steve
>> 
>> 
>> On 08/02/2012, at 6:23 AM, Charles Hedrick wrote:
>> 
>>> I seem to recall an issue with creating tables for a new instance. Is that still true?
>>> 
>>> We're currently testing MariaDB 5.2 and plan to move to it if 2.9 is not QAed for 5.5. It uses Percona's Innodb. That should give most, though not absolutely all, of the performance improvements of 5.5. (Actually, just moving to Innodb plugin gives a lot of the performance benefits.)
>>> 
>>> MariaDB 5.3 is currently in release candidate. It is attacking the large set of performance issues with subqueries. That might well be more important than the improvements in 5.5 as compared with Maria DB. The MariaDB team does expect to digest 5.5 at some point.
>>> 
>>> 
>>> On Feb 7, 2012, at 1:20 PM, Aaron Zeckoski wrote:
>>> 
>>>> I am using 5.5 locally and we use it on a few servers here and there
>>>> (for 2.9/trunk only). I still think we need QA to actually hammer on
>>>> it but I suspect that it might not be too much trouble.
>>>> 
>>>> -AZ
>>>> 
>>>> 
>>>> On Tue, Feb 7, 2012 at 12:41 PM, Noah Botimer<botimer at umich.edu>  wrote:
>>>>> MySQL 5.1 has received the testing and production installation to date.
>>>>> There were a few incompatibilities intentionally resolved, so things may
>>>>> work fine with 5.5, but I don't think we've done any formal QA -- just the
>>>>> initial work to allow the start of testing.
>>>>> 
>>>>> So, yes, I would say that 5.1 is the required version for now.
>>>>> 
>>>>> Thanks,
>>>>> -Noah
>>>>> 
>>>>> On Feb 7, 2012, at 11:12 AM, Walters, Cynthia (cmw6s) wrote:
>>>>> 
>>>>> Hello:
>>>>> Another question about setting up a system for Sakai 2.8.1.  Anyone using
>>>>> MySQL 5.5 with Sakai 2.8.1?
>>>>> 
>>>>> The release notes state v5.1+.  Should this be read as "any version of MySQL
>>>>> 5.1"?  Thus, not v5.5?
>>>>> 
>>>>> Thanks for the clarification,
>>>>> Cynthia Gast
>>>>> University of Virginia
>>>>> cmw6s at virginia.edu
>>>>> 
>>>>> _______________________________________________
>>>>> sakai-dev mailing list
>>>>> sakai-dev at collab.sakaiproject.org
>>>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>>> 
>>>>> TO UNSUBSCRIBE: send email
>>>>> to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>>>>> "unsubscribe"
>>>>> 
>>>>> 
>>>>> 
>>>>> _______________________________________________
>>>>> sakai-dev mailing list
>>>>> sakai-dev at collab.sakaiproject.org
>>>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>>> 
>>>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org
>>>>> with a subject of "unsubscribe"
>>>> 
>>>> 
>>>> --
>>>> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
>>>> _______________________________________________
>>>> sakai-dev mailing list
>>>> sakai-dev at collab.sakaiproject.org
>>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>>> 
>>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>>> _______________________________________________
>>> sakai-dev mailing list
>>> sakai-dev at collab.sakaiproject.org
>>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>> 
>>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> 
>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>> 
>> 
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120208/2ce0753d/attachment.html 