[GitHub] miloradkrstevski opened a new issue #5342: Superset 0.24 and MySQL db - Can not create / refresh charts because of big db

[GitBox <gi...@apache.org>]

miloradkrstevski opened a new issue #5342: Superset 0.24 and MySQL db - Can not create / refresh charts because of big db
URL: https://github.com/apache/incubator-superset/issues/5342
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if any
   - [ ] I have reproduced the issue with at least the latest released version of superset
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar
   
   
   ### Superset version
   0.24
   
   ### Expected results
   Faster creation (refresh) of charts
   
   ### Actual results
   Almost all of my charts can no be created (refreshed) because the creation time goes over 60 sec
   
   ### Steps to reproduce
   I work on Superset 0.24 with MySQL db connection. My db is 31.4GB from which 17.6GB is data and 13.8 is index on some of the most used columns. The records are in total 45.7M rows with 44 columns.
   
   1. Can someone please help me is it possible to work with this big db in Superset?
   2. What HW is needed for this Superset and db (they are on the same machine)? My config is virtual machine on SSD disk with 4x CPU@2.6GHz and 32GB RAM.
   3. Do I need to split Superset (as app virtual) and MySQL db (as db virtual) in order to succeed in visualization?
   
   Thank you very much in advance.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org