RE: MySQL Secure Connection(e.g. SSL) Question

[Greg . Cope]

Ah

I did not know that.  Excellent.

Still does not get round the issue that MySQL in most default binary
distributions does not include SSL.  Which I think is a shame, but then
again is probably a lib issue.

Thanks for that.

Greg

> -Original Message-
> From: Eamon Daly [mailto:[EMAIL PROTECTED]
> Sent: 25 August 2004 19:28
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL Secure Connection(e.g. SSL) Question
> 
> 
> FYI, DBD::MySQL does support SSL. See
> 
> http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm
> 
> and search for mysql_ssl. You'll need to provide
> 
> mysql_ssl_client_key
> mysql_ssl_client_cert
> mysql_ssl_ca_file
> 
> as part of the DSN on the perl side, and set ssl-ca,
> ssl-key, and ssl-cert on the server.
> 
> There's more on the subject at mysql.com:
> 
> http://dev.mysql.com/doc/mysql/en/Secure_requirements.html
> 
> 
> Eamon Daly
> 
> 
> 
> - Original Message - 
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 24, 2004 11:12 AM
> Subject: RE: MySQL Secure Connection(e.g. SSL) Question
> 
> 
> > > I need to connect to a remote MySQL database from a PC using
> > > SSL. I would
> > > prefer to connect using perl DBD. Does anyone have a
> > > suggestion how I can
> > > accomplish this task or an alternative solution?
> >
> > What about stunnel or ssh tunnels and then use DBD::mysql on top.
> >
> > ISTR that DBD::mysql cannot use SSL'ed mysql client 
> connections and your
> > remote server would have to be complied to support it.
> >
> > Greg
> >
> > >
> > > Thank You
> > >
> > >
> > > -- 
> > > 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]
> 
> 

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

RE: MySQL Secure Connection(e.g. SSL) Question

[Greg . Cope]

> I need to connect to a remote MySQL database from a PC using 
> SSL. I would
> prefer to connect using perl DBD. Does anyone have a 
> suggestion how I can
> accomplish this task or an alternative solution?

What about stunnel or ssh tunnels and then use DBD::mysql on top.

ISTR that DBD::mysql cannot use SSL'ed mysql client connections and your
remote server would have to be complied to support it.

Greg

> 
> Thank You
> 
> 
> -- 
> 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: time out factor ofMySQL

[Greg . Cope]

> 
> hi all,
>  
> i'm developing a web based application under r-g linux 9 with 
> MySQL 3.23.54a-11. i have planned to upgrade it to 4.0.20. it 
> seems that if i keep the current version of MySQL running for 
> more than 8 hrs, it times out with the web-server (tomcat 
> 4.x) and dies out. due to this, i have had inconveniences 
> using MySQ in my project. i have to restart the mysql server 
> after every 7-8 hrs if i have to keep the application running 
> for a longer time. can anybody please help me out with 
> increasing the time-out factor of MySQL.

Search the manual for timeout - interactive_timeout seems to be the thing
you need to change.

Greg

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

RE: MySQL Administrator certain options only valid at localhost

[Greg . Cope]

A probable reason is that these are in startup files and hence the interface
needs file system access.

AFAIAA There are plans to have dynamic settings that can be changed at
runtime, but these are still plans.

No idea on the rest of it thou.

Neat tool, and looks great!  Like the backup tools.  The scheduled bit of
this is blank on mine so I assume that this is a bug as it should display
the "Local host only" message.

Greg 

> -Original Message-
> From: Iago Sineiro [mailto:[EMAIL PROTECTED]
> Sent: 13 February 2004 12:10
> To: MySql Mail List
> Subject: MySQL Administrator certain options only valid at localhost
> 
> 
> 
> Hi.
> 
> I've downloaded MySql Administrator 1.0.1a alpha for Windows 
> and tried it.
> 
> It has options only enabled if MySQL Admnistrator is 
> connected to localhost.
> I'm connected as root to other host (which is Linux). For example the
> Startup Variables. Some of these options are the most 
> interesting options
> and I want to use MySQL Administrator for connect to remote 
> hosts. These
> remote hosts are Linux that could be in the same LAN but that 
> doesn't have X
> server installed.
> 
> What is the reason for this? In the future these options will 
> be enabled?
> 
> Iago.
> 
> 
> 
> -- 
> 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]

Binary dist of 3.23.43 ok, 4.0.0 alpha fails to start

[Greg Cope]

Dear All

I've reverted back to 3.23.43 from 4.0.0 as I was unable to get it to
start on my (patched) Redhat 6.2 box.

Has anyone else managed to get the binary distro of 4.0.0-alpha  to
start on a Redhat 6.2 box ?

Thanks

Greg

sql

-
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

bug (+ fix) in mysql_config ! breaks DBD::Mysql

[Greg Cope]

Dear Mysqlers

mysql_config in the linux binary distro appears to have two similar bugs
...

When run it returns:

Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags[-I'/usr/local/mysql/include/mysql']
--libs  [-static -L'/usr/local/mysql/lib/mysql'
-lmysqlclient -lz -lcrypt -lnsl -lm ]
--socket[/tmp/mysql.sock]
--port  [3306]
--version   [3.23.42]

Yet it should return:

Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
Options:
--cflags[-I'/usr/local/mysql/include']
--libs  [-static -L'/usr/local/mysql/lib/' -lmysqlclient
-lz -lcrypt -lnsl -lm ]
--socket[/tmp/mysql.sock]
--port  [3306]
--version   [3.23.42]

I.e its tacking on mysql onto the end of the cflags and libs lines.

This is a simple two line fix - hence I'm not attaching a patch.

This breaks things that use mysql_config (eg perl's DBD::Mysql modules
installer thingy).

Thanks.

Greg

-
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: XML Support

[Greg Cope]

Gary Huntress wrote:
> 
> In the past few days 3 different people have asked me about "xml support" in
> mysql.  I was unsure what to tell them actually, beyond saying "you can
> easily export recordsets to xml documents".Obviously you can store
> entire XML documents in a TEXT field, but I'm not sure thats really the
> functionality that they want.

Ah! - buzywords, when you filter them out you are left with a markup,
data descritption and somewhere to keep it - and in many cases that will
be a RDBMS, although most people use one by default. 

> Actually the observation made was that MySQL and PostgreSQL might be falling
> behind the commercial databases in terms of native XML support.  Oracle,
> MSSQL, and Sybase (probably DB2 as well since IBM is pretty big in the XML
> arena) already have some type of support.

Not falling behind, just less buzyword compliant.

To me XML and a DOM tree are not the same as relational data.  If your
data is not relational why use a RDBMS ?

> 
> I think XPath support in Selects might be a good place to start.
> 
> So basically, is anything in the works for XML?
> 

No idea, but this was discussed on the list a few months ago - check the
archives as I think a few MySQL chipped in.

Sorry if this sounds a little negative and sarcastic, but I've delt with
a few projects where it got over complicated because of the use of
XML/XSLT, and managers whom want to use a product because its got nive
brochures and buzwords .

Greg Cope

> Regards,
> Gary "SuperID" Huntress
> ===



-
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: Replication advice needed...

[Greg Cope]

Jeremy Zawodny wrote:> 
> On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
> >
> > The other solution is rsync.  I dont know much about this guy yet,
> > but I have some concerns with using it to copy over large remote
> > files.  For example, if I have a 1.2 gig table that has been heavily
> > modified over a weeks work, how reliable is the remote file after
> > rsync?  I guess Im just concerned about data integrity.
> 
> I've never had rsync corrupt data, and we routinely push around
> gigabytes per day (as a company) using rsync.
> 

Is this rsync over ssh ?

