windows 10 – Is there a way to scale down a monitor? (Win 10)

I just got a second monitor, which one that is a bit old, but does the work. Its resolution is 1024×768. My main monitor is 1920×1080.
The thing is that the second monitor looks like if it was zoomed in or scaled bigger. I found out that if I change the resolution to a bigger one it zooms out as I would want it, but it does not display some things like the start menu or even the taskbar properly.
Is there a way I can make the second monitor be scaled like the first one? Even if I try merging both displays with AMD’s Eyefinity feature, It seems to set up in the wrong way (Monitor with more resolution has black bars)

Image. Note that in the right display everything looks bigger

MySQL Enterprise Monitor Installation Error: MySQL Instance

I am trying to set up MySQL Enterprise Monitor on a RHEL8 server with MySQL 8.0.22 Enterprise Edition.
I hit this error:

**Error running /opt/mysql/enterprise/monitor/mysql/bin/mysql
–defaults-file=/opt/mysql/enterprise/monitor/mysql/my.cnf -S
/opt/mysql/enterprise/monitor/mysql/tmp/mysql.sock -u root -D mysql -e “DELETE
FROM user WHERE user = ‘root’ AND host NOT IN (‘localhost’, ‘127.0.0.1’); ALTER
USER ‘root’@’localhost’ IDENTIFIED BY ‘****’; UPDATE user SET User =
‘service_manager’ WHERE User = ‘root’; DELETE FROM user WHERE User = ”; FLUSH
PRIVILEGES;”: /opt/mysql/enterprise/monitor/mysql/bin/mysql: error while loading
shared libraries: libtinfo.so.5: cannot open shared object file: No such file or
directory

Press (Enter) to continue:**

I was able to continue, but I am not able to load the MySQL Enterprise Monitor dashboard.
I have an existing instance on the server, but I chose bundled MySQL database in the installation.

How do I resolve this error?

display – External monitor not working on full resolution with MacBook

I know this problem has been answered before, but I could not make any of the presented solutions work for me.

I just bought a Phillips 245B monitor with QHD (2560×1440) so I could run it in native resolution with my MacBook Pro (15-inch, Mid 2010) and its NVIDIA GeForce GT 330M GPU.

Unfortunately the maximum resolution that IOS lets me choose is 1080p.

I tried already:

  1. Preferences -> Displays -> option-click on Scaled
  2. Resetting the PRAM
  3. A different Mini Display Port to HDMI adapter (from Gravis) and a Mini Display Port to display port adapter, which resulted in a “no video output” on the monitor.
  4. Creating a new EDID file like here, which resulted in the monitor staying black.

I hope one of you guys can help me 🙂

Cheers

display – How to connect MacBook Pro (2020) to ultra widescreen monitor?

I have an ultrawide monitor that’s 3840 X 1200. It works perfectly fine with my windows laptop.

I now need to connect my work MacBook Pro provided to me, but under the list of resolutions (and extended hidden resolutions) none of them come close.

Is it a matter of the cable I’m using? I’m using a HDMI cable with a usb-c adaptor on the end to connect it to the MacBook.

nvidia – Ubuntu 20.04 Second monitor is not working

I tried to connect my laptop with the second monitor, however, it displays on the second monitor that No HDMI signal from your device. When I checked the Displays setting, there is no monitor too.
I use ASUS Gaming. This is the configuration of Ubuntu 20.04
enter image description here

When I checked xrandr in the terminal:
enter image description here

I also updated to the kernel 5.6 but nothing changes
Here is the setting of the software updates, there are no additional drives
enter image description here

I hope anyone can help me because I need to work on a big screen.
Thanks in advance.

postgresql – Monitor FOR loop progress in postgres

By adding raise notice. It will keep printing value of i — so that you will always have idea about loop progress.

    DO
    $do$
    BEGIN 
    FOR i IN 1..20000
    -- update some rows
    raise notice 'Current Progress Value i:%',i;
     LOOP
    END LOOP;
    END; 

Or more better way.

  1. Create a sql file : vi loop.sql — add your loop into this file with raise notice.

  2. Run as a job: psql -U username -d database_name -a -f loop.sql &>progress_log

  3. Keep monitoring latest id : tail progress_log

Note: One more tip- I think you need to initialize i – need to include a declare section.

sql – wordpress slow query shown in query monitor

