Re: performance between InnoDB vs MyISAM

[sprock]

As far as i know, using IN( SUBQUERY ) will give very poor performance, 
especially if the record set returned by the large query is really large.


try to use a join instead of WHERE IN( XXX )..


Im not sure why its that much better in INNODB though...

Foo Ji-Haw wrote:

Hi all,

Just want to share and confirm my findings on a performance issue I've 
been experiencing.


My database is strictly non-transactional, but it's got about 200,000 
records in this particular table. The table has a primary index, and 2 
integers - one for the date and the other for the time. Among the 
other fields there's a text field which usually stores a huge amount 
of text.


One thing I notice, is that under MyISAM running the following sql:
select id from mytable where id in (#subselect to extract a set of ids)
order by mydate desc, mytime desc

The time taken is really bad, like > 90 secs. But in InnoDB it is 
usually <8 secs. The time difference is too crazy to ignore.


Can anyone explain this? Is there something in InnoDB that creates the 
magic?







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

performance between InnoDB vs MyISAM

[Foo Ji-Haw]

Hi all,

Just want to share and confirm my findings on a performance issue I've 
been experiencing.


My database is strictly non-transactional, but it's got about 200,000 
records in this particular table. The table has a primary index, and 2 
integers - one for the date and the other for the time. Among the other 
fields there's a text field which usually stores a huge amount of text.


One thing I notice, is that under MyISAM running the following sql:
select id from mytable where id in (#subselect to extract a set of ids)
order by mydate desc, mytime desc

The time taken is really bad, like > 90 secs. But in InnoDB it is 
usually <8 secs. The time difference is too crazy to ignore.


Can anyone explain this? Is there something in InnoDB that creates the 
magic?




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

select substring_index(user(),_utf8'@',-1) not return ip on win2000/XP ?

[wang shuming]

Hi,
  If mysql database server  installed  on Linux without problem, but on
win2000/XP:
 select substring_index(user(),_utf8'@',-1)  return the  local  windows
station computer name  instead of  IP ?
Best regard!
Shuming Wang

RE: Best way to design one to many queries

[Nicolas Verhaeghe]

Your method is wrong because if you are looking for "5", then "56" will
match and also everything that has "5" in it.

Unless you include the spaces and look for : '% 5 %' but then you need
to add a space at the beginning and at the end of your attributes field.

That method is way too cumbersome and also creates some optimization
issues, since you need to have that attribute field with a fixed varchar
type, whether the product has attributes or not, no matter what the size
of the attributes strings will be, and you need to make the field large
enough (50 characters? 100?) to avoid running out of "space".

Eventually you will end up with a big fat products table and your app
will crawl.

You need to use three tables: one for your product, one for the
attributes and one link table. ID (integer) fields are used to link the
three tables.

You can fine-tune your tables by selecting the proper integer type you
need (smallint, mediumint or int) to optimize your database properly.

Then you need to do your search on the link table, inner joined to the
products table on the product id or not. When you pull queries on the
link table only (for instance to count how many with such attribute),
the query will fly.

The link table also allows one to many relationships.

Believe me, that's the way to do it.

-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, March 07, 2006 10:45 PM
To: MySql
Subject: Best way to design one to many queries


Been wondering this for a while now, I can explain how I do it, but I am
sure there are better ways.

I have products and attributes, for example:
Product A
nice
sweet
fast
funny

Attributes are arbitrary, attributes are in a separate table.  Yes, I
could add fields for the attributes to the products table, but that does
not allow the client the flexibility to add new attributes on the fly.

Generally, in the products table I have a text filed where I store the
id of the attribute, space separated, for example:
attributes: 1 5 23 56 3 6

The trouble is, when I want to find all products where the attribute id
is 5 and 23 and 3, I have to build it up like so:

Select prod_name from products where attribute_id like ' 5 ' AND etc etc
etc which also leads to issues with leading and trailing spaces on the
first and last attribute id's

Suggestions?
-- 
-
Scott HanedaTel: 415.898.2602
 Novato, CA U.S.A.



-- 
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]

java.net.BindException: Address already in use: JVM_Bind

[NanFei Wang]

Dear all:

I use Tomcat 5.5.9 and Mysql Server 5.0 (with the driver 
mysql-connector-java-3.1.12-bin.jar)

 to run my Application on Windows XP.

It run smoothly many times throughout the whole Application without any problem 
!

But in an unexpected time, I get the following Error messages.

I can only ' Stop ' Tomcat 5.5.9 and ' Start ' it again, Then it will be Ok to 
run my Application.

Can you tell me how to solve the problem ?

by  NanFei

javax.servlet.ServletException: Communications link failure due to underlying 
exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.BindException: Address already in use: JVM_Bind

STACKTRACE:

java.net.SocketException: java.net.BindException: Address already in use: 
JVM_Bind
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555)
at com.mysql.jdbc.Connection.(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at upload.mysqlConn.(mysqlConn.java:39)
at upload.mysqlConn.(mysqlConn.java:19)
at org.apache.jsp.queryChoice_jsp._jspService(org.apache.jsp.queryChoice_jsp:67)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValvejava:213)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValvejava:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at 
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)


** END NESTED EXCEPTION **

Best way to design one to many queries

[Scott Haneda]

Been wondering this for a while now, I can explain how I do it, but I am
sure there are better ways.

I have products and attributes, for example:
Product A
nice
sweet
fast
funny

Attributes are arbitrary, attributes are in a separate table.  Yes, I could
add fields for the attributes to the products table, but that does not allow
the client the flexibility to add new attributes on the fly.

Generally, in the products table I have a text filed where I store the id of
the attribute, space separated, for example:
attributes: 1 5 23 56 3 6

The trouble is, when I want to find all products where the attribute id is 5
and 23 and 3, I have to build it up like so:

Select prod_name from products where attribute_id like ' 5 ' AND etc etc etc
which also leads to issues with leading and trailing spaces on the first and
last attribute id's

Suggestions?
-- 
-
Scott HanedaTel: 415.898.2602
 Novato, CA U.S.A.



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

Re: Table with multiple primary keys - How

[Rhino]

- Original Message - 
From: "fbsd_user" <[EMAIL PROTECTED]>

To: 
Sent: Tuesday, March 07, 2006 11:40 PM
Subject: Table with multiple primary keys - How




What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id, email_addr,
or last_name fields will do a single read to the matching value.
Like having 3 different indexes into the same table.
I don't want those 3 field concatenated together as a single key.

Is this table definition correct?

By definition, a table cannot have more than one primary key. Period. Your 
definition will probably execute successfully - I haven't tried it so I 
can't be sure - but 'successful' only means that it will (probably) not fail 
on a syntax error. Your definition does NOT create three primary keys, it 
creates one key on the combination of three values. In other words, your 
definition concatenates the three keys together, which you say you don't 
want to do.


Your basic goal of having three separate primary keys is not possible. 
However, you _could_ create a primary key and two unique keys or three 
unique keys. But before you start doing that, I suggest you take a step back 
and rethink your design.


