summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-profiling.sql
blob: 0a0e4e1a58f73bb666c9473de41cd557cec83c3a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
-- profiling table
-- This is optional

CREATE TABLE /*_*/profiling (
  pf_count int NOT NULL default 0,
  pf_time float NOT NULL default 0,
  pf_memory float NOT NULL default 0,
  pf_name varchar(255) NOT NULL default '',
  pf_server varchar(30) NOT NULL default ''
) ENGINE=HEAP;

CREATE UNIQUE INDEX /*i*/pf_name_server ON /*_*/profiling (pf_name, pf_server);