I've had a few problems with rsync over ssh with mysql files.  Althought
the size of the files appeared to be the problem, not the fact they were
mysql files.

In the end it made no difference, and the tables were often created on
the fly for an update, and myisampk'ed - so rsync could not see and
similarities and ended up copying the lot.

Greg

> 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.41-max: up 8 days, processed 106,728,794 queries (140/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

-
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: backup/restore of mysql

[Greg Cope]

Pete Kuczynski wrote:
> 
> Hi,
> I've posted this question before, and some were kind enough to respond
> with suggestions to my question [replication], but I'm looking for
> something more difinitave.
> 
> Background: I'm running a production mysql database/php4/Apache on a NT4
> IBM Netfinity server [3500 records, growing by 100 a day or so]. I do
> not have the option to go to lunux/unix [company's call not mine].
> I am backing up the database twice a day, noon and 6 pm.
> 
> Question: if a disk should crash, I can recover the database from the
> last tape backup, but not the transactions that took place in between.
> Is replacation of the database on another box my only option?
> Dosn't mysql support transaction logging like MSSQL or Oricle, or
> Postgres?.

Yes it does - look for update log in the manual.

But if a disk gets toasted what are you going to do then (with any
system) ?

> 
> I don't wan't to switch to another database, but as this one grows, it's
> becoming incrisingly important to be able to do a complete database
> recovery in the event of a crash.

Use a proper operating system, with RAID (either hardware or software
RAID 1, or 5)

Greg


> 
> Kindest thanks!
> 
> Pete
> 
> --
> ___
> Pete Kuczynski
> Sr. Field Engineer
> DHL Airways Inc.
> Infrastructure Technology & Services
> (773)-462-9758
> 24/7 Helpdesk 1-800-434-5767
> 
>   
> -
> 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

Binding to one IP address on a multihomed host

[Greg Cope]

Dear All

I want to bind mysqld to one IP address on a multi-homed host.

A search of the manual has not revealed anything - have I missed
something or is this not an option ?

If its not an option can it be added ?

Thanks

Greg

-
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: Error 127?

[Greg Cope]

Cesar Cabrera wrote:
> 
> Hello and thanks,
> 
> can you tell me where can I get information about the errors
> presented by MySQL? I have that kind of trouble each time the server (the
> machine) crash and it's no solved after myisamchk with any option.
> 

a) perror [error number]
b) MySQL manual
c) What have you done with myisamcheck and have you tried either -r or
-o as arguments - Read the very good manual if if do not know what these
do.

Greg



> thanks again,
> 
> Cesar A. Cabrera E.
> --
> 'http://www.utp.edu.co/Lince/'
> 
> On Thu, 14 Jun 2001, Eric Persson wrote:
> 
> > It sounds like your table have been corrupt, this can result in data
> > loss. Try using isamchk to fix the problem.
> >
> > //Eric
> >
> > Cesar Cabrera wrote:
> > >
> > > Hello,
> > >
> > > what means an error 127 from table handler and an error 1030?
> > >
> > > where can I get documentation from that issues?
> > >
> > > Thanks for any help you can give me,
> > >
> > > Cesar A. Cabrera E.
> > > --
> > > 'http://www.utp.edu.co/Lince/
> > >
> > > -
> > > 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



-
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: $dbh->tables, SHOW tables, etc.

[Greg Cope]

Daniel wrote:
> 
> Scratch that, normally egcs and gcc are the same, at least on older
> redhat distros. Redhat 7.0 gives you compat-egcs package which isn't the
> same as your gcc.
> 
> I symlinked (on a 7.1 redhat box) egcs to gcc (2.96-69) and --rebuild
> 3.23.38 from the .src.rpm.
> Both show tables, show databases now work.
> 

I come across this problem - and its complier / optimisations related. 
gcc 2.92.3 + pgcc patches works OK for me. 2.92.3 plus optimisations is
can fail.

YMMY - but ditch 2.96 until its safe !

Greg


> Thanks for the heads up Colin.
> 
> Daniel wrote:
> 
> > I'm up to 3.23.37-1 (compiled with gcc 2.96-69).
> > Haven't had one work properly starting with 3.23.32.
> >
> > Gulp...It's been months now.
> >
> >
> > Thanks for the reply though,
> 
> --
> Daniel Bohling
> NewsFactor Network
> 
> -
> 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: ODBC for MySql with SSL

[Greg Cope]

Tonu Samuel wrote:
> 
> On 09 May 2001 09:43:59 +0100, Eugénio Veiga wrote:
> > Hi
> >
> > Does any body if is possible in windows 9x to implement odbc for MySql
> > with ssl ?
> > There exists any driver for this ?
> 
> Well, I do not know much about ODBC. But anyway if you tell "MySQL with
> SSL" then you mean my work on SSL support for MySQL which is in my
> laptop mostly ready and will be included in MySQL 4.0 soon. After that
> we will have "MySQL with SSL" and all client applications can use
> facilities of SSL. I personally do not know about ODBC driver and when
> this will be coded to use SSL. Anyway this can't be done before MySQL
> itself is ready for this.
> 

Will this code be used by the replication slave code ? Ie. have slaves
connecting over ssl ?

Looking forward to SSL clients though, thanks !

Greg

-
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: Rolling back of a transaction

[Greg Cope]

Sudhir wrote:
> 
> Hi,
> 
> I am a Sudhir, working as a Software Consultant in Unidux Technologies,
> Singapore.  My job here is to suggest Technology.  Now we are planning to
> purchase license for the application server JRun.  Currently we are
> developing a procurement engine in Java, using MySql as the data base
> server.  As per my database administrator, MySql don't have rolling back
> procedure for a transaction which is not to be committed.  With Oracle or
> MSSqlServer I can commit or rollback a transaction.  I mean I can control
> the transaction whether it has to be committed or rolled back.  Is it true
> that MySql don't have rollback.  We are planning to develop the engine using
> EJB and JTA.  If MySql does not have this rolling back, I fear we can not
> use JTA with MySql as back end.  So please inform me whether I can suggest
> MySql or not for developing the engine using EJB with JTA to my
> organization.
> 

RTFM

specifically DBD, Inobase, and Gemini.

It amazes me that people withh start / think about product developement,
without reading the (in this case excellent) manual.

Greg


> Thanks & Best Regards,
> 
> Venkata Sudhir Kurapati
> Software Consultant
> 64A, Horne Road,
> Singapore - 209072
> DID : +65 - 3914521
> Fax : +65 - 2962651
> 
> -
> 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: Speed and Hardware

[Greg Cope]

Andy Sharp wrote:
> 
> Hi,
> 
> I'm facing an issue with my primary mySQL server.  It powers a web site,
> which loads almost 100% dynamic data.  At peak times of the day, it
> seems to me that the Database is becomming maxxed.  (Thus bogging the
> site)
> 
> I'm aware that there are simply too many variables to completely answer
> this question - number of tables, size of tables, the queries
> themselves, system configuration, type of data, program code, etc..  but
> I'm hoping to get a ball park idea of the limitations of my current
> hardware.
> 
> The system is a Pentium 850, 1Gb Ram, Ultra-II SCSI Disks, 256 Mb Cache,
> running FreeBSD 4.1 and the binary copy of Mysql for FreeBSD.  (Had some
> unreleated problems with the thread libraries..)
> 
> The system averages 550 Queries per second, over the course of a normal
> week.  Most of these queries are what I'd describe as "average"  joins
> on a table of 5000 records to two tables of about 30,000 records.  If
> anything I've overindexed.  the database is a total of 100Mb, and the
> system typically has 0 disk usage.
> 
> During off peak times I'm getting great performance,  Fast -
> responsive.  During peak hours, the usage spikes to 700 to 900 Queries
> per second, the DB box doesn't thrash, it just slows down.  Perviously
> fast indexed queries start getting logged as slow, and even a lookup by
> primary key id can take 2 or 3 seconds.  I suspect the system is simply
> CPU bound.
> 
> So, the question is this:  Is the above usage, given an "average"
> database, ok code, and optimized queries, considered ok?  Or should I be
> looking for some kind of configuration/query problem?  Have I simply
> maxxed out my hardware?
> 
> I'm sure that further tuning may be able to squeeze more speed out of
> the hardware, but I'm looking for a speed boost of double (new site
> coming on line shortly). Yet before throwing more money on hardware (and
> the time to setup replication), I'd like to get some kind of 3rd party
> information saying "Your system is performing well enough, more tweaks
> will only give you a 10 to 20 percent boost."