I have a slow query on a wordpress site. I believe it’s my subquery inside it for the ‘abbreviation’. How can I rewrite this to make it faster? I’m not having much luck. The query takes about 0.1219 seconds I have both the query and the explain below, my goal is to modify this query to make it execute faster, thanks.

This is the query:

SELECT
    wrapper_featured_colorways.id,
    wrapper_featured_colorways.design_name AS dname,
    wrapper_featured_colorways.designId,
    wrapper_featured_colorways.submodel_id,
    wrapper_featured_colorways.sled_image,
    wrapper_featured_colorways.sled_png,
    wrapper_featured_colorways.colorway_name,
    wrapper_featured_colorways.engineId,
    wrapper_featured_colorways.yearText,
    wrapper_submodels.model_id,
    wrapper_submodels.sub_name,
    wrapper_models.model_name,
    wrapper_chassis.id AS chassis_id,
    wrapper_chassis.chassis_name,
    wrapper_manufacturers.mf_name,
    wrapper_manufacturers.mf_id,
    a.guid AS svgPath,
    afx_posts.post_type,
    afx_posts.post_title,
    GROUP_CONCAT(
        wrapper_featured_colorway_colors.color_name
    ORDER BY
        wrapper_featured_colorway_colors.sort_order
    ) AS colors
FROM
    wrapper_featured_colorways
JOIN afx_posts a ON
    (
        a.post_parent = wrapper_featured_colorways.designId
    )
JOIN afx_posts ON(
        afx_posts.ID = wrapper_featured_colorways.designId
    )
JOIN afx_postmeta z ON
    (
        (z.meta_key = 'svg_image') AND(a.ID = z.meta_value)
    )
JOIN wrapper_submodels ON wrapper_featured_colorways.submodel_id = wrapper_submodels.id
JOIN wrapper_models ON wrapper_submodels.model_id = wrapper_models.id
JOIN wrapper_chassis ON wrapper_models.chassis_id = wrapper_chassis.id
JOIN wrapper_manufacturers ON wrapper_chassis.manufacturer_id = wrapper_manufacturers.mf_id
JOIN wrapper_featured_colorway_colors ON wrapper_featured_colorways.id = wrapper_featured_colorway_colors.colorway_id
WHERE
    wrapper_featured_colorways.deleted = 0
GROUP BY
    wrapper_featured_colorway_colors.colorway_id

This is the Explain:

EXPLAIN SELECT
    wrapper_featured_colorways.id,
    wrapper_featured_colorways.design_name AS dname,
    wrapper_featured_colorways.designId,
    wrapper_featured_colorways.submodel_id,
    wrapper_featured_colorways.sled_image,
    wrapper_featured_colorways.sled_png,
    wrapper_featured_colorways.colorway_name,
    wrapper_featured_colorways.engineId,
    wrapper_featured_colorways.yearText,
    wrapper_submodels.model_id,
    wrapper_submodels.sub_name,
    wrapper_models.model_name,
    wrapper_chassis.id AS chassis_id,
    wrapper_chassis.chassis_name,
    wrapper_manufacturers.mf_name,
    wrapper_manufacturers.mf_id,
    a.guid AS svgPath,
    afx_posts.post_type,
    afx_posts.post_title,
    GROUP_CONCAT(
        wrapper_featured_colorway_colors.color_name
    ORDER BY
        wrapper_featured_colorway_colors.sort_order
    ) AS colors
FROM
    wrapper_featured_colorways