The proper way to design databases is to do logical design FIRST, then 
consider physical design. In other words, make sure that your design hangs 
together logically first and meets all your business requirements. Then, and 
only then, should you consider physical design, i.e. redesigning tables to 
optimize performance. Logical design is always done with the assumption that 
you are working on a perfect processor that has outstanding performance no 
matter what query you run. Once the logical design is perfect, you can start 
being realistic and modify your design to optimize performance for real 
world non-perfect processors.


I think you're leaping into physical design before you've finished logical 
design. You're worried about query performance before you've satisfied 
yourself that the logical design even works. You need to consider what 
primary key will support your logical design. Is the login_id alone 
sufficient to uniquely identify rows of the members table? Or do you need 
other columns to accomplish this? If, in fact, you need all three columns 
(login_id, email_addr, and last_name) to uniquely identify rows in the 
members table, then all three of those need to be in your single, 
concatenated key, exactly as you have it in your code.


Is it possible for more than one person to have the login_id ABC123? If not, 
the login_id by itself should suffice to be your primary key. In that case, 
you may want to make email_addr and last_name separate unique keys - or not. 
If the login_id is sufficient to uniquely identify a member that's fine; 
make login_id your primary key. But you may not want to make email_addr or 
last_name unique keys. What if two of your members have separate login_ids 
but share an email address? Making email_addr unique will prevent one of 
your two members from being added to the table. This is an even bigger 
problem for the last_name; if you make it unique, and you already have one 
Smith in the table, you will never be allowed to have another Smith in the 
table!


You need to sort out the issue of the primary key FIRST. Once that is 
resolved, you can start to think about making other keys unique or not. But 
right now, I think you're getting badly ahead of yourself.



create table members (
   logon_idvarchar(15),
   email_addr  varchar(30),
  last_name   varchar(30),
  member_type char(1),
   email_verified  char(1),
  logon_pwvarchar(15),
  date_added  date,
   last_login  timestamp,
   first_name  varchar(30),
   addr1   varchar(30),
   addr2   varchar(30),
   cityvarchar(20),
   state   varchar(20),
   zip varchar(15),
  phone_home  varchar(15),
   phone_officevarchar(15),
   phone_cell  varchar(15),
   mothers_maiden_name varchar(30),
  ip_of_useratsignup  varchar(16),
  primary key(login_id, email_addr, last_name)
);


--
Rhino 




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 06/03/2006


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

Re: optimization - directories and sub-directories (with descendants)

[Peter Brawley]

Eli,

>Example: I want to search on all the directories under 'd4' that 
contain the word "music".


>I got several solutions, but not satisfying:
>A) Loop from 'd4' to sub-dirs in first level, and use buffer list for 
next iterations
>when going deeper into levels. [not good: there can be many sub-dirs 
with descendants,

>and the loop will iter more; slow on searches].
>B) Storing the directory tree structure in the form of 'root/d1/d4/d6' 
and etc.
>[not good: personally I can't use it (specific implementation 
restriction)].
>C) Descendants sub-dirs connections to sub-dirs on deeper levels, so 
searching will go
>over the first level sub-dirs and the descendants sub-dirs. [not good: 
there can be many
>sub-dirs and there would be many descendants sub-dirsl; duplicating 
descendants on references].


As you say, your A and C aren't maintainable. If a node can have more 
than one parent node (ie its indegree can > 1), it ain't  a tree, so 
tree methods won't work unmodified. It's possible, though, to adapt some 
tree traversal methods to a graph like yours; for an example see the 
parts explosion section in 
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html.


PB

-

Eli wrote:

Hi,

I have a table of directories. Each row represents a directory, which 
holds his name and desc. Another table lists sub-directories from each 
directory source to its sub-directories targets.


dirs:
+--+--++
| dir_id   | dir_name | dir_desc   |
+--+--++
|0 | root |   root dir |
|   11 |   d1 |  dir no. 1 |
|   12 |   d2 |  dir no. 2 |
|   21 |   d3 |  dir no. 3 |
|   22 |   d4 |  dir no. 4 |
|   23 |   d5 |  dir no. 5 |
|   31 |   d6 |  dir no. 6 |
|   32 |   d7 |  dir no. 7 |
|   41 |   d8 |  dir no. 8 |
|   51 |   d9 |  dir no. 9 |
|   52 |  d10 | dir no. 10 |
|   61 |  d11 | dir no. 11 |
+--+--++
12 rows in set (0.00 sec)

subdirs:
+++
| dir_source | dir_target |
+++
|  0 | 11 |
|  0 | 12 |
| 11 | 21 |
| 11 | 22 |
| 11 | 23 |
| 12 | 31 |
| 22 | 31 |
| 22 | 32 |
| 23 | 52 |
| 31 | 41 |
| 41 | 51 |
| 41 | 52 |
| 52 | 61 |
+++
13 rows in set (0.00 sec)

root (0)
   +d1 (11)
   |  +d3 (21)
   |  +d4 (22)
   |  |  +d6 (31)
   |  |  |  +d8 (41)
   |  |  | +d9 (51)
   |  |  | +d10 (52)
   |  |  | +d11 (61)
   |  |  +d7 (32)
   |  +d5 (23)
   | +*d10* (52) -reference
   +d2 (12)
  +*d6* (31) -reference

Note that a directory can be contained in several parent directories 
(as long as it doesn't creates circles) - "references".


Example: I want to search on all the directories under 'd4' that 
contain the word "music".


I got several solutions, but not satisfying:
A) Loop from 'd4' to sub-dirs in first level, and use buffer list for 
next iterations when going deeper into levels. [not good: there can be 
many sub-dirs with descendants, and the loop will iter more; slow on 
searches].
B) Storing the directory tree structure in the form of 'root/d1/d4/d6' 
and etc. [not good: personally I can't use it (specific implementation 
restriction)].
C) Descendants sub-dirs connections to sub-dirs on deeper levels, so 
searching will go over the first level sub-dirs and the descendants 
sub-dirs. [not good: there can be many sub-dirs and there would be 
many descendants sub-dirsl; duplicating descendants on references].


Do you have any other suggestions? What's the better way?


-Thanks in advance... :-)




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 3/6/2006


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

Re: Table with multiple primary keys - How

[Dan Nelson]

In the last episode (Mar 07), fbsd_user said:
> What I am trying to do here is have 3 separate primary keys. Creating
> a mysql select on either of the Logon_id, email_addr, or last_name
> fields will do a single read to the matching value.  Like having 3
> different indexes into the same table.

Create one primary key and two unique indexes.  As far as mysql is
concerned, a primary is just another unique index.  I'd make login_id
the real primary key since it should never change, unlike email_addr or
last_name.  Are you sure you want last_name to be unique?  I think that
one should be just a regular index.

-- 
Dan Nelson
[EMAIL PROTECTED]

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

Table with multiple primary keys - How

[fbsd_user]

What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id, email_addr, 
or last_name fields will do a single read to the matching value. 
Like having 3 different indexes into the same table. 
I don't want those 3 field concatenated together as a single key.

Is this table definition correct?

create table members (
logon_idvarchar(15),
email_addr  varchar(30),
  last_name   varchar(30),
  member_type char(1),
email_verified  char(1),
  logon_pwvarchar(15),
  date_added  date,
last_login  timestamp,
first_name  varchar(30),
addr1   varchar(30),
addr2   varchar(30),
cityvarchar(20),
state   varchar(20),
zip varchar(15),
  phone_home  varchar(15),
phone_officevarchar(15),
phone_cell  varchar(15),
mothers_maiden_name varchar(30),
  ip_of_useratsignup  varchar(16),
  primary key(login_id, email_addr, last_name)
);


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

