Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
42
votes
4 answers

How do I remove a specific bad plan from the SQL Server query cache?

We have one particular SQL Server 2008 query (not a stored proc, but the same SQL string -- executes every 5 minutes) that intermittently caches a very bad query plan. This query normally runs in a few milliseconds, but with this bad query plan, it…
Jeff Atwood
  • 12,994
  • 20
  • 74
  • 92
41
votes
3 answers

Why multiple PTR records in DNS is not recommended?

I often read that using multiple PTR records in a DNS configuration is not recommended. However, the reasons are often vague, or not so obvious, naming: "it can cause problems", "can trigger bugs in programs expecting a single answer" : it's the…
Totor
  • 2,876
  • 3
  • 22
  • 31
27
votes
18 answers

Are there any good and lightweight LDAP querying tools?

As developers we sometimes need querying LDAP. Do you know useful tools for this task? edit: I don't mean in code, I mean utility/tool (command-line or gui, mostly gui) for just to look/confirm data, or if possible to alter...
spinodal
  • 373
  • 1
  • 4
  • 7
20
votes
11 answers

Command line active directory query email address for username

On Windows XP in an Active directory environment - what is the easiest way for me to query a user's email address from AD given their username on the command line. (Assuming I know where it is kept normally in tree). (I know about net user…
Hawkeye
  • 2,669
  • 9
  • 30
  • 34
19
votes
2 answers

AWS CLI Command Line: How to use "--query" to output multiple source lines

I am using aws-cli version 1.7.8 to get the --query output to create one record that is derived from multiple lines. In this case I am trying to get specific information from describe-instances. In the describe-instances command, we get lines /…
Chris Charles
  • 191
  • 1
  • 1
  • 4
18
votes
5 answers

How to automatically kill slow MySQL queries after N seconds?

I am looking for a well tested bash script (or alternative solution) to do so, in order to avoid max_connection to be exhausted. I know that it is fighting the symptoms, but really need such script as a short term solution.
alfish
  • 3,027
  • 15
  • 45
  • 68
13
votes
3 answers

bind would not work unless allow-query is "any"

I have this in /etc/named.conf, I commented the default values and set my own under it. My domain would not load in browser unless I set allow-query to "any", is this OK, what should I edit? If is localhost or 127.0.0.1; 10.0.1.0/24; domain would…
adrianTNT
  • 1,007
  • 5
  • 21
  • 41
12
votes
4 answers

DNS searching with wildcards?

Anything like nslookup or dig offer the ability to search based on something contained in the name ... like a wildcard search or something? I'm trying to make a little script with a GUI wrapper for our helpdesk team. Ideally, I'd like them to be…
TryTryAgain
  • 1,112
  • 4
  • 22
  • 40
10
votes
4 answers

Why are my MongoDB queries really, really slow?

I've inherited a large MongoDB server at work, and have been tasked with figuring out why queries run against it are so slow. The DB contains tons and tons of records (on the order of 10^9) and takes up about 300 GiB. At first, I thought that the…
Mark LeMoine
  • 201
  • 1
  • 2
  • 7
8
votes
1 answer

How to use WMIC to connect to remote machine and output OS information to a file?

I want to know how to use WMIC to connect to remote host and output their PC's OS information(Installed programs list) to a file. I tried wmic /node: OS get vendor, name > c:\output.txt but i got error "Node - Error: Description…
PYO
  • 91
  • 1
  • 1
  • 6
7
votes
1 answer

BIND - increase in outgoing NS queries after upgrade to CentOS 6.7?

After upgrading BIND to 9.8.2rc1-RedHat-9.8.2-0.37.rc1.el6_7.2 in a few caching nameservers I've noticed it's doing lots of outgoing NS queries, without changes to incoming traffic volume or patterns. As a result, the servers are consuming much more…
André Fernandes
  • 959
  • 7
  • 24
6
votes
1 answer

openldap sizelimit. Can't receive more than 500 entries

I can't receive more than 500 entries, when I query my openldap-server. Although I made the following changes: slapd.conf # This is the main slapd configuration file. See slapd.conf(5) for more # info on the configuration options. …
JMAD2016
  • 63
  • 1
  • 1
  • 3
6
votes
1 answer

PostgreSQL raw query vs "Function returns TABLE" - insane difference in performance. Why?

I work with the PostgreSQL and it is used for reporting. The way it is configured currently is as follows: There is a complex query which returns report data, like this: select Column1 as Name1, Column2 as Name2 from sometable tbl inner join…
Evgeny
  • 213
  • 2
  • 6
6
votes
2 answers

best practice for fixing mysql slow query log error 13

CentOS 5.5 MySQL 5.5 installed via a yum repository [ERROR] Could not use /var/log/mysqld.slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the…
comb
  • 143
  • 1
  • 6
5
votes
2 answers

Effects of internet connection speeds on server queries

Can my internet connection significantly effect queries run on phpmyadmin? I am currently 18 down and 30 up. I switched internet connections today and noticed a deep drop in query performance. The query that I am running is SELECT * FROM table.…
SephMerah
  • 159
  • 1
  • 2
  • 8
1
2 3
…
13 14