You've not mentioned your my.cnf settings (which if you've tweaked then
great).

Also are thier concurrent inserts / updates going on ?

Whats "maxing" out mysql / proccessor or Disks ? Would more memory help
(bigger disk cache) ?

Anyone given more info, and a few benchmarks, you may be able to
increase performance - are your my.cnf settings ok ?   What else is
running on the box ?  Is their a RAID array ? etc 

However on a side note you have a problem in that with a dynamic site
your performance is ultimatley limited by the ammount of hardware you
can throw at the problem.

What about looking at caching any DB output locally on the webserver -
in 90% of cases like this people claim thier sites are dynamic, yet very
little is realtime, and alot can be cached locally.

Can you cache any data locally, even if the cache is refreshed every
minute or 5 minutes it may save alot of hits on the DB, yet your users
may never know the difference.

Obviously if your site needs to be realtime (games, financial etc ..)
then the above is a load of rubbish and get ready to go buy a bigger
box, or more boxes (and use replication).

Greg

> 
> For people running largish mySQL servers, what kind of hardware do you
> have to support a volume in the range of 2,000+ queries per second?
> 
> Thanks, I appreciate any time taken in answers.
> 
> --A
> 
> Ps: If I've missed any good references to this in documentation, please
> let me know - I haven't found a good reference for "what is good
> performance" in any searching.
> 
> -
> 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: Innobase in MySQL

[Greg Cope]

Peter Zaitsev wrote:
> 
> Hello Greg,
> 
> Saturday, March 17, 2001, 3:31:53 AM, you wrote:
> 
> GC> It would be very handy if Innobase (and the GEMINI when it comes along)
> GC> where to support mysqldump in the standard way, as I assume it works as
> GC> such and I and many others would have to change thier backup scripts.
> GC> Delayed index creation is very usefull (in saving time) in larger DB
> GC> loads via a mysqldump - Hiekki is this difficult ?
> 
> I as well as insertion speed is 90% limited by idex creation (at least
> for myisam) there could be an optimization generic for all table
> handlers, done on mysql level - at first to create tables without any
> keys, then insert all data in it and then run alter table to add all
> keys what should be in this table.
> 
> The only problem I see here - i don't know how innobase/bdb will
> handle tables without primary key... i think perfomance should not be
> so good as with myisam. Still  there is a possibility to load all data
> to myisam and then run alter table which adds all indexes required and
> then converts the table to format required on the same pass.
> 

Agreed, but it would be nice if this was automatic with mysqldump ?!

Although a gut feeling would be that create myisam table, insert, create
indexes, convert will be slower. 

Greg

> I'll try to do some benchmarks accordint to this to se if it does any
> speed improvement.


> 
> --
> Best regards,
>  Petermailto:[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

Re: Innobase in MySQL

[Greg Cope]

Michael Widenius wrote:
> 
> Hi!
> 
> Try:
> 
> mysqldump --tab=directory
> 
> This does basicly what you want.
> 
> After that, it's up to Heikki to fix Innobase to do delayed creation
> of indexes.

It would be very handy if Innobase (and the GEMINI when it comes along)
where to support mysqldump in the standard way, as I assume it works as
such and I and many others would have to change thier backup scripts. 
Delayed index creation is very usefull (in saving time) in larger DB
loads via a mysqldump - Hiekki is this difficult ?

Thanks all for your work.

Greg

> 
> Peter> At least it would be a standart way to quickly backup data and recover
> Peter> it for all table handlers (backup probably does not work for all tablr
> Peter> types yet)
> 
> Regards,
> Monty
> 
> -
> 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: MySQL 3.23.35 is released

[Greg Cope]

Michael Widenius wrote:
> 
> Hi!
> 
> 
> Greg> On the off chance any ideas when this (A Gemini THandler) 3.23.x release
> Greg> may be and when we might see a public 4.x alpha.  I know the answer will
> Greg> probably be "When its ready" but a small clue would be nice :-)
> 
> Lets guess a bit :)
> 
> 3.23.36 with GEMINI should happen within 2 weeks.
> 4.0-alpha should happen within 2 months.
> 
> Regards,
> Monty

Thanks Monty, your work is much appreciated  by me and many others.

I'm looking forward to a GEMINI 3.23.X and especially 4.0-alpha (when
thier ready)

Thanks again.

Greg

-
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 3.23.35 is released

[Greg Cope]

Michael Widenius wrote:
> 
> Hi!
> 
> The 3.23.35 mainly fixes a critical bug in 3.23.34 with ORDER BY.  We
> don't know how the ORDER BY bug slipped through our testing suite or
> how fatal it's really is, but as we have got a couple of reports about
> core dumps regarding this, we recommend 3.23.34 users to
> upgrade as soon as possible. Sorry for the inconvenience.
> 
> Changes in release 3.23.35
> --
> 
>* Fixed newly introduce bug in `ORDER BY'.
> 
>* Fixed wrong define `CLIENT_TRANSACTIONS'.
> 
>* Fixed bug in `SHOW VARIABLES' when using INNOBASE tables.
> 
>* Setting and using user variables in `SELECT DISTINCT' didn't work.
> 
>* Tuned `SHOW ANALYZE' for small tables.
> 
>* Fixed handling of arguments in the benchmark script
>  `run-all-tests'.
> 

Hi All

Thanks for this Monty - its a bit odd for me as only a few minutes ago I
put off upgrading to 3.23.34a as I thought you would be releasing
3.23.35 soon - que twilight zone music 

On a more serious note, am I right in thinking the .35 release with the
Gemini Table handler is moved to a .3x release  as would seem the case
?  

On the off chance any ideas when this (A Gemini THandler) 3.23.x release
may be and when we might see a public 4.x alpha.  I know the answer will
probably be "When its ready" but a small clue would be nice :-)

Thanks for all your work.

Greg

> Regards,
> Monty
> 
> -
> 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: Mysql directory

[Greg Cope]

Zoran Raskovic wrote:
> 
> so does the mysql have to be installed under
> /usr/local/mysql ?
> I made a symbolic link named mysql that points to the
> /usr/local/mysql-3.23.32-pc-linux-gnu-i686 directory
> is that ok ?

yup

I go further and seperate data from binaries.

This helps with partion structure (i.e big data partions (/var) vs
smaller binary ones (/usr).

Thus I have a datadir=/var/lib/mysql
and install dir / prefix =/usr/local/mysql-$version

When I do an upgrade its as simple as stoping one and starting the new
one.  If I need to rollback to an older version to due to an unforseen
problem then I just restart the old one.

Greg


> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great prices.
> http://auctions.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

-
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

show tables bug - minor update

[Greg Cope]

Dear All

The following C and CXX flags will work (/usr/local/bin/gcc is actually
pgcc).

Reading specs from
/usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs
gcc version pgcc-2.95.2.1 20001224 (release).

CC='/usr/local/bin/gcc'  CFLAGS='-O6 -mpentiumpro -mstack-align-double' 
CXX='/usr/local/bin/gcc'  CXXFLAGS='-O6 -mpentiumpro
-mstack-align-double -felide-constructors -fno-exceptions -fno-rtti'

This results in a decent binary.

C and CXX flags that are blank give an ok binary with gcc (default
redhat:)

Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release).

