[ANN] QxOrm 1.4.3 and QxEntityEditor 1.2.1 released : the Qt ORM supports CMake and provides a new QxEntityEditor documentation

[QxOrm contact]

Hello,

QxOrm library 1.4.3 and QxEntityEditor application 1.2.1 just released :
http://www.qxorm.com/
The Qt ORM library now supports CMake and provides a new QxEntityEditor
documentation : http://www.qxorm.com/qxorm_en/manual_qxee.html

QxOrm library 1.4.3 changes log :

 - Support CMake : new CMakeLists.txt file added to build QxOrm library
with CMake
 - Improve SQL error messages when qx::dao functions return a database error
 - New parameter in singleton class qx::QxSqlDatabase to log SQL bound
values (setTraceSqlBoundValues) : by default, bound values are logged when
an error occurred
 - New syntax to select columns to not fetch : -{ col_1, col_2, etc... }
 - New function qx::dao::call_query_without_prepare() to execute specific
SQL queries without prepared statement
 - Improve QxModelView module : all QxOrm models (based on qx::IxModel
interface) can be serialized to JSON format (including all relationships
levels) : this is now another way to work with relationships and QML
(thanks to JSON.parse() and JSON.stringify() javascript functions) without
using nested models concept (so without using QxEntityEditor model/view
generated classes)
 - Improve qxBlogModelView sample project and QxOrm manual to show how to
access to relationships data in QML (nested models or JSON)
 - Fix a memory leak in qx::QxSqlRelation class
 - Reduce output binary size (~20%) and compilation times (~20%) to build
persistent classes based on QxOrm library
 - Support unity build concept to reduce compilation times to build QxOrm
library and C++ persistent classes generated by QxEntityEditor application
: for more details, see _QX_UNITY_BUILD compilation option in QxOrm.pri or
QxOrm.cmake configuration file
 - Improve QxConvert module : possibility to store in database complex
QVariant properties which contain QVariantMap, QVariantHash or QVariantList
types (JSON format)
 - Fix an issue with some databases when a foreign key is also a part of
the primary key
 - Fix an issue with QSharedPointer and boost::serialization when a same
raw pointer is shared by several QSharedPointer during deserialization
process

QxEntityEditor application 1.2.1 changes log :

 - Support CMake : each C++ project generated by QxEntityEditor (persistent
classes, services, model/view) provide a CMakeLists.txt file to build with
CMake
 - New online QxEntityEditor manual (user guide) available at :
http://www.qxorm.com/qxorm_en/manual_qxee.html
 - Improve Javascript engine to customize export generated files : add a
parameter named 'output_location' to know where generated files are located
+ add functions to get a list of all entities/enums of a project (see
./samples/custom_script.js file for more details)
 - Improve database import process (SQLite, MySQL/MariaDB, PostgreSQL,
Oracle and MSSQLServer) : fix an issue importing composite foreign keys +
foreign keys embedded in primary key ==> so it is now possible to import
more complex database schema
 - Improve DDL database schema export process : fix an issue with 1-1
relationship + manage composite keys
 - New menu "Naming convention" to provide a fast way to rename all
entities/properties/enums (without breaking mapping to database) : support
snake_case, camelCase and PascalCase (or upper camel case), this new menu
can be useful after an import from database process for example
 - Each screen of QxEntityEditor provides now a fast access to the online
manual (user guide) in its associated topic (new button "Documentation" +
shortcut pressing F1 key everywhere)
 - New buttons undo/redo in the main QxEntityEditor toolbar to undo or redo
actions done on entities, enumerations, comments, layout (undo/redo feature
can be disabled to improve performance on large projects)
 - Support _QX_UNITY_BUILD compilation option to reduce compilation times
of generated C++ projects (recommended with CMake which doesn't support
natively precompiled headers)
 - Fix an issue importing a relationship where target entity doesn't have a
primary key
 - Fix an issue with C++ services export plugin and JSON serialization :
"Unable to create nude pointer for input parameter"
 - Fix an issue with abstract entities and C++ model/view export plugin and
C++ services export plugin
 - Possibility to put hexadecimal values to define an enumeration
 - New Javascript sample file in directory ./samples/ named q_property.js
to show how to add automatically Q_PROPERTY definition for each property
generated by QxEntityEditor

You can download latest version of QxOrm library and QxEntityEditor
application on QxOrm website : http://www.qxorm.com/

Regards,


Lionel Marty - QxOrm library

QxOrm 1.4.1 released : new documentation (user guide), and boost::serialization becomes optional

[QxOrm contact]

Hello,

*QxOrm 1.4.1 just released !* 


Changes in version QxOrm 1.4.1 :
*!!! IMPORTANT NOTE ABOUT THIS VERSION !!!* : it is strongly recommended to
read the QxOrm.pri configuration file
 of this new version
(compilation options have changed compared to previous versions).
Now, by default, QxOrm library is a much lighter library : QxOrm depends
only on *QtCore* and *QtSql* (boost serialization is now optional and not
required by default).
By default, serialization engine is now based on Qt *QDataStream* class
(but you can still enable boost serialization defining *
_QX_ENABLE_BOOST_SERIALIZATION* compilation option in QxOrm.pri
configuration file).
So now, with default options :
 - QxOrm 1.4.1 is much easier to install because you don't have to deal
with boost serialization extra dependency ;
 - QxOrm 1.4.1 shared library is 3X smaller than 1.3.2 version ;
 - Generated binaries which depends on QxOrm library are 25% smaller ;
 - If you are not using serialization functions in current projects based
on QxOrm library, then you can define or not
*_QX_ENABLE_BOOST_SERIALIZATION* compilation option without changing any
line of your source code.


Here are all other changes of version QxOrm 1.4.1 :
 - Improve relationships engine : possibility to select columns to fetch
using syntax : my_relation { col_1, col_2, etc... }
 ;
 - Improve QxTraits module
 to reduce
compilation times and build smaller binaries ;
 - Improve QxOrm website adding possibility to search and replacing the old
FAQ  by a more organized manual
(user guide)  ;
 - New compilation option *_QX_ENABLE_BOOST_SERIALIZATION* to enable boost
serialization dependency (read QxOrm.pri configuration file for more
details) ;
 - New compilation option *_QX_ENABLE_QT_NETWORK* to enable QxService module
 (transfer persistent
layer over network) : read QxOrm.pri configuration file for more details ;
 - New compilation option *_QX_NO_RTTI* to build QxOrm library without C++
RTTI type information ;
 - Support QDataStream Qt serialization engine
 (used by default
when *_QX_ENABLE_BOOST_SERIALIZATION* compilation option is not defined) ;
 - Improve qx_query class
 (SQL queries) : new
method (named *customOperator()*) which gives the possibility to define a
custom operator (for example <@ for PostgreSQL ltree type) ;
 - Fix a program startup issue due to 'static initialization order fiasco'
creating singletons (it was an issue with some compilers during the shared
library link process) ;
 - New namespace qx::dao::throwable : same functions as qx::dao namespace
, but they throw
a *qx::dao::sql_error* exception when a SQL error occurred (instead of
returning a *QSqlError* instance) ;
 - Add a *qAssertMsg()* macro to put a more explicit error message when
throwing an assertion ;
 - Include all **.inl* files (template implementation) in QxOrm.pro project
file : QtCreator can now index these **.inl* files in its project treeview ;
 - Rename *QxStringCvt* to *QxConvert* : so if you persist custom types to
database, you have to rename from *QxStringCvt_FromVariant,
QxStringCvt_ToVariant* to *QxConvert_FromVariant, QxConvert_ToVariant*.


You can download latest version of *QxOrm library* and *QxEntityEditor
application* on QxOrm website. 


Regards,


Lionel Marty - QxOrm library

Browsing the MySQL Documentation by Topic

[Stefan Hinz]

Browsing the MySQL Documentation by Topic

