Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [query]

196 questions
0
votes
3 answers

Apache / PHP Begins to Deny SQL Requests after about 2000

We have a web page on our server that we use to run administrative scripts. For example, we might run the script "unenrolStudents()" which runs 5,000 SQL SET commands one after another and sets 5000 student entries in an SQL database to…
Daniel Stern
  • 1
  • 1
0
votes
2 answers

MS SQL Server Query Timeouts

I've got a server hosted at Rackspace that is a pretty beefy machine (dual hex core, 48 GB of RAM) and our database isn't all that big (100GB or so). SQL Server 2008 R2 Standard 64 bit. Normally, this machine runs perfectly. Very little pegging of…
Matt Dawdy
  • 429
  • 1
  • 9
  • 19
0
votes
4 answers

Can MySQL "Query" be exploited (while processing to Server)?

(Not like/about MySQL Injection) I wanna just be confirmed that someone told me a query can be changed (or) modified (by someone intruder/hacker, from middle) while we submitting it. Is it possible? I mean, lets say there is a query (fixed Query for…
Alvin
  • 101
  • 2
0
votes
4 answers

Slow INFORMATION_SCHEMA query

We have a .NET Windows application that runs the following query on login to get some information about the database: SELECT t.TABLE_NAME, ISNULL(pk_ccu.COLUMN_NAME,'') PK, ISNULL(fk_ccu.COLUMN_NAME,'') FK FROM INFORMATION_SCHEMA.TABLES t LEFT JOIN…
user10444
0
votes
1 answer

Weird LDAP search results behaviour

I am building Google Directory sync from our domain to our Google apps account. I am trying to search for all users in a specific Distribution Group: GoogleAppsActiveUsers. I am using Windows 2003 R2 as our AD. I have 1 user added to the group:…
Saariko
  • 1,791
  • 14
  • 45
  • 75
0
votes
1 answer

SharePoint 2010 search crawl not working

I have the following set up: 1 x Windows server 2008 R2 running SQL 1 x Windows server 2008 R2 running SharePoint 2010. I have an issue with the search service application, the crawl appears to run for a never ending amount of time with 0 successes…
J. Hammond
  • 1
  • 1
  • 2
0
votes
1 answer

query from sql table via powershell

I've created a SQL Server database with a simple table on my local machine. I try to query some information from this table. Here is my code: $connection= New-Object system.data.sqlclient.sqlconnection $Connection.ConnectionString = ` …
pansal
  • 269
  • 3
  • 9
  • 20
0
votes
1 answer

How many queries per second execute in postgressql database

I have to monitor database statistic for postgresql and need display as graph. How to check Query execution time and number of query per seconds in postgres. What functions available to get those output?? Any reference site will be useful.
Chandru
  • 1
  • 1
  • 1
0
votes
1 answer

MySQL database server on a VPS: can it handle the spike in traffic I'm anticipating?

I have VPS service with Hostican.com. 2.7GHz CPU, 2GB RAM (level 5, if you look at the site). I have a smartphone app that makes requests to PHP forms, which query the MySQL DB. I'm anticipating a huge surge of activity in a single day, due to an…
JustinP
  • 1
0
votes
1 answer

dns hierarchy not returning ip address

(DNS1 ,WWW1, Gateway1) (sub-internal network) (DNS0,WWW0,Gateway0) (internal network) DNS1: 192.168.250.3/24 WWW1: 192.168.250.4/24 Gateway1: 192.168.250.1 /24 (internal) :: 192.168.0.150 to 192.168.0.175…
nikhilelite
  • 101
  • 2
0
votes
1 answer

MySQL's Query Optimizer's take on disk access time

I don't have a ton of background with MySQL, and I was wondering of anyone can give me some insight into MySQL's query optimizer and the impact on the cost of disk accesses in determining a query plan for query execution. I'm interested in whether…
user73111
  • 1
0
votes
1 answer

optimize mysql queries perfomance and speed

i need some help in some mysql queries i'm trying to improve it's performance and speed i'm trying to figure out how to do that using mysql syntax . here is an snippet of a query function i use on a stats php script to fetch some countries info…
Jack
  • 1
0
votes
1 answer

Simple MySQL query locking up until database restart

I have a very simple query that runs in 216ms on my development machine but was taking more than 45 seconds on my production server, that is, until I restarted MySQL there: UPDATE `forum_categories` SET `post_count` = COALESCE(`post_count`, 0) + 1…
modulaaron
  • 257
  • 1
  • 4
  • 11
0
votes
1 answer

A Most Puzzling MySQL Problem: Queries Sporadically Slow

This is the most puzzling MySQL problem that I've encountered in my career as an administrator. Can anyone with MySQL mastery help me a bit on this?: Right now, I run an application that queries my MySQL/InnoDB tables many times a second. These…
Kyle Ingholt
  • 1
0
votes
1 answer

CPU/ memory utilization

WE have a job running very slowly. And I required to produce the analysis of CPU/ memory utilization during that backup.Also need statustics around the database performance for that batch job. How to do this, please help me on this.
user571248
1 2 3
…
13 14