How to calibrate HP 27f monitor in WIN10-64?

Question

MySQL

New HP Desktop system unit - M01-D0050ur. Unable to calibrate HP 27f 75HZ monitor. colors are not the same.
Either I've been looking at the wrong colors all this time, or he doesn't convey the color right! Green is very bright and blue (cyan) on the contrary is dull.

Which profile to choose, which one I don’t choose, nothing changes!







Here is an example of how colors, especially green, are poisonously brightly transmitted! I don't know if you can see it or not.

Answer 1

Basically the GROUP BY in the query will scan the whole table in 90%. You can of course try to play around with composite indexes on the log table. Rewrite query...
The simplest way, in my opinion, in execution and works ad-hoc:
Add a field to the devices table (let's call it lastidevent ) and make an insert trigger in the eventlog table that will update the lastidevent field on the inserted id_event in the table devices. Then, in the query, connect to the log table by the lastidevent field.
Because the devices table is not loaded, then the competition will be minimal. True, you will have to reckon with the increased costs of inserting logs.

Answer 2

I solved the problem with two requests. First, I displayed the device id by id_place:

SELECT d.*, ev1.*
    FROM devices d
    INNER JOIN eventlog ev1 ON d.id_device = ev1.id_device
    AND ev1.id_place IN(1,2,3) GROUP BY ev1.id_device

Then I threw the result into the php array and made a request for each device in a loop:

SELECT d.*, e.*
  FROM devices d INNER JOIN eventlog e ON e.id_device = d.id_device AND e.id_device = ".$val." ORDER BY e.id_event DESC LIMIT 1

Answer 3

It turns out everything is simple! Maybe someone will come in handy!

... let's disable the fast startup of the computer for one session. This will clear the computer's RAM of possible garbage.
Click Start, Shutdown and while holding the Shift key, Shut down.