installing jTDS for WorkBench

[Carl Karsten]

http://sourceforge.net/projects/jtds docs say
"jTDS does not need any special installation. Just drop the jar file into your 
application's classpath"


How do I figure out where that is on a win box?

I am trying to connect it to MsSql using http://java.com/getjava and 
http://sourceforge.net/projects/jtds and can't find a "look here, put there, 
that is the classpath."


help help...

^C



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

Re: data backup

[CodeHeads]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Tue, 07 Mar 2006 19:54:02 -0500
Mathieu Bruneau <[EMAIL PROTECTED]> wrote:

> kalin mintchev a écrit :
> >  hi all...
> > 
> > what's the best way to periodically back up mysql data?
> > so that databases and tables can be still usable even after a mysql
> > upgrade?
> > 
> > thanks...

mysqldump

man mysqldump for the usage. I use this as a backup everyday. I wrote a
bash script and I fire it off using cron everyday.

- -- 
Best regards,
~WILL~
Key: http://code-heads.com/keys/ch1.asc 
Key: http://code-heads.com/keys/ch2.asc 
Linux Commands: http://code-heads.com/commands 
Linux Registered User: 406084 (http://counter.li.org/)
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (GNU/Linux)

iD8DBQFEDk2ofw3TK8jhZrsRAuxNAKCz4VDHRoFb4xWX/9mYUPACZFtJEACff9vK
EOW3UeOeHpn4U/66cfgNlXQ=
=Q7Wv
-END PGP SIGNATURE-

Re: data backup

[Daniel da Veiga]

On 3/7/06, Mathieu Bruneau <[EMAIL PROTECTED]> wrote:
> kalin mintchev a écrit :
> >  hi all...
> >
> > what's the best way to periodically back up mysql data?
> > so that databases and tables can be still usable even after a mysql upgrade?
> >
> > thanks...
> >
> >
>
> The only absolutely portable way is the dump in text file...
>

Yeah, I use MySQL Administrator, both in Windows and Linux, the only
difference is the archiving of the backup files, that is done with rar
in Win and tar.bz2 in Linux both with scheduled scripts, pretty easy.
This method comes since version 3, did not upgrade to 5, but it saved
me lots of time switching to 4, and then 4.1.

> Good luck
>
> --
> 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]
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--

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

Re: data backup

[Mathieu Bruneau]

kalin mintchev a écrit :
>  hi all...
> 
> what's the best way to periodically back up mysql data?
> so that databases and tables can be still usable even after a mysql upgrade?
> 
> thanks...
> 
> 

The only absolutely portable way is the dump in text file...

Good luck

-- 
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]

optimization - directories and sub-directories (with descendants)

[Eli]

Hi,

I have a table of directories. Each row represents a directory, which 
holds his name and desc. Another table lists sub-directories from each 
directory source to its sub-directories targets.


dirs:
+--+--++
| dir_id   | dir_name | dir_desc   |
+--+--++
|0 | root |   root dir |
|   11 |   d1 |  dir no. 1 |
|   12 |   d2 |  dir no. 2 |
|   21 |   d3 |  dir no. 3 |
|   22 |   d4 |  dir no. 4 |
|   23 |   d5 |  dir no. 5 |
|   31 |   d6 |  dir no. 6 |
|   32 |   d7 |  dir no. 7 |
|   41 |   d8 |  dir no. 8 |
|   51 |   d9 |  dir no. 9 |
|   52 |  d10 | dir no. 10 |
|   61 |  d11 | dir no. 11 |
+--+--++
12 rows in set (0.00 sec)

subdirs:
+++
| dir_source | dir_target |
+++
|  0 | 11 |
|  0 | 12 |
| 11 | 21 |
| 11 | 22 |
| 11 | 23 |
| 12 | 31 |
| 22 | 31 |
| 22 | 32 |
| 23 | 52 |
| 31 | 41 |
| 41 | 51 |
| 41 | 52 |
| 52 | 61 |
+++
13 rows in set (0.00 sec)

root (0)
   +d1 (11)
   |  +d3 (21)
   |  +d4 (22)
   |  |  +d6 (31)
   |  |  |  +d8 (41)
   |  |  | +d9 (51)
   |  |  | +d10 (52)
   |  |  | +d11 (61)
   |  |  +d7 (32)
   |  +d5 (23)
   | +*d10* (52) -reference
   +d2 (12)
  +*d6* (31) -reference

Note that a directory can be contained in several parent directories (as 
long as it doesn't creates circles) - "references".


Example: I want to search on all the directories under 'd4' that contain 
the word "music".


I got several solutions, but not satisfying:
A) Loop from 'd4' to sub-dirs in first level, and use buffer list for 
next iterations when going deeper into levels. [not good: there can be 
many sub-dirs with descendants, and the loop will iter more; slow on 
searches].
B) Storing the directory tree structure in the form of 'root/d1/d4/d6' 
and etc. [not good: personally I can't use it (specific implementation 
restriction)].
C) Descendants sub-dirs connections to sub-dirs on deeper levels, so 
searching will go over the first level sub-dirs and the descendants 
sub-dirs. [not good: there can be many sub-dirs and there would be many 
descendants sub-dirsl; duplicating descendants on references].


Do you have any other suggestions? What's the better way?


-Thanks in advance... :-)

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

Re: Database Corruption and MySQL

[Michael Jeung]

Hi Kishore,

That's an interesting idea.  However, given that the healthy slave  
and the corrupt slave now have different values for  
Exec_Master_Log_Pos, would restoring the tables from the healthy  
slave necessarily be a good move?


I would be worried that the corrupt slave's counter position would be  
mismatched with the table.


Regards,
Michael Jeung


On Mar 7, 2006, at 3:20 PM, Kishore Jalleda wrote:

an "rsync" with the right options from the unaffected slave to the  
corrupt

one might prove to be an elegant technique

Kishore Jalleda

On 3/7/06, Michael Jeung <[EMAIL PROTECTED]> wrote:


Hi Folks,

We've got a Single Master/Multiple Slave environment.
Recently, we had some corruption on one of the slaves and I had to
repair the affected tables.

After the repair completed, some of the rows on the slave had been
deleted - so the Master and the Slave weren't exactly in synch.  The
slave was missing some records.   I verified this myself with a
select count(*) on the table.

Now, I know this is the normal way for MySQL to repair it's database.

However, what I'd like to do is restore these missing rows to the
Slave without doing a dump and reload from my backups.  Is this
possible?

The way that we normally approach this problem is to take an
unaffected slave and copy the mysql directory from an unaffected
slave over to the corrupt slave.  Then we restart MySQL on the
corrupt slave and things work out without too much difficulty.
However, this has always seemed like a terrible way to restore a
corrupt slave to me.  Is there a more elegant way to do it?

Regards,
Michael Jeung

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






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

Re: Database Corruption and MySQL

[Kishore Jalleda]

an "rsync" with the right options from the unaffected slave to the corrupt
one might prove to be an elegant technique

