I'm sorry to hear that you're having such performance problems. I imagine that these cases are nuanced and challenging, and I strongly recommend that you contact our excellent Support team (firstname.lastname@example.org) so they may work with you to collect logs and discuss your database architecture. With this information we may be able to make some improvements to the queries Tableau generates in a future release.
I would also like to point out that we have made some improvements to Tableau's connectivity for MySQL in the upcoming v8.0 release. These improvements will help with both performance and stability, though I can't disclose the specifics at this point. They are not likely to address all known performance problems with MySQL, but they should help with some of your issues.
Last, there are numerous challenges in supporting a great, responsive experience with MySQL due to the rigid and limited nature of its query optimizer. For example, MySQL has limited ability to transform subqueries, so any use of Custom SQL in Tableau with MySQL will be subject to a significant performance penalty. This can often be addressed with a change as simple as creating a VIEW and using Tableau to connect directly to that VIEW (which will appear in the table selection list). At our customer conference TCC12 I presented this point and many related topics for understanding and improving performance between Tableau and your database -- you can watch a recording of my presentation here: http://www.tableausoftware.com/tcc12conf/videos/queries-impact-performance
I hope this helps,
you could try to do two things:
1. download and run Tableau Performance Analyzer provided by certified partner InterWorks and discover the root cause of the issues or at least to help as much as possible Tableau's support team with this task.
- Troubleshoot Your Load Times
2. As you are a heavy duty shop powered by MySQL I'll suggest you to evaluate Tokutek's (http://www.tokutek.com/) tokudb storage engine and see if can improve your queries response time in general, not only those generated by BI application, Tableau in this case.
thanks Robert and Cristian,
Those are great suggestions - I'll try the performance analyzer, watch the presentation, and then contact support if I'm still having issues. I've heard of Tokutek but haven't tried them yet - I'll give them a shot.
It seems strange to me that no-one has mentioned the use of Tableau extracts in this thread? Are you aware of them and how they help with performance, and particularly provide isolation from your database?
Shout if not as they could solve all your problems overnight, this will be even further enhanced if you are a Tableau server customer too, so let us know if that's the case.
I'm the Account Manager for your organization. I reached out via email and happy to work with you on this.
Through the proper use of data extracts and the data server, you can eliminate 100% of the unwanted burden on your databases. Happy to set up a 30 minute web-ex to walk through this functionality.