JOIN afx_posts a ON
    (
        a.post_parent = wrapper_featured_colorway(...)


1   SIMPLE  wrapper_manufacturers   
    NULL
    ALL PRIMARY 
    NULL
    
    NULL
    
    NULL
    4   100.00  Using temporary; Using filesort 
1   SIMPLE  wrapper_featured_colorways  
    NULL
    ALL PRIMARY 
    NULL
    
    NULL
    
    NULL
    45  10.00   Using where; Using join buffer (Block Nested Loop)  
1   SIMPLE  wrapper_submodels   
    NULL
    eq_ref  PRIMARY PRIMARY 4   fxgraphi_v2019.wrapper_featured_colorways.submodel_id   1   100.00  Using where 
1   SIMPLE  wrapper_models  
    NULL
    eq_ref  PRIMARY PRIMARY 4   fxgraphi_v2019.wrapper_submodels.model_id   1   100.00  Using where 
1   SIMPLE  wrapper_chassis 
    NULL
    eq_ref  PRIMARY PRIMARY 4   fxgraphi_v2019.wrapper_models.chassis_id    1   10.00   Using where 
1   SIMPLE  afx_posts   
    NULL
    eq_ref  PRIMARY PRIMARY 8   fxgraphi_v2019.wrapper_featured_colorways.designId  1   100.00  Using index condition   
1   SIMPLE  z   
    NULL
    ref meta_key    meta_key    576 const   139 100.00  Using where 
1   SIMPLE  a   
    NULL
    eq_ref  PRIMARY,post_parent PRIMARY 8   fxgraphi_v2019.z.meta_value 1   10.00   Using index condition; Using where  
1   SIMPLE  wrapper_featured_colorway_colors    
    NULL
    ALL 
    NULL
    
    NULL
    
    NULL
    
    NULL
    1431    10.00   Using where; Using join buffer (Block Nested Loop)  

```

nvidia – Cannot connect second monitor via HDMI cable in Ubuntu 20.04

I just installed ubuntu 20.04 on my laptop. However, when I tried to connect my external monitor via HDMI cable the monitor is not detecting any signal.
I am using nvidia-driver-435. My GPU is “NVIDIA Corporation TU106GLM (Quadro RTX 3000 Mobile / Max-Q)”. I am using a HP G6-15 laptop. xrandr is not detecting the display

Screen 0: minimum 320 x 200, current 1920 x 1080, maximum 16384 x 16384
eDP-1 connected primary 1920×1080+0+0 (normal left inverted right x axis y axis) 344mm x 193mm
1920×1080 60.03*+ 60.01 59.97 59.96 59.93 40.02
1680×1050 60.00 59.95 59.88
1600×1024 60.17
1400×1050 59.98 60.00
1600×900 59.99 59.94 59.95 59.82
1280×1024 59.95 60.02
1440×900 59.89
1400×900 59.96 59.88
1280×960 60.00 59.99
1440×810 60.00 59.97
1368×768 59.88 59.85
1360×768 59.80 59.96
1280×800 59.99 59.97 59.81 59.91
1152×864 59.97 60.00
1280×720 60.00 59.99 59.86 59.74
1024×768 60.04 60.00 59.95
960×720 60.00
928×696 60.05
896×672 60.01
1024×576 59.95 59.96 59.90 59.82
960×600 59.93 60.00
960×540 59.96 59.99 59.63 59.82
800×600 60.00 60.32 59.96 56.25
840×525 60.01 59.88
864×486 59.92 59.57
800×512 60.17
700×525 59.98
800×450 59.95 59.82
640×512 60.02
720×450 59.89
700×450 59.96 59.88
640×480 60.00 59.94 59.94
720×405 59.51 58.99
720×400 59.97
684×384 59.88 59.85
680×384 59.80 59.96
640×400 59.88 59.98 59.96
576×432 60.06
640×360 59.86 59.83 59.84 59.32
640×350 59.84
512×384 60.00
512×288 60.00 59.92
480×270 59.63 59.82
400×300 60.32 56.34
432×243 59.92 59.57
320×240 60.05
360×202 59.51 59.13
320×180 59.84 59.32
DP-1 disconnected (normal left inverted right x axis y axis)
DP-2 disconnected (normal left inverted right x axis y axis)
HDMI-1 disconnected (normal left inverted right x axis y axis)

I was earlier using ubuntu 18.04 on the same computer and the second monitor was working. I freshly installed 20.04 after erasing the previous version after deleting everything. I switched to lightdm switched back to gdm3 but nothing worked so far.In some answers I have found to edit

sudo nano /lib/modprobe.d/nvidia-kms.conf
and comment the options nvidia-drm modeset=1.
But it is not present on my computer. I can onlye find the nvidia-graphics-drivers.conf file on /lib/modprobe.d

I don’t know what is wrong. Please let me know if you need more information.

battery life – Multiple Device Usage Monitor App with Cloud?

So I’m in a company where they lend a lot of tablets with the same google account. I want to know if there is an app that can track all the device usage like what app they use, how long is the screen on time, etc. I want to monitor and track all the usage also from the web. Is there any option or any free / paid app for this scenario? thanks!