The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
515 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 ...
0
votes
1answer
518 views

How to create one update query (mysql) on multiple databases

I have several DBS on the same mysql server. The DBS's structure and schema are exactly the same (only data is different) the query on certain db works well like this (written in phpmyadmin) UPDATE ...
0
votes
1answer
125 views

Mysql slow query log not tally with mysqladmin

I have enabled my slow query log. So I saw the query which was taking some time then I did some indexing it improve and my slow query log is not being showing any more queies. But when I run this ...
-1
votes
1answer
70 views

Slow Query in Big Tables by a field has INDEX [closed]

i don't understand the problem in this query, when I make a query with a condition of category_id = 'XX' the query take MINUTES to execute, but the same query without filter by category_id take 0.09 ...
0
votes
2answers
480 views

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, ...
1
vote
2answers
727 views

Estimating MySQL Query Runtime

I ran a MySQL query from command line using the following: nohup mysql --user=root --password=XXXXXXXXX database < report.sql > results.tab This query is extensive (5000 lines) and running a ...
1
vote
0answers
197 views

How to generate test data from an sql query and a result set?

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content. Given a database DB(S, D) consisting of the database schema S ...
2
votes
3answers
2k views

Retrieve list of users/groups that have access to a network folder and its subfolders?

One of our users is requesting a list of the users and groups that have access to two folders on the network, as well as all of the subfolders of both of these folders. There are hundreds, if not ...
2
votes
1answer
7k views

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

how solve Recursive Queries error in intodns web site?

Please see the below link : intoDNS Web Site How can I solve Recursive Queries error! the entire error is below : Recursive Queries I could use the nameservers listed below to performe ...
1
vote
3answers
413 views

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

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

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

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

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 ...
2
votes
1answer
133 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 ...
2
votes
2answers
128 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 ...
0
votes
1answer
5k views

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 ...
1
vote
0answers
92 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 ...
1
vote
1answer
286 views

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

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 ...
5
votes
2answers
1k views

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. ...
3
votes
1answer
214 views

Active Directory lookups from bound Mac without user credentials

One of my Mac boot scripts needs to grab a property from AD that is not one of the ones I can see with the built in tool called dscl, which is pretty much limited to Users, Groups, and Computer ...
2
votes
2answers
2k views

Zabbix - Populate Item with SQL Server Query

I'm trying to track a process that locks up regularly. It's a funky program that we have no control over. I'm trying to find a good way to track when the program stops responding. I have a query ...
0
votes
1answer
767 views

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

Write environmental variable on client machines, based on AD information

i want to alter the logon.bat script for our AD users (windows xp/vista/7 machines and a few servers), so that it writes an environmental variable upon login based on some AD information, like "what ...
1
vote
1answer
13k views

SCCM 2007 Query for installed software versions

How can I write a query to find machines which installed office 2003 with Sp3 in SCCM 2007? Thanks,
1
vote
2answers
243 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
1answer
321 views

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

Apache2 SSI include query-strings

Hello I have some troubles with query strings in SSI includes. Apache 2.2 mpm-prefork + mod_perl + SSI enabled Apache2 configuration: cat apache2.conf ...... AddType text/html .shtml .html .htm ...
0
votes
1answer
65 views

dns hierarchy not working !! Please help

(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 ...
0
votes
1answer
133 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
146 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
283 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
213 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
209 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
397 views

MS SQL Query Sum of subquery

I need a help i getting following output from the query . SELECT ARG_CONSUMER, cast(ARG_TOTALAMT as float)/100 AS 'Total', (SELECT SUM(cast(DAMT as float))/100 FROM DEBT WHERE DDATE ...
0
votes
1answer
125 views

How to search MySQL table for duplicates

In MySQL, I have a table named "city" with "city_name" and "latitude" and "longitude" in it. It appears that I have a few duplicates. What query can I run (in phpmyadmin) that will search through the ...
0
votes
1answer
251 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
2answers
1k views

How to rewrite query strings in url (\img?src=foo.jpg) into cachable urls (\img-foo.jpg)?

a question that is now partially resolved. A genius who can speak Apache fluently can shine light into this matter... GIVEN: Most proxies, do not cache resources with a "?" in their URL even if a ...
4
votes
4answers
7k views

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

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 ...
0
votes
2answers
491 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 ...
1
vote
2answers
403 views

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 ...
0
votes
5answers
3k views

Querying a DHCP server in C#

I have a really large network. Class A network and due to security reasons broadcast and any other PING has been blocked. I want to get all the PC IP that are alive. Is there any way to query DHCP ...
0
votes
2answers
170 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
1answer
375 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 ...
1
vote
4answers
399 views

why this statement in oracle perform much slower then ms sql

I tried to run a simple test to see how the speed fair between oracle and Ms Sql as follow: populate two tables with 2 million records, cross join them, filter by a range, and do a sum. Both table ...
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 ...
1
vote
1answer
321 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 ...