Operating Vitess: Queries

Can I address a specific shard if I want to?
If necessary, you can access a specific shard by connecting to it using the shard-specific database name, or issuing a USE statement to switch to it if alre...
Wed, Jun 30, 2021 at 10:49 AM
Can I choose between master & replica for query routing?
You can qualify the keyspace name with the desired tablet type using the @ suffix. This can be specified as part of the connection as the database name, or ...
Fri, Dec 18, 2020 at 10:18 AM
Can I set a session variable query timeout?
If you would like something similar to Percona's max_statement_time you can set the vttablet command line flag as follows: -queryserver-config-query-tim...
Fri, Apr 30, 2021 at 12:05 PM
Can I increase the resource pool timeout for streaming requests?
Yes. You can adjust the flag -queryserver-config-stream-pool-size=100.
Fri, Dec 18, 2020 at 10:14 AM
How can I perform a full table scan without the row limit per query?
Vitess supports different modes. In OLTP mode, the result size is typically limited to a preset number (10,000 rows by default). This limit can be adjusted ...
Fri, Dec 18, 2020 at 10:20 AM