Midgard DB indexes

Posted on 2007-02-04 13:01:23 EET.

I just realized that Midgard blobs table doesn't use indexes for legacy db structure. If you still use legacy applications and legacy code, add two indexes to blobs table:

CREATE INDEX blobs_pid_idx ON blobs (pid);
CREATE INDEX blobs_ptable_idx ON blobs (ptable);

Also increase cache size ( in my.cnf file ):

query-cache-size=92M

I set 92M in my case , but you can tweak it with different value.

in other news: It's not fun when the whole family is ill. Ladies are getting better. Ola must stay at grandma's place for one week more. Aga had 40,2 temperature two days ago and I got throat infected. It's just the way when your kid "brings" something from kindergarten ;)

Also I need to fix few minor issues found in 1.8.2. And make midgard-core 1.8.2.1 hotfix release package. I think I should do it soon as I am no longer a house nurse ;)

Back

Layout Copyright © 2006 Finnish Teleservice Center Ltd Oy - Site Powered by Midgard CMS