RE: MySQL Secure Connection(e.g. SSL) Question
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
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
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
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
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
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
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: backup/restore of mysql
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
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?
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.
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
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
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
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
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: MySQL 3.23.35 is released
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 3.23.35 is released
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: Innobase in MySQL
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
show tables bug - minor update
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
Re: Mysql directory
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
Re: Dropped wrong DB. Can I recover?
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
Improving MySQL installation in ApacheToolbox - RFC
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: Poddible SHOW DATABASE || TABLE bug in 3.23.33
[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: 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
Re: Bug with 'show databases|tables'
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: 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-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc
Re: Bug with 'show databases|tables'
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: phpMyAdmin equivalent
"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
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
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
show database does not work ;-(
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: show database does not work ;-(
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
Possible SHOW DATABASE || TABLE bug in 3.23.33
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: submitter ID Originator:Greg Cope Organization: organization of PR author (multiple lines) 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: machine, os, target, libraries (multiple lines) 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 ;-(
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
Re: show database does not work ;-(
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: Should I switch to SCSI HD for mysql?
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: MySQL NT Service Question
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
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
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: MySQL 3.23.31 configure fails with Berkeley DB 3.2.3h
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
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 snipped - 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
