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 ;)