Could you provide an example to load big dataset like Percona?

[vkingnew]

Always to test tidb performance by POC,sometimes we will use the production data,sometimes we can use public dataset such as ONTIME,like percona. the Genaral data format is CSV,could you provide an example like Percona-lab which used for TiDB.
https://github.com/Percona-Lab/ontime-airline-performance/tree/master/mysql

[jackysp]

I think TiDB could also use the same data set as Percona.
@vkingnew

[morgo]

The tidb manual uses public bikeshare as a example database.

I have started using ontime myself, I think it is a good dataset. Here is a blog post I wrote about it today: https://pingcap.com/blog/introduction-to-analytics-queries-for-the-mysql-dba/

[morgo]

Here is the manual link for bike share: https://pingcap.com/docs/bikeshare-example-database/ - look at the using explain page for example to see it in use

[vkingnew]

Good work,i will try.

[vkingnew]

The tidb manual uses public bikeshare as a example database.

I have started using ontime myself, I think it is a good dataset. Here is a blog post I wrote about it today: https://pingcap.com/blog/introduction-to-analytics-queries-for-the-mysql-dba/

could you show the code how to download the dataset and how to load the data,and total linenumers of ONTIME ,and how much time to run your SQL?

[morgo]

I use this script for importing with only small modifications to correct paths. Note that it requires TiDB 3.0 Beta 1, because earlier versions did not support the syntax OPTIONALLY ENCLOSED BY.

[vkingnew]

Thanks,In TiDB 2.1.7 the data which loaded into tidb display error format by Percona's script.
And support tidb 2.1.7 upgrade to 3.0 Beta 1？

[ghost]

I am going to close this issue as stale. Please feel free to re-open if you have any additional questions. Thanks!