Moin,
Die Load der DB01.xIBE war eben bei 200 ... also
Herzdruckmassage. Ursache waren hunderte gleichlautende
Db-Queries, die AAA-Angebote für ein ganzes Jahr abgefragt haben
... siehe unten.
Ich habe die lang-laufenden Queries aufgelistet (hier vor
17:30Uhr, was 3min her war):
- ssh db01.app.xibe.rz1.xtrav.de
- sudo -i
- psql -h localhost -U postgres
- select pid from pg_stat_activity WHERE query_start <
'2020-03-09 17:30:00';
und gekillt:
- select pg_cancel_backend(pid) from pg_stat_activity WHERE
query_start < '2020-03-09 17:30:00';
Verantwortlicher: FSE (DANKE für die Unterstützung!!!!), SRK
Zeitpunkt: 2020-03-09 17:33Uhr
Kunden: AAA
Info:
SELECT hotel_only_table.*, hotel_only_table.offer_id as
hotel_offer_id, giata_table.country_name, giata_
table.destination_name, giata_table.city_name,
giata_table.hotel_name, room_type_table.description as
room_type_description, board_type_table.description as
board_type_description, count(*) OVER() AS total_count
FROM hotel_only_table LEFT JOIN giata_table ON
hotel_only_table.giata_id = giata_table.giata_id LEFT JOIN
room_type_table ON hotel_only_table.room_type =
room_type_table.room_type LEFT JOIN board_type_table ON
hotel_only_table.board_type = board_type_table.board_type WHERE
adults = 2 AND children = 0 AND travel_start >= '2020-03-19' AND
travel_end <= '2021-03-09' ORDER BY price ASC, travel_start ASC,
travel_duration A
SC LIMIT 1 OFFSET
0;
VG Stefan Rank-Kunitz
Mit freundlichen Grüßen
Stefan Rank-Kunitz
- Technical Director -
________________________________________________________
TraSo GmbH
Nonnenstraße 42
D-04229 Leipzig
Tel.: +49 341 355 740 - 43
E-Mail: s.rank-kunitz@traso.de
________________________________________________________
Handelsregister: Amtsgericht Leipzig, HRB 21850