구차니의 잡동사니 모음

  Update Mozilla certificate authority bundle to version 2.9.

    The following certificate authorities were added (+):

    + "Certplus Root CA G1"

    + "Certplus Root CA G2"

    + "Certum Trusted Network CA 2"

    + "Hellenic Academic and Research Institutions ECC RootCA 2015"

    + "Hellenic Academic and Research Institutions RootCA 2015"

    + "ISRG Root X1"

    + "OpenTrust Root CA G1"

    + "OpenTrust Root CA G2"

    + "OpenTrust Root CA G3"

    + "SZAFIR ROOT CA2"

    The following certificate authorities were removed (-):

    - "CA Disig"

    - "NetLock Business (Class B) Root"

    - "NetLock Express (Class C) Root"

    - "NetLock Notary (Class A) Root"

    - "NetLock Qualified (Class QA) Root"

    - "Sonera Class 1 Root CA"

    - "Staat der Nederlanden Root CA"

    - "Verisign Class 1 Public Primary Certification Authority - G2"

    - "Verisign Class 3 Public Primary Certification Authority"

    - "Verisign Class 3 Public Primary Certification Authority - G2"

 -- Michael Shuler <michael@pbandjelly.org>  Fri, 18 Nov 2016 09:09:47 -0600 

hdmi_group=2

hdmi_mode=87

hdmi_ignore_edid=0xa5000080

hdmi_cvt 3840 2160 15 

$ sudo apt-cache search xdebug

php5-xdebug - Xdebug Module for PHP 5 

xdebug.profiler_aggregate Off Off

xdebug.profiler_append Off Off

xdebug.profiler_enable Off Off

xdebug.profiler_enable_trigger Off Off

xdebug.profiler_output_dir /tmp /tmp

xdebug.profiler_output_name cachegrind.out.%p cachegrind.out.%p

$ apt-cache search KCachegrind

kcachegrind - visualisation tool for the Valgrind profiler

kcachegrind-converters - format converters for KCachegrind profiler visualisation tool 

$ sudo vi /etc/php5/apache2/php.ini

[xdebug]

xdebug.profiler_enable = 1

xdebug.profiler_output_name = xdebug.out.%t

xdebug.profiler_output_dir = /tmp

xdebug.profiler_enable_trigger = 1

page_id

Uniquely identifying primary key. This value is preserved across edits, renames, and, as of MediaWiki 1.27, deletions, via an analogous field in the archive table (introduced in MediaWiki 1.11). For example, for this page, page_id = 10501. [1][2] This field can be accessed by WikiPage::getId(), Title::getArticleID(), etc.

page_latest

This is a foreign key to rev_id for the current revision. It may be 0 during page creation. It needs to link to a revision with a valid revision.rev_page, or there will be the "The revision #0 of the page named 'Foo' does not exist" error when one tries to view the page. Can be obtained via WikiPage::getLatest(). 

rev_id

This field holds the primary key for each revision. page_latest is a foreign key to this field.

rev_page

This field holds a reference to the page to which this revision pertains. The number in this field is equal to the page_id field of said page. This should never be invalid; if it is, that revision won't show up in the page history. If page.page_latest links to a revision with an invalid rev_page, this will cause the "The revision #0 of the page named 'Foo' does not exist" error.

rev_text_id

This is a foreign key to old_id in the text table. (The text table is where the actual bulk text is stored.) It's possible for multiple revisions to use the same text—for instance, revisions where only metadata is altered, or where a rollback is done to a previous version. 

The text table holds the wikitext of individual page revisions. If using Postgres or Oracle, this table is named pagecontent. 

mysql> SET @s = 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse';

mysql> PREPARE stmt2 FROM @s;

mysql> SET @a = 6;

mysql> SET @b = 8;

mysql> EXECUTE stmt2 USING @a, @b;

+------------+

| hypotenuse |

+------------+

|         10 |

+------------+

mysql> DEALLOCATE PREPARE stmt2;