The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
335 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 ...
6
votes
2answers
3k 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
263 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 ...
3
votes
2answers
4k 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
1k 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 ...
2
votes
1answer
18k 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
304 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
435 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
1answer
73 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
146 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
202 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
317 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
302 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
225 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
454 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
133 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
314 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
2k 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 ...
5
votes
4answers
15k 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
1k 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 ...
1
vote
2answers
543 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
2answers
177 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
488 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
579 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
58 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
352 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 ...
2
votes
1answer
173 views

SQL server Intergration services 2008 sub queries

I am looking for a way to execute sub queries from within a main query that I execute in my SSIS package. So When I execute the package, I want to be able to execute the sub query after everyline ...
0
votes
2answers
179 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: ...
0
votes
1answer
376 views

MySQL 5.1 Slow SHOW DATABASES (phpMyAdmin)

We have about 200 databases and since upgrading from 4.1 to 5.1 we've noticed that PHPMyAdmin takes a while to load the left navigation sometimes. Is there anything we can do to make this quicker? ...
0
votes
2answers
1k views

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

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

Handler_read_rnd is too high (more than 2GB)

I am running an advertising program and there are some SELECT, UPDATE and DELETE queries when showing ads. Sometimes, displaying ads is fast but sometimes it is too slow. At this time, it is slow and ...
0
votes
1answer
345 views

SQL Query fields change to uppercase on upload to server

I have just finished developing an app using CodeIgniter. When I upload it to my Host (Hostgator shared) some of the SQL text is converted to uppercase and rendering the app unusable. In my database ...
1
vote
3answers
760 views

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 ...
1
vote
3answers
680 views

“Delete query” not able to be completed

I have a very simple mysql script that is running. But it hangs, and runs forever without finishing. What are possible reasons, and how can I resolve them? delete from guid_target_infos where type_id ...
2
votes
1answer
195 views

Simple SQL Server 2005 Replication - “D-1” server used for heavy queries/reports

We have two SQL 2005 machines. One is used for production data, and the other is used for running queries/reports. Every night, the production machine dumps (backups) it's database to disk, and the ...
3
votes
1answer
167 views

Should I be suspicious of this querystring?

I noticed in my application event log some errors: Exception message: A potentially dangerous Request.QueryString value was detected from the client (term="DTİNST32") Request URL: http://...
1
vote
1answer
826 views

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

A more useful MySQL Query log that's suitable for tail -f'ing

In order to debug a webapp and mysql queries, I've enabled the mysql query log. However it's not a very good format to tail and grep through. Ideally I'd like to be able to only show queries from a ...
1
vote
2answers
152 views

select values must match the number of insert columns

I have the following query... ive checked and rechecked the types and number of values in both the insert into and the select statements. I can't figure out what is wrong. insert into [Subscription]....
0
votes
1answer
72 views

How to use variables in inner queries?

I am 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
69 views

Querying Exchange 2003 for Information About Attachments

I'm looking into the possibility of switching from Microsoft Office to Google Apps. Although Google Apps are not currently as feature rich as the Microsoft Product, the Google tools provide greater ...
0
votes
2answers
53 views

Show any null value?

is there a SQL statement that would show any null value in any record? For example if I had a table Alpha with Column A, B, and C where C was null in one record, and B was null in another, and A in ...
0
votes
5answers
2k views

What is faster for reading: SQL CE or file on the disk?

On my server side I need to store user data somehow. Some time ago I used to use INI files for writing and reading those values. Even with tousands of files it was incredibly fast (ms), maybe due to ...
1
vote
2answers
2k views

Event logs on multiple server [closed]

I am looking for tools that will allow me to aggregate and query event logs from multiple servers. In my case, this is a webfarm and I need to be able to query the event logs for all of them in one ...
18
votes
3answers
15k views

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

Access or SQL query to list most recent AutoNumber within a specific Range

I am looking to write a query where it shows me the last 50 of the highest ids, without knowing the most recent id #. The id is an autogenerated primary key. Any help would be appreciated. Maybe I ...
0
votes
3answers
4k views

The database at work has Unidata format, how do I access it?

I know just enough about database to get by - it's not normally within the scope of my job, but I think it's good for everyone to know a little bit. I'm trying to access some of the data in our DB ...
0
votes
1answer
335 views

What's a typical turn-around / response-time for this query/reply scenario?

I'm doing a feasibility study on a proposed wireless/wired network topology for a coming project of ours. A rough description of its use is "like an industrial sensor system". It looks something like ...
0
votes
1answer
554 views

What is star query optimization?

I found in a features table for SQL Server 2005 a row named "Star query optimization" but it is not explained anywhere. Could this be a feature that optimizes a query like : SELECT * FROM Table