Kishore Jalleda

On 3/7/06, Michael Jeung <[EMAIL PROTECTED]> wrote:
>
> Hi Folks,
>
> We've got a Single Master/Multiple Slave environment.
> Recently, we had some corruption on one of the slaves and I had to
> repair the affected tables.
>
> After the repair completed, some of the rows on the slave had been
> deleted - so the Master and the Slave weren't exactly in synch.  The
> slave was missing some records.   I verified this myself with a
> select count(*) on the table.
>
> Now, I know this is the normal way for MySQL to repair it's database.
>
> However, what I'd like to do is restore these missing rows to the
> Slave without doing a dump and reload from my backups.  Is this
> possible?
>
> The way that we normally approach this problem is to take an
> unaffected slave and copy the mysql directory from an unaffected
> slave over to the corrupt slave.  Then we restart MySQL on the
> corrupt slave and things work out without too much difficulty.
> However, this has always seemed like a terrible way to restore a
> corrupt slave to me.  Is there a more elegant way to do it?
>
> Regards,
> Michael Jeung
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Re: How can I observe mysqld?

[mysql]

Check this GUI out for monitoring running processes.

http://www.student.nada.kth.se/~f91-men/qps/

It will show you the connection parameters passed to the 
mysqld daemon.

I've had a terrible time trying to work out whether mysqld 
was actually running or not.The error messages are not too 
helpfull when trying to connect to the server.

I also found it very usefull to know if mysqld was actually 
running.

Sometimes, I would start mysql via mysqld_safe. But I 
noticed using qps that mysqld_safe was running, but it 
failed to start the mysqld!

I don't bother using mysqld_safe anymore - apache doesn't 
need a wrapper script like mysqld_safe. If Apache stops 
running, then it doesn't matter if mysqld is still running 
or not - you won't connect to mysqld via a web application.

Regards 

keith


On Tue, 7 Mar 2006, Karl Schock wrote:

> To: mysql@lists.mysql.com
> From: Karl Schock <[EMAIL PROTECTED]>
> Subject: Re: How can I observe mysqld?
> 
> Hello Keith,
> 
> > The web applications below will allow you to connect to and 
> > monitor and administer MySQL databases.
> > 
> > http://www.phpmyadmin.net/home_page/index.php
> 
> it helps a lot when MySQL is running. Thank you.
> But when "mysqladmin --user=x --password=y ping" says that
> the "connect failed" even phpmyadmin doesn't work anymore.
> 
> Do you know programs like tcpdump to monitor a network interface
> or top to watch the processes on a linux host? Is there a similar
> program to observe mysqld? I would like to use it. Or can I do
> that with phpmyadmin but I don't know it?
> 
> Bye
> Karl

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

RE: How can I observe mysqld?

[Ryan Stille]

> What else can I do to observe myslqd?

mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/

-Ryan

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

Re: How can I observe mysqld?

[Karl Schock]

Hello Daniel,

> > To find the reason causing the problem I started mysqld with the
> > "--log"-option and the "--log-error"-option ...
> 
> Try --log-warnings, so you know about ...

I will have a look at the documentation and - if possible - I will
even try "--log-everything". ;-)

> Also try lowering the timeouts for connections...

The value is 5 at the moment. I will lower it. Thank you.

Bye
Karl



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

Database Corruption and MySQL

[Michael Jeung]

Hi Folks,

We've got a Single Master/Multiple Slave environment.
Recently, we had some corruption on one of the slaves and I had to  
repair the affected tables.


After the repair completed, some of the rows on the slave had been  
deleted - so the Master and the Slave weren't exactly in synch.  The  
slave was missing some records.   I verified this myself with a  
select count(*) on the table.


Now, I know this is the normal way for MySQL to repair it's database.

However, what I'd like to do is restore these missing rows to the  
Slave without doing a dump and reload from my backups.  Is this  
possible?


The way that we normally approach this problem is to take an  
unaffected slave and copy the mysql directory from an unaffected  
slave over to the corrupt slave.  Then we restart MySQL on the  
corrupt slave and things work out without too much difficulty.   
However, this has always seemed like a terrible way to restore a  
corrupt slave to me.  Is there a more elegant way to do it?


Regards,
Michael Jeung

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

Re: How can I observe mysqld?

[Karl Schock]

Hello Keith,

> The web applications below will allow you to connect to and 
> monitor and administer MySQL databases.
> 
> http://www.phpmyadmin.net/home_page/index.php

it helps a lot when MySQL is running. Thank you.
But when "mysqladmin --user=x --password=y ping" says that
the "connect failed" even phpmyadmin doesn't work anymore.

Do you know programs like tcpdump to monitor a network interface
or top to watch the processes on a linux host? Is there a similar
program to observe mysqld? I would like to use it. Or can I do
that with phpmyadmin but I don't know it?

Bye
Karl



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

Re: How can I observe mysqld?

[Karl Schock]

Hello,

> how can I see the value of max-connections

I found it in phpmyadmin. It is 100.

> Can I set max-connections? If so: where can I set it? In /etc/my.cnf?

I found the answer in the mysql-documentation. RTFM I know. ;-)

Bye
Karl


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

Re: locking federated table not possible?

[Sebastian Mork]

no ideas?
--
Sebastian Mork
[EMAIL PROTECTED]
--

On Mon, 06 Mar 2006 19:46:53 +0100
Sebastian Mork <[EMAIL PROTECTED]> wrote:

> Hi,
> is it not possible to lock federated tables (creating a lock on the remote 
> machine to lock the table on the machine containing the data?)
> 
> I've a situation where I have some different databases on different servers 
> but they share a small amount of tables that are physically stored on only 
> one machine.
> the other (remote) servers use these table as federated tables.
> 
> on the server where the data is stored physically in a myIsam-table I can 
> lock the table, insert some data and unlock it.
> I've made some tests where I create a write lock, then call 1 queries to 
> insert some data (when starting these queries I created a new request that 
> tries to insert data) then the first request unlocks the table and the second 
> request runs when the unlock is done. great.
> but when I try to run a lock on a federated table it has no effect, I try to 
> lock the table, insert 1 rows and unlock the table again. but when I'm 
> running a second request while the 1 rows are inserted the second request 
> doesnt wait for the table to be unlocked, the data is inserted while the 
> first request is made.
> 
> here is my request thats starting first: (some pseudo-style code)
> ---
> lock tables tbl_lager write;
> do from 1 to 1
> INSERT INTO `tbl_lager` (`fld_pid`) VALUES ('1');
> end do
> unlock tables;
> unlocked at #now()#
> 
> and heres the second that starts when the first is running:
> ---
> lock tables tbl_lager write;
> INSERT INTO `tbl_lager` (`fld_pid`) VALUES ('1');
> unlock tables;
> unlocked at #now()#
> 
> 
> doing this local ob the server where the data is stored physically it works 
> fine.
> but on the federated table it doesn't work.
> 
> Any comments would be great. thx.
> -- 
> Sebastian Mork <[EMAIL PROTECTED]>
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
Sebastian Mork <[EMAIL PROTECTED]>


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

Re: How can I observe mysqld?

[mysql]

The web applications below will allow you to connect to and 
monitor and administer MySQL databases.

