Questions tagged [query]
196 questions
0
votes
1 answer
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 both on an ESXi host with a 1Gb interlink between…
RamboFR05TY
- 1
- 1
0
votes
0 answers
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, one per day.
We use these DB backups for…
rtindru
- 101
- 3
0
votes
1 answer
ldap query active directory: all users with their assigned groups or groups with their members
I'm trying to make a ldap query which I can run in active directory tool, so I can have an overview of all users with their groups.
What do I need to add to this script to see the groups of these users ?
&(objectCategory=person)(objectClass=user)…
Joep
- 1
- 1
- 1
0
votes
1 answer
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 this:
…
Johann Gerell
- 105
- 5
0
votes
1 answer
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
Andrei Rînea
- 310
- 5
- 17
0
votes
1 answer
"show processlist;" output - percent sign
In the output above, what does the % (percentage sign) mean ?
mysql> show…
kellogs
- 69
- 8
0
votes
1 answer
MySQL query is NOT executed from bash, but works from MySQL client
Using UBUNTU 16.
MySQL query fails from bash, but works from MySQL client:
query=$(cat << EOF
CREATE DATABASE \`${mysql_local_database}\` /*!40100 COLLATE \'utf8_hungarian_ci\' */; use \`${mysql_local_database}\`; GRANT SELECT, EXECUTE, SHOW…
klor
- 344
- 4
- 8
- 25
0
votes
1 answer
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 table, my application started to misbehave.
After…
Zorgatone
- 101
- 5
0
votes
1 answer
which table should I query for date & time in zabbix?
i need to query date and time in zabbix server. which table exactly stores these 2 parameters?
Actually there is a table named history and there are two fields in that table named "clock" and "ns", but their formats is too odd and i cannot extract…
samiranapper
- 5
- 2
0
votes
1 answer
Quering history of network interface in zabbix server return empty set?
I've installed Zabbix on Ubuntu.
Although I can see a "graph" and related "latest data" for all network interfaces in Zabbix front-end, there is no data for them when I directly query MySQL database!!!!
mysql>select value from history where…
samiranapper
- 5
- 2
0
votes
3 answers
AD query to see what PCs a user has logged onto recently
Is there any way to run a query in AD to check what PCs a user has logged into recently.
regards
Mike
Mike
0
votes
1 answer
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 INDEX_NAME,C.NAME COLUMN_NAME
FROM…
robertalks
- 21
- 2
0
votes
1 answer
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 told that SCCM does not inventory fonts. I created a…
Benjamin Jones
- 326
- 1
- 9
- 23
0
votes
0 answers
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 to execute every Query on a second MySQL server…
M41DZ3N
- 103
- 2
0
votes
1 answer
whats the best practice to do a long query like deletion of big chunks in mysql
On production servers I need sometime to delete a few 100,000s of rows . The query is optimized but deleting at once will cause servers freeze so I do it manually in chunks deleting for example 5000 rows each time. To allow the server to clear…
Niro
- 1,401
- 4
- 20
- 36