Questions tagged [mysqladmin]

MySQL Administrative Operations Client

9 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
2 answers
6k views

How to fix high memory usage of MariaDB?

I am using MariaDB(10.1.21) with following storage engines: InnoDB TokuDB Spider Engine System Configuration is : 3GB RAM Dual Core Processor I have tried pt-mysql-summary tool to identify the ...
Abhishek Ginani's user avatar
3 votes
1 answer
2k views

wait_timeout kills session in SLEEP MODE or all connection ?`

Do wait_timeout session clear all running session or only sessions which are in SLEEP mode for specified seconds ?
simplifiedDB's user avatar
2 votes
0 answers
4k views

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master ...
lalit's user avatar
  • 229
1 vote
0 answers
4k views

MySQL 8.0 - Could not acquire management access - Administration issue

I am using MySQL Workbench for many months, it was working fine. Today, when I tried to open Server Status in the MANAGEMENT tab, below error occurred. MYSQL80 and Windows Management Instrumentation ...
vicky's user avatar
  • 11
1 vote
0 answers
115 views

DatabaseRestart

I have strange problem, we are using circulation replication, between 2 different network with 5.6.25 and 5.6.22 version of MySQL and RAM is 64GB with 45GB innodb_buffer_pool Master Server is running ...
AmitPatel's user avatar
0 votes
1 answer
45 views

Can only execute mysqladmin as root account created with unix socket, all other accounts fail

I have a new install of MariaDB 10.2.27 on RHEL7. Our security scans have flagged the root account, so we have modified the name to orgdba, assigning all of the applicable privileges. I have not ...
Sarah Robb's user avatar
0 votes
0 answers
43 views

unable to login to mysql console for non root unix users

My Issues is that when I am logged in as a normal user on unix server and then try to login as MySQL root. It throws below error but when I am logged in as root to unix server and then try to connect ...
aroosh's user avatar
  • 1
0 votes
1 answer
2k views

Database ExecuteSQL(MySQL client run out of memory)

I've an online game the game server execute more than 1M queries [ SELECT , REPLACE , UPDATE ] every 10 sec the problem the memory usage still increasing i dun know why ?? i mean if we suppose that ...
JORDAN MI's user avatar
0 votes
0 answers
2k views

How to enable SSL in MySQL on Windows?

I'm a student doing a project which uses JDBC and MySQL (on Windows). I have an application with connects to a MySQL server on a remote host. To have a secure connection, I found this : http://www....
Roronoa's user avatar