Questions tagged [process]
The process tag has no usage guidance.
55
questions
0
votes
0
answers
21
views
Process for upgrading MySQL Master-Slave to a new release series version
I have several MySQL servers that I want to upgrade from 5.7.31 to the most recent release series (5.7.36 I believe), but in one test I found that replication on one server set failed, and it required ...
0
votes
0
answers
66
views
MongoDB too many forked processes
We are having an issue with the MongoDB high usage memory, this is an AWS EC2 server running only MongoDB on docker container.
total used free shared buff/cache ...
0
votes
1
answer
146
views
show detail processlist like at mariadb on maxscale
on mariadb when i need check what are query is running or sleep on mariadb instance.
i can see with SHOW PROCESSLIST or select * information_schema.processlist.
But after mariadb join and client ...
0
votes
0
answers
122
views
SQL Server Service has stopped, but process still appears in TaskMgr
A customer has the strangest situation. Windows Server 2016 with SQL Server 2016. There is only one SQL instance on the machine (the default). Service name: MSSQLSERVER.
The service take a very long ...
0
votes
0
answers
71
views
NULL queries getting stuck and using up connections
Running show processlist in phpmyadmin for me often shows queries with an Info of NULL and a Time of apparently a few seconds, but which have in fact been stuck there for a long time (each time I run ...
1
vote
2
answers
217
views
Differences between EDU and thread
In DB2, there is this command that shows active EDUs (engine dispatchable units):
db2pd -edus
There are two fields in the respective output: EDU ID and TID.
According to this db2pd page from the DB2 ...
-3
votes
1
answer
423
views
Sql Server consumes CPU but no one is using the server
In my server I have a SQL process that consumes CPU (~10%) but no one is using the server.
In query select * from master.dbo.sysprocesses order by cpu desc I see at least one suspect process:
spid: 9
...
-2
votes
1
answer
70
views
What do I do about blocked processes? [closed]
I am getting alerts stating:
The SQL Server Performance counter 'Process Blocked' (Instance N/A) of object 'General Statistics' is now above the above threshold of 40 (the current Value is 41)"
...
1
vote
0
answers
27
views
SQL Agent Job: Seeking Process flow advice on managing steps
Fellow DBAs,
I need some practical advice on how to solve a job timing issue on different servers. I have a SQL Agent job that currently has steps 1-10. Step #8 has a dependency on a SQL Agent job on ...
1
vote
2
answers
319
views
Memory threshold is attempted on SQL Server
Currently we have a monitoring for all the infrastructure (server, DB, network components, etc ...). The alert thresholds, usually saturation, are configured as follows:
90% : Warning
95% : Critical
...
1
vote
1
answer
786
views
SHOW PROCESSLIST: show processes from all sessions
SHOW PROCESSLIST shows the list of processes for the current user and session only.
Is there a way for the current user to list all their processes for all currently opened sessions?
1
vote
2
answers
431
views
Symantec Backup Exec runing DBCC CheckDB and Backup on my SQL server
What is Symantec Backup Exec (TM)?
I noticed that it is running in one the database server i am maintaining.
I am a newbie in db administration and i am not sure what it is.
It is running DBCC CheckDB ...
0
votes
1
answer
2k
views
What is "Field List" command in mysql processlist?
In my processlist, I see a long running process. There is no query, just the command "Field List" with an empty info column. Its been waiting almost 20 minutes on a table meta data lock on an ...
1
vote
0
answers
70
views
How to set processes parameter in oracle 11g Windows in accordance with RAM in the server
Could anyone explain me whether there is any limitation in setting processes parameter in Oracle 11gr2 and how to set sga_target according to this.
Right now I have set the processes to 4000 and I ...
4
votes
0
answers
103
views
How to analyze postgres client process/session memory
Is there a way to check how much of process memory is allocated for the specific buffer for a running postgres session (work memory, temp buffers, plan cache etc ... )?
I'm asking because i want to ...
1
vote
0
answers
301
views
Reduce RAM required to process OLAP cube
I have a cube which I have created by using (in Visual studio) New Project -> Import from Server (Multidimensional and data mining).
This cube is indeed created from the metadata of an already ...
0
votes
1
answer
3k
views
mongod runs with command but not with config file
I am trying to start mongod with a config file on MongoDB 3.2 on Ubuntu 14.04. I can launch mongod by issuing the command myself, but I can't get it to work with the config file.
Here's the command ...
4
votes
1
answer
13k
views
DB Restart Taking too long, site is down
I tried to restart MySQL through WHM and now its taking way too long to restart, the progress bar is still showing.
What can I do?
I can still access the server via SSH but I cannot connect to ...
2
votes
0
answers
1k
views
How to unlock / repair mysql.sock
My issues have spawned from file permission changes leading to the popular ERROR! MySQL server PID file could not be found! error. However, I believe I've repaired them, but still cannot restart MySQL....
1
vote
1
answer
651
views
Unable to query for thread information in mysql using root
I'm connected to a server's mySql database hosted on google cloud using the user 'root' with a password.
I was under the impression that the root user had all privileges but when I try to get the ...
9
votes
3
answers
3k
views
Should developers be allowed to use LocalDB vs a "development" instance?
Much like the vein of the question that was posted here previously around "Should developers be able to query production databases?" I wanted to get your thoughts on another particularly annoying ...
0
votes
1
answer
6k
views
How to decide the parameter processes count? [closed]
I am using oracle 11g database and application deployed on weblogic 12.2.1 while I tried to access my application today, I faced an issue as "Listener refused the connection with the following error:
...
0
votes
0
answers
64
views
backups taking longer to run, has anything within sql server changed?
The following is an email from one of my colleagues about an hour ago:
Any Idea why the backup time has gone up from 2.5 hrs to 5.5 hours
since the 16th Sept?
The duration has remained ...
0
votes
1
answer
1k
views
is there a way to run the same job multiple times without scheduling it?
I have to run a process, and it says:
--first see what is the situation with the job
EXEC msdb.dbo.sp_help_job @job_name=N'Create new gift vouchers'
EXEC msdb.dbo.sp_start_job N'Create ...
3
votes
3
answers
23k
views
Need to intentionally create blocking processes for testing
My team and I have an issue where we need to be able to identify processes that are blocking other processes and kill them. There are a ton of scripts that are freely available to perform these ...
3
votes
1
answer
3k
views
how to find out what process(es) caused the autogrowth of a database or a database file?
I have a process(es) hungry for tempdb, but I am struggling to identify this process.
any ways I could achieve this?
We have been alerted as Tempdb has now grown into the space you
reclaimed on ...
1
vote
1
answer
535
views
DELAYED User at MySQL
mysql> show processlist;
| Id | User | Host | db | Command | Time | State | Info || 27098 | DELAYED | localhost | ...
1
vote
4
answers
3k
views
20 mysqld processes using only 1 port?
These are from Aliyun Cloud DB Servers,20 mysqld processes using one 3306 port
Has anyone seen this before ?
Can anybody explain how to do that ?
Are there any advantages to this ?
1
vote
0
answers
486
views
EXTPROC issue during 10g to 11g database
I am currently 10g to 11g database migration and trying to configure EXTPROC.
EXTPROC32 was configured as part of 10g to execute C++ library and working fine.
It appears that 11g does not provided ...
4
votes
1
answer
924
views
Howto find out details and reasons for idle transactions?
I have started to use the "Idera SQL check" tool. It shows floating bubbles for each process active on the Sql Server system:
Those bubbles are surrounded by a red border in case the transaction is ...
1
vote
0
answers
48
views
MySQL using CPU after cancelling slow query
I had to cancel a very slow running query after it ran for a few days without completing on my Ubuntu server.
Since then MySQL has been persistently running a process which is using 25-45% of the CPU ...
3
votes
1
answer
5k
views
SSAS cube process time increased after making fact and dimension small
I have a cube of 55 GB size which takes around 2 Hour to process full. As I have data for last 4 years but our business wants only 2 years of data.
For that, I have changed dimension and Fact views to ...
1
vote
2
answers
937
views
run job with uncommitted transaction - how to find the transaction? is it still active?
By mistake I have run the job I just put into production,
but the COMMIT TRANSACTION was commented out.
when I look at the job log, it printed that it did my updates with no problem.
when I run
...
6
votes
1
answer
74k
views
Oracle intermittently throws "ORA-12516, TNS:listener could not find available handler with matching protocol stack"
While testing the Oracle XE connection establishing mechanism I bumped into the following issue.
Although connections are closed on each iteration, after 50-100 connections Oracle starts throwing ...
9
votes
3
answers
6k
views
Lots of "FETCH API_CURSOR0000..." on sp_WhoIsActive ( SQL Server 2008 R2 )
I have a strange situation. Using sp_whoisactive I can see this:
Ok, with this query, I can see what is triggering ( does this word exists in english? ) it:
SELECT c.session_id, c.properties, c....
2
votes
1
answer
491
views
What does Oracle use for handling a client connection (process or thread)?
SQL Server 2016 and MySQL 5.7 use thread-based connection handling.
PostgreSQL 9.5 uses one operating system process for each individual connection.
According to Oracle 12c documentation it's not ...
0
votes
1
answer
47
views
How can I inform myself that an automatic SQL Server process has worked?
I have a Windows batch file which extracts some data from a remote system and then imports it into an instance of MS SQL Server 2014. The batch file runs SQLCMD and uses SQL files to bulk insert from ...
2
votes
0
answers
157
views
Can data streams from Informatica to SQL Server be multi-threaded?
Suppose we have a database server, with SQL Server on it. And we are moving data from another database server, through our Informatica server, and onto that SQL Server database server. And our SQL ...
2
votes
1
answer
7k
views
MYSQL: log the query executed on certain table
I am writing a trigger that suppose to fire on inserts for a table and log the exact query used to insert.
However, using below
SELECT info INTO original_query FROM INFORMATION_SCHEMA.PROCESSLIST ...
5
votes
1
answer
3k
views
Too many mysql instances. How to kill?
I should be ashamed of myself, for asking, I know.
Check out this screenshot attached.
My server, which is indeed not seeing HUGE amounts of traffic, should not be this overloaded. Mysql is having ...
0
votes
1
answer
926
views
Alter doesn't show in processlist
I'm performing an alter. It's currently running on a large table (300,000,000).
MariaDB [my_database]> ALTER TABLE my_table
-> add INDEX a (x, y, z),
-> add INDEX d (x);
Stage: 1 of ...
0
votes
0
answers
868
views
How to tell which process in SQL Server I should kill?
I am having an issue with an application as it is running supper slow.
I don't know if it is a database issue or something else as the is nothing that I can find to be the issue.
I tried
select * ...
0
votes
1
answer
740
views
Postgres-9.1 having more Idle connections
The connections were created 2 days before. Can I kill the process manually by using the below query?
select pg_terminate_backend(procpid)
from pg_stat_activity
where datname = 'mydb'
and procpid <...
4
votes
2
answers
1k
views
Make MySQL server terminate when shell exits or on ctrl-c
If I run mysqld, ie invoke it directly on the command-line, it survives the shell being closed or hitting ctrl-c.
Is there any way to run it "interactively", ie so that it will shut down if either of ...
0
votes
0
answers
860
views
Oracle prevent CPU usage per process/session
I have an Oracle instance to which several applications from different machines connect (http servers). Normally Oracle CPU usage is ~5-10% even on high server loads. But from time to time, one of ...
3
votes
1
answer
7k
views
Monitor user to query processlist
We have a corporate monitoring system based in Zabbix. Its MySQL monitoring is quite basic, so I want to add more info. To do so, I've done a script that retrieves this info from MySQL and sends it to ...
2
votes
1
answer
332
views
MySQL Start/Stop
Could anyone explain to me what happens during MySQL startup and shutdown? And i would like to know about the safe startup/shutdown process.
2
votes
2
answers
93
views
How can I make this backup scheme more friendly for reporting?
Currently, we have around 50 remote servers, each with a production database. Each night, all 50 of these servers run a backup job and zips the backup. Each morning, a local server runs a job for each ...
1
vote
1
answer
310
views
Should I use table hints with a process-keyed table?
I read on stackoverflow that locking can be a problem when using process-keyed tables, and I was wondering if you had any suggestions on how to minimize or avoid unnecessary contention (e.g. table ...
-1
votes
1
answer
741
views
Why mysqld server service gets aborted when i start mysql client service? [closed]
I am installing mysql-5.5.7rc from source code. After installation when i start mysqld service is being run but as soon as i run mysql client service server service gets aborted.. And also ...