Yesterday my two concurrent mysqlimport process hangs the production mysql server. The two import process all shows “repair with keycache”. I am not sure why the repair command is issued, but as the “repair with keycache” takes forever and it eventually frozes the entire MySQLs, I have to optimze it.
I have migrated “ensembl + DAS” from Marie’s linux workstation to Kampen and Genesis successfully. Marie has helped me to do everything from scratch (including hacks on ensembl web codes), so that we can track on the changes made. Below is the draft I sent to Ramneek/Neal/Kevin/Tim for review. I also proposed having all these discussed in CMAB meeting when Ramneek is back.
I once helped machine to install mysql4 on her own linux box. It is on /usr/local/ensembl/mysql4. To start this instance, login to marbore as my id, change folder to /usr/local/ensembl/mysql4 and do “bin/mysqld_safe –no-defaults &”. To access the local mysql server, do a “/usr/local/ensembl/mysql4/bin/mysql -u root”.
As my site has been linked by puzzlecat, MSN search engine regularly crawl this site, but M$ sucks and its search engine is just a crap. I decided to put my site into google by submitting the sitemap to it.
Kevin is actively pushing myGRID technology across LSB site. As my presentation last time was successful, we worked hard to introduce and install this package to more users in bix team. Before doing that, I was adviced to move the myGRID server from my linux box to pierce (our dev server).
Marie asked me to help her install ensembl v31 on her local machine
as the support team is relunctant to install it on the server.
This is the new version of scripts that I used to download ensembl
mysql data v31 and import data into mysql server. This version works
with gzipped format.
The taverna workbench from mygrid 0.6beta 2 is only 1.0. I managed to upgrade it to the latest 1.2. Here is the notes on configuration.
Marie requested for a few perl modules to be installed. As Mojun is sick, I took this job instead.