The MySQL Reference Manual is huge – far more than 2000 pages. On the
MySQL documentation team, we've been discussing how to split it into
easier to digest portions. But a real split doesn't seem the best thing
to do, so we've decided to make use of our Arbitrary Docs System
(http://dev.mysql.com/doc/mysqldoc-guide/en/mysqldoc-guide-tools-arby.html)
that allows to create arbitrarily compiled documents from the MySQL
Manual. That system, called Arby for short, was written by MC Brown, and
creates dynamic excerpts from our documentation sources, rather than
static copies, thus those excerpts are always as up to date as the
complete Manual.

On the MySQL Documentation Library page (http://dev.mysql.com/doc) we've
added a table with documents that serve the information needs of
specific target groups, such as database administrators or developers.
Those documents are viewable online, and can also be downloaded in PDF
format. Some highlights:

* Security guide
* MySQL guides for Linux, Mac OS X, and Windows users
* Backup  recovery guide
* Partitioning guide
* HA/Scalability guide incorporating MySQL Proxy, memcached and DRBD

In addition, we've also added direct links into the existing online
manuals for key sections, such as the connectors, replication and SQL
Syntax sections so that no matter who you are, you should be able to
visit that page and instantly find what you want.

You can find all topics on this page:
http://dev.mysql.com/doc#topic-guides. We're open for suggestions to add
additional guides or topics to be added to that list – just send a mail
to [EMAIL PROTECTED]

Regards,

Stefan
-- 
***
Sun Microsystems GmbHStefan Hinz
Sonnenallee 1Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany  Fax:   +49-30-82702941
http://www.sun.de/mysql  mailto: [EMAIL PROTECTED]

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
***

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

PHP Documentation in the MySQL Manual

[Stefan Hinz]

PHP Documentation in the MySQL Manual
-
MySQL can be used with a multitude of programming languages, but PHP is
probably the most popular choice. For that reason, we always felt a bit
bad about our PHP-related documentation being somewhat sparse, mostly
consisting of links to the PHP manual.

Well, that situation has changed. MC Brown of the MySQL Docs team has
moved over the MySQL-related parts of the PHP documentation to the MySQL
Reference Manual now. You can find it here:

http://dev.mysql.com/doc/refman/5.1/en/php.html

No worries, we haven't actually *moved* the PHP docs. Rather than that,
they're being synced over from php.net to our mysqldoc repository on a
regular basis, where they get merged into the MySQL docs and built in
various format (HTML, PDF, CHM, etc.) just like the rest of the
documentation.

This means users who work with MySQL and PHP don't have to flip between
manuals any more, but can rather look up all information in one place.
We regard this as another sign that MySQL has a strong commitment
towards the PHP users in our community.

Currently, the PHP docs cover:

* ext/mysql (the original set of PHP functions for accessing MySQL)
* ext/mysqli (the improved and recommended set of functions)
* PDO_MYSQL (the MySQL PDO driver for PHP's PDO interface)

This will soon be amended by the newest set of functions:

* ext/mysqlnd

Tony Bedford of the MySQL Docs team will be in charge of writing the new
section on ext/mysqlnd. Currently, he's in the process of reworking the
ext/mysqli section which still lacks a lot of function descriptions.
When done with this, the MySQL-related parts of the PHP documentation
will be in much better shape, so that's a true win-win situation for PHP
and MySQL.

Needless to say, Tony will keep maintaining the PHP docs, so they'll
always be up to date, complete, and correct. Go MySQL! Go PHP! :-)

Regards,

Stefan
--
***
Sun Microsystems GmbHStefan Hinz
Sonnenallee 1Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany  Fax:   +49-30-82702941
http://www.sun.demailto: [EMAIL PROTECTED]

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
***


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP Documentation in the MySQL Manual

[Fish Kungfu]

HOORAY!!!  Thanks for all of yours and Tony's hard work!

CheersFish
-
~~Second Life addict~~


-Original Message-
From: Stefan Hinz [EMAIL PROTECTED]
Sent: Aug 15, 2008 11:09 AM
To: mysql@lists.mysql.com
Subject: PHP Documentation in the MySQL Manual

PHP Documentation in the MySQL Manual
-
MySQL can be used with a multitude of programming languages, but PHP is
probably the most popular choice. For that reason, we always felt a bit
bad about our PHP-related documentation being somewhat sparse, mostly
consisting of links to the PHP manual.

Well, that situation has changed. MC Brown of the MySQL Docs team has
moved over the MySQL-related parts of the PHP documentation to the MySQL
Reference Manual now. You can find it here:

http://dev.mysql.com/doc/refman/5.1/en/php.html

No worries, we haven't actually *moved* the PHP docs. Rather than that,
they're being synced over from php.net to our mysqldoc repository on a
regular basis, where they get merged into the MySQL docs and built in
various format (HTML, PDF, CHM, etc.) just like the rest of the
documentation.

This means users who work with MySQL and PHP don't have to flip between
manuals any more, but can rather look up all information in one place.
We regard this as another sign that MySQL has a strong commitment
towards the PHP users in our community.

Currently, the PHP docs cover:

 * ext/mysql (the original set of PHP functions for accessing MySQL)
 * ext/mysqli (the improved and recommended set of functions)
 * PDO_MYSQL (the MySQL PDO driver for PHP's PDO interface)

This will soon be amended by the newest set of functions:

 * ext/mysqlnd

Tony Bedford of the MySQL Docs team will be in charge of writing the new
section on ext/mysqlnd. Currently, he's in the process of reworking the
ext/mysqli section which still lacks a lot of function descriptions.
When done with this, the MySQL-related parts of the PHP documentation
will be in much better shape, so that's a true win-win situation for PHP
and MySQL.

Needless to say, Tony will keep maintaining the PHP docs, so they'll
always be up to date, complete, and correct. Go MySQL! Go PHP! :-)

Regards,

Stefan
-- 
***
Sun Microsystems GmbHStefan Hinz
Sonnenallee 1Manager Documentation, Database Group
85551 Kirchheim-Heimstetten  Phone: +49-30-82702940
Germany  Fax:   +49-30-82702941
http://www.sun.demailto: [EMAIL PROTECTED]

Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
***


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DOCUMENTATION ABOUT SHOW PROFILE

[Wagner Bianchi]

Hi friends,

Somebody here in this list have or knows where i get or read about the PROFILE 
of MySQL (SHOW PROFILE) ?
I see this article of Schummi, but is most superficial. 
(http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html)
Can u help me?
 
Thk's 4 all. 

Wagner Bianchi
Diretor de Tecnologia - INFODBA Technologies  Consulting
[EMAIL PROTECTED] - (31) 3272 - 0226 / 8427 - 8803


  Abra sua conta no Yahoo! Mail, o único sem limite de espaço para 
armazenamento!
http://br.mail.yahoo.com/

Re: DOCUMENTATION ABOUT SHOW PROFILE

[Peter Brawley]

Wagner,

SHOW PROFILE[S] is documented at 
http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html.


5.0 Community edition only. Perhaps it will appear in 5.1 Community? 
They do not say so.


PB

Wagner Bianchi wrote:

Hi friends,

Somebody here in this list have or knows where i get or read about the PROFILE 
of MySQL (SHOW PROFILE) ?
I see this article of Schummi, but is most superficial. 
(http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html)
Can u help me?
 
Thk's 4 all. 


Wagner Bianchi
Diretor de Tecnologia - INFODBA Technologies  Consulting
[EMAIL PROTECTED] - (31) 3272 - 0226 / 8427 - 8803


  Abra sua conta no Yahoo! Mail, o único sem limite de espaço para 
armazenamento!
http://br.mail.yahoo.com/
  



No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.9/1068 - Release Date: 10/13/2007 10:15 AM
  

MySQL Proxy documentation

[Stefan Hinz]

The MySQL Proxy documentation is in place!

The MySQL Proxy is an application that communicates over the network
using the MySQL Network Protocol and provides communication between
MySQL servers and MySQL clients. In the most basic configuration, MySQL
Proxy simply passes on queries from the client to the MySQL Server and
returns the responses from the MySQL Server to the client.

By intercepting queries from the client, the Proxy can insert additional
queries into the list of queries sent to the server, and remove the
additional results when they are returned by the server. Using this
functionality you can add informational statements to each query, for
example to monitor their execution time or progress, and separately log
the results, while still returning the results from the original query
to the client.

The proxy allows you to perform additional monitoring, filtering or
manipulation on queries without you having to make any modifications to
the client and without the client even being aware that it is
communicating with anything but a genuine MySQL server.

The MySQL Proxy is available for MySQL servers 4.1 or better and is
documented in these MySQL Reference Manuals:

* http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy.html
* http://dev.mysql.com/doc/refman/5.0/en/mysql-proxy.html
* http://dev.mysql.com/doc/refman/4.1/en/mysql-proxy.html

It's also available in various download formats from the MySQL
documentation overview page (http://dev.mysql.com/doc).

Regards,

Stefan
-- 
Stefan Hinz [EMAIL PROTECTED]
MySQL AB Documentation Manager. Berlin, Germany (UTC +2:00)
Skype:stefanhinz Cell:+491777841069 Desk:+493082702940 Fax:+493082702941

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Documentation

[andrewmchorney]

Hello

I am going to be going on vacation and will be bringing my laptop with mysql 
installed on it. Is there a source of good documentation that can be downloaded 
(.doc or .pdf) for mysql?

Andrew

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: Documentation

[J.R. Bullington]

You can download the MySQL manual from their website in PDF, ZIP, and HTML 
sources.

http://dev.mysql.com/doc/index.html


From: [EMAIL PROTECTED]
Sent: Monday, June 04, 2007 3:17 PM
To: mysql@lists.mysql.com
Subject: Documentation 

Hello

I am going to be going on vacation and will be bringing my laptop with mysql 
installed on it. Is there a source of good documentation that can be downloaded 
(.doc or .pdf) for mysql?

Andrew

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation

[Paul DuBois]

At 12:16 PM -0700 6/4/07, [EMAIL PROTECTED] wrote:

Hello

I am going to be going on vacation and will be bringing my laptop 
with mysql installed on it. Is there a source of good documentation 
that can be downloaded (.doc or .pdf) for mysql?


Downloadable document formats are available at the main documentation
page on our web site:

http://dev.mysql.com/doc/

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

slave status: vague documentation of Seconds_Behind_Master

[Ofer Inbar]

I'm confused by a bit of the documentation here:
  http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html

In the section on Seconds_Behind_Master, first it says:

  When the slave SQL thread is actively running (processing updates),
  this field is the number of seconds that have elapsed since the
  timestamp of the most recent event on the master executed by that thread.

... but later it says:

 If the network connection between master and slave is fast, the slave
 I/O thread is very close to the master, so this field is a good
 approximation of how late the slave SQL thread is compared to the
 master. If the network is slow, this is not a good approximation; the
 slave SQL thread may quite often be caught up with the slow-reading
 slave I/O thread, so Seconds_Behind_Master often shows a value of 0,
 even if the I/O thread is late compared to the master. In other
 words, this column is useful only for fast networks.

These two sections seem contradictory to me.  If Seconds_Behind_Master
actually works the way it is first defined, then it should reflect any
delays caused by the network as well as delays in the SQL thread.

Since each event in the binary log is timestamped by the master, we
know when the operation happened on the master.  If we compare that
timestamp to the current time, we know how long ago it happened - so
if we look at the timestamp of the most recent event executed by the
slave SQL thread we see when it happened on the master, and can tell
how much time has elapsed since then.

Two problems with this approach would be:

 1. If the local clocks on the master and slave aren't in sync,
the timestamp comparison to current time would be off.

 2. If no writes to the master database have happened in a while, this
would report the slave as behind because the most recent operation
on the master has a timestamp from some time ago.

Both of these lead me to suspect that Seconds_Behind_Master does *not*
actually work the way the first paragraph implies; if so, then the
second paragraph I quoted from the doc could very well be true.

But if so, what exactly does Seconds_Behind_Master show?
  -- Cos

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: slave status: vague documentation of Seconds_Behind_Master

[Mathieu Bruneau]

Ofer Inbar a écrit :
 I'm confused by a bit of the documentation here:
   http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
 
 In the section on Seconds_Behind_Master, first it says:
 
   When the slave SQL thread is actively running (processing updates),
   this field is the number of seconds that have elapsed since the
   timestamp of the most recent event on the master executed by that thread.
 

This is generally true and accepted, the important part to read here is
actively running. Which leads to the other paragraph:

 ... but later it says:
 
  If the network connection between master and slave is fast, the slave
  I/O thread is very close to the master, so this field is a good
  approximation of how late the slave SQL thread is compared to the
  master. If the network is slow, this is not a good approximation; the
  slave SQL thread may quite often be caught up with the slow-reading
  slave I/O thread, so Seconds_Behind_Master often shows a value of 0,
  even if the I/O thread is late compared to the master. In other
  words, this column is useful only for fast networks.
 

So if the SQL_THREAD isn't executing anything he will report 0 in
Seconds_behinds_master. If you think about it, it make sense because
he doesn't have any master timestamp to base his calculation on. So
the warning applies here, it's not because your SQL_THREAD report 0
seconds behind master, that means he's caught up with the master, it
simply means it's caught up with the IO_THREAD. If the io_thread is
lagging, there's no current way of knowing it


 These two sections seem contradictory to me.  If Seconds_Behind_Master
 actually works the way it is first defined, then it should reflect any
 delays caused by the network as well as delays in the SQL thread.
 
 Since each event in the binary log is timestamped by the master, we
 know when the operation happened on the master.  If we compare that
 timestamp to the current time, we know how long ago it happened - so
 if we look at the timestamp of the most recent event executed by the
 slave SQL thread we see when it happened on the master, and can tell
 how much time has elapsed since then.
 
 Two problems with this approach would be:
 
  1. If the local clocks on the master and slave aren't in sync,
 the timestamp comparison to current time would be off.
 
  2. If no writes to the master database have happened in a while, this
 would report the slave as behind because the most recent operation
 on the master has a timestamp from some time ago.
 
 Both of these lead me to suspect that Seconds_Behind_Master does *not*
 actually work the way the first paragraph implies; if so, then the
 second paragraph I quoted from the doc could very well be true.
 
 But if so, what exactly does Seconds_Behind_Master show?
   -- Cos
 

Problem 1 is true but ... you use ntp right? Seconds_Behinds_Master only
has second sensitivity anyway...

Problem 2 isn't true, because if the SQL_Thread don't have anything to
play in it's relay log it will show 0 so you won't think he is behind
the master but that leads to problem output in second paragraph that you
paste from the manual. WHere if the Network is making it lag, you may
think the slave is up-to-date but it's not really!

So basically if you want to know if your slave is really up-to-date. You
have to make sure, the IO_THREAD isn't constantly transferring and that
the SQL_THREAD has done playing everything in the relay log!

Maybe having a separate SQL_THREAD_LAG and IO_THREAD_LAG could be
something possible (Feature request?) But I don't know if the IO_THREAD
parse enough of the event to read timestamp in it.

Hope that helps!

-- 
Mathieu Bruneau
aka ROunofF

===
GPG keys available @ http://rounoff.darktech.org

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: slave status: vague documentation of Seconds_Behind_Master

[Ofer Inbar]

Mathieu Bruneau [EMAIL PROTECTED] wrote:
  In the section on Seconds_Behind_Master, first it says:
  
When the slave SQL thread is actively running (processing updates),
this field is the number of seconds that have elapsed since the
timestamp of the most recent event on the master executed by that thread.
 
 This is generally true and accepted, the important part to read here is
 actively running. Which leads to the other paragraph:
[...]
 So if the SQL_THREAD isn't executing anything he will report 0 in
 Seconds_behinds_master. If you think about it, it make sense because
 he doesn't have any master timestamp to base his calculation on. So
 the warning applies here, it's not because your SQL_THREAD report 0
 seconds behind master, that means he's caught up with the master, it
 simply means it's caught up with the IO_THREAD. If the io_thread is
 lagging, there's no current way of knowing it

Ahah.  So processing updates does *not* include monitoring the
relay log for new material, and if it sees nothing new in the relay
log it reports 0.  Thanks.
  -- Cos

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Documentation in RPM Format

[Stefan Hinz]

If you're using RPM files to install the MySQL server, clients, and
other components, we have good news for you: The MySQL Reference Manual
is available in RPM format now!

We've packaged HTML (one page per chapter) and PDF (US Letter and A4)
into separate RPM files. In other words, for each version of the
MySQL Manual (4.1, 5.0, and 5.1) there are two RPM files. For the 5.0
Manual, for example, there are:

http://downloads.mysql.com/docs/mysql-refman-5.0-en-html-chapter-1-20061109.noarch.rpm
http://downloads.mysql.com/docs/mysql-refman-5.0-en-pdf-1-20061109.noarch.rpm

You can find all available RPM files here:

http://dev.mysql.com/doc/#manual

Installation is as simple and straightforward as with any other RPM:

shell rpm -i mysql-refman-5.0-en-html-chapter-1-20061109.noarch.rpm

The MySQL Manual is frequently being updated, and once per day we create
new RPM files. Updating your MySQL documentation is as easy as this now:

shell rpm -U mysql-refman-5.0-en-html-chapter-1-20061110.noarch.rpm

We hope this will make life easier for many of our users!

Regards,

Stefan
-- 
Stefan Hinz [EMAIL PROTECTED]
MySQL AB Documentation Team Lead. Berlin, Germany (UTC +2:00)
Skype:stefanhinz Cell:+491777841069 Desk:+493082702940 Fax:+493082702941


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Suse Version 10 Documentation for MYSQL.

[Andrew Burrows]

Hi MYSQL users.

 

I have just install SuSE Version 10 and need to start working with MYSQL
could someone help me out regarding 

Documentation . Don't seem to be able to find any in the help files.

 

Andrew

Re: Suse Version 10 Documentation for MYSQL.

[George Law]

Andrew,

did you install mysql when you installed suse?

you might have to fire up YaST and install the rpms.

this is a little old... but shoudl help: 
http://www.novell.com/coolsolutions/feature/595.html
this is for 9.1, but the procedure should have remained pretty much the same 
with suse 10.



--
George

- Original Message - 
From: Andrew Burrows [EMAIL PROTECTED]

To: 'MYSQL General List' mysql@lists.mysql.com
Sent: Sunday, January 15, 2006 9:05 PM
Subject: Suse Version 10 Documentation for MYSQL.



Hi MYSQL users.



I have just install SuSE Version 10 and need to start working with MYSQL
could someone help me out regarding

Documentation . Don't seem to be able to find any in the help files.



Andrew






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL database design documentation

[Maurice van Peursem]

Hi,

I'm sure this is a stupid question, but I haven't been able to find 
it myself. Surely there must be a free PHP utility to 
web-administrate a MySQL database? I use CocoaMySQL 
(http://cocoamysql.sourceforge.net/) on my own Mac, but it isn't 
suitable for online databases. Can anyone lead me in the right 
direction?


Thanks,
Maurice van Peursem
The Netherlands

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL database design documentation

[Jimmy Guerrero]

Hello,

Two admin tools to check out if you haven't already...

PHP, you can try PHPMyAdmin - http://www.phpmyadmin.net/home_page/index.php

Non-PHP, try MySQL's GPL MySQL Administrator -
http://dev.mysql.com/downloads/administrator/index.html

However, they too may not be suitable for remote admin depending on your
setup and security needs.

Thanks,

Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com
Houston, TX USA
Phone: (713) 636-9239



-Original Message-
From: Maurice van Peursem [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 05, 2006 3:37 PM
To: mysql@lists.mysql.com
Subject: MySQL database design documentation


Hi,

I'm sure this is a stupid question, but I haven't been able to find 
it myself. Surely there must be a free PHP utility to 
web-administrate a MySQL database? I use CocoaMySQL 
(http://cocoamysql.sourceforge.net/) on my own Mac, but it isn't 
suitable for online databases. Can anyone lead me in the right 
direction?

Thanks,
Maurice van Peursem
The Netherlands

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL database design documentation

[Maurice van Peursem]

Hi,

I'm relatively new to the database-scene. I've installed MySQL on Mac 
OSX 10.3, which was easy. I've installed Perl support for MySQL, 
which was suprisingly difficult. I've installed CocoaMySQL 
(http://cocoamysql.sourceforge.net/) to create, inspect and backup 
databases. And now I'm building my first database, and that is not as 
easy as I had hoped. I know that use of the 'JOIN' keyword can save 
me pages of Perl code, but how it works exactly is not yet clear to 
me.


Therefore I'm looking for a book, or maybe other documentation (on 
the web?), that can point me in the right direction. More 
specifically, I'm looking for a book that explains how to design and 
build databases, with examples of the queries in MySQL. Most books 
describe how you install MySQL, and list the SQL commands, but this 
information I already have. Can any of you suggest to me some helpful 
learning material?


Thanks,
Maurice van Peursem
The Netherlands

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL database design documentation

[Rhino]

- Original Message - 
From: Maurice van Peursem [EMAIL PROTECTED]

To: mysql@lists.mysql.com
Sent: Sunday, November 27, 2005 6:33 PM
Subject: MySQL database design documentation



Hi,

I'm relatively new to the database-scene. I've installed MySQL on Mac OSX 
10.3, which was easy. I've installed Perl support for MySQL, which was 
suprisingly difficult. I've installed CocoaMySQL 
(http://cocoamysql.sourceforge.net/) to create, inspect and backup 
databases. And now I'm building my first database, and that is not as easy 
as I had hoped. I know that use of the 'JOIN' keyword can save me pages of 
Perl code, but how it works exactly is not yet clear to me.


Therefore I'm looking for a book, or maybe other documentation (on the 
web?), that can point me in the right direction. More specifically, I'm 
looking for a book that explains how to design and build databases, with 
examples of the queries in MySQL. Most books describe how you install 
MySQL, and list the SQL commands, but this information I already have. Can 
any of you suggest to me some helpful learning material?


For the most part, _any_ good database design book for _any_ decent 
relational database should do the job for you. That's because all (?) of the 
professional grade databases use the same SQL and the same normalization 
techniques to decide what columns belong in what tables and what primary and 
foreign keys should be used. Therefore, a good design book for DB2 or Oracle 
or Sybase would probably tell you almost exactly the same things as a good 
design book specifically intended for MySQL. You will still need to use the 
MySQL reference to help you with places where the MySQL syntax is slightly 
different than the syntax used by the other database but this really 
shouldn't happen too often.


However, if you want a design book specifically written for MySQL, you may 
want to look at http://www.informit.com/articles/article.asp?p=30885rl=1. I 
should stress that I don't have this book, nor have I read it cover to 
cover. But the sample chapter on database design is pretty good, so, if the 
rest of the book is as good, you should come out okay. In fact, you may find 
that the sample chapter alone, which you can read online for free, may tell 
you everything you really want to know and save you the cost of the book. No 
guarantees on that but it's a starting point anyway.


By the way, I have not seen any other MySQL Design books so there may be 
others that are better. The URL I've given you actually mentions some other 
books specifically for MySQL that may suit your personal learning style 
better.


Rhino




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 25/11/2005


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL database design documentation

[Ligaya Turmelle]

A couple of good links for databases.

Database Design (quick and dirty, but gets the points across):
http://www.geekgirls.com/menu_databases.htm - the from scratch side

SQL:
Basics: http://www.sqlcourse.com (you probably already know this stuff -
but just in case.
semi-Advanced: http://sqlcourse2.com (joins are specifically at
http://sqlcourse2.com/joins.html).

Maurice van Peursem wrote:

Hi,

I'm relatively new to the database-scene. I've installed MySQL on Mac 
OSX 10.3, which was easy. I've installed Perl support for MySQL, which 
was suprisingly difficult. I've installed CocoaMySQL 
(http://cocoamysql.sourceforge.net/) to create, inspect and backup 
databases. And now I'm building my first database, and that is not as 
easy as I had hoped. I know that use of the 'JOIN' keyword can save me 
pages of Perl code, but how it works exactly is not yet clear to me.


Therefore I'm looking for a book, or maybe other documentation (on the 
web?), that can point me in the right direction. More specifically, I'm 
looking for a book that explains how to design and build databases, with 
examples of the queries in MySQL. Most books describe how you install 
MySQL, and list the SQL commands, but this information I already have. 
Can any of you suggest to me some helpful learning material?


Thanks,
Maurice van Peursem
The Netherlands



--

life is a game... so have fun.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL database design documentation

[Ben Wilson]

Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206

The original edition was my first primer on relational databases. It was 
an excellent read.


Ben

Maurice van Peursem wrote:

Hi,

I'm relatively new to the database-scene. I've installed MySQL on Mac 
OSX 10.3, which was easy. I've installed Perl support for MySQL, which 
was suprisingly difficult. I've installed CocoaMySQL 
(http://cocoamysql.sourceforge.net/) to create, inspect and backup 
databases. And now I'm building my first database, and that is not as 
easy as I had hoped. I know that use of the 'JOIN' keyword can save me 
pages of Perl code, but how it works exactly is not yet clear to me.


Therefore I'm looking for a book, or maybe other documentation (on the 
web?), that can point me in the right direction. More specifically, I'm 
looking for a book that explains how to design and build databases, with 
examples of the queries in MySQL. Most books describe how you install 
MySQL, and list the SQL commands, but this information I already have. 
Can any of you suggest to me some helpful learning material?


Thanks,
Maurice van Peursem
The Netherlands




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Documentation on Like clause

[Siegfried Heintze]

Could someone kindly point me to the documentation on the like clause. I
found the documentation on the SELECT statement but could not find the
discussion on the like clause. I search too -- but there were too many
like's used outside of the SQL syntax.

Thanks,
Siegfried


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation on Like clause

[Paul DuBois]

At 15:56 -0600 7/22/05, Siegfried Heintze wrote:

Could someone kindly point me to the documentation on the like clause. I
found the documentation on the SELECT statement but could not find the
discussion on the like clause. I search too -- but there were too many
like's used outside of the SQL syntax.


http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

vcc options not in documentation?

[matt_lists]

Having trouble building 5.0.x, 4.1.12 builds fine

The very first program to link bombs, I'm thinking some dll is not 
registered, or a change in build directions between 4.1.x and 5.0.x the 
error is less than helpful, as I'm a dba not a programmer.


Any sugestions? I can build 5.0.3, but not 5.0.6 or 5.0.7, I'm hoping 
5.0.7 fixes more of the procedure bugs holding up our development 
switching from sql server to mysql


attempting to  build mysql-5.0.7-beta-nightly-20050521-win-src.zip


I'm not sure if this is the right forum, or if I should submit a bug on 
this compile error.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

vcc options not in documentation?

[matt_lists]

Ooops, it would help if I put in the error message


Configuration: mysql - Win32 Debug
Linking...
mysqlclient.lib(mf_pack.obj) : error LNK2001: unresolved external symbol 
_my_access

../client_debug/mysql.exe : fatal error LNK1120: 1 unresolved externals
Error executing link.exe.

mysqld-debug.exe - 2 error(s), 0 warning(s)



Having trouble building 5.0.x, 4.1.12 builds fine

The very first program to link bombs, I'm thinking some dll is not
registered, or a change in build directions between 4.1.x and 5.0.x the
error is less than helpful, as I'm a dba not a programmer.

Any sugestions? I can build 5.0.3, but not 5.0.6 or 5.0.7, I'm hoping
5.0.7 fixes more of the procedure bugs holding up our development
switching from sql server to mysql

attempting to  build mysql-5.0.7-beta-nightly-20050521-win-src.zip


I'm not sure if this is the right forum, or if I should submit a bug on
this compile error.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Online documentation

[Joerg Bruehe]

Hi Douglas, all!


Am Mi, den 20.04.2005 schrieb [EMAIL PROTECTED] um 17:33:
 Is the online documentation for 4.0.x available? I was working with
 dates a while back. As it happens 4.1 added the very function I wanted.
 But that was not marked as added in 4.1, nor should be be as that would
 be an unbelieable amount of cruft.

As you know, version 5.0 is the development version currently available,
but some changes are still made on the production version 4.1, and
important fixes also go into 4.0.

There is only one MySQL manual, and it covers all versions. Changes are
(or at least: should be) labeled with the version(s) from which they
become effective, and there are separate sections listing the changes by
version.

This single manual is the source for all formats and publishing forms,
with the released packages as well as online.
(Aside: I am quite happy there are not several manuals, being maintained
in parallel, as this would introduce the risk of divergence, missing
corrections etc.)


 I would be nice however if maybe one level back was available if even if
 that was as a compressed file.

If by level you mean release families like 4.0, 4.1, and 5.0, this is
not possible with the approach of one manual for all.
I understand your situation, that as a 4.0 user / admin you have to skip
over all items that refer to newer versions only, but I cannot offer an
easy solution.

All I can propose is to take the manual that came with the version you
downloaded and installed. It will at least not contain changes that were
introduced later.


The documentation team currently is changing the way the manual is
maintained, but I do not know whether this will introduce features (like
selective extraction) which would help you with your desires.


Regards,
Joerg

-- 
Joerg Bruehe, Senior Production Engineer
MySQL AB, www.mysql.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Online documentation

[Gleb Paharenko]

Hello.



I'm not sure if it is possible to find on-line documentation for 4.0.x

version, but you can download the old release, documentation is shipped

with it. Archives are at:



  http://downloads.mysql.com/archives.php







[EMAIL PROTECTED] wrote:

 Is the online documentation for 4.0.x available? I was working with

 dates a while back. As it happens 4.1 added the very function I wanted.

 But that was not marked as added in 4.1, nor should be be as that would

 be an unbelieable amount of cruft.

 

 I would be nice however if maybe one level back was available if even if

 that was as a compressed file.

 

 _

 Douglas Denault

 http://www.safeport.com

 [EMAIL PROTECTED]

 Voice: 301-469-8766

  Fax: 301-469-0601

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Online documentation

[doug]

Thank you for the clear statement of policy. I had in fact forgotten
about the manual that comes with the installation. It however is
packaged as one rather large html or text file (my system is FreeBSD).
The web site is a far superior reference because of the file format.

Doug

On Thu, 21 Apr 2005, Joerg Bruehe wrote:

 Hi Douglas, all!


 Am Mi, den 20.04.2005 schrieb [EMAIL PROTECTED] um 17:33:
  Is the online documentation for 4.0.x available? I was working with
  dates a while back. As it happens 4.1 added the very function I wanted.
  But that was not marked as added in 4.1, nor should be be as that would
  be an unbelieable amount of cruft.

[cut]

 All I can propose is to take the manual that came with the version you
 downloaded and installed. It will at least not contain changes that were
 introduced later.


 The documentation team currently is changing the way the manual is
 maintained, but I do not know whether this will introduce features (like
 selective extraction) which would help you with your desires.


 Regards,
 Joerg

 --
 Joerg Bruehe, Senior Production Engineer
 MySQL AB, www.mysql.com


_
Douglas Denault
http://www.safeport.com
[EMAIL PROTECTED]
Voice: 301-469-8766
  Fax: 301-469-0601

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Online documentation

[doug]

Is the online documentation for 4.0.x available? I was working with
dates a while back. As it happens 4.1 added the very function I wanted.
But that was not marked as added in 4.1, nor should be be as that would
be an unbelieable amount of cruft.

I would be nice however if maybe one level back was available if even if
that was as a compressed file.

_
Douglas Denault
http://www.safeport.com
[EMAIL PROTECTED]
Voice: 301-469-8766
  Fax: 301-469-0601

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: clerification of documentation on InnoDB locking.

[Jigal van Hemert]

From: Sean
 on the page http://dev.mysql.com/doc/mysql/en/InnoDB_Locks_set.html

 This statement is confusing.

  If you do not have indexes suitable for your query and MySQL has to scan
the whole table to process the query, every row of the table will become
locked

   Is it saying that all at once at the beginning of the table scan a lock
is places on the entire table or is this saying that a lock for each record
that the query is on as it scans the table will be moved through the entire
table as it scans.

If you read further it says: which in turn blocks all inserts by other
users to the table. So, after scanning the whole table all records will be
locked for inserts by other users.

  If it is a rolling lock then no big deal other clients can access pages
of the table that are not currently being scanned. If it is a table lock
then no one gets any records till the scan is done much the same as MyIsam

Not entirely so. MyISAM tables can be locked by SELECTs that take a long
time to execute. As far as I know, InnoDB takes a snapshot of the database
for a SELECT...FROM (when the transaction level is not set tot SERIALIZABLE)
and inserts can take place while the SELECT is executed.

Also, the locks are based on the ranges of the index which are scanned;
creating suitable indexes and building queries that make optimal use of
these indexes will minimize the number of records that are locked.

Regards, Jigal.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

clerification of documentation on InnoDB locking.

[Sean]

on the page http://dev.mysql.com/doc/mysql/en/InnoDB_Locks_set.html

This statement is confusing.

 If you do not have indexes suitable for your query and MySQL has to scan the 
whole table to process the query, every row of the table will become locked

  Is it saying that all at once at the beginning of the table scan a lock is 
places on the entire table or is this saying that a lock for each record that 
the query is on as it scans the table will be moved through the entire table as 
it scans.
 If it is a rolling lock then no big deal other clients can access pages of the 
table that are not currently being scanned. If it is a table lock then no one 
gets any records till the scan is done much the same as MyIsam


 Regards
  Sean Mathews Nu Tech CTO

struct SoftwareProfessional {
   double salary;
   long   lunches;
   float  jobs;
   char   unstable;
   void   work;
   short  tempers;
}; 





Sent via the WebMail system at mail.nutech.com


 
   

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Error documentation

[Titus]

Probably a real old question, but where
can I go to look up a numbered error,
as in
ERROR 1005 at line 333502: Can't create table 
'./warehouse/tblGTprojConfigs.frm' (errno: 150)

thanks
titus sends
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error documentation

[Rhino]

- Original Message - 
From: Titus [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 06, 2004 4:53 PM
Subject: Error documentation




 Probably a real old question, but where
 can I go to look up a numbered error,
 as in

 ERROR 1005 at line 333502: Can't create table
 './warehouse/tblGTprojConfigs.frm' (errno: 150)

If you go to http://dev.mysql.com/doc/ and click on the second link under
MySQL Reference Manual - Searchable, with user comments - then enter a
search term in the search box on the resulting screen, you should find what
you want.

If you search on '1005', the first hit takes you to a page
http://dev.mysql.com/doc/mysql/en/Error-handling.html which won't tell you
much that you don't already know.

However, if you look at some of the subsequent hits, or if you search on
'150', you'll get one hit that takes you to this page:
http://dev.mysql.com/doc/mysql/en/InnoDB_error_codes.html. There, you will
find an explanation of error 1005, errno 150.

Of course, that is only relevant if your table is using the InnoDB engine.
If you *aren't* using InnoDB, one of the other hits may answer your
question.

Rhino


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error documentation

[Dave Juntgen]

If you are running Linux, try.

]$ perror errno

errno being the number of the error.

David W. Juntgen
Medical Informatics Engineering Inc.
Phone: 260.459.6270
Fax  : 260.459.6271

 -Original Message-
 From: Rhino [mailto:[EMAIL PROTECTED]
 Sent: Monday, December 06, 2004 5:17 PM
 To: Titus; [EMAIL PROTECTED]
 Subject: Re: Error documentation
 
 
 - Original Message -
 From: Titus [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, December 06, 2004 4:53 PM
 Subject: Error documentation
 
 
 
 
  Probably a real old question, but where
  can I go to look up a numbered error,
  as in
 
  ERROR 1005 at line 333502: Can't create table
  './warehouse/tblGTprojConfigs.frm' (errno: 150)
 
 If you go to http://dev.mysql.com/doc/ and click on the second link
under
 MySQL Reference Manual - Searchable, with user comments - then
enter a
 search term in the search box on the resulting screen, you should find
what
 you want.
 
 If you search on '1005', the first hit takes you to a page
 http://dev.mysql.com/doc/mysql/en/Error-handling.html which won't
tell you
 much that you don't already know.
 
 However, if you look at some of the subsequent hits, or if you search
on
 '150', you'll get one hit that takes you to this page:
 http://dev.mysql.com/doc/mysql/en/InnoDB_error_codes.html. There, you
will
 find an explanation of error 1005, errno 150.
 
 Of course, that is only relevant if your table is using the InnoDB
engine.
 If you *aren't* using InnoDB, one of the other hits may answer your
 question.
 
 Rhino
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

need documentation of MyISAM file structures

[Indra Polak]

Hi,
we are recovering from a drop database and we need a clear description
of the structures of all MyISAM data files (especially the dynamic table 
structure)
in order to speed up our present reverse-engineering activities.

We are trying to recognize unallocated (disk) blocks to determine 
whether they
belong to a  MyISAM data file to put together in this way all deleted 
tables.

If anyone knows of such a description or can provide us  with pointers 
how to
obtain it, we would be very grateful.

We looked at the documentation and the source code ofcourse but that was 
not clear enough.

If anyone has a better idea how to recover from a drop database command 
(apart from using a backup)
we would be interested as well.

Have a nice day,
Indra Polak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Documentation problem?

[sean c peters]

hi all. In my struggles to buildl MySQL 4.1.3deta, i read a lot of online 
documentation, and in the process i found a lot of info about various 
configure flags in writeups all over the web. One problem i encountered, that 
i finally figured out was that some documentation names the flag 
--with-extra-charsets as --with-extra-charset
I finally got it right, but most of what i read omitted the (s). The configure 
script (quietly) allows the incorrect flag.

I dont know what can be done, with so many contributors to the documentation, 
reviewing everything in that much detail doesnt seem wholly reasonable. I'd 
guess there are a myriad of similar little issues. Any thoughts on how to 
minimize this problem.

Just wanted to bring this out.
thanks
sean peters
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql control center documentation

[Chris Stevenson]

Is there a user guide available anywhere?  I can't seem to find anything
on mysql.com

 

Re: mysql control center documentation

[Michael Stassen]

The MySQL web site was recently reorganized.  For some reason, when they did 
so, the buried the manual 4 clicks away in the Developer Zone.  It's not 
clear to me how anyone new is supposed to find it there.  In any case, the 
URL is http://dev.mysql.com/doc/mysql/en/index.html.

Michael
Chris Stevenson wrote:
Is there a user guide available anywhere?  I can't seem to find anything
on mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql control center documentation

[Michael Stassen]

Somehow I didn't notice mysql control center in the Subject until the 
exact moment I hit Send.  Sorry about that.  Please ignore my unhelpful reply.

I seem to remember that your question has been asked before, and that the 
answer was that it's pretty self-explanatory.  You might check the list 
archives http://lists.mysql.com/mysql.

Michael
Michael Stassen wrote:
The MySQL web site was recently reorganized.  For some reason, when they 
did so, the buried the manual 4 clicks away in the Developer Zone.  
It's not clear to me how anyone new is supposed to find it there.  In 
any case, the URL is http://dev.mysql.com/doc/mysql/en/index.html.

Michael
Chris Stevenson wrote:
Is there a user guide available anywhere?  I can't seem to find anything
on mysql.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysql control center documentation

[Bartis, Robert M (Bob)]

Had the same issue. I've bookmarked it, but its not clear why its so hard to find. Its 
good stuff man put it out front:-)

-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 12:13 PM
To: Chris Stevenson
Cc: [EMAIL PROTECTED]
Subject: Re: mysql control center documentation


The MySQL web site was recently reorganized.  For some reason, when they did 
so, the buried the manual 4 clicks away in the Developer Zone.  It's not 
clear to me how anyone new is supposed to find it there.  In any case, the 
URL is http://dev.mysql.com/doc/mysql/en/index.html.

Michael

Chris Stevenson wrote:
 Is there a user guide available anywhere?  I can't seem to find anything
 on mysql.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql control center documentation

[Eric Bergen]

mysql.com (php.net and freshmeat.net) sites all have a search features
where a if a requested file is not found it performs a search for it
as a key word.

Example finding the mysql control center manual is as easy as requesting
http://www.mysql.com/mysql control center 

or depending on your browser
http://www.mysql.com/mysql%20control%20center

will perform a search of mysql.com 'mysql control center'

-Eric

On Tue, 22 Jun 2004 12:26:39 -0400, Bartis, Robert M (Bob)
[EMAIL PROTECTED] wrote:
 
 Had the same issue. I've bookmarked it, but its not clear why its so hard to find. 
 Its good stuff man put it out front:-)
 
 -Original Message-
 From: Michael Stassen [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 22, 2004 12:13 PM
 To: Chris Stevenson
 Cc: [EMAIL PROTECTED]
 Subject: Re: mysql control center documentation
 
 The MySQL web site was recently reorganized.  For some reason, when they did
 so, the buried the manual 4 clicks away in the Developer Zone.  It's not
 clear to me how anyone new is supposed to find it there.  In any case, the
 URL is http://dev.mysql.com/doc/mysql/en/index.html.
 
 Michael
 
 Chris Stevenson wrote:
  Is there a user guide available anywhere?  I can't seem to find anything
  on mysql.com
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql control center documentation

[Michael Stassen]

Eric Bergen wrote:
mysql.com (php.net and freshmeat.net) sites all have a search features
where if a requested file is not found it performs a search for it
as a key word.
Interesting.  I didn't know that.  That's nice, but it's hardly intuitive. 
I expect that's designed to help with broken links, rather than to be the 
expected way to search.  After all, there is a search box at the top.  A 
good interface, however, would make it clear where to go, rather than 
requiring you to guess a URL or search for something as basic as product 
documentation.

Example finding the mysql control center manual is as easy as requesting
http://www.mysql.com/mysql control center 

or depending on your browser
http://www.mysql.com/mysql%20control%20center
will perform a search of mysql.com 'mysql control center'
The search reveals installation instructions 
http://www.mysql.com/products/mysqlcc/install.html and a section in the 
mysql manual http://dev.mysql.com/doc/mysql/en/mysqlcc.html (turns out my 
original suggestion wasn't useless, after all).  The latter is not linked 
anywhere on the mysqlcc page http://www.mysql.com/products/mysqlcc/!

-Eric
Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL documentation

[Mikhail Entaltsev]

Hi,

I have found that messages

a.. Non-standard behavior of UNION statements has changed to the standard
ones. So far, a table name in the ORDER BY clause was tolerated. From now on
a proper error message is issued (Bug #3064).
a.. Added max_insert_delayed_threads system variable as a synonym for
max_delayed_threads.
a.. Added query_cache_wlock_invalidate system variable. It allow emulation
of MyISAM table write-locking behavior, even for queries in the query cache.
(Bug #2693)


are doubled in the documentation
(http://dev.mysql.com/doc/mysql/en/News-4.0.19.html)

Best regards,
Mikhail.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation on character sets for version 4.0.17

[Nils Valentin]

Hi David,
(B
(BThank you for the detailed description. That certainly makes things easier to 
(Bargue now ;-).
(B
(BO.K Where to start ?
(B
(BFirst, as you know in version 4.0 you can basically set the character sets 
(Bonly for server and client side (not for DB, table, columns, connection and 
(Bresult sets).
(B
(BYou could set this from an application like Phpmyadmin I believe, BUT (note 
(Bits a big but) if you are on a rental server, than I doubt that this will 
(Bwork, as you will also change other users character set.
(B
(BSo I guess for now you will have to stay right were you are.
(B
(B
(B- Using MySQL 4.1
(B
(BNow lets assume 4.1 becomes stable today or tomorrow (just assuming, I have no 
(Binfo on this ;-)
(B
(BIn this case you would set the character set for the DB, table,columns etc. 
(Bf.e from Phpmyadmin. You would input the query into the editor and ask 
(BPhpmyadmin to execute it.
(B
(BI have not tried it, but that should work (if you have those privileges).
(B
(B- Separating the characters for several cgi scripts
(B
(BI am unable to help here really. I work mostly with a single cgi.
(BI can imagine that (assuming the cgi supports asian characters) it is just a 
(Bmatter of passing the right fields to the right cgi script.
(B
(BI would not suggest mixed fields in a table. Its probably wiser to separate 
(Bcolumns for asian texts and non-asian texts.
(B
(B
(B- About the search function with asian characters
(B
(BThis is a very hot issue. It wasnt discussed often yet here on the mailing 
(Blist. As described on page 21 in my presentation, Regexp() does NOT yet work 
(Bwith asian characters. Please use "LIKE" for the moment. I am not even sure 
(Bif "MATCH ... AGAINST" does work yet.
(B
(BI believe the manual mentioned somewhere which commands are supposed to work 
(Bwith asian characters.
(B
(B
(B- To sum it all up
(B
(BI hope that this answers the most important ones of your questions. With the 
(Bcgi I am a bit unable to help really. If the cgi is known to work with 
(BJapanese characters then it should really just be a matter of separating the 
(Bform fields for each cgi script.
(B
(BHowever using 4.0.xx your main issue will be that you need to change the 
(Bcharacter set on a rental server sharing the same MySQL server with different 
(Busers.
(B
(BBest regards
(B
(BNils Valentin
(BTokyo / Japan
(B
(B
(B
(B
(BOn Wednesday 05 May 2004 04:05, David Jourard wrote:
(B Nils,
(B
(B At 05:30 PM 5/4/04 +0100, you wrote:
(B Basically the best guess would be the documentation that comes with your
(B download. Note that online documents at www.mysql.com are always a mixture
(B  of several documentation versions really.
(B
(B Thats the problem.  Yesterday, I downloaded 4.0.1x yet the documentation
(B that comes with it in regards to asian character set etc. is 4.1
(B
(B But the application I'm working with is a perl/cgi/mysql thing on a virtual
(B hosted site and is using 4.0.15 (which means I can only set things from the
(B application level or via the connection string.)
(B
(B I need to know how to set this up for this version not 4.1
(B
(B  From your documentation I gather I need to tell the server what character
(B set to use and also about data coming from and going to the client.
(B
(B My problem is I'm not too sure how to start.
(B
(B Here is the data flow:
(B
(B Storing Data
(B 
(B
(B 1. web page (uses shift_sjis) --
(B 2. cgi app captures form data  with mixed fields eg. english and japanese
(B 3. cgi app --- saves data to mixed fields in a table.
(B
(B Is there something I do at the point data is being saved. Save one field in
(B one kind of encoding and the other in another kind of coding.
(B
(B OR is there something I indicate by a property of the field
(B
(B
(B Retrieving Data
(B ---
(B 1. cgi app searches on varchar fields both japanese and in english
(B 2. cgi app searchs on text fields using fulltext engine for keyword
(B searches.
(B
(B
(B Everything works fine for the english but the searches in japanese are not
(B working.
(B
(B I'm thinking maybe it has something to do with the encoding in the japanese
(B fields which I'm not sure how to do at the field level for version 4.0.15
(B
(B Thanks
(B
(B David J.
(B
(B-- 
(Bkind regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(Bhttp://www.be-known-online.com/mysql/
(B
(B-- 
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation on character sets for version 4.0.17

[Victoria Reznichenko]

David Jourard [EMAIL PROTECTED] wrote:
 
 I got the 4.0.17 documentation but when it discusses character sets it 
 discusses this topic wrt 4.1
 
 Where can I find documentation specifically in regards to the production 
 version on how to work with,  store, and search asian character sets 
 specifically Japanese.
 

In version 4.0.17 you should specify character set with --default-character-set 
option. For Japanese language take a look at sjis and ujis character sets:
http://dev.mysql.com/doc/mysql/en/Character_sets.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation on character sets for version 4.0.17

[David Jourard]

Victoria ,

Thank-you.

At 01:35 PM 5/4/04 +0300, Victoria Reznichenko wrote:

David Jourard [EMAIL PROTECTED] wrote:

 I got the 4.0.17 documentation but when it discusses character sets it
 discusses this topic wrt 4.1

 Where can I find documentation specifically in regards to the production
 version on how to work with,  store, and search asian character sets
 specifically Japanese.

In version 4.0.17 you should specify character set with 
--default-character-set option. For Japanese language take a look at sjis 
and ujis character sets:
http://dev.mysql.com/doc/mysql/en/Character_sets.html


a. I'm working with a table where some fields are using the Latin 1 ch. 
set. and other fields using Japanese.

Can I work with both character sets?

Can I run a query with both or do they have to be separate.

b. Also the application is on a hosted web site so they do not have control 
over the settings of the mysql server.  How does one set the character 
set?  Is this done from the connection string or via the select query?

Thank-you
David J.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.662 / Virus Database: 425 - Release Date: 4/20/04

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation on character sets for version 4.0.17

[Nils Valentin]

Hi David,
(B
(BYou may find my UC-2004 presentation useful as well as some UC-2003 
(Bpresentations from Mr. Gulutzan and Mr. Barkov:
(B
(Bwww.be-known-online.com/mysql
(Bmysql.planetmirror.com/Downloads/Presentations/MySQL-User-Conference-2003/National-Character-Sets-and-Unicode.pdf
(B
(BBasically the best guess would be the documentation that comes with your 
(Bdownload. Note that online documents at www.mysql.com are always a mixture of 
(Bseveral documentation versions really.
(B
(BI am not 100% if this answer all of your questions, but at least in my 
(Bpresentation you should find 90% of all the information you require.
(B
(BShould you have any other question, please do not hesitate to ask me.
(B
(BBest regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(BOn Wednesday 05 May 2004 01:16, David Jourard wrote:
(B Victoria ,
(B
(B Thank-you.
(B
(B At 01:35 PM 5/4/04 +0300, Victoria Reznichenko wrote:
(B David Jourard [EMAIL PROTECTED] wrote:
(B   I got the 4.0.17 documentation but when it discusses character sets it
(B   discusses this topic wrt 4.1
(B  
(B   Where can I find documentation specifically in regards to the
(B   production version on how to work with,  store, and search asian
(B   character sets specifically Japanese.
(B 
(B In version 4.0.17 you should specify character set with
(B --default-character-set option. For Japanese language take a look at sjis
(B and ujis character sets:
(B  http://dev.mysql.com/doc/mysql/en/Character_sets.html
(B
(B a. I'm working with a table where some fields are using the Latin 1 ch.
(B set. and other fields using Japanese.
(B
(B Can I work with both character sets?
(B
(B Can I run a query with both or do they have to be separate.
(B
(B b. Also the application is on a hosted web site so they do not have control
(B over the settings of the mysql server.  How does one set the character
(B set?  Is this done from the connection string or via the select query?
(B
(B Thank-you
(B David J.
(B
(B-- 
(Bkind regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(Bhttp://www.be-known-online.com/mysql/
(B
(B-- 
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation on character sets for version 4.0.17

[David Jourard]

Nils,

At 05:30 PM 5/4/04 +0100, you wrote:
Basically the best guess would be the documentation that comes with your
download. Note that online documents at www.mysql.com are always a mixture of
several documentation versions really.


Thats the problem.  Yesterday, I downloaded 4.0.1x yet the documentation 
that comes with it in regards to asian character set etc. is 4.1

But the application I'm working with is a perl/cgi/mysql thing on a virtual 
hosted site and is using 4.0.15 (which means I can only set things from the 
application level or via the connection string.)

I need to know how to set this up for this version not 4.1

From your documentation I gather I need to tell the server what character 
set to use and also about data coming from and going to the client.

My problem is I'm not too sure how to start.

Here is the data flow:

Storing Data

1. web page (uses shift_sjis) --
2. cgi app captures form data  with mixed fields eg. english and japanese
3. cgi app --- saves data to mixed fields in a table.
Is there something I do at the point data is being saved. Save one field in 
one kind of encoding and the other in another kind of coding.

OR is there something I indicate by a property of the field

Retrieving Data
---
1. cgi app searches on varchar fields both japanese and in english
2. cgi app searchs on text fields using fulltext engine for keyword searches.
Everything works fine for the english but the searches in japanese are not 
working.

I'm thinking maybe it has something to do with the encoding in the japanese 
fields which I'm not sure how to do at the field level for version 4.0.15

Thanks

David J.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.662 / Virus Database: 425 - Release Date: 4/20/04

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Documentation on character sets for version 4.0.17

[David Jourard]

Hi,

I got the 4.0.17 documentation but when it discusses character sets it 
discusses this topic wrt 4.1

Where can I find documentation specifically in regards to the production 
version on how to work with,  store, and search asian character sets 
specifically Japanese.

Thank-you
David Jrt; x-avg-checked=avg-ok-8ED7DEB
Content-Disposition: inline
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.662 / Virus Database: 425 - Release Date: 4/20/04
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is there any documentation of Best Practices/Troubleshooting Guides for Administering MySQL

[Schwartz, Evelyn]

We are implementing three or four MySql servers (as a start) and I'm
writing the Troubleshooting Guide for our operational staff.  None of
these folks have any MySQL experience (and I'm a newbie myself). I need
a pretty basic 'Cheat Sheet' for troubleshooting common production type
problems.

The staff is all very technical - Senior level Oracle DBAs - I'm going
to have to drag them kicking and screaming into the MySQL world :-)

Thanks in advance.  I'm having fun with this tool, I'm looking forward
to see how it does in production.

Evelyn

 

RE: Is there any documentation of Best Practices/Troubleshooting Guides for Administering MySQL

[Dan Muey]

 We are implementing three or four MySql servers (as a start) 
 and I'm writing the Troubleshooting Guide for our operational 
 staff.  None of these folks have any MySQL experience (and 
 I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for 
 troubleshooting common production type problems.
 
 The staff is all very technical - Senior level Oracle DBAs - 
 I'm going to have to drag them kicking and screaming into the 
 MySQL world :-)
 
 Thanks in advance.  I'm having fun with this tool, I'm 
 looking forward to see how it does in production.

It will do awesome, it always has for me anyway!
I'd say the best general guide is the mysql.com website, very 
informtive and intuitive.

HTH

DMuey 


 Evelyn
 
  
 
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Is there any documentation of Best Practices/Troubleshooting Guides for Administering MySQL

[Dan Muey]

 Thanks,

No problem, but please post to the list and not just 
me so we can all learn and share.
Also top posting is bad form, just FYI.

 
 I have been perusing the web site, but the manuals don't 
 always give reasons WHY you would run something.  For example 

http://www.mysql.com/doc/en/FLUSH.html the why/what/who:

You should use the FLUSH command if you want to clear some 
of the internal caches MySQL uses. To execute FLUSH, you 
must have the RELOAD privilege.

 the flush-tables command.  Why would you run it and what does 
 it do?  There are several references to this command but I 

man mysqladmin
 summed it up for me niceley

 can't seem to find exactly what it does.  Can I do it any 
 time, is it non-destructive etc.  

If the site and man don't give you the kind of answer you 
seek then post the specific question to this list.

HTH

DMuey

 
 
 -Original Message-
 From: Dan Muey [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, February 04, 2004 3:33 PM
 To: Schwartz, Evelyn; [EMAIL PROTECTED]
 Subject: RE: Is there any documentation of Best 
 Practices/Troubleshooting Guides for Administering MySQL
 
 
  We are implementing three or four MySql servers (as a 
 start) and I'm 
  writing the Troubleshooting Guide for our operational 
 staff.  None of 
  these folks have any MySQL experience (and I'm a newbie myself). I 
  need a pretty basic 'Cheat Sheet' for troubleshooting common 
  production type problems.
  
  The staff is all very technical - Senior level Oracle DBAs 
 - I'm going 
  to have to drag them kicking and screaming into the MySQL world :-)
  
  Thanks in advance.  I'm having fun with this tool, I'm 
 looking forward 
  to see how it does in production.
 
 It will do awesome, it always has for me anyway!
 I'd say the best general guide is the mysql.com website, very 
 informtive and intuitive.
 
 HTH
 
 DMuey 
 
 
  Evelyn

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is there any documentation of Best Practices/Troubleshooting Guides for Administering MySQL

[David Hodgkinson]

On 4 Feb 2004, at 20:32, Dan Muey wrote:

We are implementing three or four MySql servers (as a start)
and I'm writing the Troubleshooting Guide for our operational
staff.  None of these folks have any MySQL experience (and
I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for
troubleshooting common production type problems.
The staff is all very technical - Senior level Oracle DBAs -
I'm going to have to drag them kicking and screaming into the
MySQL world :-)
Thanks in advance.  I'm having fun with this tool, I'm
looking forward to see how it does in production.
It will do awesome, it always has for me anyway!
I'd say the best general guide is the mysql.com website, very
informtive and intuitive.


No, Evelyn's request is a good one. I use MySQL day to day
for some very different applications and have little trouble
with it. Others coming to it from so-called real database
backgrounds try to make it behave like Oracle and it rebels.
There are design and code considerations that just make life
easier for the programmer and the DBA. As with any database
(ask a Sybase DBA!)
The mod_perl support mailing list, led by Stas Bekman, produced
the mod_perl guide with community support that recently led to
an 800+ page O'Reilly book. I'd like to see something like this
for MySQL: for those beyond basic web applications and trying
to make their lives easier.
Um, does this make sense?

--
Dave Hodgkinson
CTO, Rockit Factory Ltd.
http://www.rockitfactory.com/
Web sites for rock bands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

New user B setup - documentation?

[lists . mysql]

Hallo,

I'm totally new to MySQL or any other data bases...
I installed MySQL 4.0.15a as supplied with the SlackWare 9.1 Linux 
distribution.  The only documentation supplied are the Reference Manual en 
the man pages.  But the Reference Manual is a little bit too touch for me.  I 
managed to get mysqld started, but now I'm stuck.
Is there any other documentation available somewhere that will lead me 
through the setup in a nice and gentle way?

Groetjes,

   Hans.

--- GoldED+/LNX 1.1.5cvs031202
 * Origin: The Wizard is using MBSE/Linux (2:280/1018)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation bug?

[Jeremy Zawodny]

On Mon, Dec 15, 2003 at 02:12:01PM +1100, Chris Nolan wrote:
 It seems slightly ambiguous - updates are redirected and stalled. The
 fact that the two statements are in different sentences threw me off
 slightly.

Oh, okay.  If you can suggest a more clear version, perhaps Paul will
update the manual with it?

Jeremy

 On Mon, 2003-12-15 at 03:55, Jeremy Zawodny wrote:
  On Mon, Dec 15, 2003 at 02:58:53AM +1100, Chris Nolan wrote:
   Hi all, while reading through some of the MySQL docs, I noticed the 
   following paragraph:
   
   |ALTER TABLE| works by making a temporary copy of the original table. 
   The alteration is performed on the copy, then the original table is 
   deleted and the new one is renamed. This is done in such a way that all 
   updates are automatically redirected to the new table without any failed 
   updates. While |ALTER TABLE| is executing, the original table is 
   readable by other clients. Updates and writes to the table are stalled 
   until the new table is ready.
   
   This seems a bit confusing. On one hand, it says that updates don't 
   fail, but on the other hand it says they are stalled until ALTER TABLE 
   is done executing. Am I going blind/loosing my mind (a possibility I am 
   open to) or do others agree with me?
  
  What exactly is the discrepancy you see?  Can you be explicit?
  
  The manual describes the way ALTER TABLE works accurately.
  
  Jeremy
  -- 
  Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
  [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/
 
 

-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation bug?

[Chris Nolan]

Jeremy Zawodny wrote:

On Mon, Dec 15, 2003 at 02:12:01PM +1100, Chris Nolan wrote:
 

It seems slightly ambiguous - updates are redirected and stalled. The
fact that the two statements are in different sentences threw me off
slightly.
   

Oh, okay.  If you can suggest a more clear version, perhaps Paul will
update the manual with it?
Jeremy
 

Hmm...how about something like:

ALTER TABLE workds by making a temporary copy of the original table. 
The alteration is performed on the copy,
after which the original table is deleted and the copy renamed. During 
this process, updates do not explicitly failed but
are instead stalled until the alteration is complete. Clients wishing to 
read from a table currently being altered are
able to do so as per usual.

My background is in software design, not documentation. Additionally, 
one of my clients asked me to fix
a SCO OpenServer crash for them today and wouldn't let me use a chainsaw 
or sledgehammer, so I'm a bit out
of it.

Best regards,

Chris

 

On Mon, 2003-12-15 at 03:55, Jeremy Zawodny wrote:
   

On Mon, Dec 15, 2003 at 02:58:53AM +1100, Chris Nolan wrote:
 

Hi all, while reading through some of the MySQL docs, I noticed the 
following paragraph:

|ALTER TABLE| works by making a temporary copy of the original table. 
The alteration is performed on the copy, then the original table is 
deleted and the new one is renamed. This is done in such a way that all 
updates are automatically redirected to the new table without any failed 
updates. While |ALTER TABLE| is executing, the original table is 
readable by other clients. Updates and writes to the table are stalled 
until the new table is ready.

This seems a bit confusing. On one hand, it says that updates don't 
fail, but on the other hand it says they are stalled until ALTER TABLE 
is done executing. Am I going blind/loosing my mind (a possibility I am 
open to) or do others agree with me?
   

What exactly is the discrepancy you see?  Can you be explicit?

The manual describes the way ALTER TABLE works accurately.

Jeremy
--
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/
 

   

 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Documentation bug?

[Chris Nolan]

Hi all, while reading through some of the MySQL docs, I noticed the 
following paragraph:

|ALTER TABLE| works by making a temporary copy of the original table. 
The alteration is performed on the copy, then the original table is 
deleted and the new one is renamed. This is done in such a way that all 
updates are automatically redirected to the new table without any failed 
updates. While |ALTER TABLE| is executing, the original table is 
readable by other clients. Updates and writes to the table are stalled 
until the new table is ready.

This seems a bit confusing. On one hand, it says that updates don't 
fail, but on the other hand it says they are stalled until ALTER TABLE 
is done executing. Am I going blind/loosing my mind (a possibility I am 
open to) or do others agree with me?

Regards,

Chris

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation bug?

[Jeremy Zawodny]

On Mon, Dec 15, 2003 at 02:58:53AM +1100, Chris Nolan wrote:
 Hi all, while reading through some of the MySQL docs, I noticed the 
 following paragraph:
 
 |ALTER TABLE| works by making a temporary copy of the original table. 
 The alteration is performed on the copy, then the original table is 
 deleted and the new one is renamed. This is done in such a way that all 
 updates are automatically redirected to the new table without any failed 
 updates. While |ALTER TABLE| is executing, the original table is 
 readable by other clients. Updates and writes to the table are stalled 
 until the new table is ready.
 
 This seems a bit confusing. On one hand, it says that updates don't 
 fail, but on the other hand it says they are stalled until ALTER TABLE 
 is done executing. Am I going blind/loosing my mind (a possibility I am 
 open to) or do others agree with me?

What exactly is the discrepancy you see?  Can you be explicit?

The manual describes the way ALTER TABLE works accurately.

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation bug?

[Chuck Gadd]

Chris Nolan wrote:

This seems a bit confusing. On one hand, it says that updates don't 
fail, but on the other hand it says they are stalled until ALTER TABLE 
is done executing. Am I going blind/loosing my mind (a possibility I am 
open to) or do others agree with me?
It looks perfectly correct.   They are stalled, in other words, the
queries will be forced to wait.  They won't fail, they will simply
not complete until the ALTER TABLE is done.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation bug?

[Paul DuBois]

At 2:58 +1100 12/15/03, Chris Nolan wrote:
Hi all, while reading through some of the MySQL docs, I noticed the 
following paragraph:

|ALTER TABLE| works by making a temporary copy of the original 
table. The alteration is performed on the copy, then the original 
table is deleted and the new one is renamed. This is done in such a 
way that all updates are automatically redirected to the new table 
without any failed updates. While |ALTER TABLE| is executing, the 
original table is readable by other clients. Updates and writes to 
the table are stalled until the new table is ready.

This seems a bit confusing. On one hand, it says that updates don't 
fail, but on the other hand it says they are stalled until ALTER 
TABLE is done executing. Am I going blind/loosing my mind (a 
possibility I am open to) or do others agree with me?
Agree with you in what way?  You haven't pointed out any contradiction
or inconsistency, so it's not readily apparent what you consider the
problem to be.
Updates are stalled while the ALTER TABLE operation is in progress,
then they are processed.  An update stalling is not the same as an
update failing.  Stalling just means delayed a bit.
Regards,

Chris


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation bug?

[Chris Nolan]

It seems slightly ambiguous - updates are redirected and stalled. The
fact that the two statements are in different sentences threw me off
slightly.

To everyone else who replied, thanks for your tolerance.

Regards,

Chris

On Mon, 2003-12-15 at 03:55, Jeremy Zawodny wrote:
 On Mon, Dec 15, 2003 at 02:58:53AM +1100, Chris Nolan wrote:
  Hi all, while reading through some of the MySQL docs, I noticed the 
  following paragraph:
  
  |ALTER TABLE| works by making a temporary copy of the original table. 
  The alteration is performed on the copy, then the original table is 
  deleted and the new one is renamed. This is done in such a way that all 
  updates are automatically redirected to the new table without any failed 
  updates. While |ALTER TABLE| is executing, the original table is 
  readable by other clients. Updates and writes to the table are stalled 
  until the new table is ready.
  
  This seems a bit confusing. On one hand, it says that updates don't 
  fail, but on the other hand it says they are stalled until ALTER TABLE 
  is done executing. Am I going blind/loosing my mind (a possibility I am 
  open to) or do others agree with me?
 
 What exactly is the discrepancy you see?  Can you be explicit?
 
 The manual describes the way ALTER TABLE works accurately.
 
 Jeremy
 -- 
 Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Capacity Planning - Methodology/Documentation

[Héctor L . Rodríguez R .]

Hi there!

I need to do a capacity planning for my MySQL database.
Can anyone help me finding information to do it? is there any methodology or at least 
some information about it?
I think I have anything I need to do it, I used to do it for Oracle but we're working 
with MySQL now, and I have no idea about parameters, etc (if they exists), and I was 
asked to do a capacity planning based on any supported methodology. :s

Can anyone point me in the right direction? Does anyone know where I can find some 
information?

Thank you very much

Hector L

Re: About MySQL Documentation

[Victoria Reznichenko]

Vladik Zakhozhai [EMAIL PROTECTED] wrote:
  My name is Vlad. I'm begginer with MySQL. And now I should like to know where can I 
 take good documentation, tutor or others about MySQL.

Check the following link:
http://www.mysql.com/documentation/index.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

About MySQL Documentation

[Vladik Zakhozhai]

Hello!
  My name is Vlad. I'm begginer with MySQL. And now I should like to know where can I 
take good documentation, tutor or others about MySQL.
 Thank you.
-- 
___
OperaMail free e-mail - http://www.operamail.com
OperaMail Premium - 28MB, POP3, more! US$29.99/year

Powered by Outblaze

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Documentation for new MySQL 4.1 features

[Paul DuBois]

At 16:02 +0200 7/21/03, Edgar Kraus wrote:
Hello,

is there any detailed documentation out,
which explains the new character set feature in version 4.1,
where a specific character set can be used for tables and/or columns?
Thanks
Eddie Kraus
http://www.mysql.com/doc/en/Charset.html

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

3.7 Queries from Twin Project Taken from the Documentation tutorial

[Morten Gulbrandsen]

Dear mysql users,

in the tutorial of the documentation I found an interesting 
example of a complicated non trivial sql  query:

URL:
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#
example-Maximum-column-group-row

3.7 Queries from Twin Project
3.7.1 Find all Non-distributed Twins

However, 
I can find no databases with tables to run the queries on. 

What I need is some dummy tables with  example randome data 
To run the queries on. 

person_data  
lentus  
twin_project  
twin_data  
informant_data  
harmony  
postal_groups  

It is no problem for me to create a database, 
the problem is that I have no idea about which structure the tables has,


the added URL :   
http://www.imm.ki.se/TWIN/TWINUKW.HTM

relinked to 
http://www.mep.ki.se/twin/index.html


has a malfunction

I don't need sensitive personal data, 
but the table structure and some 
example dummy data would be higly appreciated.

Yours Sincerely

Morten Gulbrandsen













-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1 character set documentation

[Joel Rees]

 At 15:05 +0900 6/12/03, Joel Rees wrote:
 Paul DuBois advised us that
   Alexander Barkov and Peter Gulutzan have written up some documentation
   on the new character set support in MySQL 4.1, which has now been added
   to the online manual.  You can read it here:
 
   http://www.mysql.com/doc/en/Charset.html
 
 Question about this:
 
  In UCS-2 (binary Unicode representation) every character is
  represented by a two-byte Unicode code ...
 
 Should I read this to imply that the current level of support is BMP
 only?
 
 That's correct.  (I assume you mean first 65536 code points.)

Yeah. The Basic Multilingual Plane.

We don't usually need any of the extended stuff for normal business, but
there are certain fields for which we'll need to be aware of this.

Thanks. 

-- 
Joel Rees [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1 character set documentation

[Joel Rees]

Paul DuBois advised us that 
 Alexander Barkov and Peter Gulutzan have written up some documentation
 on the new character set support in MySQL 4.1, which has now been added
 to the online manual.  You can read it here:
 
 http://www.mysql.com/doc/en/Charset.html

Question about this:

In UCS-2 (binary Unicode representation) every character is
represented by a two-byte Unicode code ...

Should I read this to imply that the current level of support is BMP
only?

 Note that this documentation actually is ahead of the current release
 (4.1.0) because it is current for 4.1.1 and some things have changed
 since 4.1.0.

-- 
Joel Rees [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 4.1 character set documentation

[Paul DuBois]

At 15:05 +0900 6/12/03, Joel Rees wrote:
Paul DuBois advised us that
 Alexander Barkov and Peter Gulutzan have written up some documentation
 on the new character set support in MySQL 4.1, which has now been added
 to the online manual.  You can read it here:
 http://www.mysql.com/doc/en/Charset.html
Question about this:

In UCS-2 (binary Unicode representation) every character is
represented by a two-byte Unicode code ...
Should I read this to imply that the current level of support is BMP
only?
That's correct.  (I assume you mean first 65536 code points.)

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1 character set documentation

[Paul DuBois]

Alexander Barkov and Peter Gulutzan have written up some documentation
on the new character set support in MySQL 4.1, which has now been added
to the online manual.  You can read it here:
http://www.mysql.com/doc/en/Charset.html

Note that this documentation actually is ahead of the current release
(4.1.0) because it is current for 4.1.1 and some things have changed
since 4.1.0.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Connector/J documentation now available online

[Paul DuBois]

Documentation for MySQL Connector/J, the MySQL JDBC driver, is now
available on the MySQL AB web site in HTML format:
http://www.mysql.com/documentation/connector-j/

Links to the document also are available on the main Connector/J page,
and the main documentation page:
http://www.mysql.com/products/connector-j/
http://www.mysql.com/documentation/
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

PLEASE ADD THIS TO DOCUMENTATION...

[Tim Meader]

Well, I just discovered through trial and error that threads ARE being 
spawned on Redhat 8.  The problem is that the ps that came with 7.2 7.3 
was compiled to show threads as separate processes it seems. On Redhat 8 
you have to add the -m switch to ps to make it show all threads.  Just 
thought this should be noted somewhere, since all the documentation, and 
every newsgroup posting I've seen all indicate that you SHOULD DEFINITELY 
see at least 3 mysqld processes running upon initial startup.

Later.

---
Tim Meader
ODIN Unix Group
ACS Government Services, Inc. - (301) 286-8013
[EMAIL PROTECTED] 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Please ADD this to documentation on website...

[Tim Meader]

Well, I just discovered through trial and error that threads ARE being 
spawned on Redhat 8.  The problem is that the ps that came with 7.2 7.3 
was compiled to show threads as separate processes it seems. On Redhat 8 
you have to add the -m switch to ps to make it show all threads.  Just 
thought this should be noted somewhere, since all the documentation, and 
every newsgroup posting I've seen all indicate that you SHOULD DEFINITELY 
see at least 3 mysqld processes running upon initial startup.

Later.

---
Tim Meader
ODIN Unix Group
ACS Government Services, Inc. - (301) 286-8013
[EMAIL PROTECTED]  

Patch Submittal -- Documentation

[Paul G.]

Anyone know where to find the documentation associated with patch submittal?  That is 
from inception and 
determination of need for the patch to the final application of a patch?

Thank you,

Paul G.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Patch Submittal -- Documentation

[Paul DuBois]

At 14:21 -0700 6/2/03, Paul G. wrote:
Anyone know where to find the documentation associated with patch 
submittal?  That is from inception and
determination of need for the patch to the final application of a patch?

	Thank you,

		Paul G.
Is this a MySQL question?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Patch Submittal -- Documentation

[Paul G.]

 At 14:21 -0700 6/2/03, Paul G. wrote:
 Anyone know where to find the documentation associated with patch
 submittal?  That is from inception and determination of need for the
 patch to the final application of a patch?
 
 
 Is this a MySQL question?

Yes.

Paul G.
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Patch Submittal -- Documentation

[Paul DuBois]

At 14:38 -0700 6/2/03, Paul G. wrote:
  At 14:21 -0700 6/2/03, Paul G. wrote:
 Anyone know where to find the documentation associated with patch
 submittal?  That is from inception and determination of need for the
 patch to the final application of a patch?
 
 Is this a MySQL question?
	Yes.

	Paul G.

Okay.  Well, I admit it's not clear to me what it is that you're asking
about.  Have you found a problem with some MySQL program, and you're
wondering how to demonstrate that it's a problem and submit a patch
to fix it?  Are you wondering about how to tell which patches exist
and when they were applied?  Something else?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Patch Submittal -- Documentation

[Paul G.]

 At 14:38 -0700 6/2/03, Paul G. wrote:
At 14:21 -0700 6/2/03, Paul G. wrote:
   Anyone know where to find the documentation associated with patch
   submittal?  That is from inception and determination of need for
   the patch to the final application of a patch?
   
 
   Is this a MySQL question?
 
  Yes.
 
 Okay.  Well, I admit it's not clear to me what it is that you're
 asking about.

Thank you for your candor.  Please, forgive any confusion I might have caused.

  Have you found a problem with some MySQL program, and
 you're wondering how to demonstrate that it's a problem and submit a
 patch to fix it?

Not a program, exactly.  The main mysql.h header file (source code which is 
critical part of Mysql Applications) 
is not equipped to deal with certain types of development environments.

  Are you wondering about how to tell which patches
 exist and when they were applied?

Yes and no.  Yes, in that I am trying to find out if this particular issue has 
come up given the current BT repository 
as it stands today (latest snapshot would do just as well).

No in that I know that certain things (modifications) do not exist within the 
copy of the mysql.h header file which is 
included with the Windows binary download.

Things (patches-modifications) which would, imho, go a long way in expanding 
the platform and general support 
which is available for Mysql itself (the applications, both client and server) while 
minimizing the impact on things like 
the mysql client and server application modifications in terms of a specific type of 
development environment.   By 
type of development environment I am referring to a Gnu  OpenSource piece of 
software/application which 
supports a form of the win32api runtime environment and includes minimal posix file 
system support.

I hope this helps to clarify.

Paul G.

  Something else?
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Patch Submittal -- Documentation

[Becoming Digital]

Try sub-ing to [EMAIL PROTECTED] and then sending a message
there.  That's the list for source code contributors.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: Paul G. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, 02 June, 2003 18:09
Subject: Re: Patch Submittal -- Documentation




 At 14:38 -0700 6/2/03, Paul G. wrote:
At 14:21 -0700 6/2/03, Paul G. wrote:
   Anyone know where to find the documentation associated with patch
   submittal?  That is from inception and determination of need for
   the patch to the final application of a patch?
   
 
   Is this a MySQL question?
 
  Yes.

 Okay.  Well, I admit it's not clear to me what it is that you're
 asking about.

Thank you for your candor.  Please, forgive any confusion I might have caused.

  Have you found a problem with some MySQL program, and
 you're wondering how to demonstrate that it's a problem and submit a
 patch to fix it?

Not a program, exactly.  The main mysql.h header file (source code which is
critical part of Mysql Applications)
is not equipped to deal with certain types of development environments.

  Are you wondering about how to tell which patches
 exist and when they were applied?

Yes and no.  Yes, in that I am trying to find out if this particular issue has
come up given the current BT repository
as it stands today (latest snapshot would do just as well).

No in that I know that certain things (modifications) do not exist within the
copy of the mysql.h header file which is
included with the Windows binary download.

Things (patches-modifications) which would, imho, go a long way in expanding the
platform and general support
which is available for Mysql itself (the applications, both client and server)
while minimizing the impact on things like
the mysql client and server application modifications in terms of a specific
type of development environment.   By
type of development environment I am referring to a Gnu  OpenSource piece of
software/application which
supports a form of the win32api runtime environment and includes minimal posix
file system support.

I hope this helps to clarify.

Paul G.

  Something else?




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MYSQL Documentation

[Nils Valentin]

Hello Mysql List members,

I am about to create some documents which I feel are not so complete 
documented until now.

It's not a lot right now. I ceate a table comparison chart and a MySQL error 
code listing (in text format) which you could use to lookup Client and Server 
errors. Table or OS errors still will need to be added.

I was hoping that somebody else might find it useful as well.
There is no eye candy etc. - its really just the plain information.

http://www.knowd.co.jp/staff/nils/

Best regards
-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

documentation on new MySQL 4.1 features

[Michael Kofler]

Hi,

I have just downloaded + compiled the latest bitkeeper version of MySQL 4.1
and of the MySQL manual (bk://mysql.bkbits.net/mysqldoc). I would like to
test the new features, especially the new charset/unicode support, R-trees
etc., but I fail to find any detailed documentation on it.

http://www.mysql.com/doc/en/Nutshell_4.1_features.html

and

http://www.mysql.com/doc/en/News-4.1.0.html

only list features, but are insufficient to do any serious work.

Is there a bitkeeper directory for mysqldoc-41 or something similar? Is
there any other source of documentation I could use?

Thanks a lot,

Michael Kofler

(author of the book 'MySQL' published by
 Addison Wesley Germany / apress USA)

http://www.kofler.cc/mysql



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 3.23.5x documentation

[Davy Obdam]

Helloo people,

I am looking for a Windows help file (.*hlp or .*chm) or PDF file with 
the MySQL manual for version 3.23.5x. Also i would like the HTML version 
with multiple HTML files (tar.gz). I have been looking on the MySQL 
website, but everything is version 4.0.x . Can anyone help me with this 
or knows where to download these files. I`ve tried google, but 
unsuccesfull I would prefer a recent version 3.23.5x whatever.

Thanks alot ppl,

Best regards,

Davy Obdam
mailto:[EMAIL PROTECTED]



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Error in NULLIF documentation

[Giuseppe Maxia]

Description:
The documentation for NULLIF states that expr1 is evaluated twice if the 
expressions are equal.
Actually, it is the opposite. Expr1 is evaluated twice when the two exporessions 
are NOT equal.

How-To-Repeat:

mysql set @myval:=0;
Query OK, 0 rows affected (0.00 sec)

mysql select NULLIF(@myval:=@myval+1,1); # now @myval is 1, it matches, NULLIF 
returns NULL
++
| NULLIF(@myval:=@myval+1,1) |
++
|   NULL |
++
1 row in set (0.00 sec)

mysql select NULLIF(@myval:=@myval+1,1); # After the first test, @myval is 2 ; 
doesn't match
++
| NULLIF(@myval:=@myval+1,1) |
++
|  3 |
++
1 row in set (0.00 sec)
# @myval is now 3, as a result of a double evaluation, when expr1 and expr2 were not 
equal.

Fix:
Correct the documentation

Submitter-Id:  submitter ID
Originator:Giuseppe Maxia
Organization:

MySQL support: none
Synopsis:  error in documentation
Severity:  non-critical
Priority:  low
Category:  mysql
Class: doc-bug




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Product Structure and Documentation storage in MySQL

[Magnus Sundberg]

Hi,
We are evaluating the storage of document and product information in a 
MySQL database.
The product information that is stored will be product structures, that 
then will be pointing to the document storage.

Anybody that has implemented such a database?

The first approach is something very simple, we will have less than 20 
users totally, typically maximum 3 concurrent users. We will also trust 
the users, we will need protection from users doing misstakes, not evil 
users. Evil users already have access to the server console... For small 
company networks I do believe in physical secrity and that is our 
entrance door.

/Magnus




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Documentation question

[Magnus Sundberg]

[EMAIL PROTECTED] wrote:
 Your message cannot be posted because it appears to be either spam or
 simply off topic to our filter. To bypass the filter you must include
 one of the following words in your message:
 
 sql,query
 
 If you just reply to this message, and include the entire text of it in the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. Just typing the word MySQL once will be sufficient, for example.
 
 You have written the following:
 
 Dear sirs,
 I have a small question about the documentation that I do not understand.
 In your documentation you have a small section regarding running
 multiple data base servers on the same machine. You are supposed to run
 the databases on different sockets, communication ports etc.
 I do understand that, but you do recommend that you have different
 versions compiled for this issue, even though you can run the database
 servers with just different switches.
 
   From a performance issue, I believe that you should run with just one
 binary, that will be occupy the same physical memory for the two
 multithreaded processes, even though they have different command line
 switches.
 With two different binarys will the physical memory requirement be twice
 as much.
 But it might be easier to get a system working when you have two
 different binarys. But I believe that users that can recompile your
 software with some different settings also have the competence to adjust
 runtime switches.
 
 What is wrong with the argumentaion above?
 
 /Magnus
 
 
 
 
 





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Documentation question

[Thomas Seifert]

if you run more than one binary it will NOT use the same
physical memory, even if it is the same binary.
every programm you run uses its own memory for most parts.



Thomas

sql, query

On Tue, 24 Sep 2002 16:35:21 +0200 Magnus Sundberg [EMAIL PROTECTED] wrote:

  Dear sirs,
  I have a small question about the documentation that I do not understand.
  In your documentation you have a small section regarding running
  multiple data base servers on the same machine. You are supposed to run
  the databases on different sockets, communication ports etc.
  I do understand that, but you do recommend that you have different
  versions compiled for this issue, even though you can run the database
  servers with just different switches.
  
From a performance issue, I believe that you should run with just one
  binary, that will be occupy the same physical memory for the two
  multithreaded processes, even though they have different command line
  switches.
  With two different binarys will the physical memory requirement be twice
  as much.
  But it might be easier to get a system working when you have two
  different binarys. But I believe that users that can recompile your
  software with some different settings also have the competence to adjust
  runtime switches.
  
  What is wrong with the argumentaion above?
  
  /Magnus
  
  
  
  
  
 
 
 
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Documentation correction...

[Jon Frisby]

Oh yes, I almost forgot...  The supported type aliases aren't mentioned in
the pseudo-BNF, and they probably should be for the sake of people who are
trying to learn MySQL after having used another DB product...

or  BIT
or  BOOLEAN
or  DOUBLE PRECISION[(length,decimals)] [UNSIGNED] [ZEROFILL]

-JF

 -Original Message-
 From: Jon Frisby [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, September 22, 2002 1:12 PM
 To: mysql
 Subject: Documentation correction...


 Section 6.5.3 of the MySQL documentation has some slight mistakes:

 Under the create_definition: section, the following line appears:
 orCHECK (expr)

 But this syntax doesn't appear to actually be supported yet (it
 produces an
 error rather than being silently ignored).


 Under the type: section, the following lines appear:
 orCHAR(length) [BINARY]
 orVARCHAR(length) [BINARY]

 These should be:
 or[NATIONAL] CHAR[(length)] [BINARY]
 orNCHAR[(length)] [BINARY]
 or[NATIONAL] VARCHAR(length) [BINARY]


 The following lines also appear:
 orFLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
 orDECIMAL(length,decimals) [UNSIGNED] [ZEROFILL]
 orNUMERIC(length,decimals) [UNSIGNED] [ZEROFILL]

 But they should be:
 orFLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL]
 orFLOAT[(precision)] [UNSIGNED] [ZEROFILL]
 orDECIMAL[(length[,decimals])] [UNSIGNED] [ZEROFILL]
 orNUMERIC[(length[,decimals])] [UNSIGNED] [ZEROFILL]


 Also, it may be prudent to make it more clear the full syntax for
 tbl_name
 (optional database prefix, optional `quoting`...) with a section
 describing
 the variations:

 tbl_name:
   [database.]name
 or[`database`.]`name`


 Come to think of it, col_name could benefit from that as well...

 -JF


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

client-serwer communication protocol's documentation

[Krzysztof Krupa]

Hi.
I badly need the documentation to the mySQL client-server TCP/IP
communication protocol.
I'm trying to build some measurement system with VEE 6 from Agilent
Technologies, mySQL and Apache.

There is no possibility in VEE to use ODBC, so I've decided to make some VEE
programming of the mySQL port direct string writing/receiving.

I've tried to find this documentation, but I was not able.

I would like to ask someone common with this topic to help me to get it
somehow,
or at least to answer if I can get it free for my non commercial purpose
(if not I would have to discover another idea how to do it).

Thanks in advance for Your answers.

Regards,

Krzysztof Krupa
[EMAIL PROTECTED]

student of Warsaw's University of Technology,
Faculty of Electronics and Information Technology


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Documentation Bug - change requested

[Larry Irwin]

Since CHECK cannot be used in CREATE TABLE in any way, shape or form, remove
it from the documentation for CREATE TABLE.

Lary Irwin
CCA Medical
sql, query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Database documentation

[Gigi Di Leo]

Hello list.

At the end of a db programming job (using php) I have been asked for a document 
describing in details the structure of a MySQL database.
The purpose of the document is to make other DB people able to manage and interface 
the database (I can figure out that there is also the intent to impress the customer 
by graphic and heavy paper).
Could you please suggest me some source where I could learn about the best standard 
methods to describe a DB structure ?
Is there any tool which is able to produce this kind of document semi/automatically ?

gg


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Database documentation

[Francisco Reinaldo]

Hi,

These tools are not open source:

http://www.thekompany.com/products/dataarchitect/

You can download the evaluation. It supports MySQL
directly:

http://www.datanamic.com/download/download_dezign.html

If you are not familiar with database methodology and
relation entity diagrams, I recomend you to buy a book
that explains the concept a little bit.

Bye and good luck.
--- Gigi Di Leo [EMAIL PROTECTED] wrote:
 Hello list.
 
 At the end of a db programming job (using php) I
 have been asked for a document describing in details
 the structure of a MySQL database.
 The purpose of the document is to make other DB
 people able to manage and interface the database (I
 can figure out that there is also the intent to
 impress the customer by graphic and heavy paper).
 Could you please suggest me some source where I
 could learn about the best standard methods to
 describe a DB structure ?
 Is there any tool which is able to produce this kind
 of document semi/automatically ?
 
 gg
 
 

-
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list
 archive)
 
 To request this thread, e-mail
 [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try:
 http://lists.mysql.com/php/unsubscribe.php
 


__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Database documentation

[mos]

At 01:15 PM 7/9/2002, you wrote:
Hello list.

At the end of a db programming job (using php) I have been asked for a 
document describing in details the structure of a MySQL database.
The purpose of the document is to make other DB people able to manage and 
interface the database (I can figure out that there is also the intent to 
impress the customer by graphic and heavy paper).
Could you please suggest me some source where I could learn about the best 
standard methods to describe a DB structure ?
Is there any tool which is able to produce this kind of document 
semi/automatically ?

gg


gg,

Try Visiomodeler from MS. Download at 
http://download.microsoft.com/download/visio2000enterprise/ORMtool/3.1/WIN98/EN-US/msvm31.exe.
Use ODBC to access MySQL. It can reverse engineer your MySQL database and 
can generate SQL to build your database. Oh yeah, one more thing, it's 
free. :) It also has excellent PDF documentation on how to use case tools.

Also if you just want to report on the structure, try MySQLFront from 
http://www.anse.de/mysqlfront/. Also EMS MySQLMgr has much better reporting 
and you can get a 30 day eval from http://ems-hitech.com/mymanager/.

Mike


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL AB: Need documentation clarification

[Jeremy Zawodny]

On Tue, Jun 11, 2002 at 03:58:14PM -0700, Jeff Kilbride wrote:
  both InnoDB and MyISAM keep also dynamically statistics about tables. In
  most cases running ANALYZE TABLE does not bring any benefit in query
  optimization.
 
 Personally, I'm pretty shocked to hear you say this. I was under the
 impression that running ANALYZE TABLE was a good thing and helped
 ensure the key distribution for the table in question was up to
 date.

You're correct.  There are times when the MyISAM table handler looses
touch with what the table really contains.  Running ANALYZE or
OPTIMIZE will fix that.

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.51: up 32 days, processed 706,777,053 queries (248/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql documentation prompt

[Michal Dvoracek]

Hello,

http://www.mysql.com/doc/m/y/mysql.html

there is section how to set up own prompt for mysql. I tryed but
doesn't working. (tested on 3.23.43 and 4.0.1-alpha)

Is possible to set up own prompt in mysql ?

Regards,
Michal Dvoracek  [EMAIL PROTECTED]

sql, table, select


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL AB: Need documentation clarification

[Heikki Tuuri]

Erv,


- Original Message -
From: Erv Young [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, June 11, 2002 3:49 AM
Subject: MySQL AB: Need documentation clarification
 2)  Also, the discussion of ANALYZE TABLE at
 http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html leaves the user of InnoDB
 tables in limbo.  If this doesn't work on InnoDB tables, what takes its
 place, or why does its place not need to be taken?

both InnoDB and MyISAM keep also dynamically statistics about tables. In
most cases running ANALYZE TABLE does not bring any benefit in query
optimization.

 Thanks.

 --Erv Young

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL AB: Need documentation clarification

[Heikki Tuuri]

For the mail filter: SQL database

- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 11, 2002 2:47 PM
Subject: Re: MySQL AB: Need documentation clarification


 Erv,


 - Original Message -
 From: Erv Young [EMAIL PROTECTED]
 Newsgroups: mailing.database.mysql
 Sent: Tuesday, June 11, 2002 3:49 AM
 Subject: MySQL AB: Need documentation clarification
  2)  Also, the discussion of ANALYZE TABLE at
  http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html leaves the user of
InnoDB
  tables in limbo.  If this doesn't work on InnoDB tables, what takes its
  place, or why does its place not need to be taken?

 both InnoDB and MyISAM keep also dynamically statistics about tables. In
 most cases running ANALYZE TABLE does not bring any benefit in query
 optimization.

  Thanks.
 
  --Erv Young

 Best regards,

 Heikki Tuuri
 Innobase Oy
 ---
 InnoDB - transactions, hot backup, and foreign key support for MySQL
 See http://www.innodb.com, download MySQL-Max from http://www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL AB: Need documentation clarification

[Jeff Kilbride]

 both InnoDB and MyISAM keep also dynamically statistics about tables. In
 most cases running ANALYZE TABLE does not bring any benefit in query
 optimization.

Personally, I'm pretty shocked to hear you say this. I was under the
impression that running ANALYZE TABLE was a good thing and helped ensure
the key distribution for the table in question was up to date. I've seen a
lot of other posts on this list from people who advocate running ANALYZE
TABLE on a regular basis. You're saying this in not necessary?

Thanks,
--jeff



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL AB: Need documentation clarification

[Erv Young]

MySQL AB staff:

1)  The recent discussion on the subject Not using indexes??? brought to 
light an opportunity for interpreting the documentation in contradictory 
ways.  The page http://www.mysql.com/doc/M/y/MySQL_indexes.html does not 
mention the IS NOT NULL comparison operator, nor does it mention the 
inequality () operator.

This allows the reader to believe that since those operators are not 
mentioned, it goes without saying that they never use an index.  It also 
allows the reader to believe that since each is simply the negation of a 
comparison whose index use is specifically documented, it goes without 
saying that they also use an index.

Which of these interpretations is the truth that goes without saying, and 
which is the error that should be obvious even to the uninitiated?  Or 
(removing my tongue gingerly from my cheek), what is going on here?

2)  Also, the discussion of ANALYZE TABLE at 
http://www.mysql.com/doc/A/N/ANALYZE_TABLE.html leaves the user of InnoDB 
tables in limbo.  If this doesn't work on InnoDB tables, what takes its 
place, or why does its place not need to be taken?

Thanks.

--Erv Young


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php