Now all I need to do is find some Ok flags for egc !

regards

Greg

-
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

More show databases / tables bug news ...

[Greg Cope]

Dear All

I got very excited today when 3.23.34 worked (i.e now show tables bug) !

I then recomplied with optimisations and then with pgcc and bug
reappears.

I am now having a go with different CFLAGS and CXXFLAGS.

Not being a C / complier / libs expert I can not comment any further !

How weird.

Greg

-
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: Poddible SHOW DATABASE || TABLE bug in 3.23.33

[Greg Cope]

[EMAIL PROTECTED] wrote:
> 

Whops !

This is the know bug, but I did mysqlbug on this machine a fwe weeks
ago, and have only just sorted out the mailserver today - and did not
notice this in the queue - appologies for wasting anyones time with
this.

As an aside has anyone got further than this being a possible glibc
issue ?

Greg

> >Description:
> SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list 
>of blanks - no of blank lines
> equals number of databases / tables)
> 
> >How-To-Repeat:
> Do a mysqlshow or SHOW DATABASES under mysql
> 
> >Fix:
> 
> >Submitter-Id:  
> >Originator:Greg Cope
> >Organization:
> 
> >MySQL support: none
> >Synopsis:  SHOW command possiblxky broken in 3.23.33
> >Severity:  non-critical
> >Priority:  low
> >Category:  mysql
> >Class: sw-bug
> >Release:   mysql-3.23.33 (Source distribution)
> 
> >Environment:
> 
> System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50 EST 2001 i686 
>unknown
> Architecture: i686
> 
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
> Compilation info: CC='gcc'  CFLAGS='-O3 -malign-double -ffast-math 
>-funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer'  
>CXX='c++'  CXXFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti 
>-fno-exceptions -march=pentiumpro -fomit-frame-pointer'  LDFLAGS=''
> LIBC:
> lrwxrwxrwx1 root root   13 Feb 13 10:46 /lib/libc.so.6 -> 
>libc-2.1.3.so
> -rwxr-xr-x1 root root  4101836 Jan 15 15:49 /lib/libc-2.1.3.so
> -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a
> -rw-r--r--1 root root  178 Jan 15 15:49 /usr/lib/libc.so
> Configure command: ./configure  --prefix=/usr/local/mysql-3.23.33 --enable-assembler 
>--with-mysqld-ldflags=-all-static --with-mysqld-user=mysql 
>--localstatedir=/var/lib/mysql --sysconfdir=/etc --with-extra-charsets=complex 
>--datadir=/var/lib/mysql --localstatedir=/var/lib/mysql --infodir=/usr/info 
>--mandir=/usr/man --without-debug --without-bench
> Perl: This is perl, version 5.005_03 built for i386-linux
> 
> -
> 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

Improving MySQL installation in ApacheToolbox - RFC

[Greg Cope]

Dear All

I've been using apachetoolbox - a shell script that installs apache with
the options of including lots of modules (php, mod_ssl, mod_perl etc
...).  Its great for installing a custom apache (something I do all to
often ;-).

It offers a menu and will download / configure / complie any need bits
and peices.

It will also install MySQL into a /usr/local/mysql.

I'm trying to improve this will the following "features":

- Add a mysql user and group (fail silently if they are already there).
- install into /usr/local/mysql-$VERSION (configureable)
- symlink /usr/local/mysql-$VERSION to /usr/local/mysql
- datadir is set to /var/lib/mysql
- run install_db
- Chown -R mysql:mysql /var/lib/mysql
- complie mysql in a similar way to how the "Offical" mysql binaries are
complied, here is my configure line:
--with-mysqld-ldflags=-all-static 
--with-mysqld-user=mysql 
--without-debug 
--without-bench 
--datadir=/var/lib/mysql
- enable assembler if on an i x86 platform
- enable tcpwrappers it libwrap is installed

I could change the CFLAGS as well for optimisations if thats handy.

If anyone thinks it would be handy I could make the datadir configurable
- but I do not want to pollute the thing with too many questions.

Has anyone any comments on this (the RFC bit ?) ?  Obviously this will
be a comprimise as alot of admins install stuff in different places, and
different platforms install things in different places.

This is not supposed to be a mysql installer - if you don't want to
complie from source then use the binaries or RPMS.  What this is
supposed to be is an improvement to the way apachetoolbox deals with
mysql.  Thats all.

Comments / suggestions welcome.

Greg

-
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: Dropped wrong DB. Can I recover?

[Greg Cope]

lounge fly wrote:
> 
> Wow, did I ever screw up.
> 
> I meant to drop an unused development database and ended up dropping a used
> production database.
> 
> Can I recover it?
> 
> If so, how?

Go find a backup ;-0

If you've not got any then you can, but it may not work, restore /
undelete files - their is a HOWTO on this, although its not simple, and
assumess that the files have not been overwriten (the undelete recovers
the inodes that point to the data).

If / when  you restore the DB you then go and instute a proper backup
procedure !

> 
> The server runs Linux.
> 
> Signed,
> Screwed
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com
   ^
No thanks.

Greg.

> 
> -
> 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: show databases|tables problem

[Greg Cope]

Paul DuBois wrote:
> 
> I've been reading the thread about SHOW DATABASES and SHOW TABLES
> returning lists of blank entries or no results.  Just out of curiosity,
> I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.23.33
> and found that suddenly I had the problem too!  However, then I remembered
> that I'd upgraded glibc in the meantime to deal with some other RPMs
> I installed that required a newer glibc.  So I went back and recompiled
> 3.23.32 and installed it.  Guess what?  I still have the problem.
> 
> glibc and glibc-common versions are 2.2-12 if that's relevant.  Based on
> the preceding information, I'd guess it's not a MySQL problem per se.

This makes alot of sense - as I never had the problem before my glibc
upgrade (from redhat errata).

If its any help I get this bug on glibc-2.1.3 on RedHat and Suse (both
have been upgraded from errata).

Thanks Paul.

Greg