http://www.phpmyadmin.net/home_page/index.php
Check out the DEMO link in the top menu bar, RHS.

Or there is the MySQL Administrator at:

http://www.mysql.com/products/tools/administrator/index.html
Check out the Tutorial Movie at the top of the RH column.

Regards 

Keith Roberts

In theory, theory and practice are the same;
In practice they are not. 

On Tue, 7 Mar 2006, Karl Schock wrote:

> To: mysql@lists.mysql.com
> From: Karl Schock <[EMAIL PROTECTED]>
> Subject: How can I observe mysqld?
> 
> Hello, 
> 
> my problem: I run a phpbb-Forum with a mysql database on a linux
> server. 
> Every 5 - 7 days the mysql database runs in a vicious circle: 
> 
> "mysqladmin --user=x --password=y ping" says that the "connect failed". 
> The socket /var/lib/mysql/mysql.sock is there. 
> "ps aux | grep mysqld" shows me some mysqld-processes. But one of them 
> is marked as "". 
> 
> To find the reason causing the problem I started mysqld with the 
> "--log"-option and the "--log-error"-option as recommended by others
> to me at forums.mysql.com.
> Now I have a log-file, but as far as I can judge it there 
> are no error-messages in the log-file but only innocent queries.
> The mysqld.err-log-file is allways empty (0 Bytes).
> 
> What else can I do to observe myslqd?
> 
> If this mailing list is not the right place to ask such
> questions please let me know.
> 
> Bye
> Karl
> 
> 
> -- 
> 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: How can I observe mysqld?

[Karl Schock]

Am Dienstag, den 07.03.2006, 11:30 -0500 schrieb Kishore Jalleda:

Hello Kishore,

> May be the mysqld server has exceeded max-connections, and is therefore not
> able to serve any clients

how can I see the value of max-connections and how can I see how many
connections are active at the moment?
Can I set max-connections? If so: where can I set it? In /etc/my.cnf?

> ( but you should have a log for that)

There are no messages like "max-connections exceeded" in the log files.

> is this your server

Yes, it is.

> and does this happen at peak times

No it doesn't and I think the server is not very busy
all the day. It is only a small forum with usually 5 to
10 visitors at the same time.
"mysqladmin status" says "Queries per second avg: 0.7"
for example. I think that is not very much or is it?

> and what happens after the circle, mysqld just dies 

Yes.

Bye
Karl



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

Re: How can I observe mysqld?

[Daniel da Veiga]

On 3/7/06, Karl Schock <[EMAIL PROTECTED]> wrote:
> Hello,
>
> my problem: I run a phpbb-Forum with a mysql database on a linux
> server.
> Every 5 - 7 days the mysql database runs in a vicious circle:
>
> "mysqladmin --user=x --password=y ping" says that the "connect failed".
> The socket /var/lib/mysql/mysql.sock is there.
> "ps aux | grep mysqld" shows me some mysqld-processes. But one of them
> is marked as "".
>
> To find the reason causing the problem I started mysqld with the
> "--log"-option and the "--log-error"-option as recommended by others
> to me at forums.mysql.com.
> Now I have a log-file, but as far as I can judge it there
> are no error-messages in the log-file but only innocent queries.
> The mysqld.err-log-file is allways empty (0 Bytes).

Try --log-warnings, so you know about aborted clients too, this app
accessing your server, does it close the connection in a proper way?
If it doesn't, then you would get a fine list of a lot of dead
clientes using your slots, and being disconnected when the timeout
reaches the max, that would explain why it may function for a few days
then crash, because the number of zumbi connections become larger than
the timeouts and mysql is not killing them fast enough.

Again, this is just a theory...

Also try lowering the timeouts for connections...

>
> What else can I do to observe myslqd?
>
> If this mailing list is not the right place to ask such
> questions please let me know.
>
> Bye
> Karl
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--

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

Re: Is MySQL is expected to support these in the future?

[SGreen]

"J A" <[EMAIL PROTECTED]> wrote on 03/07/2006 12:31:57 PM:

> 1.   Support for N-types for the future. UNICODE support for NCHAR, 
NCLOB and 
> NVARCHAR datatypes
> 2.   Support for UCS-2 or UTF-16 for future.
> 3.   Support for N-types in Stored Procedures
> 4.   Automatic translation of N-type to SP’s Unicode
> 5.   Embedded database server within a client application.
> 
> _
> On the road to retirement? Check out MSN Life Events for advice on how 
to 
> get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
> 
> 

I don't know where you are getting your information. Most of this is 
already done!!!

1. Please see:
http://dev.mysql.com/doc/refman/5.0/en/charset-national.html

2. Please see (UCS-2... don't know about UTF-16):
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html?ff=nopfpls

3. AFAIK - All character sets and collations are supported within stored 
procedures.

4. Please see:
http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html

5. Please see:
http://dev.mysql.com/doc/refman/5.0/en/libmysqld.html

Please, next time check the online documentation first

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Is MySQL is expected to support these in the future?

[J A]

1.	Support for N-types for the future. UNICODE support for NCHAR, NCLOB and 
NVARCHAR datatypes

2.  Support for UCS-2 or UTF-16 for future.
3.  Support for N-types in Stored Procedures
4.  Automatic translation of N-type to SP’s Unicode
5.  Embedded database server within a client application.

_
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement



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

Re: Merge tables: how to get the "insert_method"?

[SGreen]

"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 10:46:58 AM:

> Hello Shawn,
> 
> Thanks for replying.
> 
> INSERT_METHOD is an option valid for merge tables.
> See http://dev.mysql.com/doc/refman/5.0/en/create-table.html
> 
> From what I can see, the only way to get it, is parse the 
> SHOW CREATE TABLE output.
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & 
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>   "Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 09:57:17 
AM:
> 
>   > Hi,
>   > 
>   > Anyone got a clue where to get a hold of "insert_method"
>   > after creating the table?
>   > 
>   > Is the SHOW CREATE TABLE output the only way to
>   > get it?
> 
>   > 
> 
>   "insert_method" ?? 
> 
>   I thought I knew a little about databases and table design but 
> that's a new term for me. What does it mean and how would I apply it
> in order to modify a table's contents? 
> 
>   Shawn Green
>   Database Administrator
>   Unimin Corporation - Spruce Pine 
> 

Thank you very kindly. 

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: How can I observe mysqld?

[Kishore Jalleda]

May be the mysqld server has exceeded max-connections, and is therefore not
able to serve any clients ( but you should have a log for that), is this
your server, and does this happen at peak times, and what happens after the
circle, mysqld just dies 

Kishore Jalleda

On 3/7/06, Karl Schock <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> my problem: I run a phpbb-Forum with a mysql database on a linux
> server.
> Every 5 - 7 days the mysql database runs in a vicious circle:
>
> "mysqladmin --user=x --password=y ping" says that the "connect failed".
> The socket /var/lib/mysql/mysql.sock is there.
> "ps aux | grep mysqld" shows me some mysqld-processes. But one of them
> is marked as "".
>
> To find the reason causing the problem I started mysqld with the
> "--log"-option and the "--log-error"-option as recommended by others
> to me at forums.mysql.com.
> Now I have a log-file, but as far as I can judge it there
> are no error-messages in the log-file but only innocent queries.
> The mysqld.err-log-file is allways empty (0 Bytes).
>
> What else can I do to observe myslqd?
>
> If this mailing list is not the right place to ask such
> questions please let me know.
>
> Bye
> Karl
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

Re: Problem INNODB error 995

[Heikki Tuuri]

Osvaldo,

Osvaldo Sommer wrote:

Heikki:

All servers have the auto upgrade on, so all the windows upgrade has been
install.


this is interesting. Error 995 might then be a hardware problem.


We have a raid 5 on all servers. Could that give a random error? We can try
a give a low format to the disks.

Osvaldo Sommer


Best regards,

Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up 
MyISAM tables

http://www.innodb.com/order.php



-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED] 
Sent: Lunes, 06 de Marzo de 2006 11:50 p.m.

