Choosing http or https during manual installation of WordPress and database

When you manually install WordPress, somewhere during the process it asks you to select weather your site uses http or https. Why is this? What does it matter? How will your choice translate to changes/a different use of eg your database?
Bc when I installed WP I chose http bc at that time I didn't had an SSL yet. Then I created a few pages, posts and categories. The URLs of these started w/ http.
Then a while later I installed SSL certificate on that domain name and since then pages, posts…

Choosing http or https during manual installation of WordPress and database

Optimization paramters read-only mysql 5.7 database?

down vote favorite What’s the best way to MySQL database that is only read-only, and will never have any modifications made to it.

1) I have increased my innodb_buffer_pool_size to 70% of available RAM

2) Increase query cache size to 40mb

Running against a load generator, after some time the database starts bottlenecking to only 1000 statements per second.

The configuration is 2-cores, 8GB ram 50GB SSD. The database contains a single InnoDB 13 GB table with the same exact query running on two indexed columns.

We are using a vertx server to hit the database. The symptom we see is that the web service performance degrades after 15-20 minutes of heavy load.

Where can the bottleneck be? What parameters should we optimize?

Oracle XML Database database invalid, how to validate/recompile … can i drop and recreate it. Please suggest

The installed components and their status,

Oracle Database Catalog Views 12.1.0.2.0 Valid Oracle Database Packages and Types 12.1.0.2.0 Valid Oracle XML Database 12.1.0.2.0 Loaded

The XML Database component states as loaded, as there are invalid objects.

–> Tried to recompile invalid objects by running utlrp.sql but no use, still the invalid objects exist.

–> Unable to expdp/impdp due to sys objs being invalid with the below error,

ORA-04063: package body “SYS.DBMS_METADATA” has errors 04063. 00000 – “%s has errors” *Cause: Attempt to execute a stored procedure or use a view that has errors. For stored procedures, the problem could be syntax errors or references to other, non-existent procedures. For views, the problem could be a reference in the view’s defining query to a non-existent table. Can also be a table which has references to non-existent or inaccessible types. *Action: Fix the errors and/or create referenced objects as necessary

old well established, with huge database

Why are you selling this site? i can't maintain any more due to poor eyesight

How is it monetized? people pay for premium memership

Does this site come with any social media accounts? yes, but that is a minor part… the huge database is the most valuable thing

How much time does this site take to run? as much as you wish, it can surely be a full time job if you want to…

we can meet in person and settle the payment in cash as well

What challenges are…

old well established, with huge database

MYSQL get the turnover , income, total expenses from my database and group them by year-month

I have 4 tables :

Products - to record products spending - to record expenses directv  - to record subscription payments to TV channels sales    - to record sales 

Products has 4 columns : idProd is the primary key

+--------+-----------+--------------+-------------+ | idProd | nameProd  | sellingPrice | buyingPrice | +--------+-----------+--------------+-------------+ |      1 | Iphone 8  |          500 |         400 | |      2 | Samsung 2 |          600 |         400 | +--------+-----------+--------------+-------------+ 

Spending – 3 columns and idSpd is the primary key

+-------+--------+------------+ | idSpd | amount | dateSpd    | +-------+--------+------------+ |     1 |   1000 | 2018-11-01 | |     2 |   1000 | 2018-11-01 | |     3 |   1000 | 2018-10-01 | |     4 |   4000 | 2018-10-01 | +-------+--------+------------+ 

Sales – 5 columns with idSale as primary key and idProd to link it to the product’s table

+--------+--------+--------------+----------+------------+ | idSale | idProd | sellingPrice | quantity | dateSale   | +--------+--------+--------------+----------+------------+ |      1 |      1 |          700 |        2 | 2018-11-01 | |      2 |      1 |          700 |        5 | 2018-11-15 | |      3 |      2 |          800 |        2 | 2018-11-16 | +--------+--------+--------------+----------+------------+ 

and directv :

+-------+-----------------+-------+------------+ | idDtv | brand           | price | dateDtv    | +-------+-----------------+-------+------------+ |     1 | channel decoder |   150 | 2018-11-09 | +-------+-----------------+-------+------------+ 

and I wish to get for example :

income|gain of product  |  turnover | Spending | DirecTv | month | year 1000  |     400         | 5500      | 3000     | 50      | 10     |2018 500   |     200         |  1000     | 2000     | 0       | 11     |2018 

my queries :

--for directv select sum(dv.price) , month(dv.dateDtv), year(dv.dateDtv) from directv dv GROUP by year(dv.dateDtv) , month(dv.dateDtv)   --for turnover select sum(sl.quantity*sl.sellingPrice) , month(sl.dateSale) , year(sl.dateSale) from sales sl GROUP by year(sl.dateSale) , month(sl.dateSale)  --for spending select sum(spd.amount) , month(spd.dateSpd) , year(spd.dateSpd) from spending spd GROUP by year(spd.dateSpd) , month(spd.dateSpd)   --for gain of product SELECT sum(s.quantity*(s.sellingPrice-p.buyingPrice)) from sales s JOIN products p on s.idProd = p.idProd GROUP by year(s.dateSale) , month(s.dateSale)  

and income = gain of product + directv – spending

but i want joins all these queries and calculate the income , someone could help me ? it was okay but i was unable to combine with my new table product today