Jasper Reports

Best BI Software

Posted on

JasperSoft Pentaho Watson Analytics *** Very Poor (even cancelled the trial) *** Microsoft Power BI AWS¬†Quick Sight *** Still on Trial *** DELL – Boomi *** No Trial that I was Able to see ***   SQL Graphs review from Quora…   Chartio : for the data-consuming portion of the company.¬† Most of our small […]


Mautic: Clear Cache from Application

Posted on

root@ubuntu:~# php /var/www/mautic/app/console cache:clear Note that after clearing Cache the App is Stuck because there is a Permissions problem (Mautic cannot write the Cache Folder) so you need to chmod -R 777 cache folder (this is insecure but works). You need to use the appropriate permissions based on your requirements.


PostgreSQL: Table Sizes

Posted on

SELECT *, pg_size_pretty(total_bytes) AS total , pg_size_pretty(index_bytes) AS INDEX , pg_size_pretty(toast_bytes) AS toast , pg_size_pretty(table_bytes) AS TABLE FROM ( SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM ( SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME , c.reltuples AS row_estimate , pg_total_relation_size(c.oid) AS total_bytes , pg_indexes_size(c.oid) AS index_bytes , pg_total_relation_size(reltoastrelid) AS toast_bytes FROM pg_class c LEFT JOIN pg_namespace […]


MySQL: Enable Logging

Posted on

mysql> show variables like ‘%log%’; Recreate the log files I deleted by mistake. It appears the MySQL does not recreate them automatically. touch /var/log/mysql.log chown mysql:adm /var/log/mysql.log touch /var/log/mysql/error.log chown mysql:adm /var/log/mysql/error.log touch /var/log/mysql/mysql-slow.log chown mysql:adm /var/log/mysql/mysql-slow.log touch /var/log/mysql/mysql.log chown mysql:adm /var/log/mysql/mysql.log