The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
3answers
24 views

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 ...
2
votes
2answers
135 views

MySQL query times for tuning are different every time

I am tuning SQL query time for my slow query but every time I get different times so I can't evaluate my optimize solution. For example, I run query select * from abc where abc.status in (x,y,z) and ...
1
vote
2answers
45 views

Is it possible to use workbench to connect to a linux server and send the output to a csv or text file?

I have a user that is using workbench to connect to a Linux MySQL Server and would like to have the query results sent straight to a csv or text file on his computer. I know how to do it if I were ...
1
vote
2answers
591 views

Mysql server high trafic makes websites really slow or unable to load

Lately we have been having a lot of problems with our mysql server, from websites being really slow or even unable to load them at all. The server is a dedicated server that only runs our mysql ...
1
vote
2answers
257 views

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 ...
0
votes
2answers
900 views

apache - query string rewrite rule appends condition to URL

In trying to rewrite site-search.html?searchword=search%20term as advanced-search#q=search%20term I always end up with advanced-search#q=%3Fsearchword%3search%20term The %3Fsearchword%3 ...
0
votes
2answers
507 views

Querying a LINUX DHCP server in C#

I have a very large network say Class A. I have Linux DHCP and Microsoft DHCP servers deployed. I am successful in querying Microsoft DHCP server but Is there any way to Query LINUX DHCP server to get ...
0
votes
2answers
173 views

Is there a way to find out the detailed statistics of the querys that processed by Mysql?

The load average of my service is high, always around 15. And the reason for that is the Mysql is overloaded. I'm wondering How Can I find out which specific query/script consume the most Mysql ...
0
votes
2answers
57 views

MySQL stop responsing when modify main tables

It's an InnoDB database. The query cache has 1.2GB in size with 300k queries in the cache. Most of the cached queries are related to 3 major tables (260MB data length plus 600MB index length ...
0
votes
2answers
171 views

MySQL server has gone away occasionally on simple select query

For many weeks I have had a problem with a simple SQL query where from time to time the MySQL server has crashed. But recently it is crashing every day, 1-2 times a day. The query is very simple: ...
-1
votes
2answers
2k views

SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts

Which time out value does SQL server takes while executing the query/ stored procedure? The application time out is set at 20 minutes, the SQL Query/ command timeout is set at 10 minutes, then there ...
2
votes
1answer
135 views

how to optimize postgresql81 for a hug query but not a complicated one?

i have a query which execution takes 15s on the server. the server is bi-xeon 5130 (2GHz) with 2GB of RAM and 160GB of scsi hardrive in RAID. Database is PostgreSQL 8.1 on Debian 4 etch. This query ...
1
vote
1answer
469 views

Can IP tables allow specific DNS queries based on domain name?

I have iptables blocking all UDP traffic at the moment, however I want to allow only certain DNS queries to get through. Let's use google.com as an example. I am trying to use string matching to ...
1
vote
1answer
56 views

SQL Performance - Convert parameter or column type

I was asked this on an interview, and would like some feedback... I have a stored procedure that takes in a varchar parameter IsActive that is either a "YES" or "NO" string. The stored procedure ...
1
vote
1answer
331 views

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 ...
1
vote
1answer
68 views

variables used in inner queries

im trying to build a query that has something like this select id, (select top 1 create_date from table2 where table1id = t1.id and status = 'success') ...
0
votes
1answer
32 views

Diagnosing where all the queries are coming from

We have an issue where a site on a shared hosting account is going over the allowed query limit per user; that is set at 100k queries/hr. The site shouldn't be generating that amount of queries TBH ...
0
votes
1answer
48 views

Query Sring - Variable redirection

I need help on this query string: I am using IIS 8 and I have this URL: http://automotive.ooplinks.com/index.php?route=product/search&filter_tag=westin *I would like to redirect the variable ...
0
votes
1answer
71 views

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 ...
0
votes
1answer
138 views

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 ...
0
votes
1answer
160 views

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 ...
0
votes
1answer
294 views

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` ...
0
votes
1answer
230 views

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 ...
0
votes
1answer
213 views

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 ...
0
votes
1answer
262 views

MS SQL Query Count & Sum

select count(distinct consumerno), sum (case when ccon like '%D%' then 1 else 0 end) as Domestic, sum (case when ccon like '%B%' then 1 else 0 end) as Business from consumer left join contract on ...
0
votes
1answer
384 views

Putting indexes in separate filegroup kills our queries

Can anyone shed some light on this? On our dev boxes, our database resides entirely in the PRIMARY filegroup, and everything works fine. On one of our production servers, recently upgraded from 2005 ...
-3
votes
1answer
104 views

MS Exchange script to summarize emails by title

We have Microsoft Server 2008 64 bit running Exchange 2007 64 bit. We would like to run a script to summarize all emails sent to 3 different email accounts on this exchange server according to a ...
1
vote
0answers
82 views

Query Windows Search Server Express via another web page/server (apache et.al.)

I have Windows Search Server Express; is it possible to query it from another web site, running on Apache? Background: the Apache server runs an intranet site and needs to be able to query the data ...
1
vote
0answers
93 views

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 ...
0
votes
0answers
19 views

Cannot query UDP services

I run a couple UDP services, one including Teamspeak 3. Unfortunately, I am unable to query either of these UDP services (I cannot connect to the Teamspeak 3 server) besides the TCP based stuff, ...
0
votes
0answers
69 views

LDAP query to obtain distinguished name of a list of users

Hi im working on a migration process on which we are migrating users from one server to another domain controller. Right now I have a list of users I migrated, but I also got another of them I didnt. ...
0
votes
0answers
36 views

WMI remote query where TimeGenerated > n seconds ago

I'm querying Windows security logs remotely using WMI for a monitoring application and would ideally like to perform the following query: Select * from Win32_NTLogEvent Where Logfile='Security' AND ...