clustering – Increase TempDB Files, Shrink VLF’s with FCI

I am planning to resize and increase the number of tempDB files and shrink the VLF’s on an FCI. In this case, the tempdb files are stored on the network drive, rather than the local disk. I couldn’t find anything that addresses situation, but I need to know the impact the increase would have on a FCI. Thanks!

LVM: shrink / zero, extending SWAP

kamals@poc02:~$ sudo lvs
  LV                     VG        Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  root                   vg_system -wi-ao----  63.98g
  scratch                vg_system -wi-ao---- 465.66g
  .
  .
  swap                   vg_system -wi-ao----  16.00g
  var                    vg_system -wi-ao----  31.99g
kamals@poc02:~$ sudo vgs
  VG        #PV #LV #SN Attr   VSize   VFree
  vg_system   1   6   0 wz--n- 930.51g 296.88g
kamals@poc02:~$ df -h /scratch/
Filesystem                     Size  Used Avail Use% Mounted on
/dev/mapper/vg_system-scratch  459G  726M  435G   1% /scratch
kamals@poc02:~$ sudo umount /scratch

kamals@poc02:~$ sudo e2fsck -f /dev/mapper/vg_system-scratch
e2fsck 1.42.13 (17-May-2015)
Pass 1: Checking inodes, blocks, and sizes
Pass 2: Checking directory structure
Pass 3: Checking directory connectivity
Pass 4: Checking reference counts
Pass 5: Checking group summary information
scratch: 25/30523392 files (16.0% non-contiguous), 2134330/122070016 blocks
kamals@poc02:~$ sudo resize2fs /dev/mapper/vg_system-scratch 450G
resize2fs 1.42.13 (17-May-2015)
Resizing the filesystem on /dev/mapper/vg_system-scratch to 117964800 (4k) blocks.
The filesystem on /dev/mapper/vg_system-scratch is now 117964800 (4k) blocks long.
kamals@poc02:~$ sudo lvreduce -L -9G /dev/mapper/vg_system-scratch
  WARNING: Reducing active logical volume to 456.66 GiB
  THIS MAY DESTROY YOUR DATA (filesystem etc.)
Do you really want to reduce scratch? (y/n): y
  Size of logical volume vg_system/scratch changed from 465.66 GiB (119209 extents) to 456.66 GiB (116905 extents).
  Logical volume scratch successfully resized.
kamals@poc02:~$ sudo mount /dev/mapper/vg_system-scratch /scratch/
kamals@poc02:~$ lsblk | grep scratch
  ├─vg_system-scratch                252:4    0 456.7G  0 lvm  /scratch
kamals@poc02:~$
kamals@poc02:~$ df -h /scratch/
Filesystem                     Size  Used Avail Use% Mounted on
/dev/mapper/vg_system-scratch  443G  727M  420G   1% /scratch
kamals@poc02:~$


SWAP Space extend:
===================

kamals@poc02:~$ lsblk | grep swap
  ├─vg_system-swap                   252:1    0    16G  0 lvm  (SWAP)
kamals@poc02:~$ sudo swapoff /dev/vg_system/swap
kamals@poc02:~$
kamals@poc02:~$ sudo lvresize -L+9G /dev/vg_system/swap
  Size of logical volume vg_system/swap changed from 16.00 GiB (4095 extents) to 25.00 GiB (6399 extents).
  Logical volume swap successfully resized.
kamals@poc02:~$ sudo mkswap /dev/vg_system/swap
mkswap: /dev/vg_system/swap: warning: wiping old swap signature.
Setting up swapspace version 1, size = 25 GiB (26839347200 bytes)
no label, UUID=5fbefbfc-b0fc-46d5-8d5e-b547c184ac14
kamals@poc02:~$ sudo swapon /dev/vg_system/swap
kamals@poc02:~$
kamals@poc02:~$ free -th | grep -i swap
Swap:           24G          0B         24G
kamals@poc02:~$
kamals@poc02:~$ lsblk | grep swap
  ├─vg_system-swap                   252:1    0    25G  0 lvm  (SWAP)

Here I am trying to shrink the data / scratch disk in 9G and increase that amount of SWAP space.

I am seeing here that the LVM / scratch reduction is working as expected (465.66G-9G ~ = 456.7G), but why is the FS size in df -h 443G from 459G simply by reducing 9G.

I performed once again with the 1G reduction, I see that the df value is reduced to 428G.

kamals@poc02:~$ df -h /scratch/
Filesystem                     Size  Used Avail Use% Mounted on
/dev/mapper/vg_system-scratch  428G  727M  405G   1% /scratch
kamals@poc02:~$

I have a couple of questions,

Am I doing something wrong here?

Are these steps correct? Can I deploy them on production servers simply by taking downtime?

Is there any chance of data loss with these steps?

Is there a better solution?

Thank you!

brute force: generating a list using the specific shrink indication block

Hello everyone, I want to generate a list in Crunch that has the following conditions

  1. Must be 12 characters (minimum and maximum)
  2. it must start with 9665
  3. using these characters 0123456789
    so the list is like this
    966501234567
    966501234576
    and so
    I tried

    crunch 12 12 012345789 -s 9665

but it said that the minimum length should be 4, what should I do?

Thanks in advance, have a great day

How can I shrink a zfs volume in ubuntu 18.04?

Given a single disk installation with zfs, how can I shrink the zfs partition / group so I can add a new partition to disk? Other instructions I've seen indicate setting the volsize property on the group, but doing so gives the following error: cannot set property for 'rpool': 'volsize' does not apply to datasets of this type

