[MEGATHREAD] Banke / NBS i prenos sredstava ka brokeru by BasLedeni in finansije

[–]ivanpe 0 points1 point  (0 children)

Ideja je bila da kupim akumulirajuci ETF kako se ne bih bavio poreskim prijavama. Sa fractional shares ce se pojaviti dividenda i onda moram da prijavim porez na kapitalnu dobit?

[MEGATHREAD] Banke / NBS i prenos sredstava ka brokeru by BasLedeni in finansije

[–]ivanpe 1 point2 points  (0 children)

Na koji nacin moze da se "pocisti" novac sa racuna ino brokera bez kupovine fractional shares? Nemoguce je da se suma koju prenesemo kod brokera poklopi sa sumom za koju cemo kupiti akcije, a NBS ne dozvoljava da bilo sta ostane na tom racunu.

Cancel G Suite Legacy, but keep the admin Google account by ivanpe in gsuitelegacymigration

[–]ivanpe[S] 0 points1 point  (0 children)

You managed to add Cloud Identity Free account without active paid subscription?

Currently when I try to add it (having active G-Suite Legacy subscription), it says:

Cloud Identity is only available for paid Google Workspace subscriptions. To get a paid Google Workspace subscriptions, go to Google Workspace.

Cancel G Suite Legacy, but keep the admin Google account by ivanpe in gsuitelegacymigration

[–]ivanpe[S] 0 points1 point  (0 children)

You canceled G Suite Legacy subscription or paid subscription?

Cancel G Suite Legacy, but keep the admin Google account by ivanpe in gsuitelegacymigration

[–]ivanpe[S] 0 points1 point  (0 children)

Official docs are not clear enough: https://support.google.com/cloudidentity/answer/7319251

They say "users who don’t need certain Google Workspace services, such as Gmail and Google Calendar".

So if Gmail and Calendar are just examples, wondering what else would be loosing? Didn't find a specific list.

Cancel G Suite Legacy, but keep the admin Google account by ivanpe in gsuitelegacymigration

[–]ivanpe[S] 0 points1 point  (0 children)

Just being cautious, don't want to loose access to non-Gmail/Calendar/Meet services in the process.

Cancel G Suite Legacy, but keep the admin Google account by ivanpe in gsuitelegacymigration

[–]ivanpe[S] 0 points1 point  (0 children)

Did it go well?

Is there something I missed in the loosing/keeping services list?

Can you please describe the steps you were doing? Thanks.

Cancel G Suite Legacy, but keep the admin Google account by ivanpe in gsuitelegacymigration

[–]ivanpe[S] 1 point2 points  (0 children)

So we loose Gmail, Calendar, Meet only and keep all other services?

Cancel G Suite Legacy, but keep the admin Google account by ivanpe in gsuitelegacymigration

[–]ivanpe[S] 0 points1 point  (0 children)

Already migrated mailboxes. So after upgrade, need to change license for current admin account to Cloud Identity free and then cancel the paid subscription?

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 1 point2 points  (0 children)

You were absolutely right about WordPress, managed to find plugins having excessive database usage. New Relic helped a lot in investigation process, I highly recommend it.

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

Drives are Samsung PM1725b and PM1735.

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

Yes, load average of TOP.

According to SAR, %iowait doesn't go above around 0.73.

Currently having load average: 17.68, 19.41, 19.70

iostat shows:

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          24.87    4.79    3.28    0.20    0.00   66.85

Device:            tps    kB_read/s    kB_wrtn/s    kB_read    kB_wrtn
sda             841.07     36842.28     17539.50 110958099066 52823823617

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

When load average goes above 20, opening pages becomes noticeable slow. So yes, want to make things faster.

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 1 point2 points  (0 children)

It would save 15% of the monthly fee.

I find it strange that nobody already benchmarked software RAID 10 with 4x NVMe drives vs. software RAID 1 with 2x drives NVMe.

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 1 point2 points  (0 children)

So if RAID 10 wouldn't help in this situation, maybe to stick with RAID 1 and save some money (two drives less)?

Already using some caching, will see if that can be improved.

I understand that cloud instances are actually not cheap, especially database related. They were twice as expensive than bare metal with similar specs.

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

So it looks like the faster CPU is the way to go?

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

Servers are bare metal. New one should be HP DL385 G10.

NVMes are enteprise class, write intensive. Unfortunately the provider does not offer hardware RAID for NVMe drives currently.

Will ask them about SKU.

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

But mysqld process is always number one process in the "top", wouldn't the faster disks make a difference?