To: mysql@lists.mysql.com
Subject: Re: Problem INNODB error 995

Osvaldo,

- Original Message - 
From: ""Osvaldo Sommer"" <[EMAIL PROTECTED]>

Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 07, 2006 12:58 AM
Subject: Problem INNODB error 995




--Boundary_(ID_PMYElD1sU13Il0ENO4J+aw)
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: 7bit

We have 4 windows 2003 server with mysql 4.0.12 install in each one. They
have been working for about 1.5 years with no problem.

Two weeks ago, in one server we lost the mysql service, and when we look 
the
.err file it report a 995 error. We can star the service again and it 
works.





In the two weeks the service has stop in the same server about 10 times, 
but

none in the other server. We have the same applications working in each
server.



What can we do to stop the error? We even thought that we have a problem
with windows, so we reinstall it, but the problem continue.



Please help



http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/
system_error_codes__500-999_.asp

"ERROR_OPERATION_ABORTED
995 The I/O operation has been aborted because of either a thread exit or an

application request"

a few InnoDB users have reported this error number in the past 2 years. I 
have suspected that it is some bug in Windows or its device drivers, since 
InnoDB does not request aborts of I/O requests, nor do InnoDB's threads exit


in the middle of an I/O operation.

Did you upgrade the OS in that server before you started getting this error?

Is the server identical to the other servers where mysqld works ok?

The error might actually be a hardware problem. I have noticed that a 
hardware fault can produce strange error numbers in Linux. The same might 
hold for Windows.




Osvaldo Sommer



Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables

http://www.innodb.com/order.php




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

RE: Problem INNODB error 995

[Osvaldo Sommer]

Heikki:

All servers have the auto upgrade on, so all the windows upgrade has been
install.

We have a raid 5 on all servers. Could that give a random error? We can try
a give a low format to the disks.

Osvaldo Sommer

-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED] 
Sent: Lunes, 06 de Marzo de 2006 11:50 p.m.
To: mysql@lists.mysql.com
Subject: Re: Problem INNODB error 995

Osvaldo,

- Original Message - 
From: ""Osvaldo Sommer"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 07, 2006 12:58 AM
Subject: Problem INNODB error 995


> --Boundary_(ID_PMYElD1sU13Il0ENO4J+aw)
> Content-Type: text/plain;
> charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> We have 4 windows 2003 server with mysql 4.0.12 install in each one. They
> have been working for about 1.5 years with no problem.
>
> Two weeks ago, in one server we lost the mysql service, and when we look 
> the
> .err file it report a 995 error. We can star the service again and it 
> works.
>
>
>
>
> In the two weeks the service has stop in the same server about 10 times, 
> but
> none in the other server. We have the same applications working in each
> server.
>
>
>
> What can we do to stop the error? We even thought that we have a problem
> with windows, so we reinstall it, but the problem continue.
>
>
>
> Please help

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/
system_error_codes__500-999_.asp

"ERROR_OPERATION_ABORTED
995 The I/O operation has been aborted because of either a thread exit or an

application request"

a few InnoDB users have reported this error number in the past 2 years. I 
have suspected that it is some bug in Windows or its device drivers, since 
InnoDB does not request aborts of I/O requests, nor do InnoDB's threads exit

in the middle of an I/O operation.

Did you upgrade the OS in that server before you started getting this error?

Is the server identical to the other servers where mysqld works ok?

The error might actually be a hardware problem. I have noticed that a 
hardware fault can produce strange error numbers in Linux. The same might 
hold for Windows.

> Osvaldo Sommer

Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables
http://www.innodb.com/order.php


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



-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 06/03/2006



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

Re: Merge tables: how to get the "insert_method"?

[Felix Geerinckx]

On 07/03/2006, [EMAIL PROTECTED] wrote:

> "insert_method" ?? 
> 
> I thought I knew a little about databases and table design but that's
> a new term for me. What does it mean and how would I apply it in
> order to modify a table's contents?


>From http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html:

"To create a MERGE table, you must specify a UNION=(list-of-tables)
clause that indicates which MyISAM tables you want to use as one. You
can optionally specify an INSERT_METHOD option if you want inserts for
the MERGE table to take place in the first or last table of the UNION
list. Use a value of FIRST or LAST to cause inserts to be made in the
first or last table, respectively. If you do not specify an
INSERT_METHOD option or if you specify it with a value of NO, attempts
to insert rows into the MERGE table result in an error."

-- 
felix

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

Re: Merge tables: how to get the "insert_method"?

[Martijn Tonies]

Hello Shawn,

Thanks for replying.

INSERT_METHOD is an option valid for merge tables.
See http://dev.mysql.com/doc/refman/5.0/en/create-table.html

>From what I can see, the only way to get it, is parse the 
SHOW CREATE TABLE output.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
  "Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 09:57:17 AM:

  > Hi,
  > 
  > Anyone got a clue where to get a hold of "insert_method"
  > after creating the table?
  > 
  > Is the SHOW CREATE TABLE output the only way to
  > get it?
   
  > 

  "insert_method" ??   

  I thought I knew a little about databases and table design but that's a new 
term for me. What does it mean and how would I apply it in order to modify a 
table's contents? 

  Shawn Green
  Database Administrator
  Unimin Corporation - Spruce Pine 

Re: Merge tables: how to get the "insert_method"?

[SGreen]

"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 09:57:17 AM:

> Hi,
> 
> Anyone got a clue where to get a hold of "insert_method"
> after creating the table?
> 
> Is the SHOW CREATE TABLE output the only way to
> get it?
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS 
SQL
> Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> 
> 

"insert_method" ?? 

I thought I knew a little about databases and table design but that's a 
new term for me. What does it mean and how would I apply it in order to 
modify a table's contents?

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: INstalling DBD for mysql--Help needed

[Vinay]

Hello Guys,
 I was able to connect to mysql database using perl DBI.

I was using the wrong version of Perl on HP-UX to install the DBI and DBD.
There were two versions , 32 bit and 64 bit perl. by default the 32 bit perl
was picked up. I changed the path to 64 bit perl interpreter and the DBI
created 64 bit objects and I had to use right 64-bit flags for DBD::mysql
installation.


Thanks for all who helped

Vinay


- Original Message - 
From: "Jake Peavy" <[EMAIL PROTECTED]>
To: "MySQL" 
Sent: Friday, March 03, 2006 5:38 PM
Subject: Re: INstalling DBD for mysql--Help needed