> 
> --
> Paul DuBois, [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

-
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: Bug with 'show databases|tables'

[Greg Cope]

Canadian Lumberer wrote:
> 
> Hi,
> 
> I hope to be helpful for further investigation of the problem.
> 
> On Wed, Mar 07, 2001 at 08:20:16AM +0700, Eugene Lineitzev wrote:
> > >Description:
> >   I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
> > all 'show' commands doesn't works. They display empty tables.
> In my case error appeared in RedHat 6.2 with kernel 2.2.18. And on RedHat 7.0
> sources from www.mysql.com compliled and work pretty well.
> 
> > >How-To-Repeat:
> >  $ mysql
> >  mysql> show databases;
> >  +--+
> >  | Database |
> >  +--+
> >  |  |
> >  |  |
> >  |  |
> >  |  |
> >  |  |
> >  |  |
> >  |  |
> >  |  |
> >  +--+
> >  8 rows in set (0.00 sec)
> >
> >  mysql> use UNEXISTANT;
> >  ERROR 1049: Unknown database 'UNEXISTANT'
> >
> >  mysql> use mysql;
> >  Database changed
> >
> >  mysql> show tables;
> >  Empty set (0.00 sec)
> >
> >
> > As we can see, there are AVAILABLE databases, but 'show databases'
> >   doesn't displays anything. We can make 'use' with correct names,
> >   can't with unexistant, but the tables in database can't be reached.
> >
> >
> >   BTW, I have found the dependence of number in line ('8 rows in set)
> >   above - it corresponds to number of entries in /var/lib/mysql/
> >   directory:
> >
> >   $ ls -a /var/lib/mysql/
> >   .   Phantom.log Phantom.tsk.ru.pid  mysql.sock
> >   ..  Phantom.tsk.ru.err  mysql   test
> On my RH 6.2 there is another dependancy. show databases returns number of
> entries in the directory without . and ..
> 
> Moreover, show tables returns very nice list of tables' names. All names are
> truncated in the first 4 characters (tables_priv -> es_priv). Perhaps it's
> interesting to know that my data folder is /data.
> 
> > GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
> > gcc version 2.96 2731 (Red Hat Linux 7.0)
> > Compilation info: CC='egcs'  CFLAGS=' -O6'  CXX='egcs'  CXXFLAGS=' -O6 
> -felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
> Another common moment is on RH 6.2 I compiled it with egcs and libstdc++ was
> not installed.

If this helps my problems are on:

Redhat 6.2 I've libstdc++-2.9.0-30 and it has the above bug on kernel
2.2.17 and 2.4.2 complie with gcc -v of
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release).

SUSE 7.0 libstdc is not install - bug still apears gcc is gcc version
2.95.2 19991024, Kernel 2.2.16

greg

> On RH7.0 I compiled with gcc and libstdc++ was installed.
> 
> It looks like we have problems with either egcs or libstdc and company.

My experience does not suggest this but I am opne to any ideas !


> 
> Hope it helps MySQL developers.

So do I

Greg

> 
> Best regards,
> Lumberer.
> 
> -
> 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: Bug with 'show databases|tables'

[Greg Cope]

Richard Ellerbrock wrote:
> 
> >>Description:
> >   I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
> >all 'show' commands doesn't works. They display empty tables.
> >>How-To-Repeat:
> >Install RedHat 7.0 on Intel platform, apply all updates from RedHat
> >(up to March, 01 2001), compile kernel 2.2.17-14 from kernel-sources
> >package, then compile MySQL from RPM supplied by www.mysql.com.
> 
> The compiler shipped with Redhat 7.0 is broken (it is a beta GCC!). The compiler 
>requirements are explained in the Manual.

This is not a complier bug!

> 
> Rather use the binary RPM's supplied by MySQL team. Or downgrade to Redhat 6.2 if 
>you want a stable system. I don't think 7.0 is ready for real production work.

The same problem appears on 6.2  and on SUSE 7.0 !

Agreed that 7.0 is not ready for production.

Greg 

> 
> --
> Richard Ellerbrock
> [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

-
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: Bug with 'show databases|tables'

[Greg Cope]

Eugene Lineitzev wrote:
> 
> >Description:
> I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
> all 'show' commands doesn't works. They display empty tables.
> >How-To-Repeat:
> Install RedHat 7.0 on Intel platform, apply all updates from RedHat
> (up to March, 01 2001), compile kernel 2.2.17-14 from kernel-sources
> package, then compile MySQL from RPM supplied by www.mysql.com.
> 
> Compiling went OK and MySQL can be installed. By we will always
> get such strange results for 'show' commands:
> 
>  $ mysql
>  Welcome to the MySQL monitor.  Commands end with ; or \g.
>  Your MySQL connection id is 3 to server version: 3.23.33-log
> 
>  Type 'help;' or '\h' for help. Type '\c' to clear the buffer
> 
>  mysql> show databases;
>  +--+
>  | Database |
>  +--+
>  |  |
>  |  |
>  |  |
>  |  |
>  |  |
>  |  |
>  |  |
>  |  |
>  +--+
>  8 rows in set (0.00 sec)
> 
>  mysql> use UNEXISTANT;
>  ERROR 1049: Unknown database 'UNEXISTANT'
> 
>  mysql> use mysql;
>  Database changed
> 
>  mysql> show tables;
>  Empty set (0.00 sec)
> 
> As we can see, there are AVAILABLE databases, but 'show databases'
> doesn't displays anything. We can make 'use' with correct names,
> can't with unexistant, but the tables in database can't be reached.
> 
> BTW, I have found the dependence of number in line ('8 rows in set)
> above - it corresponds to number of entries in /var/lib/mysql/
> directory:
> 
> $ ls -a /var/lib/mysql/
> .   Phantom.log Phantom.tsk.ru.pid  mysql.sock
> ..  Phantom.tsk.ru.err  mysql   test
> 
> There are total 8 files (with '.' and '..' entries). We can create
> one more file by peforming 'touch /var/lib/mysql/asdf' and here are
> new mysql report:
> 
> mysql> show databases;
> +--+
> | Database |
> +--+
> |  |
> |  |
> |  |
> |  |
> |  |
> |  |
> |  |
> |  |
> |  |
> +--+
> 9 rows in set (0.00 sec)
> 
> Very strange, isn't it ?..
> 
> And what is more, I _have_  tried to undefine the HAVE_READDIR_R in
> config.h .  The same results...
> 
> I have tried to compile OLD MySQL (version 3.22.32), it works
> with absolutelly the same problems.
> 
> >Fix:
> 
> I doesn't know how to correct this. I'll be very thankful if someone
> help me...
> 
> >Submitter-Id:  
> >Originator:[EMAIL PROTECTED]
> >Organization:
> none
> >MySQL support: none
> >Synopsis:  The bug with empty 'show databases' results. Linux RedHat 7.0 i386
> >Severity:  critical
> >Priority:  high
> >Category:  mysql
> >Class: sw-bug
> >Release:   mysql-3.23.33 (Official MySQL RPM)
> >Server: /usr/bin/mysqladmin  Ver 8.15 Distrib 3.23.33, for pc-linux-gnu on i686
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
> 
> Server version  3.23.33-log
> Protocol version10
> Connection  Localhost via UNIX socket
> UNIX socket /var/lib/mysql/mysql.sock
> Uptime: 13 min 1 sec
> 
> Threads: 1  Questions: 1 Slow queries: 0  Opens: 6  Flush tables: 1  Open tables: 0 
>Queries per second avg: 0.016
> >Environment:
> 
> System: Linux Phantom.tsk.ru 2.2.17-14 #1 Tue Mar 6 03:05:11 TSK 2001 i686 unknown
> Architecture: i686
> 
> Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
> gcc version 2.96 2731 (Red Hat Linux 7.0)
> Compilation info: CC='egcs'  CFLAGS=' -O6'  CXX='egcs'  CXXFLAGS=' -O6
>-felide-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
> LIBC:
> lrwxrwxrwx1 root root   11 Mar  5 17:37 /lib/libc.so.6 -> libc-2.2.so
> -rwxr-xr-x1 root root  5155229 Jan 11 07:09 /lib/libc-2.2.so
> -rw-r--r--1 root root 24498288 Jan 11 06:35 /usr/lib/libc.a
> -rw-r--r--1 root root  178 Jan 11 06:35 /usr/lib/libc.so
> lrwxrwxrwx1 root root   10 Mar  6 00:23 /usr/lib/libc-client.a -> 
>c-client.a
> Configure command: ./configure  --disable-shared --with-mysqld-ldflags=-all-static 
>--with-client-ldflags=-all-static --with-charset=koi8_ru --enable-assembler 
>--with-mysqld-user=mysql --with-unix-socket

Re: phpMyAdmin equivalent

[Greg Cope]

"MikeBlezien" wrote:
> 
> Hello All,
> 
> Was wonder if any knows of a Perl equivalent to the PHP's version of
> phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP
> installed, and frankly, to lazy to do all the typing thru telnet session! :)

MysqlTool

Looks pretty good

 http://dajoba.com/projects/mysqltool/

Greg

> 
> TIA,
> 
> Mickalo
> 
> Mike(mickalo)Blezien
> 
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://www.thunder-rain.com
> Tel: 1(225) 686-2002
> =
> 
> -
> 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: Problems with SHOW DATABASES / TABLES

[Greg Cope]

Sinisa Milivojevic wrote:
> 
> As building process, nor system libs, may not be perfect, try using
> our binaries.

Thanks Sinisa, but this does not solve the problem - I've several
machines (RedHat|SUSE|SUN) (7) that all have near identical (with
different data and binary dirs so that I can upgrade without touch data
dirs) setups - hence I do not use the binaries (although I could, but I
would end up having to edit my.cnf etc alot to cope with my setup).

Just tried this on SUSE 7.0 (with errata updates) and still the same
problems 

Hopefull 3.23.34 may solve my problems !

Thanks again for your help.

Greg

> 
> Regards,
> 
> Sinisa
> 
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team

-
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: Problems with SHOW DATABASES / TABLES

[Greg Cope]

Sinisa Milivojevic wrote:
> 
> HI!
> 
> In response to several mail messages on mailing list that were
> centered around some misbehaviour of SHOW DATABASES / TABLES, I have
> tested thoroughly (with several --user=... options) 3.23.33 and found
> out that it works perfectly.

Hum 

Not meaning to be difficult, but as yet I can not get mine to work
perfectly.

> 
> Causes of misbehavious can be :
> 
> - errors in building process (if our binary is not used)

Seems to build fine - complied 3.23.32 and .33 with no problems.  I've
logs if thats any use.

> 
> - Unix ownership/permission problems

Again 3.23.32 works fine, 3.23.33 does not.

I've been testing this for a while.

I've even install 3.23.33 and copied the LIBEXECDIR/mysqld from 3.23.32
into the 3.23.33 dir and it fires up ok and SHOW works ok.

If I use the 3.23.33 LIBEXECDIR/mysqld SHOW does not work.

I've re-read the install docs and I am following them to the letter (as
I have done for the past 2 yrs ;-):

The DATADIR is chown -R mysql:mysql (i.e all user mysql and group mysql)
the dir has 755 perms.

What I am trying to say is that the mysqld in 3.23.33 reacts differently
than 3.23.32 when it comes to SHOW !

> 
> - Usage of --safe-show-... options in 3.23.33

nope.

> 
> - Usage of untested kernels

Linux 2.2.17 Should be ok (Redhat errata upgrade for 6.2)

Sinisa I do appreciate your help, but I still appear to have a problem.

A confused,

Greg

> 
> Regards,
> 
> Sinisa
> 
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team
> 
> -
> 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: Possible SHOW DATABASE || TABLE bug in 3.23.33

[Greg Cope]

Sinisa Milivojevic wrote:
> 
> Greg Cope writes:
>  > >Description:
>  > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
>  > a nice list of blanks - no of blank lines
>  > equals number of databases / tables)
>  >
>  > >How-To-Repeat:
>  > Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33
>  >
>  > >Fix:
>  >
>  > >Submitter-Id:  
>  > >Originator:Greg Cope
>  > >Organization:
>  >  
>  > >MySQL support: none
>  > >Synopsis:  SHOW command possiblxky broken in 3.23.33
>  > >Severity:  non-critical
>  > >Priority:  low
>  > >Category:  mysql
>  > >Class: sw-bug
>  > >Release:   mysql-3.23.33 (Source distribution)
>  >
>  > >Environment:
>  > 
>  > System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50
>  > EST 2001 i686 unknown
>  > Architecture: i686
>  >
>  > Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
>  > /usr/bin/cc
>  > GCC: Reading specs from
>  > /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
>  > gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
>  > Compilation info: CC='gcc'  CFLAGS='-O3 -malign-double -ffast-math
>  > -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro
>  > -fomit-frame-pointer'  CXX='c++'  CXXFLAGS='-O3 -malign-double
>  > -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions
>  > -march=pentiumpro -fomit-frame-pointer'  LDFLAGS=''
>  > LIBC:
>  > lrwxrwxrwx1 root root   13 Feb 13 10:46 /lib/libc.so.6
>  > -> libc-2.1.3.so
>  > -rwxr-xr-x1 root root  4101836 Jan 15 15:49
>  > /lib/libc-2.1.3.so
>  > -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a
>  > -rw-r--r--1 root root  178 Jan 15 15:49 /usr/lib/libc.so
>  > Configure command: ./configure  --prefix=/usr/local/mysql-3.23.33
>  > --enable-assembler --with-mysqld-ldflags=-all-static
>  > --with-mysqld-user=mysql --localstatedir=/var/lib/mysql
>  > --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql
>  > --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man
>  > --without-debug --without-bench
>  > Perl: This is perl, version 5.005_03 built for i386-linux
>  >
> 
> Hi!
> 
> As there are so many reports, we shall investigate a problem.
> 
> Regards,
> 
> Sinisa


