is 'start' a keyword?
I tried to create a table with a column named 'start'. This word does not appear here: http://dev.mysql.com/doc/mysql/en/Reserved_words.html But, my effort to create such a column yeilded a syntax error, and I did subsequently learn of a 'start' directive, such as in: START TRANSACTION, COMMIT, and ROLLBACK Syntax START SLAVE Syntax Is the URL I cited intended to be a canonical list of keywords I can't use for table/column names? -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is 'start' a keyword?
On Thu, Oct 14, 2004 at 10:33:45PM -0400, Brian Reichert wrote: I tried to create a table with a column named 'start'. This word does not appear here: http://dev.mysql.com/doc/mysql/en/Reserved_words.html Hmph; I had a typo in my 'create table' directive. Sorry about the noise... -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1 database; 2 scripts; different results
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote: My question is, in my admin script I deleted a record, but it still shows up using the other script. The admin script shows 102 records and the other shows 103. The record does show up in the 'public' script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can someone shed some light on what might be happening here? Web caching? Flushing tables after your delete? -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Create Temporary Table, incorrect rows
On Tue, Jul 06, 2004 at 10:30:38AM -0400, Paul McNeil wrote: Good day to all. I have a table and want to find duplicate info in the table. I know duplicated info exists by running the following... Select count(*) from myTable - 141123 Select distinct(myData) from myTable - 1411000 I presume there's a typo here: count(*) should have returned a larger number than distinct(myData), not smaller. So I created a temporary table to store distinct records and want to do a join with original table to see what records are duplicates. Create Temporary Table A Select distinct(mydata),rowID from myTable; This is a different query than above. What cout do you get from this query: Select distinct(mydata),rowID from myTable; Yes, it will be huge, but you want that count of selected rows. God Bless Paul C. McNeil Developer in Java, MS-SQL, MySQL, and web technologies. -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Create DB help
On Mon, Jun 21, 2004 at 12:01:06PM -0400, Tony Martino wrote: I believe it is exactly what I need. What I need to knwo now... could you please tell me WHERE I need to try: mysql -u{username} -p {databasename}filename.sql This assumes a few things: - that the database (as opposed to the tables in the database) has already been created. - that '{username}' has the priviledges of writing to said database ('create table', and so forth. As to 'where': from the command line. 'mysql' is the name of the command-line client for MySQL. Unless I'm misunderstandig your question... Thank you very much in advance Tony -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dump table
On Wed, Jun 16, 2004 at 09:16:52AM +0400, Vinay wrote: Thanks Brian but i'm on Red Hat enterprise server so i wouldn't be able to use the Features of FreeBSD and restarting the server is not a solution for me as i need to be able to perform hot backup. One of my solutions was to bump the database in a text file. this wroks fine for small tables but with lager one this takes too much time and somtimes freezers the server. Next trick: Replication. You _can_ afford to temporarily turn off the slave server for backups, replication will pick back up when you restart. This could possibly avoid using snapshots, if you could have so few transactions that you could afford to keep the slave server offline long enough to dump. And since this would require a second server, if you _do_ need snapshots, you'll have the opportunity to research and implement options, Linus-based or otherwise. V!nay -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dump table
On Tue, Jun 15, 2004 at 10:14:54AM +0400, Vinay wrote: Hi, I just like to know what is the best way to dump the databases to flat files as some of the tables on my system are up to 1.4G and the whole database size is over 2.5G . I trying to set up a cron job that will back up the table everyday and my main consern is the size of the tables and the time it may take to back up all the data and the fact that even during the back up theire will be other people using the database. I've seen people play horrible tricks with NetApps (an other heavy journaling filesystems), wherein you could get a snapshot of the whole FS very quickly. The order of events is then - shut down DB - snapshot the FS - start the DB - back up the now-static snapshot any way you see fit, such as spinning up a second instance of MySQL to use that snapshot, for a mysqldump. The FreeBSD 5.x series seems to offer filesystem snapshots (for example), but I've not explored them yet.. V!nay -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql backup script
On Tue, Jun 15, 2004 at 08:04:00AM -0500, Steve Buehler wrote: I am having a problem with a backup script that is written in a shell (/bin/sh) script to backup my mysql databases. For some reason on any day with an even number I get the following error: MySQL could not be stopped, exiting... It is really weird because it will run on odd number days without a problem. Should I put some kind of a wait in the script after it stops the mysqld and before it checks to make sure the pid file is still there? If so, does anybody know how? I am not sure that that will solve the problem though because it exits afterward and the mysql daemon is still running without having to restart it. Below is the relevant part of the script. The script is run from cron with this line 0 1 * * * /root/backup/backup.sh /dev/null 21 But since the logs do show it running, That shouldn't be the problem. Thanks Steve # Perform myisamchk #mysqladmin -p$MYSQLPWD shutdown /etc/rc.d/init.d/mysqld stop if [ -f $mysqlpid ]; then Does /etc/rc.d/init.d/mysqld (however indirectly) remove the $mysqlpid file when it exits? Is $mysqlpid the same as '/etc/rc.d/init.d/mysqld start' would create? Couldn't you check for an exit status of '/etc/rc.d/init.d/mysqld stop' instead? I've played stupid games like this, to work around weak management scripts (pseudo-code): while( -f $mysqlpid ) sleep 1 end There are risks with that, as well, of course, but you see what it's trying to do... -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lots of databases...how wrong is it?
On Sat, May 29, 2004 at 02:31:08PM +0100, Yannick Warnier wrote: Hi there, All of my my comments are base don my personal experience: - how wrong is creating 20 databases (total 400 tables) when you know you could create just one (total around 200 tables)? http://dev.mysql.com/doc/mysql/en/Creating_many_tables.html 7.4.9 Drawbacks to Creating Many Tables in the Same Database - what does MySQL handle better? Databases or tables? It depends on what you mean by 'handle'. Under the hood, as far as the file system goes, databases are merely directories, and tables are merely files in a database's directory. Of course, the set of database directories is kept under a single directory, whatever your 'datadir' variable is set to. All filesystems, irrespective of the OS in use, have performance problems when there are too many files (or directories) in a directory. Precisely what 'too many' is depends on the OS/filesystem in question, plus other modifiers such as how fast are your drives, how much RAM do you have, and so forth. 'Too many' is usually up in the thousands. A few hundred is usually fine. You can experience the performance of simply trying to use 'ls' on a directory; on a big directory, it will pause for a long period of time, as it gathers the list of files and sorts them. Your questions above WRT numbers of tables: creating 20 databases (total 400 tables) when you know you could create just one (total around 200 tables)? All points at numbers of files that are so small that they shouldn't be a major limit. Your first number, though: I am using a mysql server at the moment which contains 2800 different databases. Crosses that line into 'too many', for many filesystems. If your data is homogenous enough that is could be wadded up into one monster database, or broken up into an arbitrary number of smaller databases, then consider minimizing the number of databases, such that the number of tables per database is kept down in the hundreds. If your 2800 was really the number of tables in use, you could perhaps afford to scatter those tables into, say, ten databases of 280 each. But what you pick for numbers really does depend on the performance of your machines/OS/filesystem, as modified by what step's you've taken to tune your MySQL server. You're in the best position of all of us to make those tests. - could a slowdown problem causing me to have a show databases query answered in 42.50 seconds (more often being 0.02 sec) be bound to too many databases? It could be a factor, but there could be other factors, such as how heavily the MySQL server is being used at that point. Or what other activity on that box is consuming CPU or disk cycles. Thanks, Yannick -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SHA1 Question
On Fri, May 28, 2004 at 12:04:53PM -0400, Brian Muha wrote: Hello all and I hope this email finds you all well.. My question is I currently have passwords encrypted in SHA1 via LDAP... What I need to do is get these user names and passwords out of ldap and placed in mysql .. The application is qmail/courier.. The question is can i just take the already made SHA1 passwords and insert them right into mysql password table.. or must i get the plain text passwords and have mysql encrypt them again with SHA1. Nope, you should be able to import the SHA1 passwords directly. Make sure that whatever authentication tool that's going to use with MySQL knows that these are SHA1-encrypted passwords (as opposed to MD5, or whatever.) It should be easy enough to do one as a test, to see... TIA Brian -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for a C API if it exisits
On Tue, May 25, 2004 at 03:36:08PM -0600, Sarix wrote: Cause when I do my web end to all this life is easy cause I can do $name = $row['Name'] and it works for PHP so I figured there has to be an API that would do that.. But I can't seem to find it in the documention. Is there something that will help with this, or is C just too old to have helpful ablitles like this. :) People have written libraries for C to emulate higher-level languages. Here is an example, but I've not used it myself: http://www.annexia.org/freeware/c2lib/doc/ It speaks of 'vectors', and you could easily wrap your DB access routines in this, to give you something very like the named hashes that Perl and PHP use. -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unknown error, urgent help please
On Tue, May 18, 2004 at 10:08:32AM -0400, Ronnie Regev wrote: Hi, Before I go on, I know nothing about mysql, but my db admin is out of town and I need to be pointed in the right direction please. Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual hosting environment on Ensim webppliance-3.5.20-7. When using phpMyAdmin and attempting to upload a csv file, the following error is the result: Maybe MySQL doesn't have permission to read '/tmp/php7T1P2m' ? Maybe you don't have the right username/hostname/password? I don't know how PHP combines the details of DB access. Everything PHP is doing, you should be able to replicate from the mysql client... Ronnie Regev System Administrator Microsoft Certified Professional MCP Daslweb Inc. [EMAIL PROTECTED] -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump problem
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote: Hi, I've been using mysqldump to backup my entire database. Every day, I restore the whole thing to my test/develop database by piping the large sql generated by mysqldump. All is well until the file size of the sql file reached about 4Gbytes. I wonder if there is a size limit to the database I can backup and restore? Consider the OS and filesystem as well (wheatever uyou _are_ using; you didn't tell us). Quotas? Limits by FS? getrlimit()? Many Thanks. Regards, Gilbert Wu [EMAIL PROTECTED] http://www.sabrefund.com/ http://www.sabrefund.com/ -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database design.. Asking again
On Mon, May 10, 2004 at 09:49:31PM -0700, Scott Haneda wrote: Sorry for the post again, I hijacked a thread and wanted to get this on the correct track. I can not seem to find the section in the manual that talks about the max number of tables MySql can use, can someone point me please? A classic hit is how efficient is your filesystem at handling large directories. Each table corresponds to a few files. Too many files in a single subdirectory can cause performance problems. I don't know if there's a limit at to how many tables can be handled by a single MySQL query. There are MySQL system variables that limit as to how big that query command can be. - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Executing Pre-Written Commands
On Fri, Apr 23, 2004 at 10:47:53AM -0400, Chris Stevenson wrote: Anyone out there have any experience with the book MySQL by Paul DuBois? I'm having trouble figuring out how to save/resuse executed commands (primarily creating tables at this point). Perhaps I could bounce a few questions offline if you've got used this book before or think you can assist me regardless. It's usually as easy as 'cat sql_command.txt | mysql'. To wit, maintain a text file of SQL commands you want executed. I do things like: #-- drop table if exists user; create table user ( user VARCHAR(254) unique NOT NULL, user_id INT UNSIGNED not null PRIMARY KEY AUTO_INCREMENT, password VARCHAR(32) binary NOT NULL, name VARCHAR(254) NOT NULL, index (user) ); # initialize a 'default' user insert into user (user, password, name, email) values ('none', '--disabled--', 'No user assigned', ''); #- This way, I can completely reset my user table at a whim, and even annotate my data. I go so far as to have separate tables in separate files, all named something.sql. Then, I can reset one table cat user.sql | mysql test Or all of them: cat *.sql | mysql test Mind you, I haven't performed the latter with foreign keys, so you may have to take measures to assure tables are created / initialized into the right order... If you have a extant database, with lots of data that you're testing, just do a mysqldump of that table (or database) into a text file, and you can replay it as above. There are special arguments to mysqldump to maintain the delete/create table (and database) commands, so read those docs. Thank you and have a great day! Chris Stevenson -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to determine when a MySQL database was last modified?
On Fri, Feb 06, 2004 at 08:18:10PM +, Phil wrote: Doesn't seem to change the mtime on table files. It appears that for InnoDB tables these files are only updated when the definition of a table is changed. The content of the all InnoDB tables is kept in one or two massive files directly under the 'data' directory! At _some_ point your data has to end up on disk. I haven't read up on the caching that MySQL does. I know you can manually FLUSH TABLES, but that's of no use to you: you want to passively detect when the file's changed. I just did a one-record update to a test database: Before: # ls -ld user.* -rw-rw 1 mysql mysql 18168 Dec 22 16:58 user.MYD -rw-rw 1 mysql mysql 20480 Dec 26 18:00 user.MYI -rw-rw 1 mysql mysql 8794 Dec 11 14:20 user.frm After: # ls -ld user.* -rw-rw 1 mysql mysql 18168 Feb 7 12:33 user.MYD -rw-rw 1 mysql mysql 20480 Feb 7 12:33 user.MYI -rw-rw 1 mysql mysql 8794 Dec 11 14:20 user.frm I updated that same record again: # ls -ld user.* -rw-rw 1 mysql mysql 18168 Feb 7 12:34 user.MYD -rw-rw 1 mysql mysql 20480 Feb 7 12:34 user.MYI -rw-rw 1 mysql mysql 8794 Dec 11 14:20 user.frm This is with MySQL 3.23.58 and MyISAM tables. So, in my (very) limited testing; changing a table's content does promptly correspond to an updated mtime of the data and index columns. I do see that you're using InnoDB tables; I'll try to set another test environment. Good luck, anyway... -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to determine when a MySQL database was last modified?
On Fri, Feb 06, 2004 at 09:17:32AM -0500, Dan Greene wrote: I'm not 100% sure on this, but what about the .myd file timestamp? Well, it depends on which table type, obvously. There are several files for each database, see what the mtime is on each of them, to determine what's a live file. If you're using rsync for backups, I wouldn't worry; it's good at moving partial files around. -- Brian Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Preventing data collisions
On Mon, Nov 17, 2003 at 11:06:39PM -0600, David Dice wrote: I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find an answer. How do I prevent data collision in the following scenario: User A and User B are examining the same data (say a customer's name and address). User A modifies something (say the customer's phone number) and saves the transaction. User B modifies something different at the same time. How can I prevent User B's modification from being saved? Under MySQL, you can lock the a table during sensitive transactions. If you're using InnoDB tables, you can use row locking. http://www.mysql.com/doc/en/Locking_methods.html This is a database I'm converting from Foxpro, and there I would have just told User B that User A had the data open, and prevented them from editing it. I'm sure there's a better way. Thanks for your advice. David Dice -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL: forbidden syntax search
On Sun, Nov 16, 2003 at 03:31:18AM +0100, M. Bader wrote: Hi, I need a little help on my SQL syntax. I want to store forbidden inputs from the GUI in a table and query it on input from the user; This doesn't answer your question specifically, but rather, describes a separate solution... simple layout: CREATE TABLE `forbidden_input` (`lfdnr` TINYINT (3) UNSIGNED DEFAULT '0' AUTO_INCREMENT, `input` VARCHAR (255) NOT NULL, PRIMARY KEY(`lfdnr`), UNIQUE(`input`)); Content is something like this: 1,'+' 2,'^' 3,'' 4,'' 5,'(' 6,')' 7,'~' 8,'' 9,'%' Must the forbidden inputs be in a table? Couldn't you use the regular expression syntax instead? Something like: SELECT `input` FROM lok_forbidden_input WHERE 'Hello World' regexp '[+^()~%]'; (This is utterly untested. Tweak as neccessary. You might need to backquote some characacters there...) The point being, you can build your regular expression to contain a list of weird characters you want to match. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql well suited for bibliographic data...
On Sat, Oct 25, 2003 at 12:47:16PM -0600, Miguel Maloney wrote: Does Mysql support repeatability of fields and subfields? and would it be well suited for a bibliographic database? What is a 'subfield'? And what do you mean by 'repeatability'? Regards, Miguel Maloney Email: [EMAIL PROTECTED] Website: http://maloneyja.com -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help installing DBI modules
On Sat, Aug 23, 2003 at 10:42:45AM -0400, March, Kristopher (Contractor) (DSCR) wrote: I'm trying to install DBI perl modules on a SUN 8 box. I can't seem to find a make utilitity for building the components. Is it called something else or will I have to go out and install it? Is /usr/ucb/bin in your path? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: External Access
On Fri, Aug 22, 2003 at 09:20:08AM -0500, Christensen, Dave wrote: I know that we need to open a port, such as 3306, to access the server. My question is whether that port requires TCP, UDP or both to be open. TCP. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving MySQL
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote: We've run out of disk space and would like to move either the entire MySQL system or if possible move the databases. Can this be done without any difficulties? Yes, if you can afford to turn off your server. If you need to keep your server live, then things become more complicated, but solvable... Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: curtime
On Wed, Aug 20, 2003 at 10:54:28AM -0300, Fabio Bernardo wrote: When I write select curtime(); It?s return the mysql?s system time, but I would like to change this time (because it?s late 3 minutes) Then your system's time need to be updated correctly. Any ideas? Get your sysadmin to install an NTP client on your server. Thanks a lot -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Will a SIGTERM shutdown while using LinuxThreads?
On another mailing list, there is a discussion about whether or not it is adequate/proper to manage the MySQL server process via a watchdog script (namely, DJB's daemontools). The point behind this watchdog script is to launch a service (such as mysqld) in the foreground, and notice if that process exits. An auxilary tool will send this managed process a SIGTERM, to request shutdown. It has been working for me under FreeBSD, and the MySQL docs imply this should work for other OSes, but someone just pointed out to me this info: http://www.mysql.com/doc/en/Linux.html When using LinuxThreads you will see a minimum of three processes running. These are in fact threads. There will be one thread for the LinuxThreads manager, one thread to handle connections, and one thread to handle alarms and signals. I myself don't use Linux, much less LinuxThreads. Can anyone advise how the theree process/threads should handle a SIGTERM in such a watchdogged environment? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql.log error - Please help
On Fri, Apr 04, 2003 at 09:10:50AM +0200, Jocelyn Fournier wrote: Hi, Or simply use perror 28 :) [EMAIL PROTECTED]:~$ perror 28 Error code 28: No space left on device Golly, I had no idea that such a utility came with the MySQL distribution. Kinda handy. Learn something new everyday... Regards, Jocelyn -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql.log error - Please help
On Fri, Apr 04, 2003 at 12:22:18PM +0530, Minal Amle wrote: Hello, I am facing a problem while inserting data in one of the tables of my mysql database as: Error writing file '/var/log/mysql.log' (Errcode :28) I suspect this 'Errcode' corresponds to 'errno' under UNIX systems. On mine, that would corresspond to: #define ENOSPC 28 /* No space left on device */ My box, a FreeBSD box, has this constant in /usr/include/sys/errno.h. your system may vary... man errno Good luck... Thanks in advance. Regards, Minal Amle Software Engineer OAS Information Systems Pvt. Ltd. #2, Symphony-C, Range Hills Road, Pune 411020 Tel: +91 20 5520311 Fax: +91 20 5520312 Email: [EMAIL PROTECTED] http://www.oas.co.in -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Configure fails
On Fri, Mar 07, 2003 at 11:05:37AM -0600, Judi Buff wrote: I am using the the following command: #./configure --enable-thread-safe-client --prefix=/usr/local/mysql You realize that you've given us no details of your platform. OS, version, which version of MySQL, etc. Please help if you can and thanks in advance! Judith Buff Computer System Manager/WebCT Admin Texas AM University at Galveston 200 Seawolf Parkway Galveston, Texas 77553 Ph: 409-740-4961 Fax: 409 740-4450 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large - 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: Unexpected ending
On Tue, Dec 10, 2002 at 01:28:13PM -0500, Lefevre, Steven wrote: Hey folks - Linux newbie here. I have RH 8.0 installed on a machine. I did an RPM installation of MySQL 3.23 (or whatever the current 3 series is). When I try to start the safe daemon, I get this: [root@server ]# /usr/bin/safe_mysqld Starting mysqld daemon with databases from /var/lib/mysql 021210 13:26:51 mysqld ended 'safe_mysqld' blows, it hides information. Try running mysqld more directly. Step 1: edit safe_mysqld to make it tell you what it's trying to do. Edit the very first line to look like this: #!/bin/sh -x Step 2: re-run safe_mysqld, it will now dump out each command as it runs it. The last thing you see will be the full invokation of mysqld, with all the arguments and all of that. Step 3: run that actual invocation of mysqld, with all of it's arguments, without redirecting the output anywhere. This is, to say, avoid this at the end: $err_log 21 Now, when mysqld pukes at you, you'll actually see error messages. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 on virtual hosting
(This is a forward of some private mail with the original poster, with his permission.) Date: Sun, 24 Nov 2002 22:59:33 -0500 From: Brian Reichert [EMAIL PROTECTED] To: Sweethome.co.il Webmaster [EMAIL PROTECTED] Cc: Brian Reichert [EMAIL PROTECTED] Subject: Re: MySQL on virtual hosting On Mon, Nov 25, 2002 at 03:15:00AM +0200, Sweethome.co.il Webmaster wrote: The Virtual dedicated systems will need much more resources in real life. I can't imagine having 40 MySQL servers running at once when I can't restrain a single one :) You can constrain a single one, very easily: # nice limits -d whatever -m whatever /usr/local/mysql/libexec/mysqld Of course, you may not want the jail methodology in general; I'm not trying to trick you into it, by any means. If you're virtual hosting, there is the implication that you have more than one customer on a single system, say, forty of them. You have at least two options: - You can let all forty clients (with all of their myriad users, sets of users, etc.) talk to a single MySQL daemon. You have the ease of no clever engineering to get the to all use this daemon, but you now have the task of accounting for their usage, and constraining them individually. - You can give each client their own separate MySQL daemon. You have the overhead of each MySQL daemon process consuming some OS resources, but now you have the freedom to almost completely manage the resources of any one of these daemons. Plus, you get to deal with the extra hassles of: - Isolating which clients want binary replication: those logs each eat up diskspace, and client's shouldn't unduly impair each other's backups. - What if one client make a request that makes MySQL spin? That'll impair everyone else's ability to process queries. - What if someone needs the ability to use DATAFILES under MySQL? Now you get to juggle who gets read/write permission to the same directories that the MySQL does... If you generalize this work above to other services, such as mail servers, web servers, etc., you'll see that you're re-solving the same kind of problem, over and over again. And when you try to worry about how much bandwidth each of these services is really consuming, one tends to migrate to virtual machines as a more complete, general solution. No matter how you cut it, you'll still have forty clients (humans, not mysql clients; each might be dozens of connections) wanting to interact with your daemon(s). Either your machine has the gnads to handle that, or it doesn't. My desktop is a dual-CPU box, with 1.5G of memory. An idle instance of MySQL looks like this: natto% ps auxwwe -p 196 USERPID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND mysql 196 0.0 1.0 11896 10728 con- S29Oct02 5023:13.08 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/natto.numachi.com.pid Having forty MySQL daemons, unto itself, doesn't cost the OS very much at all. But I _do_ think that for manageability, accounting, 'fairness' to your other clients, that there's a lot to said for sandboxing them as completely as possible. Using a jail gets you all they down to network traffic. If nothing else, you can learn who the 'piggy' clients are, and decide to migrate them to another box, where they have more room... Have fun. :) Justin -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 on virtual hosting
On Sun, Nov 24, 2002 at 10:39:43PM +0200, Sweethome.co.il Webmaster wrote: Dear list, Does any of you guys operate a mysql server in virtual hosting environment? I need some advice on tuning and restriction based on system resources. One thing you need to nail down is what the abstraction is: _how_ do you want to implement virtual hosting? For example, under FreeBSD, you can create a jail(8): a complete virtual machine tied to an IP address, and you can cram one of your (human) clients in there, with all of their services. (Before you worry about consuming all of your public IPs for such tricks, note that you can run them on private IPs, and use the kernel's ability to NAT connections in/out of the box to these virtual machines.) That technically eats more resources than other virtual hosting methods, but it most completely isolates a user from the rest of the system, if you need fine-grained control over how your machine's getting utilized, this gets you down to the nuts and bolts. The kernel itself will let you play tricks for traffic shaping, so you can constrain which of your virtual machines get traffic 'appropriately', and you can packet-filter everything to death, so that you can prevent them from running services that you don't want. This is somewhat distinct from the excellent question you ask, and I'm curious what various people's responses will be... Thanks for all answers, Justin Grindea [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: information about the tables in the database
On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db 'show tables' thanks :) Inbal - 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 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 as a desktop DB
On Tue, Sep 24, 2002 at 10:41:26PM +0100, Adam Parker wrote: I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop database? How does it compare to Access when it is used like this? I regularly use MySQL on my desktop. Under UNIX, at least, there are all sort of useful utilities that like to hook in. But is it faster than Access in the single-user environment, when dealing with large databases? I have no input, I'm sorry. I don't use M$ on my desktop. Thanks for any help. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Fw: Query to update column length
On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote: Hi all, I am writing an application that requires my application to possibly update the length of a char field while data is being imported into the db. First, can I update the size/type of a column using UPDATE? Would someone be willing to give me an example? I beleive 'UPDATE' updates records within a table, and 'ALTER TABLE' affects the characteristics of the table itself. thank you Shaun filter: mysql -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Perl DBI Interfacer
On Sat, Sep 21, 2002 at 02:06:01AM -0500, Kevin wrote: Hello, I was wondering if anyone knows PERL DBI, if so please respond to [EMAIL PROTECTED] personally, or to the list My question is, I'm trying to build a 'custom' querier for a survey program... based on the information submitted, the program will generate an SQL Query statement. The command that my program works absolutely find if I copy/paste it into MySQL, however, DBI won't pass it... if I pass the QUERY Along to DBI typed in manually it works... I'm not in the mood to unpeel this code, just to see output. As I'm curious, could you set the DBI trace (to 2 or better), run your query, and show us the logs? That we can see what DBI is getting, and what it's actually complaining about (since you didn't tell us...) Thanks Kevin -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: aggregate functions producing bad data
On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote: My query: SELECT count(id), count( IF(call_end - call_start 5, id, NULL) ), count( IF(call_end - call_start = 5, id, NULL) ) FROM t_calllog_calls; My result: 1994 1956 35 However, 1956 + 35 != 1994. Running MySQL 3.23.49-nt One thing I'd check: what happens if t_calllog_calls.id is NULL? Cheers, Rich -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: To share with MySql friends in net?
On Wed, Aug 21, 2002 at 12:30:02PM -0300, Ray da Costa wrote: Oi, for gentility! Could inform which the procedure to share the MySql that is in my machine with the escritorio friends. I may be misunderstanding you. If you have a MySQL database on your machine, and you want other people, from other machines, to access it, you need to: - make sure that MySQL is allowing network connentions (_don't_ use --skip-networking) - create users (with or without passwords), and describe which hosts that can connect from. See: http://www.mysql.com/doc/en/Connection_access.html Hope this helps... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: return row count from show processlist
On Tue, Jul 30, 2002 at 12:31:32PM -0400, Chris Friedline wrote: hello everyone, i'm a newbie so please excuse the probably dumb question. i'm using monitoring software to record the number of processes at a current time. currently, i'm just sending a show processlist and my monitoring software returns something like this: Fix your monitoring software. The SQL query 'show processlist' is just that; an SQL query. The MySQL API (either directly used, or used via the perl DBI module, or the like) will let you get a _ton_ of information about the query you've made, including the names of the columns, the number of rows, etc. thanks very much, in advance. chris -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: a newserver would be better than this mailing list
On Tue, Jul 30, 2002 at 11:11:34AM +0200, Bart Burkhardt wrote: hello list, i think it would be better to have a mysql news server instead of this email list. i will name some reasons that i think of, correct me if i am wrong.. - with a newsgroup you only select the messages that you want to read or where you can give an answer on. You can only 'select' the message once you have knowledge about what's in the headers. - with this email list my mailbox fills with too many single messages, replys are not threaded (no plus sign to expand thread) I'm using a MUA called 'mutt' that _does_ support message threads. Email and news messages use the same header information to encode that. - when i go on vacation, and return, i would have a mailbox that is flooded causing that my other messages could not be delivered. - using a newsgroup server is less waste of cyberspace because it is centrally located Not really; a single message is relentlessly copied to thousands of hosts all over the world. - a mysql newsserver could seperate different subjects like; installation / advanced query / communication / bugreport / announcements / ideas / platform sections.. - there are probably more reasons to setup a newsserver Having configured private email and news servers before: - Regardless of one's editorial decision to differentiate lists/groups, people will cross-post, or otherwise not post appropriately, and, without facist moderation, the lists/groups will essentially blur into one. - As I mentioned above, there is no distinction between an email message and a news message WRT to threading; just get a client that supports the feature. - If you're interested in a private news server (one wherein the groups aren't part of Usenet), then perhaps the only 'feature' you gain is from your news client saying 'get me messages newer than such-and-such a date'. It's often easier to read an on-line archive of the list via a web browser; if nothing else, most graphical browsers present 'new' (uncached) links in a different color than ones that are previously viewed... But I concede the usefulness of a mailing list digest. Bart - 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 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Jon Frisby---MySQL help needed
On Mon, Jul 29, 2002 at 01:13:30PM -0400, Aamer Rauf wrote: Hi Jon, Whatever you have suggested so far hasn't worked. I thought that maybe something is missing in my stating the problem and implementing your suggested solutions. So here is a more expanded picture of the queries: $sth=$dbh-prepare(INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?)); $sth-execute(,$var1,$var2); $sth=$dbh-prepare(SELECT \@t1id:=LAST_INSERT_ID()); $sth-execute(); $sth=$dbh-prepare(INSERT INTO TABLE1A (Aid,id,var1) VALUES (?, @t1id, $var1); $sth-execute(,,$var1); Doesn't this chain of events reuse the variable $sth, which essentially closes the old statement handler? Doesn't that lose state? I'm guessing... Please take a note that in the last prepare statement I have also tried \@t1id ,\@t1id, LAST_INSERT_ID(). I have used these in 'execute' statement too with question marks (?) in the prepare statement. Any new idea please? Try grabbing the new ID manually, before the second prepare: my $id = $dbh-{'mysql_insertid'}; Then, manually use that as a bind variable. Thanks, Aamer -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: auto_increment
On Sun, Jul 14, 2002 at 07:21:59PM +0200, Raymond Hamaker wrote: Hi all, When i use MS access 2000 with odbc to fill my MySQL db(running on linux) auto_increment seems not to work . Does not seem to work doesn't help us help you. What did you try to do? What did you expect to happen? What did happen? Is that normal? Or am i missing something? TIA Raymond -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Separate List For administration
On Wed, Jun 19, 2002 at 04:27:59PM -0400, Nilesh Shah wrote: MySQL Team, Can we have separate list for MySQL administration and replication?. You can start any mailing you'd like; no one's stopping you. I am sure there are lots of people here are only interested in Advance things in mysql. This is very general list. You're welcome to take any steps you want in moderating any mailing list you start up, to prevent it from becoming too general. Any one agrees with me?. In gernal, I do. :) Nilesh -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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.pm and the mysql root password
On Mon, Mar 25, 2002 at 06:12:26PM -0800, daniel wrote: so how do you install mysql.pm once you've got a password on mysql? The DBI module will make use of the DBI_PASS environemnt variable; maybe that'll help: env DBI_PASS=mySQLpass perl -MCPAN -e shell Failing that; edit the 'make test' script. Good luck... _ daniel a. g. quinn starving programmer war does not determine who is right -- only who is left. - bertrand russell -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Access denied on use mysql;
On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote: mysql Hi Colin, I wish I can be able to live chat with you, but because of my hearing impaired...it would not be possible..But what is the real problem? A few days ago I got assistance from others on my Mysql problem. It has been fixed and everything works fine. I _think_, when he said 'live chat', that he meant an IRC channel. 'Internet Relay Chat'. Just lots of typing. :) -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Create database if does not exist.
On Wed, Mar 13, 2002 at 09:40:44AM -0800, Radhakrishna Mohan Tadepalli wrote: I want to create a database test_db1, if test_db1 does not exist in the server using sql script. Is it possible? From http://mysql.com/doc/C/R/CREATE_DATABASE.html 6.5.1 CREATE DATABASE Syntax CREATE DATABASE [IF NOT EXISTS] db_name CREATE DATABASE creates a database with the given name. Rules for allowable database names are given in section 6.1.2 Database, Table, Index, Column, and Alias Names. An error occurs if the database already exists and you didn't specify IF NOT EXISTS. Did you even check the on-line manual? - 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 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 under FreeBSD 4.5
On Fri, Feb 22, 2002 at 12:10:52AM -0700, [EMAIL PROTECTED] wrote: Just recently installed FreeBSD 4.5-RELEASE and cvsup'd to latest 4-STABLE. Updated ports tree and did a make install in /usr/ports/databases/mysql323-server and received the following on the mysql_install_db part: I have not tried to install MySQL under 4.5-RELEASE yet, but, in the past, I've never failed to build MySQL from source under FreeBSD. What is the port accomplishing? Maybe you could trying installing MySQL from source. Merely a suggestion; I realize this doesn't answer your question, though... /usr/local/bin/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthread/uthread _create.c (errno = ?) Abort trap - core dumped Installation of grant tables failed! Hmm, one problem I _did_ have, way back when: MySQL's makefiles try to use '-O6' as a compiler flag. Try setting that to something sane like '-O2'. From source, I was doing this (to prevent segfaults under 4.1-RELEASE): env CC=gcc CFLAGS=-O2 CXX=gcc \ CXXFLAGS=-O2 -felide-constructors -fno-exceptions -fno-rtti \ ./configure \ --disable-shared \ --enable-assembler \ --enable-large-files \ --without-debug Good luck... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Need help please!
On Thu, Feb 14, 2002 at 01:05:24PM -0500, Richard C Rossy wrote: Ok I can't seem to get this. Now is it possible to have MySQL on a other computer and run the script. In other words the perl script is on foo.com and MySQL database is on foo2.com. What is need to make the script work. What I have in the script is: Have you actually read the perl docs for DBI? DBI Class Methods ... connect $dbh = DBI-connect($data_source, $username, $password) or die $DBI::errstr; ... Examples of $data_source values are: dbi:DriverName:database_name dbi:DriverName:database_name@hostname:port dbi:DriverName:database=database_name;host=hostname;port=port There is no standard for the text following the driver name. Each driver is free to use whatever syntax it wants. So - compare the documentation with what your effort was, and note the difference: $dbh = DBI-connect(DBI:mysql:$mysqldatabase, $mysqlhost,$mysqlusername, $mysqlpassword) || die(Couldn't connect to database!\n); -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: HELP: cannot connect to MySQL server
On Thu, Feb 14, 2002 at 03:41:32PM -0800, wally liau wrote: Dear MySql experts: we have mysql and mm driver installed on a unix server, but when I try to run Blob (in testsuite/), it gives error message: cannot connect to MySQL server on //localhost:3306 Can you, at this point, connect to the server via the 'mysql' binary? - Is there a server running on this machine? - Is there a server running on this machine at port 3306? - Is there a server running on this machine at port 3306 that lets user 'test' coonect with the password 'test'? our system admininstor doesn't seem to know what's going wrong (that's why I'm looking for help from mysql community). I'm sorry. :/ -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Re: Access denied to apache@localhost
On Wed, Feb 13, 2002 at 12:04:22AM +0100, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query Should I just put these words into my signature, just so I can contribute to the mailing list? If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: On Sun, Feb 10, 2002 at 11:58:12AM +0100, Nick Wilson wrote: Hi all I've just set up and the latest problem I have getting started is that 'Access denied for user: apache@localhost' msg. How can I put that right? Either a) grant appropriate priveleges to the user in question, or b) tell the invoking code to use a user ID with appropriate priveleges. It obviously depends on what problem you're atcually trying to solve... -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Re: How to duplicate a table complete with indexes? #
On Fri, Feb 08, 2002 at 09:09:39PM +0100, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query This 'anti-spam' measure, is kinda lame, I must say. (Picture that said in an Ed Grimley voice. If you understand _that_, shame on you! :) If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: On Fri, Feb 08, 2002 at 01:22:08PM -0600, BD wrote: This works fine except it doesn't create any indexes that OldTable had. Is there a generic way to duplicate a table that includes the indexes? I don't want to have to manually create indexes for it. What's wrong with outright copying the files associated with the table? (Assuming the table's not in use). I would _assume_ that this would work; i havent' tested it, of course... TIA Brent -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Re: How to duplicate a table complete with indexes? #
On Fri, Feb 08, 2002 at 09:09:39PM +0100, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query This 'anti-spam' measure, is kinda lame, I must say. (Picture that said in an Ed Grimley voice. If you understand _that_, shame on you! :) If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: On Fri, Feb 08, 2002 at 01:22:08PM -0600, BD wrote: This works fine except it doesn't create any indexes that OldTable had. Is there a generic way to duplicate a table that includes the indexes? I don't want to have to manually create indexes for it. What's wrong with outright copying the files associated with the table? (Assuming the table's not in use). I would _assume_ that this would work; i havent' tested it, of course... TIA Brent -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: mysqld with daemontools
On Wed, Jan 30, 2002 at 01:31:53PM +0900, Tatsuhiko Miyagawa wrote: Has anybody out there experienced with mysqld running on daemontools? Yes. We're now testing this combination on our staging server without any problem, but if you can suggest any problem for it or anything, it would be appreciated. * Environment mysql 3.23.47 FreeBSD 4.4R I've done it under FreeBSD 4.2. % cat /service/mysqld/run #!/bin/sh PATH=/usr/local/bin:/usr/bin:/bin export PATH exec env - PATH=$PATH /usr/local/mysql/libexec/mysqld 21 I have a whole pile of scripts for mysqld itself, logging, and a control script for starting/stopping mysql. What do you need? -- Tatsuhiko Miyagawa [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Test Case (Urgent)
On Fri, Jan 11, 2002 at 04:48:18PM +0530, Manish Mehta wrote: Hi, I am new to test case design in Database. I wants to know Basically how to calculate the Maximum Database. A database can consist of several tables. Each table is stored (essentially) as a file. The size of a that file depends on a) your operating system, and b) which table type you use. See the list's archives for some specific numbers. When we have to take backup.? What do you mean by 'backup'? Copying the database's files directly to tape? That depends on your computer's disk subsystem, and what you're writing them to. 'Dumping' the database to a file? That also depends on your computer's disk subsystem, and might also be limited to your CPU and how much physical memory you have. What are steps to be flow please tell me. The 'best' thing to do, for whatever methods your speaking of, is: 1) install MySQL on the hardware where all of this would take place; the software is freely available. 2) create a database and a table, and try to fill it; shouldn't take more than a couple of hours, assuming you're willing to cobble a script together. 3) try to back up the database you just created. Honestly, your own experiments will give you the most concrete numbers, given the hardware and methods you have... Thanks in advance. Manish Mehta E-mail: [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Location of databases
On Tue, Jan 08, 2002 at 10:04:40AM -0500, Michael D. Stackhouse wrote: We run MySql on our Freebsd server, and on our Win2K server. We have several clients, and would like to store the databases in the clients' root directory. Is this possible? Under UNIX, all of the separate databases exist as a unique subdirectory under a directory; see references to DATADIR in the documentation. Any one database's tables exists as separate files within the respective database directory. You can physically relocate a database directory to wherever you want, as long as you maintain a symlink to it from the DATADIR. Bear in mind that the MySQL engine will be running as a specific UID, and that UID will need read/write permission for the database's new home... Thanks! -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: hey folks!
On Mon, Jan 07, 2002 at 03:52:10PM -0800, Viorel C wrote: I'm a newbie in DB administration. Could somebody tell me what do I need to start a web-based project for book listing, mail lists etc, all retrieved from a database updated by LAN users and listed on a web page? Go for www.freshmeat.net, and look for pre-built stuff. Telling you 'what you need', with no information, is an excercise in futility... Good luck. Thanks in advance! Viorel C -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: killed by SIGSEGV
On Tue, Dec 04, 2001 at 04:40:23PM +, matt wrote: Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' Something that was affecting me adversely in the past: I _think_ MySQL is built with '-O6', as a compiler flag, and using anything more that '-O2' with g++ can introduce buggy code. Ater least, I ran into this under FreeBSD 3.4, running gcc version 2.7.2.3. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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, mySQL keeps crashing.
On Mon, Oct 01, 2001 at 04:41:58PM -0600, Spinlock wrote: I was using gcc not g++ The guts of MySQL are written in C++, and hence the Gnu C++ compiler will be used: From the manpage gcc(1): DESCRIPTION The C and C++ compilers are integrated. Both process input files through one or more of four stages: prepro- cessing, compilation, assembly, and linking. Source file- name suffixes identify the source language, but which name you use for the compiler governs default assumptions: gccassumes preprocessed (.i) files are C and assumes C style linking. g++assumes preprocessed (.i) files are C++ and assumes C++ style linking. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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, mySQL keeps crashing.
On Thu, Sep 27, 2001 at 07:19:02PM -0600, Spinlock wrote: Hello. I am running mySQL 3.23.42 on FreeBSD 4.2. I have compiled it with InnoDB and full debug to help figure out why it keeps crashing. I've done a few core dumps and I'll paste 3 of them, it keeps on crashing in the same function all the time. The configure flags I used are: env CFLAGS=-O3 -mpentiumpro CXX=gcc CXXFLAGS=-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --with-debug --with-innodb Please advise what to do. Using '-O3' is not advisable with the g++ compiler family. Try reconfiguring with just '-O'. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: site admin and log script needed
On Thu, Sep 27, 2001 at 07:43:30AM +1000, mike wrote: Hi All, I have built a PHP database driven website and am now looking for a good script that I can place on the server to track visits to the site. I want to place all the info in a mySQL database and be able to view the results on the web. Can anyone point me to a good script for this purpose. I would like to record hits to the site but not necessarily display the number on the website files. This doesn't sound like a MySQL question. Are you asking about analyzing your web access logs? TIA -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
replication issue with FreeBSD 4.2-RELEASE
I'm exploring mysql replication under FreeBSD 4.2-RELEASE. Two machines, named 'master' and 'slave', each running FreeBSD 4.2-RELEASE and MySQL 3.23.36-debug. I've followed the instructions at http://www.mysql.com/doc/R/e/Replication_HOWTO.html All very straight forward. When I spin everything up, I see these errors on the slave server: /usr/local/libexec/mysqld: ready for connections 010718 19:28:17 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 010718 19:29:22 Error reading packet from server: Lost connection to MySQL server during query (read_errno 35,server_errno=2013) 010718 19:29:22 Slave: Failed reading log event, reconnecting to retry, log 'master-bin.001' position 803 010718 19:29:22 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'master-bin.001' at position 803 And the last two errors just keep repeating. I can otherwise connect just fine: slave% mysql -u repl -prepl -h master.xxx.xxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 58 to server version: 3.23.36-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql quit Bye I presume 'read_errno 35' refers to: 35 EAGAIN Resource temporarily unavailable. This is a temporary condition and later calls to the same routine may complete normally. Does anyone have any insight? Funky hardware? The list has mentioned 4.2-RELEASE having threading problems, fixed in 4.3. Might this be the case? I don't want to have to upgrade the OS, out-of-hand. Upgrade the version of MySQL on the master a/o slave? I see some changes WRT replication: F.2.1 Changes in release 3.23.40 Added slave_wait_timeout for replication. F.2.3 Changes in release 3.23.38 Better error message when slave max_allowed_packet is too low to read a very long log event from the master. F.2.4 Changes in release 3.23.37 Fixed bug that erroneously logged a drop of internal temporary table on thread termination to the binary log - bug affected replication. Would any of these apply to the errors I'm seeing? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 loves FreeBSD (but not NetBSD) ...
On Tue, Jul 17, 2001 at 10:05:24PM -0400, Haapanen, Tom wrote: ... or should that be FreeBSD loves MySQL? I finally caved in after a year of increasing (and unexplained) MySQL crashes, despite numerous updates to more recent versions of NetBSD and MySQL, and dozens of experiments with different configuration options. MySQL would die (and restart automatically) every 5-15 minutes on the database server acting as the back end for our web site, motorsport.com. (This on NetBSD/i386, as when we started, MySQL was distinctly unhappy with NetBSD/Alpha) FWIW - I had nasty problems with stable builds under FreeBSD, until I noticed the build process was trying to make use of '-O6' when compiling C++ code using GCC 2.95.2 ; not a good combination. When I switched to using env CC=gcc CFLAGS=-O2 CXX=gcc \ CXXFLAGS=-O2 -felide-constructors -fno-exceptions -fno-rtti \ ./configure ... To configure, the binary was much more stable. (This is as of mysql-3.23.35.) Maybe that was a similar issue under NetBSD... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
On Thu, Jul 12, 2001 at 03:49:12PM -0700, Jeff Philapy wrote: It is hard to say where I am confused because the HOWTO requires me to try and follow it as I setup replication. So let me try and follow the documentation and if I see anything that can make it more clear then I will let you know. One thing that does come to mind though is maybe adding something that helps users to understand the process a little more clearly in advance without having to try and follow the documentation first. I don't know what you would put for that. I do have one question though, where is the my.cnf located? I ran locate my.cnf and it returned no results. There may not be one at all. All of the directives in my.conf can be supplied on the command line to mysqld. I prefer to avoind my.cnf for a variety of reasons, not the last of which is that I can, from 'ps', see pretty much everything I need to know about the daemon. Note the last three of these lines. I've censored some sensitive information, but the rest show you what you might need WRT supplying stuff on the command line. (I may not have all of this correct, BTW. I'm still exploring replication myself.) slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid` USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND mysqld 61562 0.0 0.2 11220 1768 p0- S22Jun01 4:22.20 MYSQL_TCP_PORT=3306 log_dir=/var/mysqld/log TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777 /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english --port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info --set-variable=max_connections=1000 --master-host=* --master-user=repl --master-password=** --server-id=2 --log-slave-updates --log-bin=/var/mysqld/log/slave1-bin --log-update=/var/mysqld/log/slave1 But, as to your original question: see http://www.mysql.com/doc/O/p/Option_files.html For a description of possible locations for my.cnf. Thanks, Jeff -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: out of memory
On Mon, Jul 09, 2001 at 08:14:24PM -0600, David Keeney wrote: dies (during the execute statement) with the error : Out of Memory: Killed process 31666 (temp.pl). Killed Look for 'SQL_BIG_TABLES' in the Docs... `SQL_BIG_TABLES = 0 | 1' If set to `1', all temporary tables are stored on disk rather than in memory. This will be a little slower, but you will not get the error `The table tbl_name is full' for big `SELECT' operations that require a large temporary table. The default value for a new connection is `0' (i.e., use in-memory temporary tables). -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: help meeeeeeeee
On Wed, Jul 04, 2001 at 12:01:19AM -0500, ryc wrote: It sounds like you are asking for comments reguarding your choice of vb/mysql... If that is the case, sure it can be done. The only problem I can see if you plan on having end users use this program, they would have to install and configure Mysql on their computers. This might be a bit of a burdon for them. But that is for you to decide. Not strictly true, without more details; the M$ clients could be talking to a centralized MySQL server via ODBC. The list can offer more advice if you ask more specific questions. ryan -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
replication doesn't maintain logs?
I hope I've merely misread instructions. I've successfully set up replication, a master to one slave. However, even though the slave was comfigured to maintain both a 'classic' update log, as well as a binary log, none of the stuff it's replicating are reflected in the logs. Said logs are created: slave1# ls -ld * -rw-r--r-- 1 mysqld mysqld 73 Jun 18 18:53 slave1-bin.001 -rw-r--r-- 1 mysqld mysqld 31 Jun 18 18:53 slave1-bin.index -rw-r--r-- 1 mysqld mysqld 69 Jun 18 18:53 slave1.001 But, this is after I imported an entire database via replication. Does anyone have any advice? My environment: slave1# uname -r -s FreeBSD 4.2-RELEASE slave1# /usr/local/libexec/mysqld -v /usr/local/libexec/mysqld Ver 3.23.36 for unknown-freebsdelf4.2 on i386 slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid` USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND mysqld 55910 0.0 2.5 26976 25644 p0 SMon06PM 26:31.02 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld log_dir=/var/mysqld/log TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777 /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english --port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info --set-variable=max_connections=1000 --master-host=bmdb1.ops.about.com --master-user=repl --master-password=* --server-id=2 --log-bin=/var/mysqld/log/slave1-bin --log-update=/var/mysqld/log/slave1 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Re: replication doesn't maintain logs?
No, this isn't spam. I was publicly thanking someone for advice given. :/ On Thu, Jun 21, 2001 at 08:25:37PM -, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: On Thu, Jun 21, 2001 at 08:53:31AM -0700, Ben Curtis wrote: You need to have log-slave-updates in my.cnf Ah! Thanks for the pointer; let me try that out... -- My pid is Inigo Montoya. You killed -9 my parent process. Prepare to vi. Cute .sig. :) -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Problem building MyODBC 2.50.37 on BSD
On Wed, Jun 20, 2001 at 10:59:46AM -0500, Jeff Jirsa wrote: Hi, I'm having a problem building MyODBC 2.50.37 on BSD. When I run make after configure, I get the error: Makefile, line 315: Need an operator make: fatal errors encountered -- cannot continue When I see this, my first assumption is the makefile author assumed GNU make, rather than BSD make. Install the 'gmake' package, for a quick test.. Line 315 contains: -include $(DEP_FILES) If I comment out 315 and run make again, I get: make: don't know how to make catalog.lo. Stop Please HELP! I've compiled other projects using configure and have never seen this problem before. I am running FreeBSD 3.4 i386, MySQL v3.23.38 database, and unixODBC 2.0.7 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: Can anyone help me.. for install on a Freebsd 4.2 box..
On Thu, Apr 19, 2001 at 11:37:14AM -0700, Larry Caragay wrote: Would anyone out there have the installation instruction for Mysql for a FreeBSD 4.2 box??? I've built it several times under FreeBSD 4.2. WHat problem are you seeing? Larry P.S. Thanks in advance... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
OUTFILE ownership under mysqld 3.23.36-debug
Ok, this is confusing me. Under FreeBSD 4.2 and MySQL 3.23.36-debug: The mysqld process is not running as root, but as 'mysqld:mysqld'. bmdb2# ps -orgid,ruid,command -eww -p 46884 RGID RUID COMMAND 6724 6724 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld/db/mojo log_dir=/var/mysqld/log TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777 /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english --port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info --set-variable=max_connections=1000 --log-update=/var/mysqld/log/bmdb2 The 'RGID RUID' is the real (as opposed to 'effective') GID and UID of the process. Then there's the environment. Then the arguments to the server itself. (You may not that I'm not using /etc/my.cnf to configure the server; I prefer to see the arguments.) Also, the server was lauched outright as UID mysqld, so I'm not using '--user'. The user 'mysqld' has it's own group, and that's the only group it's in: bmdb2# id mysqld uid=6724(mysqld) gid=6724(mysqld) groups=6724(mysqld) Yet, somehow, an SQL command such as this: select username from user limit 5 into outfile '/var/tmp/mysqld/sample'; creates a file with the 'wheel' group: bmdb2# ls -ld /var/tmp/mysqld/sample -rw-rw-rw- 1 mysqld wheel 65 Apr 10 19:36 /var/tmp/mysqld/sample I have no idea how a non-root process can set a different group than it's own. I can't find any suid/sgid code in the installed MySQL code. Does anyone have any insight on this? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 dbi modules
On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote: HI, I sent this note a couple days ago and no one has commented. I am trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed successfully byt the Mysql-modules failed druing the 'make test' step.I am using mysql version 3.23.32-log. MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf. _Where_ is the socket? Assuming you've done a 'make install' as root, and you are running 'make test' as a mere mortal, do you have read permissions on the full path to the socket? (Remember that you need read _and_ execute permissions on directories.) You make it sound like you're using a relative path 'local/mysql'; that doesn't sound right. What _do_ you have in my.cnf? (I, for one, _never_ use my.cnf. In fact, I don't use safe_mysqld, either; I run mysql, with a ton of command-line flags, directly under a watchdog script.) I don't know the details of how you set everything up, but it would seem you managed to trick either the test scripts in Msql-Mysql-modules-1.2215.tar.gz (which is possible), or you've built/run MySQL itself in a confusing manner, such that safe_mysqld is really running it with different paramaters than you've intended. If you have read access to the socket, but the '10dsnlist' can't tell it there, then perhaps the test script is making a bad guess. You can tell MySQL clients to look for the socket via an environemnt variable: section A Environment variables: MYSQL_UNIX_PORT The default socket; used for connections to localhost. Maybe that'll help... Any help would be appreciated, TIA Subject: Mysql dbi modules I have almost installed all of the dbi/dbm modules but can't get thru the 'make test'. I get the error msg: 't/10dsnlist.DBI-connect(database=test) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at t/10dsnlist.t line 45' MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf How can I change the test to reference the current setup? Thanks, Dave - 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 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: There are no DB defined space limits on MySQL Databases ?
On Tue, Feb 20, 2001 at 09:33:40AM +0800, yindu wrote: thank you. i know mysql stored its tables in files,And i have looked through the mysql handbook.But i hadn't found information about the file systerm of mysql,i think a table is a file,then all tables in the same database should be stored in the same file_content.But where can i find them? I'm assuming you've installed MySQL under some kind of UNIX. If so: MySQL does not have it's own 'filesystem'; it stores everything in several large files in the UNIX filesystem. MySQL (by default) keeps it's databases in /usr/local/var. This is the 'datadir' parameter to the server. You can see what yours is set to: % echo 'show variables' | mysql This will dump out a list of all of the configuration variables your server is using. Look for 'datadir'. Within that directory, there will be several sub-directories (yours will be different than mine): % ls -l /usr/local/var drwx-- 2 root wheel 512 Apr 26 2000 customers drwx-- 2 root wheel 512 Apr 26 2000 mysql drwx-- 2 root wheel 512 Apr 26 2000 test Each one of these is a database. My MySQL server has three databases, 'customer', 'mysql' and 'test'. 'mysql' is the database that the server itself uses to keep track of valid users, permissions, and the like. 'customer' is one I use for a project. That directory contains several files: % ls /usr/local/val/customer customer.ISD customer.ISM customer.frm site.ISD site.ISM site.frm My database 'customer' has two tables: 'customer' and 'site'. MySQL stores the information about any one table in three files. For example, my customer table has three files: customer.ISDthis is the data file customer.ISMthis is the index file customer.frm(I forget what this is, sorry) Where can i find local informations? I don't know what you mean; sorry. :/ now i create a database named yd for my database user.If i want to know how much space have been used,what can i do ? The 'space used' by a database is the amount of diskspace taken up by the subdirectory, including all of its files. One way is with the 'du' command: % du -k /usr/local/var/customers 20843 The '-k' flag means "count in 1024 byte blocks". Therefore, I'm using 20843 * 1024 = 21343232 bytes. (About two megabytes.) Hope this helps... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: There are no DB defined space limits on MySQL Databases ?
On Fri, Feb 16, 2001 at 10:46:40AM -0800, Fox Mulder wrote: --- Brian Reichert [EMAIL PROTECTED] wrote: On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: There are no DB defined space limits on MySQL Databases ?It's dangerours .How to control the database space on my database user? Filesystem quotas. But, to define filesystem quota, I will need to change de Owner of the file to the name of the respecive user right? Example: if the table belong to user max, I'll: chown max.users *.ISM Right?? Well, let me make sure I undertand what you mean. If _all_ of the database tables are owned by the same user (ie. the user the mysqld runs as), then you could arrange that the database tables live on their own filesystem. If the database tables have to co-exist if other files owned by other users, then yes, you'd have to employ per-user quotas. As you how your OS imposed those limits, you'd have to do research. But yes, at the very least, those database table files would have to be owned by the user you're trying to constrain. If that user is different than the UID that mysqld runs under, then you'd have to assure that mysqld has read/write access to the file. As I write this, I realize I don't know if/how quotas will be imposed when mysqld's UID write to a file owned by otheruser. I suspect that mysqld's own limits will be enforced, not otheruser's. Look into: - putting the worrisome files onto their own filesystem. - resource limits (RLIMIT_FSIZE in setrlimit(2), for example. My OS (FreeBSD) has a command-line tool [limits(1)] for contraining processes. - filesystem quotas. My OS lets me have both user and group quotas. YMMV. []'s Fox W. Mulder __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.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 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: There are no DB defined space limits on MySQL Databases ?
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: There are no DB defined space limits on MySQL Databases ?It's dangerours .How to control the database space on my database user? Filesystem quotas. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: /tmp/mysql.sock disappearing?
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote: I couldn't fine this mentioned in the archives, so I hope someone has seen this before: I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. There is still server process (sleeping), and there is still a pidfile. This can happen after ten or fifteen minutes of queries. I don't have a cronjob, or any other external process that scrubs /tmp. I have to apologize to everyone; I found out that I _did_ have a cronjob that caused this socket to go away: I had been doing this nightly: /usr/local/bin/mysqladmin -uroot -proot flush-logs /usr/local/bin/safe_mysqld safe_mysqld out-of-hand removes $MYSQL_UNIX_PORT; I don't know why. (I also don't know why I felt the need to restart mysqld after a flush-logs.) Thanks for everyone's advice... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
/tmp/mysql.sock disappearing?
I couldn't fine this mentioned in the archives, so I hope someone has seen this before: I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. There is still server process (sleeping), and there is still a pidfile. This can happen after ten or fifteen minutes of queries. I don't have a cronjob, or any other external process that scrubs /tmp. Has anyone seen this sort of symptom before? FWIW, the details: OS: FreeBSD 3.4-RELEASE MySQL 3.22.32 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: /tmp/mysql.sock disappearing?
On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote: I've seen it after installing two versions of MySQL on one server. I forgot to set another location for the second MySQL process before starting it with /bin/safe_mysqld. The result was that the socket was removed by the second process. Looking at safe_mysqld you would probably get the same result if you run multiple MySQL processes of the same version but from different data directories. Believable, but we in fact only have the one instance of mysql running. :/ 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 -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
logging to a FIFO?
I _used_ to be able to log to a FIFO as recently as mysql-3.22.32, but now with mysql-3.23.33, I can't: 010213 17:03:11 Could not use /var/mysql/db/localhost.fifo for logging (error 29) where in /usr/include/sys/errno.h: #define ESPIPE 29 /* Illegal seek */ I'm guessing someone's trying to seek on my log file. :/ What gives? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: /tmp/mysql.sock disappearing?
On Wed, Feb 14, 2001 at 09:03:16AM +0800, Rolf Hopkins wrote: Do you have a cron job that's cleaning up your socket file along with whatever other garbage it's cleaning up? Nope. As I said in my original mail: I don't have a cronjob, or any other external process that scrubs /tmp. I'm waiting for it to happen again; it's been behaving for twelve hours now... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: table too big to dump?
On Wed, Feb 07, 2001 at 05:38:49PM -0600, Dan Nelson wrote: It's probably trying to read the whole table into memory. Try adding "--opt" to the mysqldump commandline. OK, I've had _many_ responses that in effect say 'use -q' (--opt is a superset). It works. Thanks. Dumb question: why isn't the -q behavior the default bahavior? Under what conditions is it advantageous to _not_ use -q? -- Dan Nelson [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
table too big to dump?
I apologize if this has been discussed already, but I quick poke at the archives didn't reveal anything. We have a table that iamchk says is fine. We are trying to get an SQL dump of this table. But, we keep getting out-of-memory errors. I've tried several things, all to no avail, and I'm looking for advice/suggestions. Some real details: The platform: FreeBSD 3.4-RELEASE on a dual-CPU box, with 1G of physical and 2G of swap. We're running MySQL 3.22.32. This machine is idle; there are no other processes, no uses of the database, other than my client. The table: # ls -l audit_trail_271.* -rw-rw 1 root wheel 1486838307 Nov 10 05:26 audit_trail_271.ISD -rw-rw 1 root wheel84807680 Nov 10 05:26 audit_trail_271.ISM -rw-rw 1 root wheel9060 Oct 25 05:06 audit_trail_271.frm # isamchk audit_trail_271.ISM Checking ISAM file: audit_trail_271.ISM Data records: 3869676 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links When I try to do a mysqldump on the localhost, I get an out-of-memory error: # mysqldump -uroot -proot customer audit_trail_271 mysqldump: Out of memory (Needed 8164 bytes) mysqldump: Got error: 2008: MySQL client run out of memory When I try to a dump from over the network: # mysqldump -uroot -proot -h db_host1 customer audit_trail_271 # MySQL dump 7.1 # # Host: db_host1Database: customer # # Server version3.22.32-log # # Table structure for table 'audit_trail_271' # CREATE TABLE audit_trail_271 ( audit_trail_id int(10) unsigned DEFAULT '0' NOT NULL auto_increment, account_id int(10) unsigned DEFAULT '0' NOT NULL, user_id int(10) unsigned, bid_id int(10) unsigned, cpc int(10) unsigned, ics2_id int(10) unsigned, action varchar(20) DEFAULT '' NOT NULL, acct_amt int(11) DEFAULT '0' NOT NULL, gift_amt int(11) DEFAULT '0' NOT NULL, free_amt int(11) DEFAULT '0' NOT NULL, bill_amt int(11) DEFAULT '0' NOT NULL, decl_amt int(11) DEFAULT '0' NOT NULL, ref_base varchar(40), ref_more text, apache_log text, mtime timestamp(14), ctime datetime, PRIMARY KEY (audit_trail_id), KEY account_id (account_id) ); # # Dumping data for table 'audit_trail_271' # And there it hangs forever. As in, I let is sit for hours, and no data comes over the pipe. The server admits there's a connection: # echo 'show processlist;' | mysql -u root -proot customer Id UserHostdb Command TimeState Info 162128 rootdb_host2 customerQuery 446 Sending data SELECT * FROM audit_trail_271 162130 rootlocalhost customerQuery 0 NULLshow processlist And, if I simply do a 'select *', and dump all output into a bitbucket: # echo 'select * from audit_trail_271;' | mysql -u root -proot customer /dev/null mysql: Out of memory (Needed 8164 bytes) ERROR 2008 at line 1: MySQL client run out of memory Does anyone have any advice about how I can get a dump of this table? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: table too big to dump?
On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote: When I try to do a mysqldump on the localhost, I get an out-of-memory error: # mysqldump -uroot -proot customer audit_trail_271 mysqldump: Out of memory (Needed 8164 bytes) mysqldump: Got error: 2008: MySQL client run out of memory Sorry about a rely to myself; on a lark, I did some exploring, and the use of the '--opt' flag made the difference. What is that [not] doing, that changed the behavior of eveything? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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 Tables over Multiple Drives
On Tue, Jan 30, 2001 at 06:51:01AM -0500, Jason Frisvold wrote: Well, there are a few reasons.. We have a system with 4 8G drives.. If we use one for root and one to mirror that root, we have 2 drives left. Now, if we raid those 2 remaining drives (RAID5) we get about 12 Gigs of space available... I'm confused; what does RAID5 on just two drives get you? One drive, and you're still dead. I would have thought that (in this case) just striping would have been the way to go... --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "I love deadlines. I especially like the whooshing sound they make as they go flying by." -- Douglas Adams -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: 'USE_RAID' in mysql-3.22.32?
On Mon, Jan 29, 2001 at 11:48:29PM +0100, Tonu Samuel wrote: On Mon, 29 Jan 2001, Brian Reichert wrote: In pawing though the source for mysql-3.22.32 (our current version in production), I noticed in acconfig.h, a macro 'USE_RAID', which in term seems to set up the use of include/raid.h. But, I can't find any documentation for this, and the configure program doesn't seem to set it one way or another. What is the state of that code? For that version of MySQL, it it useful/meaningful to activate it, if I intend to make use of a RAID array? This is impossible. RAID was introduced in 3.23.x series. Also documentation have evreything about it. 'Impossible'? Just now, I can grab: http://www.mysql.com/Downloads/MySQL-3.22/mysql-3.22.32.tar.gz And, in that tarball, on line 190 of acconfig.h: /* Use MySQL RAID */ #undef USE_RAID And there is a include/raid.h. And, Docs/mysqld_error.txt has this message defined: #define ER_NO_RAID_COMPILED 1174 "This version of MySQL is not compiled with RAID support", There is no 'RAID' attribute to the 'CREATE TABLE' syntax in the supplied docs. My question was: What is the state of that code? I _surmise_ that it's unused code, as it was not fully implemented at this point. I was uncertain if it was code that specific to the yet-to-be-introcuded RIAD attributes to a table, or if it just messed with the layout of files on disk to allow for better performance in general on RAID arrays. I merely wanted verification. Tonu -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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
'USE_RAID' in mysql-3.22.32?
In pawing though the source for mysql-3.22.32 (our current version in production), I noticed in acconfig.h, a macro 'USE_RAID', which in term seems to set up the use of include/raid.h. But, I can't find any documentation for this, and the configure program doesn't seem to set it one way or another. What is the state of that code? For that version of MySQL, it it useful/meaningful to activate it, if I intend to make use of a RAID array? -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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