sqlDashboards Blog

SQL Pie Chart MYSQL

I came across this interesting post on ASCII pie charts for MySQL. I thought I’d use our command line tool sqlChart todraw the database pie chart instead.

[raw]
<br /> c:\Program Files (x86)\TimeStored.com\sqlDashboards>mysql -s mysql -u root –password=pp -D sakila<br /> -e “SELECT * FROM (SELECT table_name,data_length + index_length AS size FROM information_schema.TABLES WHERE table_schema = ‘sakila’) a<br /> WHERE SIZE IS NOT NULL ORDER BY SIZE DESC LIMIT 8”</p> <p>table_name size<br /> rental 2850816<br /> payment 2228224<br /> inventory 376832<br /> film_text 325440<br /> film_actor 278528<br /> film 278528<br /> customer 131072<br /> staff 98304</p> <p>c:\Program Files (x86)\TimeStored.com\sqlDashboards>sqlchart -s mysql -u root –password=pp -D sakila -e “SELECT *<br /> FROM (SELECT table_name,data_length + index_length AS size FROM information_schema.TABLES WHERE table_schema = ‘sakila’) a<br /> WHERE SIZE IS NOT NULL ORDER BY SIZE DESC LIMIT 8” -o c:\temp\aa\sizes.png -c piechart<br /> c:\temp\aa\sizes.png<br />
[/raw]

Simply changing our mysql command to sqlchart and adding the additional arguments
"-o c:\temp\aa\sizes.png -c piechart"
gives us the following SQL Pie Chart:

MySQL Sakila Table Sizes Pie Chart

Notice because sqlchart’s command line arguments closely resemble the mysql command line options, we can quickly change the calls from querying to graphing.