On 3/3/06, Vinay <[EMAIL PROTECTED]> wrote:
>
> Hello,
>I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I
> have installed DBI successfully but having a hard time installing DBD for
> mysql on HP-UX.
> I am getting make errors while installing. I want to use perl to connect
> to mysql database.
>
>
> Any help appreciated,
>
> Thank you,
> vinay



how do you think we're going to help?  should I try to perform a Vulcan mind
meld with your server?  Or did you just want me to come over and fix it for
you?

I tell ya what - just give us your server IP, open up telnet, and provide
the root password.

we'll get that nasty DBD!

-jp



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

Merge tables: how to get the "insert_method"?

[Martijn Tonies]

Hi,

Anyone got a clue where to get a hold of "insert_method"
after creating the table?

Is the SHOW CREATE TABLE output the only way to
get it?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

Re: Merge tables: how to know the base tables?

[Prasanna Raj]

Oh yeah got it u meant UNION clause .
Still i have no idea about that i usally see it in show create tables 
statements .

Sorry :(

--Praj

On Tue, 7 Mar 2006 15:10:51 +0100
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> > Simple way is show table status; there is a column Type : value MRG_MyISAM
> is the base table.
> 
> No, that's not what I meant -- I meant, the merge
> table uses a UNION clause to get signal where it
> get it's data from.
> 
> Where can I get the sources for the merge table?
> That is, what is used in the UNION clause when
> creating it.
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> 
> > --Praj
> >
> > On Tue, 7 Mar 2006 14:02:44 +0100
> > "Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> >
> > > Hi there,
> > >
> > > How do you know what the sources are for a MERGE
> > > table?
> > >
> > > SHOW TABLE STATUS doesn't show it, as far as I
> > > can see?
> > >
> > > Is it really only available in SHOW CREATE TABLE?
> 
> 

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

Re: Select IP from Text Type

[Косов Евгений]

Hi, Ron.

I think REGEXP can help you..

http://dev.mysql.com/doc/refman/5.0/en/regexp.html


Im trying to select an IP from a TEXT (details) type field, which works if I do 
this:

select id from `table` where `details` like '%192.168.0.1%' :

But If I want any record with an IP in that TEXT type field it seems a little 
tricky.
I have tried:
select id from `table` where INET_ATON(details) BETWEEN INET_ATON('127.0.0.1') 
and
INET_ATON('192.168.0.2');
select id from `table` where INET_ATON(details) BETWEEN INET_ATON('%127.0.0.1%')
and INET_ATON('%192.168.0.2%');
select id from `table` where details BETWEEN INET_ATON('%127.0.0.1%') and 
INET_ATON('%192.168.0.2%');

For instance I know this IP (192.168.0.1) is in 14 different records, what I 
was hoping for is
a result like so doing a wildcard search for any IP in this text field.
+--+
| id |
+--+
|   66 |
|  148 |
 etc..
14 rows in set (0.01 sec)

Any other ideas on how I could do this? 
Ron





--
Regards,
Eugene Kosov

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

How can I observe mysqld?

[Karl Schock]

Hello, 

my problem: I run a phpbb-Forum with a mysql database on a linux
server. 
Every 5 - 7 days the mysql database runs in a vicious circle: 

"mysqladmin --user=x --password=y ping" says that the "connect failed". 
The socket /var/lib/mysql/mysql.sock is there. 
"ps aux | grep mysqld" shows me some mysqld-processes. But one of them 
is marked as "". 

To find the reason causing the problem I started mysqld with the 
"--log"-option and the "--log-error"-option as recommended by others
to me at forums.mysql.com.
Now I have a log-file, but as far as I can judge it there 
are no error-messages in the log-file but only innocent queries.
The mysqld.err-log-file is allways empty (0 Bytes).

What else can I do to observe myslqd?

If this mailing list is not the right place to ask such
questions please let me know.

Bye
Karl


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

Re: Innobase bought out by Oracle

[SGreen]

Dan Rossi <[EMAIL PROTECTED]> wrote on 03/07/2006 05:47:41 AM:

> yet just another multi-national gupling up its competitors, i stumbled 
> across this blog 
> http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys- 
> innodb.html and had no idea, its just as bad the the latest Eola patent 
> case against microsoft and others its getting out of hand. What are 
> going to be the effects on the development of Mysql if oracle is going 
> to own the company that supply Innodb ?
> 
> 

As of the most recent official comments from those in the know (the actual 
principals involved in negotiations), there is no anticipated impact on 
either InnoDB or MySQL. 

The worst case scenario is that the development and support of InnoDB 
forks into two versions. One stays within Oracle's realm the other belongs 
to the community. InnoDB is still open source and I have heard of no 
intent to change that status.

There have also been rumors of other open-source developers trying to 
develop more database engines. Perhaps one of them will surpass InnoDB and 
take over as the preferred transactional engine.

Basically, it's still business as usual; only it's with a different 
businessman.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Select IP from Text Type

[Ron McKeever]

Im trying to select an IP from a TEXT (details) type field, which works if I do 
this:
select id from `table` where `details` like '%192.168.0.1%' :

But If I want any record with an IP in that TEXT type field it seems a little 
tricky.
I have tried:
select id from `table` where INET_ATON(details) BETWEEN INET_ATON('127.0.0.1') 
and
INET_ATON('192.168.0.2');
select id from `table` where INET_ATON(details) BETWEEN INET_ATON('%127.0.0.1%')
and INET_ATON('%192.168.0.2%');
select id from `table` where details BETWEEN INET_ATON('%127.0.0.1%') and 
INET_ATON('%192.168.0.2%');

For instance I know this IP (192.168.0.1) is in 14 different records, what I 
was hoping for is
a result like so doing a wildcard search for any IP in this text field.
+--+
| id |
+--+
|   66 |
|  148 |
 etc..
14 rows in set (0.01 sec)

Any other ideas on how I could do this? 
Ron

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

Re: Logging (wrong) passwords by mysqld

[Mark Matthews]

Manuel Schmitt (manitu) wrote:

Hi,

I'am searching for a way to have mysqld log all passwords which clients
are using ("trying") while connecting.

As to the documentation and to my trials neither the error log nor the
general query log contain passwords, only the usernames.

I already tried to get them via ethereal, but this should not work with
encrypted connections.

Any help would be appreciated.

Thanks
Manuel



Manuel,

The password isn't passed to the server only a one-way hash of the 
password is, so it can't be logged.


-Mark

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

Re: Merge tables: how to know the base tables?

[Martijn Tonies]

Hi,

> Simple way is show table status; there is a column Type : value MRG_MyISAM
is the base table.

No, that's not what I meant -- I meant, the merge
table uses a UNION clause to get signal where it
get it's data from.

Where can I get the sources for the merge table?
That is, what is used in the UNION clause when
creating it.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> --Praj
>
> On Tue, 7 Mar 2006 14:02:44 +0100
> "Martijn Tonies" <[EMAIL PROTECTED]> wrote:
>
> > Hi there,
> >
> > How do you know what the sources are for a MERGE
> > table?
> >
> > SHOW TABLE STATUS doesn't show it, as far as I
> > can see?
> >
> > Is it really only available in SHOW CREATE TABLE?


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

Re: MySQL InnoDB Row insert Calculation

[Ady Wicaksono]

Resend,

Anybody please give me information about different insert performance 
between MySQL 5.0.18 and MySQL 4.1.18

as my posting at

http://forums.mysql.com/read.php?22,74279,74279

Thank your


Heikki

Please see my testing result on MySQL Forum

http://forums.mysql.com/read.php?22,74279,74279#msg-74279

I need explanation about this issue :)


