Question : The following is an except from oracle documentation. Overview of User Processes When a user runs an application […]
mongod runs with command but not with config file
Question : I am trying to start mongod with a config file on MongoDB 3.2 on Ubuntu 14.04. I can […]
Too many mysql instances. How to kill?
Question : I should be ashamed of myself, for asking, I know. Check out this screenshot attached. My server, which […]
Alter doesn’t show in processlist
Question : I’m performing an alter. It’s currently running on a large table (300,000,000). MariaDB [my_database]> ALTER TABLE my_table -> […]
DELAYED User at MySQL
Question : mysql> show processlist; | Id | User | Host | db | Command | Time | State | […]
Need to intentionally create blocking processes for testing
Question : My team and I have an issue where we need to be able to identify processes that are […]
What does Oracle use for handling a client connection (process or thread)?
Question : SQL Server 2016 and MySQL 5.7 use thread-based connection handling. PostgreSQL 9.5 uses one operating system process for […]
How can I inform myself that an automatic SQL Server process has worked?
Question : I have a Windows batch file which extracts some data from a remote system and then imports it […]
run job with uncommitted transaction – how to find the transaction? is it still active?
Question : By mistake I have run the job I just put into production, but the COMMIT TRANSACTION was commented […]
Monitor user to query processlist
Question : We have a corporate monitoring system based in Zabbix. Its MySQL monitoring is quite basic, so I want […]