manual/chapters/en installation.xml,1.21,1.22 tuning.xml,1.11,1.12
Sebastian Bergmann <[email protected]> Mon, 08 Mar 2004 07:26:50 +0000
| Newsgroups | gmane.comp.web.phpopentracker.cvs |
|---|---|
| Message-ID | <[email protected]> |
Update of /cvsroot/phpopencounter/manual/chapters/en
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12435/chapters/en
Modified Files:
installation.xml tuning.xml
Log Message:
Flush.
Index: tuning.xml
===================================================================
RCS file: /cvsroot/phpopencounter/manual/chapters/en/tuning.xml,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** tuning.xml 25 Jan 2004 06:38:55 -0000 1.11
--- tuning.xml 8 Mar 2004 07:26:48 -0000 1.12
***************
*** 105,110 ****
<para>
! With MySQL you can use the so called &MYSQL_MERGE_TABLES; and
! let phpOpenTracker manage a set of log tables, one for each
month. This can increase the performance of &POT_API; queries
because database queries are now only executed on the relevant
--- 105,110 ----
<para>
! With MySQL you can use the so called &MYSQL_MYISAM_MERGE; backend
! and let phpOpenTracker manage a set of log tables, one for each
month. This can increase the performance of &POT_API; queries
because database queries are now only executed on the relevant
***************
*** 137,141 ****
use this together with the <xref linkend="tuning.mysql-merge-tables"/>
you will have to set the configuration directive
! <varname>delay_key_write</varname> to <varname>On</varname>.
</para>
</section>
--- 137,154 ----
use this together with the <xref linkend="tuning.mysql-merge-tables"/>
you will have to set the configuration directive
! <varname>delay_key_write</varname> to &true;.
! </para>
!
! <para>
! Creating a table with
! <varname>DELAY_KEY_WRITE=1</varname> will make the
! updating of indexes faster, as these are not logged to disk
! until the file is closed. The downside is that you should
! run <filename>myisamchk</filename> on these tables before
! you start <filename>mysqld</filename> to ensure that they
! are okay if something killed <filename>mysqld</filename> in
! the middle. As the key information can always be generated
! from the data, you should not lose anything by using
! <varname>DELAY_KEY_WRITE=1</varname>.
</para>
</section>
Index: installation.xml
===================================================================
RCS file: /cvsroot/phpopencounter/manual/chapters/en/installation.xml,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -d -r1.21 -r1.22
*** installation.xml 18 Jan 2004 16:22:44 -0000 1.21
--- installation.xml 8 Mar 2004 07:26:48 -0000 1.22
***************
*** 71,76 ****
<listitem>
<para>
! Configure your RDBMS connection by setting the correct values
! for the <varname>db_*</varname> directives.
</para>
</listitem>
--- 71,77 ----
<listitem>
<para>
! Configure your database connection by setting the
! correct values for the <varname>db_*</varname>
! directives.
</para>
</listitem>
***************
*** 110,140 ****
<para>
! Declaring a table with
! <varname>DELAY_KEY_WRITE=1</varname> will make the
! updating of indexes faster, as these are not logged to disk
! until the file is closed. The downside is that you should
! run <filename>myisamchk</filename> on these tables before
! you start <filename>mysqld</filename> to ensure that they
! are okay if something killed <filename>mysqld</filename> in
! the middle. As the key information can always be generated
! from the data, you should not lose anything by using
! <varname>DELAY_KEY_WRITE=1</varname>. If you do not want
! to use the <varname>DELAY_KEY_WRITE=1</varname> simply
! remove it from <filename>mysql.sql</filename> before
! executing that script to create the phpOpenTracker tables.
</para>
! <para>
! If you intend to use &MERGE_TABLES;, do not create the
! <filename>pot_accesslog</filename> and
! <filename>pot_visitors</filename> tables yourself and remove the
! corresponding SQL commands from <filename>mysql.sql</filename> before
! executing that script to create the phpOpenTracker tables. For more information
! see the section on &MERGE_TABLES;. If you removed
! the <varname>DELAY_KEY_WRITE=1</varname> option from
! <filename>mysql.sql</filename> make sure to set
! <varname>delay_key_write = Off</varname> in your
! <filename>conf/phpOpenTracker.php</filename> configuration file.
! </para>
<para>
--- 111,154 ----
<para>
! phpOpenTracker ships with several database table creation
! scripts for MySQL:
</para>
! <itemizedlist>
! <listitem>
! <para>
! <filename>innodb.sql</filename>
! </para>
!
! <para>
! Use the <filename>innodb.sql</filename> table creation
! script to create the tables using the &MYSQL_INNODB; storage
! backend.
! </para>
! </listitem>
!
! <listitem>
! <para>
! <filename>myisam.sql</filename>
! </para>
!
! <para>
! Use the <filename>myisam_merge.sql</filename> table creation
! script to create the tables using the &MYSQL_MYISAM; storage
! backend.
! </para>
! </listitem>
!
! <listitem>
! <para>
! <filename>myisam_merge.sql</filename>
! </para>
!
! <para>
! Use the <filename>myisam_merge.sql</filename> table creation
! script if you plan on using &MERGE_TABLES;.
! </para>
! </listitem>
! </itemizedlist>
<para>
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click