Big Woocommerce Shop

Hi

I have an Shop with an Mysql database of 100mb. if i dont cache it takes like 10 seconds to load the site.

now i want to build an f… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1843509&goto=newpost

Has the Time Machine option to “”Delete all backups of” disappeared in Big Sur?

I have a folder that gets filled with large files that I want Time Machine to remember while retaining the option of regularly forgetting these large files. For this and up until Catalina I would regularly enter Time machine, go to this folder and use the command Delete all backups of... (see for instance the screen capture of @Inder ‘s answer in this thread). As of my recent upgrade to Big Sur I no longer see this contextual menu option.

Is it gone from Macos for good? Is there an alternative that does not involve under-the-hood sudo-type terminal surgery?

Thanks!

database design – How to break down MySQL big table into multiple to solve operational issue

This is my current table schema in MySQL
we are not facing any performance issue in our application but there are operational issue .
The size of this table is 7 TB (6TB data and 1 TB index ) and has 4 Billions rows .

Because of the this one table having this big size we are not able to do any alter table on this table .
We have to use percona which takes 1 week to complete .

so to handle this we have decided to break this table in to 3 .
There are two columns which stores xml file that we want to move to separate table and this two column alone takes 2.5 TB of storage .

DETAILS longtext, and SUMMARY varchar(4000) DEFAULT NULL,

Along with it we also want to move few more columns to another table so that all three tables will become lighter
like third table we want to move USES_TYPE varchar(255) NOT NULL, STEP_TYPE varchar(255) NOT NULL, NAME varchar(1500) DEFAULT NULL, and REMARKS varchar(1000) DEFAULT NULL,

CREATE TABLE `app_data` (
`ID` varchar(255) NOT NULL,
`USES_TYPE` varchar(255) NOT NULL,
`STEP_TYPE` varchar(255) NOT NULL,
`CUST_ID` varchar(255) DEFAULT NULL,
`DETAILS` longtext,
`DATE_TIME` datetime(6) DEFAULT NULL,
`GROUP_ID` varchar(255) DEFAULT NULL,
`SYSTEM_ID` varchar(255) DEFAULT NULL,
`NAME` varchar(1500) DEFAULT NULL,
`CUSTOMER_ID` varchar(255) DEFAULT NULL,
`REMARKS` varchar(1000) DEFAULT NULL,
`SUMMARY` varchar(4000) DEFAULT NULL,

PRIMARY KEY (`ID`),
KEY `IDX_APP_DATA_CID_OT` (`CUST_ID`,`USES_TYPE`) USING BTREE,
KEY `IDX_APP_DATA_SYSTEM_ID` (`SYSTEM_ID`) USING BTREE,
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

Now my final table will be comething like 

Table one 

CREATE TABLE `app_data_table1` (
`ID` varchar(255) NOT NULL,
`DETAILS` longtext,
`SUMMARY` varchar(4000) DEFAULT NULL;
)

Table Two would be like 

CREATE TABLE `app_data_table2` (
`ID` varchar(255) NOT NULL,
`USES_TYPE` varchar(255) NOT NULL,
`STEP_TYPE` varchar(255) NOT NULL,
`NAME` varchar(1500) DEFAULT NULL,
`REMARKS` varchar(1000) DEFAULT NULL;
)

and table three 

CREATE TABLE `app_data` (
`ID` varchar(255) NOT NULL,
`CUST_ID` varchar(255) DEFAULT NULL,
`DATE_TIME` datetime(6) DEFAULT NULL,
`GROUP_ID` varchar(255) DEFAULT NULL,
`SYSTEM_ID` varchar(255) DEFAULT NULL,
`CUSTOMER_ID` varchar(255) DEFAULT NULL,

PRIMARY KEY (`ID`),
KEY `IDX_APP_DATA_CID_OT` (`CUST_ID`) USING BTREE,
KEY `IDX_APP_DATA_SYSTEM_ID` (`SYSTEM_ID`) USING BTREE,
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

I am new to data base but this is what i am coming up i know this is not optmised so my humble request is to pleae guide me on this.

Once we do this we need to use join to dispaly on UI or where ever we fetch so will that be slower ?

macos – Macbook Pro 2016 – Big Sur Battery Issue after replacement

Background – i bought a 2016 Macbook Pro (A1708) a few weeks ago that was at 800+ cycles and the battery was listed as “service recommended”, would not charge past 1% and switch off if unplugged. So i bought a new battery and installed it. Little did i know that there was a replacement program for the 2016/2017 MAcbook Pro’s that had issues after Big Sur upgrade..doh! So now Apple wont touch me as i replaced the battery but the issue still persists even with a new battery. I have attempted an SMC reset and PRAM/NVRAM resets and it still doesn’t work. I have wiped SSD and gone back to Mojave (same issue) then upgraded back to the latest version of Big Sur.

Did this bug with Big Sur brick something on the logicboard/SMC? Has anyone else had this issue and worked out how to resolve?

display – Lag on external monitor using a Macbook Air 2017 with a Intel HD Graphics 6000 1536 MB and running macOs Big Sur 11.2.3: what could be the solution?

HOST MACHINE: Macbook Air 2017

GRAPHICS: Intel HD Graphics 6000 1536 MB

MACOS: Big Sur 11.2.3

Intel HD Graphics 6000:

Chipset Model: Intel HD Graphics 6000

Type: GPU

Bus: Built-In

VRAM (Dynamic, Max): 1536 MB

Vendor: Intel

Device ID: 0x1626

Revision ID: 0x0009

Metal Family: Supported, Metal GPUFamily macOS 1

Displays:
SyncMaster:

Resolution: 1920×1080 (1080p FHD – Full High Definition)

UI Looks like: 1920 x 1080 @ 60.00Hz

Framebuffer Depth: 30-Bit Colour (ARGB2101010)

Display Serial Number: H9XZ103518

Main Display: Yes

Mirror: Off

Online: Yes

Rotation: Supported

Automatically Adjust Brightness: Yes

Connection Type: Analog VGA or Analog Over DVI-I

Adapter Firmware Version: 0,00

1) At home I use my mac connected to a SAMSUNG 2494HS via VGA + CableDeccon video adapter.
The default resolution is 1920×1080 at ~60HZ.

Recently ( maybe correlated to the new macOs update) I noticed some lag in the external monitor. The events occured only when I run VirtualBox (v. 6.1) and I increase the resolution: above a certain threshold the VM starts to lag.

It is not correlated to any specific VM, but is the same with any.

2) If I use the HDMI cable (whatever type) or I set ad unscaled resolution with VGA, the display looks blurry.

