Internet connection monitor with logging

We are having intermittent issues with our internet connection in a community house of nine people. It seems to cut out for short intervals so I am looking for an app to test connectivity at regular intervals and log it. For example to ping a host on the internet every minute or so and log the results. What I want is to log when the connection is down and for how long over a period of time. This is not an enterprise issue so I am looking for a free app or script to accomplish this.
Thanks

displayport – What is the advantage of connection to the monitor USB-C port vs. the display port

Some monitors have, among other ports, a display port connector as well as a USB-C connector.

Assuming a laptop also have a USB-C port with a THUNDERBOLT 3 support.

Is there a real difference, in terms of display quality only ignoring other USB-C capabilities like charging, between connecting the laptop to the screen using

  • USB-C -> Display port
  • USB-C -> USB-C

Does a graphic card needed in led 32 inches normal TV using as monitor

I wanna change my lg 32 inches led TV into a monitor so this screen is much larger than normal monitor so plz suggest me if I have to add some graphics card into this or their is no need to add graphics card

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.

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.

nvidia – Does the Ubuntu OS have a monitor driver?

I can’t upgrade my current configuration
I have a Dell 7920 running Ubuntu 18.04.
I have a NVIDIA Quadro GV100, 32GB installed as CUDA 9.2
I am using this NVIDIA card to also drive my monitor.
During my original purchase the sales persons asked “Are you sure you don’t want a separate card for your monitor?” – I said No. I should have said Yes.
I can’t upgrade the Ubuntu OS to 19. or 20. or the NVIDIA card to 10. or 11. because the monitor is tied to the card.
I got a system upgrade that I allowed to start and it failed before completion so now I get an error on the CUDA.
I have a NVIDIA Geforce GT 1030 that I could dedicate to the monitor but will not work. It is using the same driver as the Quadro.
I would like to install a simple card that has the driver as part of the Ubuntu OS.
Does the Ubuntu OS have a monitor driver?
Is there a simple card I can buy that has an internal driver?
Is there a Non NVIDIA driver I can install that the Geforce GT 1030 would recognize?
Am I confused and not seeing the real issue?
Thank you and Peace,
Gerard

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!

linux – How to set a default resolution in external monitor using Fedora

I’d like to know to set an external monitor resolution persistently as 1280×720 instead of 1920×1080, which is not the screen resolution but rather the first one, so I don’t know why it happens. When I boot into Windows, it uses the correct resolution natively, but not in Fedora 32. I have tried

$ xrandr –output HDMI-1 –mode 1280×720

But every now and then when I change between laptop only or both screens, the external monitor resolution goes to 1920×1080.

Thanks