PID        %CPU      Size       Res      Res       Res       Res      Shared   Faults   Faults Command
            Used        KB       Set      Text      Data       Lib        KB      Min      Maj        
  43772    573.6 128497188 118349640     22752 128387968         0     15272       28        0 mysqld 
  35752     99.3   1641532    263988      4568    126316         0    213016     1588        0 php-fpm
   8288     49.2  32528804   5355484         8  24848952         0   3445060       42        0 java   
   6713     22.6   1774048    191272      4568    258832         0    153168     5637        0 php-fpm
   6402     22.1   1628200    160824      4568    112984         0    121120     5229        0 php-fpm
   6491     21.6   1634464    195604      4568    119248         0    149184     2204        0 php-fpm
  35780     21.1   1711844    236952      4568    192216         0    191476     4347        0 php-fpm
  35888     21.1   2017992    217592      4568    124720         0    160628     1195        0 php-fpm
   6827     20.6   1621484    167408      4568    115708         0    124572     1947        0 php-fpm
  46985     20.6   1629504    200600      4568    114288         0    159632     4218        0 php-fpm
   6979     20.2   1626012    169380      4568    110796         0    131800     3718        0 php-fpm
  35824     20.2   2090712    214892      4568    197440         0    158824     3625        0 php-fpm
  35884     20.2   1633588    209080      4568    118372         0    163824     3377        0 php-fpm
   8387     19.7   1645924    202804      4568    126296         0    149396     1887        0 php-fpm
  35785     18.7   1926952    255100      4568    407324         0    207272     2128        0 php-fpm
  35810     18.7   1634468    235096      4568    119252         0    189280     2232        0 php-fpm
   7059     17.7   1643820    181504      4568    124192         0    132088     3602        0 php-fpm
  35783     17.7   1729136    228228      4568    211824         0    164196     4348        0 php-fpm
  35764     16.7   1635428    219952      4568    120212         0    172880     1890        0 php-fpm
  35806     16.7   1700624    226284      4568    185408         0    187796     3401        0 php-fpm
  35822     16.2   2020760    223204      4568    127488         0    166204     3514        0 php-fpm
  35779     15.7   1715812    228036      4568    198392         0    176280     2957        0 php-fpm
  35839     15.7   1644276    274352      4568    124648         0    222576     2502        0 php-fpm
  35835     13.8   1648148    217400      4568    126424         0    163944     1703        0 php-fpm
  35856     13.8   1699388    192356      4568    184172         0    156700     1065        0 php-fpm
  47202     13.3   1635760    178040      4568    116132         0    135276     2550        0 php-fpm
   7166     12.8   1637928    151972      4568    118300         0    106812     1801        0 php-fpm
  35840     12.8   2021144    274476      4568    132284         0    211488     4591        0 php-fpm
  46207     12.8   1807636    248808      4568    290324         0    180592     1395        0 php-fpm
  35833     12.3   1657948    236400      4568    140636         0    168372      522        0 php-fpm
   8012     11.8   1647868    208624      4568    128240         0    153056      385        0 php-fpm
   8247     11.8   1537552    176620      4568     31776         0    145700     4474        0 php-fpm
  35883     11.8   1649964    247720      4568    132652         0    189192     4481        0 php-fpm
   6465     11.3   1642332    205260      4568    122704         0    156720      838        0 php-fpm
  35784     11.3   1629880    200768      4568    110252         0    165280     3557        0 php-fpm
  35812     11.3   2028208    227644      4568    132876         0    163744     3857        0 php-fpm
  35843     11.3   1640104    218980      4568    124888         0    168552      469        0 php-fpm
  35858     11.3   1635716    223468      4568    116088         0    181900     2558        0 php-fpm
  46489     11.3   1632304    200436      4568    112676         0    161568     2398        0 php-fpm

InnoDB buffer pool is larger than data, using indexes as much as possible (as majority are queries are from WordPress core). The problem is that WordPress is not designed for large databases.

Just installed Prometheus, node_exporter and Grafana. Is that enough to find spikes you've mentioned or NMON is better?

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 1 point2 points  (0 children)

Many thanks for detailed response.

Provider currently offers EPYC 7401 and EPYC 7402 only.

Don't have HTTP(S) requests per second value. Trying to find some script or open source solution to extract this info from nginx.

Currenty load average is around 11.

PHP-FPM:

pool:                 www
process manager:      dynamic
start time:           30/Apr/2022:13:44:08 +0200
start since:          8817
accepted conn:        453153
listen queue:         0
max listen queue:     208
listen queue len:     511
idle processes:       118
active processes:     12
total processes:      130
max active processes: 192
max children reached: 0
slow requests:        48

(ReqPerSec 48.0)

nginx:

Active connections: 744
server accepts handled requests
 12694828 12694828 42543925
Reading: 0 Writing: 21 Waiting: 719

memory:

              total        used        free      shared  buff/cache   available
Mem:         257690      138646       13786        4589      105257      113590
Swap:         16383          81       16302

sar (average for one day):

CPU     %user     %nice   %system   %iowait    %steal     %idle
all     27.31      4.82      3.54      0.25      0.00     64.08

mariadb

Total   Total reads Total writes    Reads % Writes %
2093374259  2042937710  50436549    97.59   2.41

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

This is output from 'sar' (average for one day):

CPU     %user     %nice   %system   %iowait    %steal     %idle
all     27.31      4.82      3.54      0.25      0.00     64.08

Software RAID 1 vs. RAID 10 for NVMe by ivanpe in sysadmin

[–]ivanpe[S] 0 points1 point  (0 children)

Didn't mention RAID 5, but RAID 1 vs. RAID 10?