Changeset 2df08064 for server/databases
- Timestamp:
- 01/31/2016 06:49:17 AM (8 years ago)
- Branches:
- systemd-13485
- Children:
- d19fb65
- Parents:
- 957e8a3d
- Location:
- server/databases
- Files:
-
- 1 added
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
server/databases/databases.xml
r957e8a3d r2df08064 23 23 24 24 <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="db.xml"/> 25 <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="lmdb.xml"/> 25 26 <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="mariadb.xml"/> 26 27 <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="postgresql.xml"/> -
server/databases/db.xml
r957e8a3d r2df08064 36 36 </para> 37 37 38 &lfs7 7_checked;38 &lfs78_checked; 39 39 40 40 <bridgehead renderas="sect3">Package Information</bridgehead> … … 78 78 <xref linkend="tcl"/>, 79 79 <xref linkend="openjdk"/> or <xref linkend="java"/>, and 80 <xref linkend="sharutils"/> (for the <command>uudecode</command> command) 80 <xref linkend="sharutils"/> (for the <command>uudecode</command> command 81 - Java bindings are required) 81 82 </para> 82 83 … … 149 150 <title>Installation of Berkeley DB</title> 150 151 151 <!-- <note>152 <para>153 If you plan on installing <application>Berkeley DB</application> with154 Java support, you should check the system for certain versions of155 <xref linkend="jdk"/> and <xref linkend="gmime"/>. Specifically,156 if <application>JDK</application>-6 Update X and the157 <command>uudecode</command> program from the158 <application>GMime</application> program is on the system, the build159 will fail (unless you run the modified <command>./configure</command>160 command shown below). You can run two commands161 (<command>javac -version</command> and162 <command>uudecode --version</command>) to determine what versions are163 installed. You can also download and run a shell script from164 <ulink url="&files-anduin;/jdk-uudecode-check.sh"/> that will alert you165 to a non-working condition. If the identified programs exist on the166 system, you must modify the <command>./configure</command> command as167 shown below.168 </para>169 170 <screen><userinput>uudecode="no" ../dist/configure --(use the parameters shown below)</userinput></screen>171 </note> -->172 173 152 <para> 174 153 Install <application>Berkeley DB</application> by running the following … … 183 162 --enable-cxx && 184 163 make</userinput></screen> 185 186 <para>187 This package does not have a working testsuite.188 </para>189 164 190 165 <para> -
server/databases/mariadb.xml
r957e8a3d r2df08064 7 7 <!ENTITY mariadb-download-http "https://downloads.mariadb.org/interstitial/mariadb-&mariadb-version;/source/mariadb-&mariadb-version;.tar.gz"> 8 8 <!ENTITY mariadb-download-ftp "ftp://mirrors.fe.up.pt/pub/mariadb/mariadb-&mariadb-version;/source/mariadb-&mariadb-version;.tar.gz"> 9 <!ENTITY mariadb-md5sum "9 56561f3798d1fe8dfbe4b665287a87a">10 <!ENTITY mariadb-size "5 4MB">11 <!ENTITY mariadb-buildsize "1. 4 GB">12 <!ENTITY mariadb-time " 10 SBU (with tests)">9 <!ENTITY mariadb-md5sum "9aa4d68b24c1ddd8cb56923a920684b3"> 10 <!ENTITY mariadb-size "53 MB"> 11 <!ENTITY mariadb-buildsize "1.6 GB (with tests)"> 12 <!ENTITY mariadb-time "3.8 SBU, (with tests - all using parallelism=4)"> 13 13 ]> 14 14 … … 36 36 </para> 37 37 38 &lfs7 7_checked;38 &lfs78_checked; 39 39 40 40 <bridgehead renderas="sect3">Package Information</bridgehead> … … 122 122 <warning> 123 123 <para> 124 MariaDB and MySQL cannot be installed on the same system without 124 MariaDB and MySQL cannot be installed on the same system without 125 125 extensive changes to the build configuration of one of the two applications. 126 126 </para> … … 183 183 184 184 <para> 185 <command>sed -i ...</command>: This command setscorrect installation185 <command>sed -i ...</command>: Set correct installation 186 186 directory for some components. 187 187 </para> … … 282 282 #bdb_max_lock = 10000 283 283 284 # Uncomment the following if you are using InnoDB tables285 #innodb_data_home_dir = /srv/mysql286 #innodb_data_file_path = ibdata1:10M:autoextend287 #innodb_log_group_home_dir = /srv/mysql284 # InnoDB tables are now used by default 285 innodb_data_home_dir = /srv/mysql 286 innodb_data_file_path = ibdata1:10M:autoextend 287 innodb_log_group_home_dir = /srv/mysql 288 288 # You can set .._buffer_pool_size up to 50 - 80 % 289 289 # of RAM but beware of setting memory usage too high 290 #innodb_buffer_pool_size = 16M291 #innodb_additional_mem_pool_size = 2M290 innodb_buffer_pool_size = 16M 291 innodb_additional_mem_pool_size = 2M 292 292 # Set .._log_file_size to 25 % of buffer pool size 293 #innodb_log_file_size = 5M294 #innodb_log_buffer_size = 8M295 #innodb_flush_log_at_trx_commit = 1296 #innodb_lock_wait_timeout = 50293 innodb_log_file_size = 5M 294 innodb_log_buffer_size = 8M 295 innodb_flush_log_at_trx_commit = 1 296 innodb_lock_wait_timeout = 50 297 297 298 298 [mysqldump] … … 391 391 <seg> 392 392 aria_chk, aria_dump_log, aria_ftdump, aria_pack, aria_read_log, 393 innochecksum, msql2mysql, my_print_defaults, myisam_ftdump, 394 myisam chk, myisamlog, myisampack, mysql, mysql_client_test,393 innochecksum, msql2mysql, my_print_defaults, myisam_ftdump, myisamchk, 394 myisamlog, myisampack, mysql, mysql_client_test, 395 395 mysql_client_test_embedded, mysql_config, mysql_convert_table_format, 396 396 mysql_embedded, mysql_find_rows, mysql_fix_extensions, … … 401 401 mysqldumpslow, mysqlhotcopy, mysqlimport, mysqlshow, mysqlslap, 402 402 mysqltest, mysqltest_embedded, mytop, perror, replace, 403 resolve_stack_dump and resolveip 403 resolve_stack_dump, resolveip, wsrep_sst_common, wsrep_sst_mysqldump, 404 wsrep_sst_rsync, wsrep_sst_xtrabackup, and wsrep_sst_xtrabackup-v2 404 405 </seg> 405 406 <seg> 406 libmysqlclient.{so,a}, libmysqlclient_r.{so,a}, 407 libmysqld.{so,a} and libmysqlservices.a 407 libmysqlclient.{so,a}, 408 libmysqlclient_r.{so,a} (symbolic links to libmysqlclient.{so,a}), 409 libmysqld.{so,a}, libmysqlservices.a, 410 and several under /usr/lib/mysql/plugin/ 408 411 </seg> 409 412 <seg> 410 413 /etc/mysql, 411 /srv/mysql, 412 /usr/include/mysql, 413 /usr/lib/mysql, 414 /usr/share/doc/mariadb-&mariadb-version; and 415 /usr/share/mysql 414 /usr/{include,lib,share}/mysql, and 415 /usr/share/doc/mariadb-&mariadb-version; 416 416 </seg> 417 417 </seglistitem> … … 420 420 <bridgehead renderas="sect3">Short Descriptions</bridgehead> 421 421 422 <!-- 422 423 <para> 423 424 Descriptions of all the programs and libraries would be several … … 426 427 url="https://mariadb.com/kb/en/mariadb-documentation/"/>. 427 428 </para> 428 429 --> 429 430 <para> 430 431 The <application>Perl</application> DBI modules must be installed … … 433 434 </para> 434 435 436 <variablelist> 437 <bridgehead renderas="sect3">Short Descriptions</bridgehead> 438 <?dbfo list-presentation="list"?> 439 <?dbhtml list-presentation="table"?> 440 441 <varlistentry id="aria_chk-mariadb"> 442 <term><command>aria_chk</command></term> 443 <listitem> 444 <para> 445 is used to check, repair, optimize, sort and get information 446 about Aria tables. 447 </para> 448 <indexterm zone="mariadb aria_chk-mariadb"> 449 <primary sortas="b-aria_chk-mariadb">aria_chk</primary> 450 </indexterm> 451 </listitem> 452 </varlistentry> 453 454 <varlistentry id="aria_dump_log-mariadb"> 455 <term><command>aria_dump_log</command></term> 456 <listitem> 457 <para> 458 is a tool to dump content of Aria log pages. 459 </para> 460 <indexterm zone="mariadb aria_dump_log-mariadb"> 461 <primary sortas="b-aria_dump_log-mariadb">aria_dump_log</primary> 462 </indexterm> 463 </listitem> 464 </varlistentry> 465 466 <varlistentry id="aria_ftdump-mariadb"> 467 <term><command>aria_ftdump</command></term> 468 <listitem> 469 <para> 470 displays full-text index information. 471 </para> 472 <indexterm zone="mariadb aria_ftdump-mariadb"> 473 <primary sortas="b-aria_ftdump-mariadb">aria_ftdump</primary> 474 </indexterm> 475 </listitem> 476 </varlistentry> 477 478 <varlistentry id="aria_pack-mariadb"> 479 <term><command>aria_pack</command></term> 480 <listitem> 481 <para> 482 is a tool to generate compressed, read-only Aria tables. 483 </para> 484 <indexterm zone="mariadb aria_pack-mariadb"> 485 <primary sortas="b-aria_pack-mariadb">aria_pack</primary> 486 </indexterm> 487 </listitem> 488 </varlistentry> 489 490 <varlistentry id="aria_read_log-mariadb"> 491 <term><command>aria_read_log</command></term> 492 <listitem> 493 <para> 494 displays Aria log file contents. 495 </para> 496 <indexterm zone="mariadb aria_read_log-mariadb"> 497 <primary sortas="b-aria_read_log-mariadb">aria_read_log</primary> 498 </indexterm> 499 </listitem> 500 </varlistentry> 501 502 <varlistentry id="innochecksum-mariadb"> 503 <term><command>innochecksum</command></term> 504 <listitem> 505 <para> 506 prints checksums for InnoDB files. 507 </para> 508 <indexterm zone="mariadb innochecksum-mariadb"> 509 <primary sortas="b-innochecksum-mariadb">innochecksum</primary> 510 </indexterm> 511 </listitem> 512 </varlistentry> 513 514 <varlistentry id="msql2mysql-mariadb"> 515 <term><command>msql2mysql</command></term> 516 <listitem> 517 <para> 518 is a tool to convert mSQL programs for use with MySQL. 519 </para> 520 <indexterm zone="mariadb msql2mysql-mariadb"> 521 <primary sortas="b-msql2mysql-mariadb">msql2mysql</primary> 522 </indexterm> 523 </listitem> 524 </varlistentry> 525 526 <varlistentry id="my_print_defaults-mariadb"> 527 <term><command>my_print_defaults</command></term> 528 <listitem> 529 <para> 530 displays the options from option groups of option files. 531 </para> 532 <indexterm zone="mariadb my_print_defaults-mariadb"> 533 <primary sortas="b-my_print_defaults-mariadb">my_print_defaults</primary> 534 </indexterm> 535 </listitem> 536 </varlistentry> 537 538 <varlistentry id="myisam_ftdump-mariadb"> 539 <term><command>myisam_ftdump</command></term> 540 <listitem> 541 <para> 542 displays information about FULLTEXT indexes in MyISAM tables. 543 </para> 544 <indexterm zone="mariadb myisam_ftdump-mariadb"> 545 <primary sortas="b-myisam_ftdump-mariadb">myisam_ftdump</primary> 546 </indexterm> 547 </listitem> 548 </varlistentry> 549 550 <varlistentry id="myisamchk-mariadb"> 551 <term><command>myisamchk</command></term> 552 <listitem> 553 <para> 554 gets information about your database tables or checks, repairs, 555 or optimizes them. 556 </para> 557 <indexterm zone="mariadb myisamchk-mariadb"> 558 <primary sortas="b-myisamchk-mariadb">myisamchk</primary> 559 </indexterm> 560 </listitem> 561 </varlistentry> 562 563 <varlistentry id="myisamlog-mariadb"> 564 <term><command>myisamlog</command></term> 565 <listitem> 566 <para> 567 displays MyISAM log file contents. 568 </para> 569 <indexterm zone="mariadb myisamlog-mariadb"> 570 <primary sortas="b-myisamlog-mariadb">myisamlog</primary> 571 </indexterm> 572 </listitem> 573 </varlistentry> 574 575 <varlistentry id="myisampack-mariadb"> 576 <term><command>myisampack</command></term> 577 <listitem> 578 <para> 579 is a tool for compressing MyISAM tables. 580 </para> 581 <indexterm zone="mariadb myisampack-mariadb"> 582 <primary sortas="b-myisampack-mariadb">myisampack</primary> 583 </indexterm> 584 </listitem> 585 </varlistentry> 586 587 <varlistentry id="mysql-mariadb"> 588 <term><command>mysql</command></term> 589 <listitem> 590 <para> 591 is a simple SQL shell with input line editing capabilities. 592 </para> 593 <indexterm zone="mariadb mysql-mariadb"> 594 <primary sortas="b-mysql-mariadb">mysql</primary> 595 </indexterm> 596 </listitem> 597 </varlistentry> 598 599 <varlistentry id="mysql_client_test-mariadb"> 600 <term><command>mysql_client_test</command></term> 601 <listitem> 602 <para> 603 is used for testing aspects of the MySQL client API that cannot be 604 tested using mysqltest and its test language. 605 </para> 606 <indexterm zone="mariadb mysql_client_test-mariadb"> 607 <primary sortas="b-mysql_client_test-mariadb">mysql_client_test</primary> 608 </indexterm> 609 </listitem> 610 </varlistentry> 611 612 <varlistentry id="mysql_client_test_embedded-mariadb"> 613 <term><command>mysql_client_test_embedded</command></term> 614 <listitem> 615 <para> 616 is a tool to test client API for embedded server. 617 </para> 618 <indexterm zone="mariadb mysql_client_test_embedded-mariadb"> 619 <primary sortas="b-mysql_client_test_embedded-mariadb">mysql_client_test_embedded</primary> 620 </indexterm> 621 </listitem> 622 </varlistentry> 623 624 <varlistentry id="mysql_config-mariadb"> 625 <term><command>mysql_config</command></term> 626 <listitem> 627 <para> 628 provides you with useful information for compiling your MySQL 629 client and connecting it to MySQL. 630 </para> 631 <indexterm zone="mariadb mysql_config-mariadb"> 632 <primary sortas="b-mysql_config-mariadb">mysql_config</primary> 633 </indexterm> 634 </listitem> 635 </varlistentry> 636 637 <varlistentry id="mysql_convert_table_format-mariadb"> 638 <term><command>mysql_convert_table_format</command></term> 639 <listitem> 640 <para> 641 converts the tables in a database to use a particular storage 642 engine. 643 </para> 644 <indexterm zone="mariadb mysql_convert_table_format-mariadb"> 645 <primary sortas="b-mysql_convert_table_format-mariadb">mysql_convert_table_format</primary> 646 </indexterm> 647 </listitem> 648 </varlistentry> 649 650 <varlistentry id="mysql_embedded-mariadb"> 651 <term><command>mysql_embedded</command></term> 652 <listitem> 653 <para> 654 is a MySQL client statically linked to 655 libmysqld. 656 </para> 657 <indexterm zone="mariadb mysql_embedded-mariadb"> 658 <primary sortas="b-mysql_embedded-mariadb">mysql_embedded</primary> 659 </indexterm> 660 </listitem> 661 </varlistentry> 662 663 <varlistentry id="mysql_find_rows-mariadb"> 664 <term><command>mysql_find_rows</command></term> 665 <listitem> 666 <para> 667 reads files containing SQL statements and extracts statements that 668 match a given regular expression or that contain USE db_name or 669 SET statements. 670 </para> 671 <indexterm zone="mariadb mysql_find_rows-mariadb"> 672 <primary sortas="b-mysql_find_rows-mariadb">mysql_find_rows</primary> 673 </indexterm> 674 </listitem> 675 </varlistentry> 676 677 <varlistentry id="mysql_fix_extensions-mariadb"> 678 <term><command>mysql_fix_extensions</command></term> 679 <listitem> 680 <para> 681 converts the extensions for MyISAM (or ISAM ) table files to 682 their canonical forms. 683 </para> 684 <indexterm zone="mariadb mysql_fix_extensions-mariadb"> 685 <primary sortas="b-mysql_fix_extensions-mariadb">mysql_fix_extensions</primary> 686 </indexterm> 687 </listitem> 688 </varlistentry> 689 690 <varlistentry id="mysql_install_db-mariadb"> 691 <term><command>mysql_install_db</command></term> 692 <listitem> 693 <para> 694 initializes the MySQL data directory and creates the system 695 tables that it contains, if they do not exist. 696 </para> 697 <indexterm zone="mariadb mysql_install_db-mariadb"> 698 <primary sortas="b-mysql_install_db-mariadb">mysql_install_db</primary> 699 </indexterm> 700 </listitem> 701 </varlistentry> 702 703 <varlistentry id="mysql_plugin-mariadb"> 704 <term><command>mysql_plugin</command></term> 705 <listitem> 706 <para> 707 is a utility that enable MySQL administrators to manage which 708 plugins a MySQL server loads. 709 </para> 710 <indexterm zone="mariadb mysql_plugin-mariadb"> 711 <primary sortas="b-mysql_plugin-mariadb">mysql_plugin</primary> 712 </indexterm> 713 </listitem> 714 </varlistentry> 715 716 <varlistentry id="mysql_secure_installation-mariadb"> 717 <term><command>mysql_secure_installation</command></term> 718 <listitem> 719 <para> 720 is a tool to improve MySQL installation security. 721 </para> 722 <indexterm zone="mariadb mysql_secure_installation-mariadb"> 723 <primary sortas="b-mysql_secure_installation-mariadb">mysql_secure_installation</primary> 724 </indexterm> 725 </listitem> 726 </varlistentry> 727 728 <varlistentry id="mysql_setpermission-mariadb"> 729 <term><command>mysql_setpermission</command></term> 730 <listitem> 731 <para> 732 sets permissions in the MySQL grant tables. 733 </para> 734 <indexterm zone="mariadb mysql_setpermission-mariadb"> 735 <primary sortas="b-mysql_setpermission-mariadb">mysql_setpermission</primary> 736 </indexterm> 737 </listitem> 738 </varlistentry> 739 740 <varlistentry id="mysql_tzinfo_to_sql-mariadb"> 741 <term><command>mysql_tzinfo_to_sql</command></term> 742 <listitem> 743 <para> 744 loads the time zone tables in the mysql database. 745 </para> 746 <indexterm zone="mariadb mysql_tzinfo_to_sql-mariadb"> 747 <primary sortas="b-mysql_tzinfo_to_sql-mariadb">mysql_tzinfo_to_sql</primary> 748 </indexterm> 749 </listitem> 750 </varlistentry> 751 752 <varlistentry id="mysql_upgrade-mariadb"> 753 <term><command>mysql_upgrade</command></term> 754 <listitem> 755 <para> 756 examines all tables in all databases for incompatibilities with 757 the current version of MySQL Server. 758 </para> 759 <indexterm zone="mariadb mysql_upgrade-mariadb"> 760 <primary sortas="b-mysql_upgrade-mariadb">mysql_upgrade</primary> 761 </indexterm> 762 </listitem> 763 </varlistentry> 764 765 <varlistentry id="mysql_waitpid-mariadb"> 766 <term><command>mysql_waitpid</command></term> 767 <listitem> 768 <para> 769 signals a process to terminate and waits for the process to exit. 770 </para> 771 <indexterm zone="mariadb mysql_waitpid-mariadb"> 772 <primary sortas="b-mysql_waitpid-mariadb">mysql_waitpid</primary> 773 </indexterm> 774 </listitem> 775 </varlistentry> 776 777 <varlistentry id="mysql_zap-mariadb"> 778 <term><command>mysql_zap</command></term> 779 <listitem> 780 <para> 781 is a tool to kill processes that match a pattern. 782 </para> 783 <indexterm zone="mariadb mysql_zap-mariadb"> 784 <primary sortas="b-mysql_zap-mariadb">mysql_zap</primary> 785 </indexterm> 786 </listitem> 787 </varlistentry> 788 789 <varlistentry id="mysqlaccess-mariadb"> 790 <term><command>mysqlaccess</command></term> 791 <listitem> 792 <para> 793 checks the access privileges for a host name, user name, and 794 database combination. 795 </para> 796 <indexterm zone="mariadb mysqlaccess-mariadb"> 797 <primary sortas="b-mysqlaccess-mariadb">mysqlaccess</primary> 798 </indexterm> 799 </listitem> 800 </varlistentry> 801 802 <varlistentry id="mysqladmin-mariadb"> 803 <term><command>mysqladmin</command></term> 804 <listitem> 805 <para> 806 is a client for performing administrative operations. 807 </para> 808 <indexterm zone="mariadb mysqladmin-mariadb"> 809 <primary sortas="b-mysqladmin-mariadb">mysqladmin</primary> 810 </indexterm> 811 </listitem> 812 </varlistentry> 813 814 <varlistentry id="mysqlbinlog-mariadb"> 815 <term><command>mysqlbinlog</command></term> 816 <listitem> 817 <para> 818 read binary log files. 819 </para> 820 <indexterm zone="mariadb mysqlbinlog-mariadb"> 821 <primary sortas="b-mysqlbinlog-mariadb">mysqlbinlog</primary> 822 </indexterm> 823 </listitem> 824 </varlistentry> 825 826 <varlistentry id="mysqlbug-mariadb"> 827 <term><command>mysqlbug</command></term> 828 <listitem> 829 <para> 830 is a tool to generate bug report. 831 </para> 832 <indexterm zone="mariadb mysqlbug-mariadb"> 833 <primary sortas="b-mysqlbug-mariadb">mysqlbug</primary> 834 </indexterm> 835 </listitem> 836 </varlistentry> 837 838 <varlistentry id="mysqlcheck-mariadb"> 839 <term><command>mysqlcheck</command></term> 840 <listitem> 841 <para> 842 performs table maintenance: It checks, repairs, optimizes, 843 or analyzes tables. 844 </para> 845 <indexterm zone="mariadb mysqlcheck-mariadb"> 846 <primary sortas="b-mysqlcheck-mariadb">mysqlcheck</primary> 847 </indexterm> 848 </listitem> 849 </varlistentry> 850 851 <varlistentry id="mysqld-mariadb"> 852 <term><command>mysqld</command></term> 853 <listitem> 854 <para> 855 is the MySQL server daemon. 856 </para> 857 <indexterm zone="mariadb mysqld-mariadb"> 858 <primary sortas="b-mysqld-mariadb">mysqld</primary> 859 </indexterm> 860 </listitem> 861 </varlistentry> 862 863 <varlistentry id="mysqld_multi-mariadb"> 864 <term><command>mysqld_multi</command></term> 865 <listitem> 866 <para> 867 is designed to manage several mysqld processes that listen for 868 connections on different Unix socket files and TCP/IP ports. 869 </para> 870 <indexterm zone="mariadb mysqld_multi-mariadb"> 871 <primary sortas="b-mysqld_multi-mariadb">mysqld_multi</primary> 872 </indexterm> 873 </listitem> 874 </varlistentry> 875 876 <varlistentry id="mysqld_safe-mariadb"> 877 <term><command>mysqld_safe</command></term> 878 <listitem> 879 <para> 880 is the recommended way to start a mysqld server on Unix 881 and NetWare. 882 </para> 883 <indexterm zone="mariadb mysqld_safe-mariadb"> 884 <primary sortas="b-mysqld_safe-mariadb">mysqld_safe</primary> 885 </indexterm> 886 </listitem> 887 </varlistentry> 888 889 <varlistentry id="mysqldump-mariadb"> 890 <term><command>mysqldump</command></term> 891 <listitem> 892 <para> 893 is a backup program. 894 </para> 895 <indexterm zone="mariadb mysqldump-mariadb"> 896 <primary sortas="b-mysqldump-mariadb">mysqldump</primary> 897 </indexterm> 898 </listitem> 899 </varlistentry> 900 901 <varlistentry id="mysqldumpslow-mariadb"> 902 <term><command>mysqldumpslow</command></term> 903 <listitem> 904 <para> 905 parses MySQL slow query log files and prints a summary of their 906 contents. 907 </para> 908 <indexterm zone="mariadb mysqldumpslow-mariadb"> 909 <primary sortas="b-mysqldumpslow-mariadb">mysqldumpslow</primary> 910 </indexterm> 911 </listitem> 912 </varlistentry> 913 914 <varlistentry id="mysqlhotcopy-mariadb"> 915 <term><command>mysqlhotcopy</command></term> 916 <listitem> 917 <para> 918 locks the table, flush the table and then performs a copy of 919 the database. 920 </para> 921 <indexterm zone="mariadb mysqlhotcopy-mariadb"> 922 <primary sortas="b-mysqlhotcopy-mariadb">mysqlhotcopy</primary> 923 </indexterm> 924 </listitem> 925 </varlistentry> 926 927 <varlistentry id="mysqlimport-mariadb"> 928 <term><command>mysqlimport</command></term> 929 <listitem> 930 <para> 931 reads a range of data formats, and inserts the data into a 932 database. 933 </para> 934 <indexterm zone="mariadb mysqlimport-mariadb"> 935 <primary sortas="b-mysqlimport-mariadb">mysqlimport</primary> 936 </indexterm> 937 </listitem> 938 </varlistentry> 939 940 <varlistentry id="mysqlshow-mariadb"> 941 <term><command>mysqlshow</command></term> 942 <listitem> 943 <para> 944 shows the structure of a MariaDB database. 945 </para> 946 <indexterm zone="mariadb mysqlshow-mariadb"> 947 <primary sortas="b-mysqlshow-mariadb">mysqlshow</primary> 948 </indexterm> 949 </listitem> 950 </varlistentry> 951 952 <varlistentry id="mysqlslap-mariadb"> 953 <term><command>mysqlslap</command></term> 954 <listitem> 955 <para> 956 is a diagnostic program designed to emulate client load for a 957 MySQL server and to report the timing of each stage. 958 </para> 959 <indexterm zone="mariadb mysqlslap-mariadb"> 960 <primary sortas="b-mysqlslap-mariadb">mysqlslap</primary> 961 </indexterm> 962 </listitem> 963 </varlistentry> 964 965 <varlistentry id="mysqltest-mariadb"> 966 <term><command>mysqltest</command></term> 967 <listitem> 968 <para> 969 runs a test case against a MySQL server and optionally compares 970 the output with a result file. 971 </para> 972 <indexterm zone="mariadb mysqltest-mariadb"> 973 <primary sortas="b-mysqltest-mariadb">mysqltest</primary> 974 </indexterm> 975 </listitem> 976 </varlistentry> 977 978 <varlistentry id="mysqltest_embedded-mariadb"> 979 <term><command>mysqltest_embedded</command></term> 980 <listitem> 981 <para> 982 is similar to the <command>mysqltest</command> command but is built 983 with support for the libmysqld embedded server. 984 </para> 985 <indexterm zone="mariadb mysqltest_embedded-mariadb"> 986 <primary sortas="b-mysqltest_embedded-mariadb">mysqltest_embedded</primary> 987 </indexterm> 988 </listitem> 989 </varlistentry> 990 991 <varlistentry id="mytop-mariadb"> 992 <term><command>mytop</command></term> 993 <listitem> 994 <para> 995 is a console-based tool for monitoring the threads and overall 996 performance of a MySQL server. 997 </para> 998 <indexterm zone="mariadb mytop-mariadb"> 999 <primary sortas="b-mytop-mariadb">mytop</primary> 1000 </indexterm> 1001 </listitem> 1002 </varlistentry> 1003 1004 <varlistentry id="perror-mariadb"> 1005 <term><command>perror</command></term> 1006 <listitem> 1007 <para> 1008 is a utility that displays descriptions for system or storage 1009 engine error codes. 1010 </para> 1011 <indexterm zone="mariadb perror-mariadb"> 1012 <primary sortas="b-perror-mariadb">perror</primary> 1013 </indexterm> 1014 </listitem> 1015 </varlistentry> 1016 1017 <varlistentry id="replace-mariadb"> 1018 <term><command>replace</command></term> 1019 <listitem> 1020 <para> 1021 is a MariaDB/MySQL extension to the SQL standard. 1022 </para> 1023 <indexterm zone="mariadb replace-mariadb"> 1024 <primary sortas="b-replace-mariadb">replace</primary> 1025 </indexterm> 1026 </listitem> 1027 </varlistentry> 1028 1029 <varlistentry id="resolve_stack_dump-mariadb"> 1030 <term><command>resolve_stack_dump</command></term> 1031 <listitem> 1032 <para> 1033 resolves a numeric stack dump to symbols. 1034 </para> 1035 <indexterm zone="mariadb resolve_stack_dump-mariadb"> 1036 <primary sortas="b-resolve_stack_dump-mariadb">resolve_stack_dump</primary> 1037 </indexterm> 1038 </listitem> 1039 </varlistentry> 1040 1041 <varlistentry id="resolveip-mariadb"> 1042 <term><command>resolveip</command></term> 1043 <listitem> 1044 <para> 1045 is a utility for resolving IP addresses to host names and 1046 vice versa. 1047 </para> 1048 <indexterm zone="mariadb resolveip-mariadb"> 1049 <primary sortas="b-resolveip-mariadb">resolveip</primary> 1050 </indexterm> 1051 </listitem> 1052 </varlistentry> 1053 1054 </variablelist> 1055 435 1056 </sect2> 436 1057 -
server/databases/postgresql.xml
r957e8a3d r2df08064 7 7 <!ENTITY postgresql-download-http "http://ftp.postgresql.org/pub/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> 8 8 <!ENTITY postgresql-download-ftp "ftp://ftp.postgresql.org/pub/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> 9 <!ENTITY postgresql-md5sum " 1fe952c44ed26d7e6a335cf991a9c1c6">10 <!ENTITY postgresql-size "1 7MB">11 <!ENTITY postgresql-buildsize " 194 MB">12 <!ENTITY postgresql-time "1. 3 SBU">9 <!ENTITY postgresql-md5sum "e58fffe9359e311ead94490a06b7147c"> 10 <!ENTITY postgresql-size "18 MB"> 11 <!ENTITY postgresql-buildsize "233 MB (with tests)"> 12 <!ENTITY postgresql-time "1.6 SBU (with tests)"> 13 13 ]> 14 14 … … 34 34 from the Berkeley Postgres database management system.</para> 35 35 36 &lfs7 7_checked;36 &lfs78_checked; 37 37 38 38 <bridgehead renderas="sect3">Package Information</bridgehead> … … 107 107 </para> 108 108 109 <para>Tests must be run as unprivileged user, because they need to 110 start a temporary server, and this is prevented as root user. For 111 the same reason, you need to stop all PostgreSQL servers if any is 112 running. If a previous version of PostgreSQL is installed, it may be 113 necessary to use <emphasis>--disable-rpath</emphasis> with 114 <emphasis>configure</emphasis> to avoid failures, but <command>it is 115 not recommended</command> to install the binaries created using this 116 switch. To test the results, issue: <command>make 117 check</command>.</para> 118 109 119 <para>Now, as the <systemitem class="username">root</systemitem> user:</para> 110 120 … … 117 127 <screen role="nodump/"><userinput>make -C contrib/<replaceable><SUBDIR-NAME></replaceable> install</userinput></screen> 118 128 119 <warning> 120 <para>This package contains a known security hole that allows other 121 users on the same machine to gain access to an operating system account 122 while it is doing "make check": CVE-2014-0067. Tests must be run after 123 install, with postgresql server down, as unprivileged user.</para> 124 </warning> 125 126 <para>To test the results, issue: <command>make check</command>.</para> 127 128 <para><emphasis>If you only intend to use <application>PostgreSQL</application> 129 as a client to connect to a server on another machine, your installation is 130 complete and you should not run the remaining commands.</emphasis></para> 129 <para><emphasis>If you only intend to use 130 <application>PostgreSQL</application> as a client to connect to a server on 131 another machine, your installation is complete and you should not run the 132 remaining commands.</emphasis></para> 131 133 132 134 <!-- 'Upgrading' seems to only ever exist in the docs for *previous* version --> … … 277 279 <seg> 278 280 clusterdb, createdb, createlang, createuser, dropdb, droplang, 279 dropuser, ecpg, initdb, pg_ basebackup, pg_config, pg_controldata,280 pg_c tl, pg_dump, pg_dumpall, pg_isready, pg_receivexlog,281 pg_rec vlogical, pg_resetxlog, pg_restore, pltcl_delmod,282 p ltcl_listmod, pltcl_loadmod, postgres, postmaster (deprecated),283 p sql, reindexdb, vacuumdb, and optionally (in contrib/) oid2name,284 pg_archivecleanup, pgbench, pg_standby, pg_test_fsync,285 pg_test_timing, pg_upgrade, pg_xlogdump, vacuumlo, and many others281 dropuser, ecpg, initdb, pg_archivecleanup, pg_basebackup, pg_config, 282 pg_controldata, pg_ctl, pg_dump, pg_dumpall, pg_isready, 283 pg_receivexlog, pg_recvlogical, pg_resetxlog, pg_restore, pg_rewind, 284 pg_test_fsync, pg_test_timing, pg_upgrade, pg_xlogdump, pgbench, 285 pltcl_delmod, pltcl_listmod, pltcl_loadmod, postgres, postmaster 286 (deprecated), psql, reindexdb, vacuumdb, and optionally (in contrib/) 287 oid2name, pg_standby, vacuumlo, and many others 286 288 </seg> 287 289 <seg> 288 290 libecpg.{so,a}, libecpg_compat.{so,a}, libpgcommon.a, libpgport.a, 289 libpgtypes.{so,a}, and libpq.{so,a} 291 libpgtypes.{so,a}, libpq.{so,a}, various charset modules, and 292 optionally programming language modules under /usr/lib/postgresql 290 293 </seg> 291 294 <seg> 292 295 /usr/include/{libpq,postgresql}, 293 296 /usr/lib/postgresql, 294 /usr/share/doc/postgresql-&postgresql-version;, 295 /usr/share/postgresql, and 297 /usr/share/{doc/postgresql-&postgresql-version;,postgresql}, and 296 298 /srv/pgsql 297 299 </seg> … … 538 540 <indexterm zone="postgresql pg_restore"> 539 541 <primary sortas="b-pg_restore">pg_restore</primary> 542 </indexterm> 543 </listitem> 544 </varlistentry> 545 546 <varlistentry id="pg_rewind"> 547 <term><command>pg_rewind</command></term> 548 <listitem> 549 <para>synchronizes a PostgreSQL data directory with another data 550 directory that was forked from the first one.</para> 551 <indexterm zone="postgresql pg_rewind"> 552 <primary sortas="b-pg_rewind">pg_rewind</primary> 540 553 </indexterm> 541 554 </listitem> -
server/databases/sqlite.xml
r957e8a3d r2df08064 5 5 %general-entities; 6 6 7 <!ENTITY sqlite-dl-version "3 090200">8 <!ENTITY sqlite-doc-version "3 090200">9 10 <!ENTITY sqlite-download-http "http s://www.sqlite.org/2015/sqlite-autoconf-&sqlite-dl-version;.tar.gz">7 <!ENTITY sqlite-dl-version "3100200"> 8 <!ENTITY sqlite-doc-version "3100200"> 9 10 <!ENTITY sqlite-download-http "http://sqlite.org/2016/sqlite-autoconf-&sqlite-dl-version;.tar.gz"> 11 11 <!ENTITY sqlite-download-ftp " "> 12 <!ENTITY sqlite-md5sum " bc4eb5b3fc5efcb6e059794306cac1ca">13 <!ENTITY sqlite-size "2. 2MB">14 <!ENTITY sqlite-buildsize "73 MB (with Documentation)">15 <!ENTITY sqlite-time "0. 5SBU">16 17 <!ENTITY sqlite-docs-download "http s://www.sqlite.org/2015/sqlite-doc-&sqlite-doc-version;.zip">18 <!ENTITY sqlite-docs-md5sum " edc091d50cb97880ebebd9d961e37c17">19 <!ENTITY sqlite-docs-size "5. 1MB">12 <!ENTITY sqlite-md5sum "adaa31593bb5605ec6d6f34f81b43008"> 13 <!ENTITY sqlite-size "2.3 MB"> 14 <!ENTITY sqlite-buildsize "73 MB (with Optional Documentation)"> 15 <!ENTITY sqlite-time "0.3 SBU"> 16 17 <!ENTITY sqlite-docs-download "http://sqlite.org/2016/sqlite-doc-&sqlite-doc-version;.zip"> 18 <!ENTITY sqlite-docs-md5sum "08f301085279c2e4451f7dd568342943"> 19 <!ENTITY sqlite-docs-size "5.2 MB"> 20 20 ]> 21 21 … … 103 103 <bridgehead renderas="sect4">Optional</bridgehead> 104 104 <para role="optional"> 105 <ulink url="http://www.thrysoee.dk/editline/">libedit</ulink> and 105 106 <xref linkend="unzip"/> (required to unzip the documentation) 106 107 </para> … … 136 137 -DSQLITE_ENABLE_COLUMN_METADATA=1 \ 137 138 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \ 138 -DSQLITE_SECURE_DELETE=1" && 139 make</userinput></screen> 139 -DSQLITE_SECURE_DELETE=1 \ 140 -DSQLITE_ENABLE_DBSTAT_VTAB=1" && 141 make -j1</userinput></screen> 140 142 141 143 <para> … … 168 170 <parameter>CFLAGS="-g -O2 -DSQLITE_ENABLE_FTS3=1 169 171 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_SECURE_DELETE 170 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1"</parameter>: Applications such as 171 <application>Firefox</application> require secure delete and enable unlock 172 notify to be turned on. The only way to do this is to include them in the 172 -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -DSQLITE_ENABLE_DBSTAT_VTAB=1"</parameter>: 173 Applications such as <application>Firefox</application> require secure 174 delete and enable unlock notify to be turned on. Since 175 <application>firefox-41</application> the dbstat virtual table is also 176 required. The only way to do this is to include them in the 173 177 CFLAGS. By default, these are set to <literal>"-g -O2"</literal> so we 174 178 specify that to preserve those settings. You may, of course, wish to omit
Note:
See TracChangeset
for help on using the changeset viewer.