Questions tagged [query]
The query tag has no usage guidance.
49
questions with no upvoted or accepted answers
3
votes
2
answers
1k
views
MySQL - Select queries 10x slower on Azure VM vs on-prem VM
We have been working on a project to migrate a MySQL database from an on-premise Linux server to a Windows VM on Azure (IaaS). (There's a specific reason because of which we have gone with the IaaS ...
2
votes
0
answers
389
views
WMI Query - First and Fourth IP octet
Is anyone aware of any WMI queries that could be used within group policy which only lists all IP address, which end in .200 and
I have multiple sites, multiple networks, I only need to list the ...
- 21
2
votes
0
answers
405
views
Show or log long queries with values instead placeholders
I have any very long sql query in postgresql. I tried show what postgress do with:
select * from pg_stat_activity
unfortunately I see something like:
select some_fields from anytable1 anytable2 ...
- 348
2
votes
1
answer
149
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 ...
- 21
2
votes
2
answers
177
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 ...
- 39
1
vote
2
answers
370
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 ...
- 11
1
vote
0
answers
70
views
Reduce Query Syntax for ends_with()
I have the following query:
--query "Contents[?ends_with(Key, 'jpg') || ends_with(Key, 'NEF') || ends_with(Key, 'nef') || ends_with(Key, 'CR2') || ends_with(Key, 'cr2')]"
Is there a way to ...
- 111
1
vote
2
answers
372
views
Nginx rewrite to specific part of requested uri
I am quite new to nginx rewrite concept and I can't figure out how to rewrite the requested_uri to a specific Uri. I am trying to make rewrites to specific js files.
For example, I have this ...
- 11
1
vote
0
answers
247
views
SCCM collection evaluates major version numbers in unexpected way
Why do SCCM collections based upon the logic Installed Applications (64).Version is less than "100.0" not evaluate to true for applications of version 99.* and below?
The full WQL query ...
- 11
1
vote
0
answers
914
views
Alternate method for caching mysql query (query_cache) on version above 8.0
On mysql version 8+ the query_cache support was removed.
I know why it is not a friendly thing with InnoDB when considering the CPU.
But I've some databases which really need this support where user ...
- 33
1
vote
1
answer
3k
views
Optimizing MariaDB Performance
I need a different set of eyes checking my MariaDB settings. During peak load times, the CPU can hit upwards of 600% or more, and slows down Wordpress application. I have used MySQLTuner to tweak a ...
- 11
1
vote
0
answers
502
views
Pgpool-II would not invalidate query cache for user schemas
I've configured pgpool2 (v3.4.3) with postgresql (v9.5) to cache queries like this:
memory_cache_enabled = on
memqcache_method = 'shmem'
memqcache_total_size = 67108864
memqcache_max_num_cache = ...
- 217
1
vote
2
answers
6k
views
Create SCCM device collection based on last logged on users who are members of an AD security group
I'm trying to create a device collection in SCCM 2012 which contains only the devices who are used by the users who are members of a certain User AD Security Group. I tried to accomplish this by first ...
- 33
1
vote
2
answers
85
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 ...
Jeff
1
vote
1
answer
79
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 ...
- 11
1
vote
3
answers
3k
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 ...
- 11
1
vote
0
answers
109
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 ...
- 209
1
vote
1
answer
392
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 ...
0
votes
0
answers
15
views
Initial patch install checking via SCCM query
I want to make a better query for Windows Server OS patching (2016 & 2019). The one listed below is what I wrote that my company currently uses. If a newly built servers OS install time is ...
- 101
0
votes
0
answers
212
views
Inconsistent Clickhouse database query performance
Folks,
Clickhouse Server version: 22.8.21 (have tried a variety of 22.x and 23.x versions as supported by clickhouse-backup to restore my data with for testing, none seemed to improve the query ...
0
votes
0
answers
64
views
Which is the correct capability in Courier SMTP config to get user's password (encryption type)
MySql: 8.0.34-0ubuntu0.22.04.1
I have followed this guide: Postfix With Courier IMAP Mail Server Installation (unfortunately they do not answer questions).
I had to change the encryption method for ...
- 101
0
votes
1
answer
234
views
GCP- Alert for adding new user or service account to a project
I want to create an alert in my project in GCP that lets me know when a new user or service account is added to the project. I understand I need to use Logs Explorer and run a query but I am not sure ...
google-cloud-platform
0
votes
1
answer
782
views
SQL Developer queries are very slow if I am not connected as sys
I want to run my PL/SQL Queries on SQL Developer and created a new user connection. But if I run:
set serveroutput on size unlimited;
begin
dbms_output.put_line('Hello Oracle.');
end;
/
clear ...
0
votes
1
answer
777
views
Using SNMP to monitor windows RDP logons?
It is possible to monitor WIN RDP logons (user,login duration) using SNMP specific OID ?
- 1
0
votes
1
answer
1k
views
Strapi + Postgres: Cannot SELECT from table - syntax error
I am using strapi and postgres. I created two collections in strapi called "solutions" and "references".
When I run \dt I get the following output:
...more tables
public | ...
- 101
0
votes
1
answer
91
views
Slow SQL Queries over local net
Slow Queries for SQL over 1Gb link between servers using just SSMS
Server Configs:
Main SQL Node:
32GB Ram
16 cores
Sage Evolution Server:
16 cores
16GB ram
The config of the servers is that they ...
0
votes
0
answers
119
views
How to make daily database backups readily queryable
We have a production database that generates daily database backups that are uploaded to S3 in form of compressed .sql.bz2 files. We basically have a S3 bucket that has a large number of such backups, ...
- 101
0
votes
1
answer
1k
views
Large database table queries return empty set
I'm trying to understand a weird problem with a MySQL database on one of my websites.
When I loaded a big set of data from a CSV file (2,200,000 records with a single column, using LOAD DATA) into a ...
- 101
0
votes
1
answer
958
views
MSSQL query not working, even if there is data
Trying to run a more complex SQL query on an MS SQL server, but I get no data output. Logically should be fine, but I cant see why it doesnt work:
SELECT D.NAME DATABASE_NAME,T.NAME TABLE_NAME,I.NAME ...
- 21
0
votes
1
answer
795
views
Finding list of fonts for each PC
I am trying to find the best way to find a list of clearview fonts on each PC on our domain. Questions:
1.) Should I use SCCM & how? I've create a Query but I am getting nothing right now. I was ...
- 336
0
votes
0
answers
75
views
MySQL execute every query on a second server
I have a Web-application on a Linux Debian 8 Server saving in MySQL.
I need a backup which is always the latest version(not even a minute behind) so the only way i could think off to archive this is ...
- 103
0
votes
0
answers
1k
views
LDAP Query Of All Users In Various Groups In A Specific ActiveDirectory OU
I need to configure Atlassian Crowd to query all the users in my AD server that are in various groups in a top-level OU.
The DN for the OU is "OU=Atlassian,DC=NNNN,DC=com". The various groups would ...
- 285
0
votes
1
answer
319
views
Concurrent MySQL processes
I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours).
My ...
- 111
0
votes
1
answer
60
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 ...
- 319
0
votes
3
answers
46
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 ...
0
votes
1
answer
103
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 ...
- 101
0
votes
1
answer
175
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
1
answer
290
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 ...
- 1
0
votes
1
answer
367
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` ...
- 257
0
votes
1
answer
482
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
1
answer
258
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 ...
user571248
0
votes
1
answer
424
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 ...
- 543
0
votes
2
answers
277
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 ...
- 323
0
votes
1
answer
1k
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 ...
- 133
0
votes
2
answers
70
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,725
0
votes
2
answers
609
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:
...
Nik
-1
votes
1
answer
3k
views
AD query - get bitlocker active computers
I have query in Active Directory which should return all computers with bitlocker not active based on this script:
https://community.spiceworks.com/topic/1083065-bitlocker-status-on-all-computers
...
- 11
-1
votes
1
answer
4k
views
DNS Fails to simple query test
I seem to have a real odd problem that seems to escape me. I have two servers - both of which are ad controllers. My Problem Child is Windows 2008 R2, My other is a Windows 2012R2 that runs no problem....
- 1
-1
votes
2
answers
8k
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 take into consideration while executing a query or stored procedure? The application timeout is set at 20 minutes. The SQL query/command timeout is set at 10 ...
- 1