All Questions
211
questions
0
votes
1
answer
299
views
I can not find -no-auto-rehash config in system varaibles
i am trying to find if auto rehash is enabled or not basically trying to find -no-auto-rehash is applied to DB or not. how can i check that.
I tried looking in all system variables but can't find that
0
votes
2
answers
764
views
How to updated my.cnf file to increase innodb-buffer-pool-size?
I am trying to updated the my.cnf file to increase the buffer pool size for a query I am running in python via mysql because I keep getting the error:
OperationalError: 2013 (HY000): Lost connection ...
- 77
0
votes
2
answers
179
views
MariaDB stops working without reason on small centos8 server
I have small web/mail server with apache/mariadb. Last week we changed some of the WWW code and to make it work I changed in php.ini line :
max_input_vars to 5000 (now 4000, it was 1000 at the start)
...
- 1
1
vote
0
answers
1k
views
ERROR Found option without preceding group in config file /etc/my.cnf at line 1. ERROR Fatal error in defaults handling. Program aborted
I am getting this error when i run mysql -uroot after installing mysql through brew install mysql
mysql: [ERROR] Found option without preceding group in config file /etc/my.cnf at line 1.
mysql: [...
- 11
0
votes
0
answers
567
views
transaction-isolation level is ignored in my.cnf
I am using mysql 8.0.27 running on ubuntu 20.04. transaction-isolation level is ignored in my.cnf and runs in default transaction_isolation-REPEATABLE-READ, but I am able to change the transaction-...
- 11
0
votes
0
answers
50
views
ft_stopword_file does not work with compressed tables
I added ft_stopword_file = "" to my.cnf in order to ignore stopwords.
Next, I compressed the MyISAM table using myisampack and myisamchk.
But there was a problem with stopwords, they are no ...
- 15
0
votes
1
answer
479
views
How to configure Mysql Server to maximize performance
I hold a server with 12 cores CPU, 16GB RAM and 128GB SSD, using Centos as operating system, mainly for MySQL server. But I found that server always process queries with bad performance. I am not sure ...
- 11
0
votes
0
answers
25
views
mycnf under etc does not take effect
Install mysql offline.
Create /etc/my.cnf file manually.
Add some options in /etc/my.cnf.
Restart MySQL.
Login MySQL, options added does not take effect.
/etc/mysql/mysql.conf.d/mysqld.cnf is ok.
...
- 1
0
votes
1
answer
6k
views
MySQL - Change secure_file_priv from NULL to either path or empty
My OS: Mac Big Sur 11.4
MySQL Workbench Version 8.0.28
As I need to import bulk CSV files to MySQL, my goal here is to NOT receive NULL when run:
SHOW VARIABLES LIKE 'secure_file_priv';
I have tried ...
- 35
0
votes
0
answers
253
views
How to access (use) passwords stored in MySQL myLogin.cnf from batch and desktop applications
I need to reference the password stored in myLogin.cnf from a batch script and a desktop application's connection string. I've also added MYSQL_TEST_LOGIN_FILE as an environment variable, but the ...
- 35
1
vote
0
answers
243
views
How to access (use) passwords stored in MySQL myLogin.cnf
I need to access the password stored in myLogin.cnf from a batch script and a desktop application's connection string. Is this possible, and if so, how would I go about it? My scripts and application ...
- 35
0
votes
0
answers
86
views
Disabling MySQL strict mode using nano sudo on Mac
I created the file my.cnf with this:
[mysqld]
secure_file_priv=""
and when I tried to load data, I found that MySQL does not allow me to load columns with empty rows. So I decided to ...
- 159
0
votes
0
answers
894
views
mysql dump file missing table structures and data
I'm running the following command in mysql to dump a database:
mysqldump --login-path=bc --single-transaction --routines my_database > /tmp/my_database
The dump file that is generated only ...
- 185
0
votes
1
answer
238
views
How to use pspg for mycli pager
I have this config on my .myclirc
table_format = psql
enable_pager = True
This the output is not what I expeceted, I tried to set pspg on the [client] section on the .my.cnf but mysqldump will ...
- 1,578
1
vote
1
answer
3k
views
my.cnf in kubernetes configmap is not recognized by mysql pod
my.cnf in kubernetes configmap is not recognized by mysql pod.
This is
mysql.yaml
apiVersion: apps/v1
kind: StatefulSet
metadata:
namespace: *****
name: *****
spec:
serviceName: mysql-service
...
- 115