Thanks for the reply.

I've narrowed this down to a possible issue with the mysqld binary - as
I've two versions of mysql on my machine - 3.23.32 and .33.

If I fire up .32 everything is fine.

If I fire up .33 everthing appears fine until you do a "SHOW" command. 
Both binaries are setup with the same configure line and hence share the
same data dirs (althought not at the same time ;-)

Thanks again.

Greg


> 
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team

-
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: show database does not work ;-(

[Greg Cope]

Rick Roberts wrote:
> 
> mysql> select version();
> +---+
> | version() |
> +---+
> | 3.23.33   |
> +---+
> 1 row in set (0.01 sec)
> 
> mysql> SHOW DATABASES;
> +--+
> | Database |
> +--+
> | mysql|
> | test |
> +--+
> 2 rows in set (0.02 sec)
> 
> I'm using Mandrake 7.2.
> I installed using the RPM
> MySQL-3.23.33-1.i386.rpm

Thanks


Not much help to me mind ...

Thanks again ;-(

Greg

-
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: show database does not work ;-(

[Greg Cope]

Fred van Engen wrote:
> 
> On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote:
> > Dear All
> >
> > I've just installed mysql on a new host (3.23.33) and show databases
> > does not work ;-(.
> >
> 
> Maybe it would help to read (or search) the list before posting.

I have already searched the list, and it has not helped.

> 
> There are several mails regarding this problem, among them a mail with
> subject 'Some problems encountered when linked to glibc-2.2.1'. It
> suggests a fix I believe. If the fix isn't clear, please repost your
> (new) question. I'm not running MySQL on Linux, but someone else will
> probably be able to help implement the fix then.

I'm on glibc-2.1.3

I've narrowed this down to a difference between the mysqld binary.  I
just tried it on two near identical machines and there appears to be a
bug bug.

3.23.32 works as expected - 3.23.33 does not - here at least.

Greg

> 
> Regards,
> 
> Fred.
> 
> --
> Fred van Engen  XO Communications B.V.
> email: [EMAIL PROTECTED] Televisieweg 2
> tel: +31 36 5462400 1322 AC  Almere
> fax: +31 36 5462424 The Netherlands
> 
> -
> 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

Possible SHOW DATABASE || TABLE bug in 3.23.33

[Greg Cope]

>Description:
SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
a nice list of blanks - no of blank lines
equals number of databases / tables)

>How-To-Repeat:
Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33

>Fix:

>Submitter-Id:  
>Originator:Greg Cope
>Organization:
 
>MySQL support: none
>Synopsis:  SHOW command possiblxky broken in 3.23.33
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.33 (Source distribution)

>Environment:

System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50
EST 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from
/usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc'  CFLAGS='-O3 -malign-double -ffast-math
-funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro
-fomit-frame-pointer'  CXX='c++'  CXXFLAGS='-O3 -malign-double
-ffast-math -funroll-all-loops -fno-rtti -fno-exceptions
-march=pentiumpro -fomit-frame-pointer'  LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root   13 Feb 13 10:46 /lib/libc.so.6
-> libc-2.1.3.so
-rwxr-xr-x1 root root  4101836 Jan 15 15:49
/lib/libc-2.1.3.so
-rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a
-rw-r--r--1 root root  178 Jan 15 15:49 /usr/lib/libc.so
Configure command: ./configure  --prefix=/usr/local/mysql-3.23.33
--enable-assembler --with-mysqld-ldflags=-all-static
--with-mysqld-user=mysql --localstatedir=/var/lib/mysql
--sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql
--localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man
--without-debug --without-bench
Perl: This is perl, version 5.005_03 built for i386-linux

-
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: show database does not work ;-(

[Greg Cope]

Rick Roberts wrote:
> 
> SHOW DATABASES;

Sorry my subject line had the last S missing:

mysql> 010216 15:29:14   1 Query  SHOW DATABASES
SHOW DATABASES;
+--+
| Database |
+--+
|  |
|  |
|  |
|  |
| test |
+--+
5 rows in set (0.01 sec)

Are you using 3.23.33 ?

Greg

-
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

show database does not work ;-(

[Greg Cope]

Dear All

I've just installed mysql on a new host (3.23.33) and show databases
does not work ;-(.

The data directory is thus:

drwxrwsr-x5 mysqlmysql4096 Feb 16 14:06 mysql

Inside it has:

[root@server1 lib]# ls -l mysql/
total 28
drwx--S---2 mysqlmysql4096 Feb 16 13:43 foo
drwxrwxr-x   24 mysqlmysql4096 Feb 16 13:23 mysql
-rw-rw1 mysqlmysql5769 Feb 16 14:09 server1.log
-rw-rw-r--1 mysqlmysql 780 Feb 16 14:06
server1.totallyradio.com.err
-rw-rw1 mysqlmysql   4 Feb 16 14:06
server1.totallyradio.com.pid
drwx--2 mysqlmysql4096 Feb 16 13:23 test

Which all looks normal.

I can connect etc  but show does not work - if I do :

SELECT * on mysql.users;

I get results.

Is this a bug (in which case I do a full bug report) -- I have a feeling
I am doing something very wrong that must be obvious ?

A rather dazed and confused,

Greg

-
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: Should I switch to SCSI HD for mysql?

[Greg Cope]

Dave Hodgkinson wrote:
> 
> "mike thomas" <[EMAIL PROTECTED]> writes:
> 
> > Greg,
> >
> > Well, I'm doing like "%stuff%" selects on a single column table
> > with 20 million records, so any speed gain would be greatWould
> > I be correct in saying that a select of this type will always do
> > a table scan?
> 
> Pretty much.
> 
> > I think I'll go with SCSI and increase the RAM so I can use a
> > heap table.
> 
> A cheap first step might be to go with a couple of decent 7200 rpm,
> ATA100 (or whatever the hell they're calling themsevles this week)
> disks and RAID0 them.
> 
> Striping Good.

This still does not help the seek time of SCSI vs EIDE (ATA100 only
helps the bus speed AFAIR).

Some calc's I did a while back implied that SCSI seek time is 40% better
(or less) - this was comparing IBM SCSI 10k drives to IBM EIDE.

Agreed that striping is good tho.

> 
> Also, make sure your IDE is spiffed up to the max. Do an:
> 
> hdparm /dev/hda (or whatever).

Redhat is very bad for not tweeking the UDMA - but they do not as they
are afraid of damaging old drives that do not support it.

> 
> Make sure it's using DMA, unmasked IRQ, 32 bit i/o and, a multcount of
> 16. Benchmark your drive before and after, with:
> 
> hdparm -t /dev/hda
> 
> You should see >10MB per second after tuning up.

Once you've tweaked it put the hdparm setting at the end of your
/etc/rc.d/rc.local (if on redhat - your's may be in a different
location) so that it gets loaded at each boot.

You may also wish to mount your disks with no atime (each time your
disks are access the access time of the file is update - if you do not
need this then switch it off) eg an example line from my /etc/fstab:

/dev/hda2   /   ext2noatime,defaults
1 1

> 
> However, I can't help thinking for your application There Must Be A
> Better Way. Do you really need to do substring matching all the time?
> Can you pre-build an intermediate results set that can be optimally
> queried?

(Dave sometimes you worry me ;-)

Dave's right - substring matching is bad performance wise.

Greg

> 
> Dave.
> 
> --
> Dave Hodgkinson, http://www.hodgkinson.org
> Editor-in-chief, The Highway Star   http://www.deep-purple.com
>   Apache, mod_perl, MySQL, Sybase hired gun for, well, hire
>   -

-
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: Should I switch to SCSI HD for mysql?

[Greg Cope]

mike thomas wrote:
> 
> Hi all
> 
> I am running mysql on linux (redhat 6.2) using a regular 18Gb
> EIDI hard drive. Does anyone know how much (ball park figure) a
> SCSI hard drive would speed up selects and inserts?

This is a how long is a piece of string question .

EIDE disks have nearly the same data transfer rates as SCSI drives.

but

SCSI drives have nearly twice the seek-time performance - or their
average seek time is twice as good.

So it depends on how many seeks a query takes to complete that will
determine any performance increase.  Each query will be atleast two IIRC
from the manual - which has a section on Disk performance.

If you are serious about performance go SCSI.

Greg

> 
> Thanks everyone!
> 
> Michael Thomas
> abcXyz.com
> [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

-
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 NT Service Question

[Greg Cope]

Lee Jenkins wrote:
> 
> Hello all.
> 
> We are currently using MS Access for a multi-user application (4-5 clients).
> We sent out a system to a customer with NT Service enabled in anticipation
> of switching over to MySQL.
> 
> We noticed that when activity on the MS database got heavy (if you can call
> 3 clients heavy activity) that our application that was talking to it would
> hang alot.  It's a small network using TCP/IP over NetBEUI with a Win2K Box
> in the back with 128 MB RAM/PIII 666 MHz.  When I un-installed the MySQL NT
> Service (3.23 Gamma) the problem disapeared.
> 
> Any Ideas (other than stop using MS Access)?
> 

Access is horrible in a multiuser environment and will hag due to
locking issues.

I do not use the word Database with Access - having worked with it in
the past!

MySQL IMHO being a RDatabaseMS has few locking issues and is designed
for a multiuser environment, something which access was not.

As an aside 128 meg of RAM is not alot for a W2k server - RAM being
cheap you may wish to upgrade it.

Greg


> Lee Jenkins
> 
> -
> 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

Patch to add restart to mysql.server rc start script

[Greg Cope]

Dear All

Here is a quick / obvious hack to supportfiles/mysql.server.sh to add
restart command.

I added this as I sometimes do a hard restart, and thought it may be of
use to others.

Can this be patched to the one in the source by someone with CVS rights
- it should not break anything ;-)

Greg


--- mysql.server.sh.bak Thu Jan 25 15:23:38 2001
+++ mysql.server.sh Thu Jan 25 15:29:50 2001
@@ -147,9 +147,14 @@
 fi
 ;;
 
+  'restart')
+$0 stop
+$0 start
+;;
+
   *)
 # usage
-echo "usage: $0 start|stop"
+echo "usage: $0 start|stop|restart"
 exit 1
 ;;
 esac

-
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: Inheritance

[Greg Cope]

Lee Martin wrote:
> 
> I would like to know whether the latest version of MySQL supports OO
> databse design and the Enhanced Entity Relationship Model in particular
> Specialization and Generalization.

As much as any (generalised) RDBMS. (i.e no).

The (excellent) Manual (online) outline what it can and cannot do.

If you want to use MySQL in this area you will have to implement your
own OO -> RDBMS translation etc ...

It is not an OO DBMS.

Hope that helps.

Greg

> 
> Any information would be useful.
> 
> Thanks :)
> 
> 
>   Lee Daniel Martin
>   CSAI
>   School Of Cognitive & Computing Science
>   University of Sussex
> 
>   tel:  01273 673903 (home)
> 07941 692424 (mobile)
> -
>  [EMAIL PROTECTED]  (Unix)
>  [EMAIL PROTECTED]   (PC)
> -
> 
> -
> 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: 3.23.21 + DB 3.2.3h

[Greg Cope]

"Ashley M. Kirchner" wrote:
> 
> I downloaded both the 3.23.31 version of mySQL, as well as the
> patched BerkeleyDB (v3.2.3h) from mysql.com.  I compiled BDB and
> installed it under /usr/local.  Then I proceeded to mySQL and gave it
> the following configure args:
> 
> ./configure --prefix=/usr/mysql
> --with-berkeley-db-includes=/usr/local/include
> --with-berkeley-db-libs=/usr/local/lib
> 
> And when it reaches the BDB check, I get this error:
> 
> checking for BerkeleyDB... supplied
> configure: error: didn't find valid BerkeleyDB: invalid version 3.2.3
> (must be at least version 3.2.3g)
> 
> Okay, what am I missing now?  I thought 'g' came before
> 'h'...someone please tell me I'm wrong?

There is a small bug in the configure script - Monty submited an easy
one line fix:

replace 'DB_VERSION_STRING.*g' 'DB_VERSION_STRING.*h' -- configure

That should do the trick.

Greg


> 
> AMK4
> 
> --
> H | Hi, I'm currently out of my mind.  Please leave a message.  BP!
>   |
>   ~
>   Ashley M. Kirchner    .   303.442.6410 x130
>   Director of Internet Operations / SysAdmin. 800.441.3873 x130
>   Photo Craft Laboratories, Inc. .eFax 248.671.0909
>   http://www.pcraft.com  .3550 Arapahoe Ave, #6
>   .. .  .  . .Boulder, CO 80303, U.S.A.
> 
> -
> 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: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

[Greg Cope]

Thimble Smith wrote:
> 
> > >Description:
> >   I just downloaded MySQL 3.23.31 and the "patched version" of
> >   Berkeley DB 3.2.3h from the www.mysql.com site.  I ran configure
> >   with the option to enable the Berkeley DB, but it fails, telling
> >   me I don't have the proper version of the DB.  Here are the last
> >   few lines from the configure output:
> >
> >   checking for BerkeleyDB... supplied
> >   configure: error: didn't find valid BerkeleyDB: '/usr/local/BerkeleyDB.3.2' 
>doesn't look like a BDB directory (invalid version 3.2.3 (must be at least version 
>3.2.3g))
> 
> Yes, this configure bug slipped through due to an international
> conspiracy.  But the resistance is still powerful, as evidenced
> by this patch:
> 
> --- acinclude.m4Thu Jan 18 22:26:20 2001+++ 
>/tmp/acinclude.m4   Fri Jan 19 13:58:24 2001
> @@ -823,12 +823,12 @@
>  bdb_version_ok=yes
># This is ugly, but about as good as it can get
>elif test $db_major -eq 3 && test $db_minor -eq 2 && test $db_patch -eq 3 &&\
> -   grep 'DB_VERSION_STRING.*g: ' [$1] > /dev/null
> +   grep 'DB_VERSION_STRING.*h: ' [$1] > /dev/null
>then
>  bdb_version_ok=yes
>else
>  bdb_version_ok="invalid version $db_major.$db_minor.$db_patch"
> -bdb_version_ok="$bdb_version_ok (must be at least version 3.2.3g)"
> +bdb_version_ok="$bdb_version_ok (must be least version 3.2.3h)"
>fi
>  ])
> 