3) Last but not least, if I close the mac and use only the external display with the setting as 1) the VM does not lag any more.

What could be the problem and possible solutions?

I tried to unscale the resolution, use differents setting for the VM (different video adapter, memory size, processors…) but with no success.

mac – Message is extreemly slow to open Big Sur

mac – Message is extreemly slow to open Big Sur – Ask Different

macos – Delete duplicate/older program versions from openwith – Mac Big Sur

macos – Delete duplicate/older program versions from openwith – Mac Big Sur – Ask Different

Big Trade Ltd – Bigtradeltd.com

I’m not admin.

IPB Image

Program started date: April 10, 2021

Description:

QUOTE

Big Trade Ltd | The Best Bitcoin Trading was founded in 2015 by a group professional foreign exchange market traders and analysts. After long consultations and analytical investigation of brokerage service market, it was decided to create a company, which could fill unsatisfied demand in the area of trust asset management services on the Forex market and crypto currencies.

Clients who have entrusted us their funds managing get an opportunity to minimize their risks (regardless of the chosen investment strategy), and this represents one of the primary targets when working on the lucrative but risky Forex and crypto currencies markets.

Plans:

QUOTE

Principal is included in profit

100.45% – 138% After 1 Day
Plan 1 $50.00 – $1000.00 100.45
Plan 2 $1001.00 – $5000.00 110.00
Plan 3 $5001.00 – $10000.00 122.00
Plan 4 $10001.00 – $1000000.00 138.00

0.3% – 35% Daily For 10 Years
Plan 1 $50.00 – $1000.00 0.30
Plan 2 $1001.00 – $5000.00 10.00
Plan 3 $5001.00 – $10000.00 22.00
Plan 4 $10001.00 – $1000000.00 35.00

122% – 130% After 12 Hours
Plan 1 $2001.00 – $5000.00 122.00
Plan 2 $5001.00 – $10000.00 125.00
Plan 3 $10001.00 – $50000.00 128.00
Plan 4 $50001.00 – $1000000.00 130.00

1000% – 1100% After 7 Days
Plan 1 $501.00 – $1000.00 1000.00
Plan 2 $1001.00 – $5000.00 1025.00
Plan 3 $5001.00 – $10000.00 1060.00
Plan 4 $10001.00 – $1000000.00 1100.00

2300% – 2400% After 15 Days
Plan 1 $501.00 – $1000.00 2300.00
Plan 2 $1001.00 – $5000.00 2325.00
Plan 3 $5001.00 – $10000.00 2360.00
Plan 4 $10001.00 – $1000000.00 2400.00

Language: English.

Money systems: PM, BTC, Ethereum, BTC Cash.

Minimum deposit: $50
Maximum deposit: $1000000
Withdrawals is instant.
Referral bonus: 3%

Script: Licensed GoldCoders:

QUOTE

Check GoldCoders’ HYIP Manager License
bigtradeltd.com – Licensed

DDoS Protection from: OVH SAS.
Dedicated IP: 66.70.220.97 is hosted on a dedicated server.

Initial value of PM account:
U28821850 (Big Trade Ltd)
Account type: Verified,
8.3 Trust Score point(s)

Information about SSL Certificate:
Issuer: Sectigo RSA Domain Validation Secure Server CA
Validity: 04/09/2021 – 04/10/2022
DNS resolves bigtradeltd.com to 66.70.220.97
Serial Number: 19D14123754362DCC2C6E78E338A3F5C

Whois:

QUOTE

Domain name: bigtradeltd.com
Registry Domain ID: 2593899356_DOMAIN_COM-VRSN

Updated Date: 2021-03-21T17:02:51Z
Creation Date: 2021-02-25T09:10:22Z
Registry Expiry Date: 2022-02-25T09:10:22Z

Registrar: NAMECHEAP INC
Registrar IANA ID: 1068

Reseller: NAMECHEAP INC

Name Server: ns1.bigtradeltd.com
Name Server: ns2.bigtradeltd.com

IP Address 66.70.220.97

IP Location Canada – Quebec – Montreal –
Ovh Hosting Inc.
ASN Canada AS16276 OVH, FR
(registered Feb 15, 2001)

My investment(listing):
Date : 04/10/2021 21:43
From/To Account : U1028268 -> U28821850
Amount : 100
Currency : USD
Batch : 384420144
Memo: Shopping Cart Payment. Deposit to Big Trade Ltd User analysis.

Big Trade Ltd

The first instant payment on “Perfect Money” is received:
04/11/2021 21:46 384654185
+ 0.45 U28821850->U1028268
Memo: Withdraw to analysis from Big Trade Ltd.

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive Proxies-free.com New Proxy Lists Every Day Proxies123