Heikki Tuuri wrote:


Ady,

- Original Message - From: "Ady Wicaksono" 
<[EMAIL PROTECTED]>

Newsgroups: mailing.database.myodbc
Sent: Monday, March 06, 2006 5:32 PM
Subject: MySQL InnoDB Row insert Calculation


With autocommit=1, anybody could give calculation on how many rows 
could

be inserted in 1 seconds?




I am assuming that you perform a COMMIT after each insert.

If the computer does not have a battery-backed disk cache, then the 
commit speed is limited by the disk rotation speed, which is at most 
250 rotations per second nowadays.


If the computer does have a battery-backed disk cache (or you take 
the risk and use a non-battery-backed cache), then the speed is 
limited by the CPU usage, and for big tables by the disk seek time.


If the insertion is CPU-bound, you normally can insert 3000 rows per 
second, or more.


For a big table, several gigabytes or more, inserts to secondary 
indexes may require disk seeks, limiting the maximum insert speed to 
100 rows per second, or less.


Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up 
MyISAM tables

http://www.innodb.com/order.php










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

Re: Merge tables: how to know the base tables?

[Prasanna Raj]

Hi 

Simple way is show table status; there is a column Type : value MRG_MyISAM is 
the base table.

--Praj

On Tue, 7 Mar 2006 14:02:44 +0100
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:

> Hi there,
> 
> How do you know what the sources are for a MERGE
> table?
> 
> SHOW TABLE STATUS doesn't show it, as far as I
> can see?
> 
> Is it really only available in SHOW CREATE TABLE?
> 
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
> 
> 

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

Merge tables: how to know the base tables?

[Martijn Tonies]

Hi there,

How do you know what the sources are for a MERGE
table?

SHOW TABLE STATUS doesn't show it, as far as I
can see?

Is it really only available in SHOW CREATE TABLE?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

Re: selecting records newer than say 20 min

[Gregory Machin]

Hi
Thanks for you support hope you have a grate day ..

On 3/7/06, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
> Hello Gregory,
>
>
> > What, is the easest way to select all the records created in the last 20
> min
> > stay based on a column that has a timestamp record.
>
> select * from mytable
> where some_timestamp > date_add(current_timestamp, interval -15 minute)
>
> Martijn Tonies
> Database Workbench - development tool for MySQL, and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>


--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support and admin)

+27 72 524 8096

Re: selecting records newer than say 20 min

[Martijn Tonies]

Hello Gregory,


> What, is the easest way to select all the records created in the last 20
min
> stay based on a column that has a timestamp record.

select * from mytable
where some_timestamp > date_add(current_timestamp, interval -15 minute)

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


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

Re: selecting records newer than say 20 min

[Косов Евгений]

Hi, Gregory

Hmm.. I think you just should add something like 'create_time > 
DATE_SUB(NOW(), INTERVAL 20 MINUTE)' to a where clause of your query. Or 
something similar..


You can find more at 
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.


Also consider creating of an index on your timestamp field, if your 
table is large.




Hi
What, is the easest way to select all the records created in the last 20 min
stay based on a column that has a timestamp record.

Many Thanks

--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support and admin)

+27 72 524 8096


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

Instance manager and starting instances on demand

[Giuseppe Maxia]

When setting up several instances in the instance manager, if you don't want 
them all to start at once, but you want to
start instances on demand (like when you have instances of different MySQL 
versions) the only way I found to achieve
this goal is is to set the option "nonguarded".
Then, when you start the instance with "START INSTANCE name", it starts, but 
the IM does not monitor it. Justly so,
because of the nonguarded option.
So before submitting a bug (or feature request) report, my questions are:

1) Is this the correct way of setting several instances and firing them on 
demand?
2) Can I revert the effects of nonguarded? I tried with UNSET 
instance_name.nonguarded, but it does not have any effect.

Thanks for any help.
Giuseppe

-- 
 _  _ _  _
(_|| | |(_|><  The Data Charmer
 _|
http://datacharmer.blogspot.com/


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

Re: selecting records newer than say 20 min

[Marco Simon]

select * from table where mytimestamp > (unix_timestamp - 20) ??

Gregory Machin schrieb:
> Hi
> What, is the easest way to select all the records created in the last 20 min
> stay based on a column that has a timestamp record.
>
> Many Thanks
>
> --
> Gregory Machin
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> www.linuxpro.co.za
> www.exponent.co.za
> Web Hosting Solutions
> Scalable Linux Solutions
> www.iberry.info (support and admin)
>
> +27 72 524 8096
>   


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

Innobase bought out by Oracle

[Dan Rossi]

yet just another multi-national gupling up its competitors, i stumbled  
across this blog  
http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys- 
innodb.html and had no idea, its just as bad the the latest Eola patent  
case against microsoft and others its getting out of hand. What are  
going to be the effects on the development of Mysql if oracle is going  
to own the company that supply Innodb ?



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

Re: Boolean searches on InnoDB tables?

[Gabriel PREDA]

*MySQL Manual - Chapter 12.7.4. Full-Text Restrictions* says: *Full-text
searches are supported for MyISAM tables only. *

You could try to do what i did... with some overhead... I also had InnoDB
tables for an application and also was in a great need of Full-Text
Searches.

I made a mirror MyISAM table but with the full text index. The full text
searches were performed on the MyISAM tables. The inserts were done on both
tables.

Now depending on the size of the tables you have to do a sync. of the tables
or complete reconstruction of the MyISAM table. Despite the fact that
inserts were done on the both tables I also did a sync. every Sunday ( I had
the smallest traffic on Sundays) and a complete reconstruction of the table
every 2 months... ( MyISAM table - is now 750 MB )

The system is working fine for about 16 months now !

--
Gabriel PREDA
Senior Web Developer

Re: offset or skip_count

[Косов Евгений]

Hi, Rich.

What is skip_count? I couldn't find any reference to it in mysql 
documentation.


I'm not sure I understood your question, but I beleive you're asking for 
LIMIT modifier.



SELECT * FROM $table LIMIT $offset, $record_count;

or

SELECT * FROM $table LIMIT $record_count OFFSET offset;



Hi folks.

I'm wanting to provide some safety for a search.  I'll be grabbing about 
45 fields, and perhaps thousands of records, so that I can build an xml 
file using my middleware.  How can I structure an SQL statement so that 
I can jump through records 100 at a time?  Do I use offset or skip_count?


Cheers




Regards,
Eugene Kosov.

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

offset or skip_count

[Rich]

Hi folks.

I'm wanting to provide some safety for a search.  I'll be grabbing about 
45 fields, and perhaps thousands of records, so that I can build an xml 
file using my middleware.  How can I structure an SQL statement so that 
I can jump through records 100 at a time?  Do I use offset or skip_count?


Cheers

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