MySQL Alter Table Drop Column INPLACE NoLock – Until which point the column being dropped is accessible?

I am trying to run MySQL Alter INPLCAE command to drop few columns from a very large 90GB table. While the Alter is running I am able to run the Select statement on the same table to ensure that the table is not locked.

MySQL Version 5.7 with innodb

Questions:

  1. While the alter command is running with in place algorithm and nolock, up to what point the data can be accessed in the columns being dropped? e.g. at the point when the columns are almost being dropped? I need to make this change in prod so need to make sure of this.

  2. Can the application still update the table while the alter to drop columns is running? Currently the columns are stored and after dropping them we will be converting them Virtual.

  3. Will there be any downtime at all, I read somewhere that the table will be locked shortly at the end, correct me if I am wrong.

Thanks!

Index Drop for Partial Overlap?

I’m working with a 50mil row table with the following:

  • Clustered Index keyed on [Col1]
  • Nonclustered Index keyed on [Col1], [Col2] (no includes)

It seems like the right call here would be to drop #2 and rebuild #1 keyed on [Col1], [Col2]. Sound right? Would the tuning logic be the same if the NCI still had [Col1] as its first key and then 7 other keys after that (rebuild the CX with 8 keys)?

WordPress DROP tables with prefix

Hi I am trying to drop some tables in bulk before creating them again for testing purposes.

I am trying to run this statement

dbDelta(       "SET GROUP_CONCAT_MAX_LEN=10000;       SET @tbls = (SELECT GROUP_CONCAT(TABLE_NAME)       FROM information_schema.TABLES       WHERE TABLE_SCHEMA = 'wp_test'       AND TABLE_NAME LIKE 'mch_%');       SET @delStmt = CONCAT('DROP TABLE ',  @tbls);       PREPARE stmt FROM @delStmt;       EXECUTE stmt;       DEALLOCATE PREPARE stmt;",       $  wpdb->prefix ) 

But nothing happens, my plugin gets activated with no errors, but the tables are still there.

I am new to this stuff, so I would like to understand the proper way to do this.

Efficiently DROP huge table with cascading replication in PostgreSQL

What I have:

Database: PostgreSQL 9.3

Table T,

  • Structure: 10 integers/bools and 1 text field
  • Size: Table 89 GB / Toast 1046 GB
  • Usage: about 10 inserts / minute
  • Other: reltuples 59913608 / relpages 11681783

Running cascading replication: Master -> Slave 1 -> Slave 2

  • Replication Master -> Slave 1 is quite fast, a good channel.
  • Replication Slave 1 -> Slave 2 is slow, cross-continent, about 10 Mbit/s.

This is a live, used database with about 1.5TB more data in it.


What’s needed to be done:

  • Drop all data to start with a fresh setup (to do constant cleanups and not allow it to grow this big).

Question: What would be the most efficient way to achieve this:

  • without causing huge lags between Master and Slave 1
  • without causing Slave 2 to get irreversibly lagged to a state where catching up is not possible

As I see it:

  • Safe way – do a copy, swap places, DELETE data constantly watching lag
  • Other way – do a copy, swap places, DROP table – but this would cause enormous amounts of data at once and Slave 2 would get lost?

T-shirt and Accessories using POD drop shipping

Why are you selling this site?
I started this project but I have too many shirt businesses on my back burner so I'm letting someone else take this business and make it big

How is it monetized?
by selling print on demand items

Does this site come with any social media accounts?
no, it does not have a social presence

How much time does this site take to run?
takes 20-30 minutes to add a few items and publish them to the site. I can help the new owner with a…

T-shirt and Accessories using POD drop shipping

How to select selected Html Drop Down and paste it automatically into a Contact Form

first of all its my first question in Stackoverflow, because im hardstuck in a problem right now. So hopefully someone can help me with that.

The project: I am building a Product Configurator for a Website. The main goal is, that customers can configurate their product and the options they selected are automatically placed in a Contact Form.

I am working on WordPress with Elementor. The Plugin I used for the configurator is: "Woocommerce Extra Product options"

My Problem: I need to get the ID’s of the specific selected containers and fill the text of the containers automatically in the Form down below.

The site: https://soundgreets.com/produkt/konfigurator/

Does anyone know how i can do this? Maybe in a .php file? Or in elementor? I did some massive CSS on the site, so that it looks like it is right now. This Selector is to select all containers of the Dropdowns.

.tc-extra-product-options .cpf-type-select .tmcp-field-wrap label.fullwidth select{ color: red; } What i also tried is to use Elementors Html Code-widget to get the variable of the specific Id of a container.

This didnt work: the output is "undefined"

var e = document.getElementById(“tmcp_select_160362915b5ef2”); var strUser = e.options[e.selectedIndex].text; document.write(strUser) I hope someone has an idea on this.

thanks in advance

Berkan

PS: The site could look a bit messy i am sorry for that

Drop servicing business, 2 buyers + 1 seller(s) (mid-sized comp.) are ready to start, $3/Prospect

* An old business listing is being reused, old comments may be irrelevant.

$ 3 Cost Per Prospect (Upwork Virtual Assistants, real humans, no ads/bots)

I am selling this site to cash out before doing it again.

Client information is confidential please dm/comment for that
Tools used/taught after/during the sale: Discord, G Maps, Upwork (for Discord VAs + telemarketing VAs)

We do not have a website, only a LinkedIn. For this dire reason, before the sale, I can…

.. get you…

Drop servicing business, 2 buyers + 1 seller(s) (mid-sized comp.) are ready to start, $ 3/Prospect

Milestone leveling for a party of players who drop in and out?

Historically I have generally used XP for tracking character progress in my party. But my latest new campaign I intend to move to a milestone approach.

However the one thing I don’t fully understand is the best way to manage milestones for parties where players drop in and out of sessions. Up front we have accepted that due to life my players will not be able to make every session and so we have agreed that sessions will take place the character will just be missing, or be jaegured.

What is the best way to manage milestone leveling in this case, should I track player attendance and take this into account, level everyone at the storyline moments anyway, or take more of a player by player approach (which feels like doing XP just without the XP).

I know DnD published material is moving towards the milestone approach is there any official ruling from them with regards to league sessions etc?

Drop tables but space not claimed in postgres 12

I have upgraded Postgresql 9.5 to Postgresql 12.4 a few days back using pg_upgrade utility with link (-k) option.

So basically I am having two data directories i.e. One is old data directory (v9.5) and the current one in running state (v12.4).

Yesterday I have dropped two tables of size 700MB and 300MB.

After connecting to postgres using psql utility I can see database size whose tables was dropped got decreased (with \l+ ) but what is making me worry is that only a few MBs have been freed from storage partition.

I have run vacuumdb only on that database but no luck. I have checked if any deleted open file is there on OS level using lsof but there is none.

Looking for the solution.

D&D 5e does a fiend drop any items carried when it is killed and returned to Avernus?

I had a bearded devil carrying some keys that would open a jail cell, tied to his belt and was slain. My question is, does it drop the keys and can be retrieved by my players or would they go with it back to Avernus?

I am not too concerned if I have to make my own ruling but if this has been answered somewhere I would prefer to use that rule.

Many Thanks.