The process tag has no wiki summary.
2
votes
1answer
107 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
1answer
59 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
2answers
57 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 ...
11
votes
3answers
2k views
SQL Server 2008 R2 “Ghost Memory”?
We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
1
vote
1answer
72 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 ...
0
votes
1answer
127 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 ...
3
votes
2answers
2k views
Internal reason for killing process taking up long time in mysql
I copied a big table's structure with (it is an InnoDB table btw)
CREATE TABLE tempTbl LIKE realTbl
Then I changed an index, and filled it up so I could run some test.
Filling it was done using:
...
5
votes
1answer
1k views
Unable to kill SPID
I have a SQL Server 2005 Std (x64) with SP4 that has a procedure I cannot seem to kill. If I view sys.dm_exec_requests I see SPID 103 with wait_type of LCK_M_SCH_M, a status of SUSPENDED and command ...
1
vote
2answers
379 views
Question about 'user process' in the context of Oracle
The following is an except from oracle documentation.
Overview of User Processes
When a user runs an application
program (such as a Pro*C program) or
an Oracle tool (such as Enterprise
...
22
votes
4answers
802 views
Is there a “best-practices” type process for developers to follow for database changes?
What is a good way to migrate DB changes from Development to QA to Production environments? Currently we:
Script the change in a sql file and attach that to a TFS work item.
The work is ...
