MySQL taille des bases

Bases

SELECT table_schema AS "MaBase",
 ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Taille en (MB)"
 FROM information_schema.TABLES
 GROUP BY table_schema;

Tables

SELECT table_name AS  "MaBase",
 ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Taille en (MB)"
 FROM information_schema.TABLES
 WHERE table_schema = "NOMDEBASE"
 ORDER BY (data_length + index_length) DESC;

MariaDB connect engine DBF Windows

Télécharger la version .msi adaptée 32/64 bits  https://downloads.mariadb.org/

SHOW ENGINES; /*voir si engine CONNECT est installé*/
INSTALL SONAME 'ha_connect';
SHOW ENGINES; /*vérifier s'il est maintenant bien installé*/


Les noms de tables sont passés en minuscules pour Windows contrairement à Linux

USE MABASE;
DROP TABLE IF EXISTS CAISSE;
CREATE TABLE CAISSE engine=CONNECT table_type=DBF file_name='C:\\FICHIERS\\CAISSE.DBF'; /* création MABASE.caisse*/
CREATE TABLE CAISSE engine=CONNECT table_type=DBF file_name='/home/FICHIERS/CAISSE.DBF'; /* Linux MABASE.CAISSE*/


Des choses qui fonctionnent sur les DBF connectés

ALTER TABLE CAISSE ADD COLUMN IF NOT EXISTS QREST_ENT int NULL AFTER CDE_NUM;
ALTER TABLE CAISSE ADD PRIMARY KEY (ID);
ALTER TABLE CAISSE MODIFY COLUMN FACTURE_ID bigint(10) ;
ALTER TABLE CAISSE ADD INDEX (REF) ;

Pour Windows 2003 server la dernière version supportée : ICI

// Vieux DBF xbase Foxpro

CREATE DATABASE IF NOT EXISTS DBF_SOM CHARACTER SET CP850;;
USE DBF_SOM;

DROP TABLE  IF EXISTS AGENT;
CREATE TABLE AGENT 		engine=CONNECT table_type=DBF READONLY=0 option_list='Accept=1' file_name='h:\\DBF\\FICHIERS\\AGENT.DBF';
ALTER TABLE `AGENT` ADD PRIMARY KEY (`CODEAGENT`);

HTTP2 activation apache2

apache2ctl -version  si < 2.4.17 il faut bricoler -> sinon on passe à la fin

****Bricolage ****

ajouter « deb http://http.debian.net/debian testing main »  dans /etc/apt/sources.list.d/testing.list

ajouter dans /etc/apt/preferences.d/testing

Package: *
Pin: release a=testing
Pin-Priority : 300

–> apt-cache policy apache2  ->  testing doit aparaitre en haut

apt-get install -y -t testing apache2

***********

a2enmod http2

apachectl -t

Dans /etc/apache2/conf-available/http2.conf

Protocols h2 h2c http/1.1
H2Direct on
H2StreamMaxMemSize 5120000000

H2Push on
H2PushPriority * after
H2PushPriority text/css before
H2PushPriority image/jpeg after 32
H2PushPriority image/png after 32
H2PushPriority application/javascript interleaved

SSLProtocol all -SSLv2 -SSLv3
SSLHonorCipherOrder on
SSLCipherSuite ‘EECDH+ECDSA+AESGCM EECDH+aRSA+AESGCM EECDH+ECDSA+SHA384 EECDH+ECDSA+SHA256 EECDH+aRSA+SHA384 EECDH+aRSA+SHA256 EECDH+aRSA+RC4 EECDH EDH+aRSA !RC4 !aNULL !eNULL !LOW !3DES !MD5 !EXP !PSK !SRP !DSS’

a2enconf http2

dans le .conf du vhost : Protocols h2 http/1.1

a2dismod mpm_itk

a2dismod mpm_prefork

a2enmod mpm_worker

apachectl -t

/etc/init.d/apache2 stop

/etc/init.d/apache2 start

test en ligne ex :ICI