I have created a new application in Grails and surprisingly, in production environment it was slower than on my laptop. Production administrator found that my application generate too many SQL queries. The delay was caused by network latency. So, I had to find a way how to monitor number of SQL queries on MySQL server.… Continue reading Monitoring number of SQL queries in MySQL
Tag: MySQL
From Mysql to Oracle: Grails application migration
Today I have finished migration of our Grails prototype. Originally we did develop it for MySQL, but the final system have to work with Oracle. This post summarize troubles and differences I was facing. User creation Since I am not Oracle administrator, it took me some time to put together script that creates user and… Continue reading From Mysql to Oracle: Grails application migration
Improve performance of MySQL driver for RoR
Last week I was working on the performance tuning of a rails application. I ran a profiler and found something very interesting. I found that there is a procedure that is called very often and takes a lot of time. % cumulative self self total time seconds seconds calls ms/call ms/call name 14.99 18.13 18.13… Continue reading Improve performance of MySQL driver for RoR
Full text search in Ruby on Rails 2 – MySQL
My previous post compared MySQL and ferret full text search engines. For our project, the ferret was the winner. Nevertheless, I will try to show the beauty and simplicity of using MySQL indexes. Create table and indices First of all it is necessary to create table and the corresponding index. Create table articles( id integer… Continue reading Full text search in Ruby on Rails 2 – MySQL