Thanks for that.

But does the conspiricy not continue ?  

Do you not need to patch aclocal.m4 as this contains a referance to
3.2.3g, and do the 

replace 'DB_VERSION_STRING.*g' 'DB_VERSION_STRING.*h' -- configure

that Monty suggest to fix the congfigure script ?

Greg

> 
> Sorry about that.
> 
> Tim
> 
> --
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Tim Smith <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
> /_/  /_/\_, /___/\___\_\___/   Helsinki, Finland (for a few weeks)
><___/   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

-
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 3.23.31 configure fails with Berkeley DB 3.2.3h

[Greg Cope]

Matt Wagner wrote:
> 
> Greg Cope writes:
> > Chris Johnson wrote:
> > >
> > > >Description:
> > > I just downloaded MySQL 3.23.31 and the "patched version" of
> > > Berkeley DB 3.2.3h from the www.mysql.com site.  I ran configure
> > > with the option to enable the Berkeley DB, but it fails, telling
> > > me I don't have the proper version of the DB.  Here are the last
> > > few lines from the configure output:
> >
> > This sounds similar to a problem that I reported a few hours ago to this
> > list.
> >
> > Monty, MySQL dev team, any ideas ?
> 
> I've forwarded Chris's report to bugs@.
>

Thanks

Greg

 
> Regards,
> 
> Matt
> 
> --
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /   Matt Wagner <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
> /_/  /_/\_, /___/\___\_\___/  River Falls, Wisconsin, USA
><___/   Developer
> 
> -
> 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: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h

