amjith on main
Identify TiDB in the prompt. Include TiDB in tests and mycli… Merge pull request #1068 from d… (compare)
amjith on tidb
Add TiDB changes to changelog. (compare)
amjith on tidb
Add TiDB to myclirc. (compare)
amjith on tidb
Identify TiDB in the prompt. (compare)
select id, name from users in (156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 156963, 156964, 156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 15
6963, 156964, 156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 156963, 156964);
When I copy, there is an extra space. How do I solve this problem
hi mycli users.. I'm facing an issue.. hope someone has an answer.
When I try to connect to MySQL 8 which has SSL on.. I get this error.
(3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.')
Any trick to bypass the ssl and connect to it. Its a remote server where I dont get to control or access to certificate.
hey there - I am having issues with mycli
regarding the --login-path
argument although same configuration works for mysql
client.
This fails and asks me password
mycli --login-path=foo -D bar
Connecting to socket /tmp/mysql.sock, owned by user
Password:
This works
mysql --login-path=foo -D bar
What could be the problem?
~ $ mysql --version
mysql Ver 14.14 Distrib 5.7.32, for osx10.15 (x86_64) using EditLine wrapper
~ $ mycli --version
Version: 1.23.2
Hi, I am using mycli version 1.23.2 on ubuntu 21.04. I need to provide both the -p switch together with password in order to use mycli. With either or both the password or -p switch left out, I will get an error message, see below.
This has been raised as an issued dbcli/mycli#973
Any help is much appreciated.
❯ mycli -u root
Connecting to socket /var/run/mysqld/mysqld.sock, owned by user mysql
(1698, "Access denied for user 'root'@'localhost'")
Approaches to handle 10 million records of 10 tables each with several joins
I have 10 million records of 10 tables each with several joins. I am looking for the best alternative or DB assign or approach to read the records very quickly that is the query should be fast.
option#1 - normalize the tables, don't go for joins unnecessarily
option#2 - add all the columns in 1st query where multiple times the
where conditions will be used in the looping construct
option#3 - go for nosql database instead of mysql
Please advise
Thanks