|
Tuesday, 21 September 2010 19:01 |
Add the following lines in the MySQL configuration file (my.cnf or my.ini) to log the queries and the slow queries in a MySQL table:
slow-query-log
log-output = TABLE
long_query_time = 1
general-log
expire_logs_days = 1
Sample queries:
select * from mysql.general_log order by event_time desc limit 10;
select * from mysql.slow_log order by start_time desc limit 10;
 Read more: |
|
Monday, 14 December 2009 06:00 |
 | About SQL Power Wabit
An easy-to-use, all-in-1 Business Intelligence Reporting and Analysis tool. It offers database and business users the ability to perform Ad-Hoc Queries, generate Standard Reports and more. The most intuitive and simplest BI Reporting tool on the market, SQL Power Wabit includes innovative features such as a drag-&-drop playpen, live result-set updates, global searching, and WYSIWYG report formatting. With a single mouse click, query results can be instantly transformed into elegant reports that can be further customized with fonts, colours, sections, breaks, headers, footers, logos, and more.
Features include:
- Standard Reports & Custom Dashboards
Ad-hoc Queries & Drill-down OLAP cubes
- Line, Bar & Pie Charts
- Real-time BI Reporting
- Many more features. |
Read more: |
