- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
CREATE TABLE search_terms_new ( search_terms_id mediumint(9) NOT NULL, search_terms varchar(255) NOT NULL, PRIMARY KEY(search_terms_id) ) ENGINE = InnoDB AUTO_INCREMENT = 0 GO ALTER TABLE search_terms_new ADD CONSTRAINT the_unique UNIQUE (search_terms) GO
INSERT IGNORE INTO server_logs.search_terms_new (search_terms_id,search_terms) SELECT LAST_INSERT_ID()+1, search_terms FROM server_logs.search_terms
1 record(s) affected [Executed: 10/28/2013 4:35:49 PM] [Execution: 5s]
0 record(s) affected [Executed: 10/28/2013 4:36:25 PM] [Execution: 4s]
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.