$ zpool list
NAME    SIZE  ALLOC   FREE  CKPOINT  EXPANDSZ   FRAG    CAP  DEDUP    HEALTH  ALTROOT
bpool  1.88G   196M  1.68G        -         -      -    10%  1.00x    ONLINE  -
rpool   228G  10.9G   217G        -         -     2%     4%  1.00x    ONLINE  -

css: shrink the image as soon as the screen gets smaller, before the screen side touches the image

I am trying to achieve something, but I don't know the correct way to do it. I hope someone can help me in the right direction.

With responsive images, the image will get smaller as soon as the screen is as big as the image, and then the image will get smaller along with the screen (if I'm right). But I am trying to make an image smaller as soon as the screen gets smaller.
This is the page https://videosafari.nl/banner-test/ and it is the red logo (NPO1).

The real problem is that the images below the logo get smaller when the screen gets smaller but the logo stays the same size. I want the logo to stay in proportion to the images below, so I would like it to be smaller. Any suggestion?

    .carousellogo {
    display: inline-block;
    margin: 0px 0px 12px 30px;}
    

The original image is width = "149" height = "100" but I made it smaller to make sure the image stays sharp on retina displays. width = "75" height = "".

I hope I was clear enough and thanks for taking the time to read my question. BTW I'm just a beginner with css and html.

Have a nice day and stay safe.

file groups: control the db shrink SQL Server rhythm to divide it into several files

(Moving this manually from StackOverflow, since it really belongs here).

We have a SQL Server Enterprise production database that contains some data TB. We need to divide the data into multiple files. The tests in preproduction environments have worked well, with the exception that during the reduction, the performance of the database is degraded. We would like to anticipate possible problems with the reduction / division of files in the production system, since we have large clients with SLAs that limit our ability to make changes that significantly affect performance.

Does the SQL Server reduction / split functionality have the ability to limit the overhead incurred by the reduction / split during the transition to multiple files? Or, do we have roads that allow the same limiting capacity? Alternatively, can an approach be adopted that gradually divides / reduces files during maintenance windows?

dungeons and dragons: can you shrink and then teleport within an enemy using another size and then again to expand and exploit the creature?

So my group is playing a campaign of God and my character has divine rank 1. I chose to alter the size as my divine ability, but one of the advantages of being a literal god is that I can teleport at will as free action. So my question is, during combat, if I use alter size to reduce the size of a pinhead, and I teleport WITHIN an enemy, then I use alter size again to expand enough to basically explode his body … how could you calculate that exactly ……

transaction log – The log file will not shrink – suggestions?

I have a 225 GB database with a 390 GB log file, which has recently exploded in size. I am trying to reduce it, according to these instructions: https://www.brentozar.com/blitz/transaction-log-larger-than-data-file/

I cannot reduce it in SSMS or by using the DBCC SHRINKFILE command. I tried to wait until it was not in use, and I also tried a registry backup and then ran DBCC SHRINKFILE again, but it was in vain. Any ideas on what I can do?

I saw in this article (https://www.mssqltips.com/sqlservertutorial/3311/how-to-shrink-the-transaction-log/) that it says you could try changing the recovery model to Simple, run the shrink, then change it back to Full, but that seems risky, so be careful to try.

It is also worth noting that my database is duplicated and currently stuck in a suspended state.

I wonder if you could give any advice. We are your typical store without DBA, so I appreciate any suggestions or suggestions from beginners. Thank you!

User behavior – Mobile button – When touching (before releasing), should it grow or shrink?

TL; DR: Both methods can work. Contraction It is more logical but has less visibility due to the user's finger. Growing It does not correspond to the expectations of real life but the interaction is better visible.


Instinctively, I would always prefer a button to shrinkage, how you are pressing down And that corresponds to the perception of the real world.
The only problem that can arise with this is that the finger then covers the button And the user can no longer see what happens to him. So the growth method has the advantage of better visibility.

Google's Materials Design Guidelines mention elevation and how it helps the user to understand the order of the user interface elements.
They have a section that talks about raised buttons and these should go up when you press. There is an interesting discussion about this here:
Material design – buttons go up, do not depress
Personally I do not agree with that decision, as it is totally counterintuitive.

Here is another question that could be related to yours:
Make people understand that they can click on a button in a flat design


At the end, You can probably achieve both methods As long as you design them attractive enough and understandable enough.

Algorithms – Shrink Article 0-1 Backpack Problem

I have found a variant of the backpack problem with articles that shrink.

Indeed, it is a 0-1 backpack problem where the initial weight of each item is W (n) + V (n) and its value is V (N), but immediately after placing it in the container, the item is reduced by W (north). This means that for each item IN the backpack, the weight and value are the same. (Therefore, it is also possible to see this as a irrelevant irrelevant 0-1 "stuffed" backpack irrelevant to the value).

Therefore, in this case, you must also determine the correct order of the elements to be inserted and whether a specific element is legal in the combination before placing it in the container.

I have already determined that the order of insertion, given a valid collection, should be based on W (n) + V (n) descending, but so far I can not create a set of valid collections in anything below O (2 ^ north) .

The dynamic programming solutions are failing me due to the apparent interdependence of the elements that makes memorization seem impossible.

I realize that I have not given much here, but I really might need some help. How is this variant addressed?

If it's funny, the real application is that we have a lot of different electrical devices that cause a known overload when they turn on and then they extract a certain amount of energy. We never want to trigger a switch, so we must take into account the increase in voltage to determine how many we can activate at the most.