Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
1
vote
3 answers

Need to fetch result of only one column from the MySQL status variables

I wanted to fetch only the value from status variables. Suppose the query is show status where Variable_name='Aborted_clients' It returns +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | Aborted_clients | 4 …
Phanindra
  • 203
  • 1
  • 4
  • 11
1
vote
1 answer

How can I cap the MySQL query log size?

I have Investigated enabling MySQL query logging. At some point, soon, it would be nice to enable this on my companies production server so that if there is ever a question about queries run against the database, we can see them. I have found: Add…
syn4k
  • 569
  • 1
  • 6
  • 12
1
vote
0 answers

How to create an SSIS package with a Script Component

I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS. I want to take data from a Source database elaborate them and put in a Destination database. In the…
CiccioMiami
  • 209
  • 1
  • 3
  • 14
1
vote
1 answer

Periodically run query to transfer data between two SQL Servers

I have two MS SQL Servers, let's call them Source and Destination. I need to bring some data from a database table in Source by making a simple query (a Select and a Sum) and bring the result to a database table in Destination. I need to run the…
CiccioMiami
  • 209
  • 1
  • 3
  • 14
1
vote
1 answer

A pseudo-Sql server to intercept and see all MySQL queries

I would like to setup a "pseudo-server" to intercept all the SQL queries made by my local application. The reason for that is that I can't administer the Mysql server, and it's difficult for me to edit the configuration files to enable any logging.…
Matthieu Napoli
  • 421
  • 1
  • 5
  • 11
1
vote
2 answers

Mysql crashes by some strange queries

I have some strange log entries in my debug where I see that the mysql crashes: Apr 13 08:51:16 cronjob1 mysqld[22953]: Attempting backtrace. You can use the following information to find out Apr 13 08:51:16 cronjob1 mysqld[22953]: where mysqld…
Nik
  • 11
  • 1
1
vote
2 answers

How do I filter the Security Log using XML for the following data

A manager has asked me to log the start and stop times and dates when a user launches a particular program (Starcraft II). I have enabled logging on the user's machine so that it will report all process creation and termination. (Windows Logs ->…
Bugat
  • 69
  • 1
  • 2
  • 6
1
vote
2 answers

Cancel query in MySql

I have a query running for some hours, if I cancel this query what is going to happen to the database? The query is an ALTER TABLE that adds a new column. UPDATE: I executed the script this way mysql -u username -p database mysql> ALTER TABLE…
Daniel Moura
  • 215
  • 2
  • 11
1
vote
1 answer

PostgreSQL - Using COALESCE keyword in SSIS

When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a connection to the database and other key words are working…
hadEnoughOfKeyboardGangstars
  • 133
  • 5
1
vote
2 answers

SQL Server query hangs indefinitely - restoring database only solution

Occasionally we encounter a query that hangs indefinitely on our SQL Server. This query is being called from a separate ColdFusion web server. If I run profiler while it is hung I just see locks being allocated and released over and over again. …
Chris
  • 21
  • 1
  • 4
1
vote
2 answers

mysql slow query log

I am trying to write a script to parse the MySQL slow query log. I have seen 1 or 2 parser. does anyone know how to extract the information from that log? I mean does anyone know the structure of the file so I can work with that and if anyone know a…
Kourosh Samia
  • 321
  • 1
  • 5
  • 12
1
vote
3 answers

Perfectly reproducable select statement default ordering issue

I've recently been chasing an issue with a client's db... solution found, but impossible to recreate. Essentially, we're doing a Select * from mytable where ArbitraryColumn = 75 Where MyTable has an Identity column, called 'MyIndentityColumn' -…
Dave
  • 281
  • 1
  • 3
  • 11
1
vote
1 answer

Active directory - query groups by email address

How do I query my workplace's directory to get a list of all the groups with an associated email address that terminates in "fr"? I can use either the AD snap-in or the commandline tools, but no third party clients. Thanks.
Kaze no Koe
  • 113
  • 1
  • 4
1
vote
0 answers

Reduce Query Syntax for ends_with()

I have the following query: --query "Contents[?ends_with(Key, 'jpg') || ends_with(Key, 'NEF') || ends_with(Key, 'nef') || ends_with(Key, 'CR2') || ends_with(Key, 'cr2')]" Is there a way to reduce this? I tried with all of the suffixes in one…
davidbitton
  • 111
  • 2
1
vote
2 answers

Nginx rewrite to specific part of requested uri

I am quite new to nginx rewrite concept and I can't figure out how to rewrite the requested_uri to a specific Uri. I am trying to make rewrites to specific js files. For example, I have this requested_uri:…
dimpap
  • 11
  • 2
1 2 3
…
13 14