[Greg Cope]

Chris Johnson wrote:
> 
> >Description:
> I just downloaded MySQL 3.23.31 and the "patched version" of
> Berkeley DB 3.2.3h from the www.mysql.com site.  I ran configure
> with the option to enable the Berkeley DB, but it fails, telling
> me I don't have the proper version of the DB.  Here are the last
> few lines from the configure output:

This sounds similar to a problem that I reported a few hours ago to this
list.

Monty, MySQL dev team, any ideas ?

Greg




-
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

can't get mysql-3.23.31 to cofigure with berkeleydb support ?

[Greg Cope]

Dear All

I can't get mysql-3.23-31 to configure with Berkeley DB support

My configure line is thus:

./configure --prefix=/usr/local/mysql-3.23.31 \
--enable-assembler \
--with-mysqld-ldflags=-all-static \
--with-mysqld-user=mysql \
--localstatedir=/var/lib/mysql \
--sysconfdir=/etc \
--with-extra-charsets=complex \
--datadir=/var/lib/mysql \
--localstatedir=/var/lib/mysql \
--infodir=/usr/info \
--mandir=/usr/man \
--without-debug \
--without-bench


Which gives:



checking for BerkeleyDB... searching...
Not using Berkeley DB



Yet, 

[root@duck src]# ls mysql-3.23.31
COPYING Makefile.in   config.guess   configure.in  isam   
merge  mysys  stamp-h.in
COPYING.LIB READMEconfig.h   db-3.2.3h libmysql   
missingreadline   strings
Docsacconfig.hconfig.h.indbug  libmysql_r 
mit-pthreads   regex  support-files
INSTALL-SOURCE  acinclude.m4  config.log extra libtool
mkinstalldirs  scriptstests
MIRRORS aclocal.m4config.status  heap  ltconfig   
myisam sql
Makefileclientconfig.sub include   ltmain.sh  
myisammrg  sql-bench
Makefile.am config.cache  configure  install-shman
mysql-test stamp-h


I.e db-3.2.3h has been unpacked in the source DIR, as per the docs.

I've also installed BerkleyDB and used:

--with-berkleydb-dir=/usr/local/BerkeleyDB.3.2

On the configure line, and still no joy.

What am I doing wrong ?

Greg

-
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