Too many mysqld-max processes!!
Hello, I am running mysql on linux and I have too many mysqld-max processes running at the same time. Why is that and what can I do about it apart from killing the processes after every boot? Thanks in advance, Balteo. - 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
Nested queries and joins
Hello, I have the following nested query that I would like to port to Mysql: SELECT * FROM ad_catego WHERE db_subcategory NOT IN (SELECT rules.db_subcategory FROM rules WHERE rules.db_login='$session_login') AND db_category_int =2 The query uses two tables desc ad_catego; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | db_subcategory | varchar(30) | | PRI | | | | db_category| varchar(15) | | | | | | db_category_int| smallint(6) | | | 0 | | | db_subcategory_int | smallint(6) | | | 0 | | ++-+--+-+-+---+ desc rules; ++-+--+-++---+ | Field | Type| Null | Key | Default| Extra | ++-+--+-++---+ | db_login | varchar(15) | | PRI || | | db_subcategory | varchar(30) | | PRI || | | db_daterule| date| | | -00-00 | | ++-+--+-++---+ I tried several joins without success... I would like to select all the subcategories that a user does not have. Can anyone help? Thanks in advance, Balteo. - 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
InnoDB logs
Hello, I have a couple of questions regarding InnoDB logs' structure. -Are the innodb logs stored in the main innodb tablespace? -How is the information stored in the logs? Does it look like SQL queries as the mysql binary update logs do? -What is the difference between the mysql binary logs and the innodb logs? (apart from the fact that update logs are used in case of a manual recovery and innodb logs are used in case of a automatic recovery.) Thanks in advance, Balteo. - 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
3.23.50???
What's going on at Mysql?? When can we expect 3.23.50??? Balteo. - Original Message - From: Rodrigo Pérez <[EMAIL PROTECTED]> To: <> Sent: Sunday, May 05, 2002 11:32 PM Subject: Re: Optimization > Thanks Jay, > Actually what i want to do is much more simple. I want to have on the same > query result, the first 10 rows with this word and the total of rows from > the table with this specific word. > > The result should be like a search engine page result. Has the total of > pages with that word and the first 10 results. I want to put it together in > only one query. Is it possible ? > > SELECT COUNT(*) from TABLE where name="JOHN" > SELECT * from TABLE where name="JOHN" limit 10 > > Thanks, > Rodrigo > - Original Message - > From: "Jay Blanchard" <[EMAIL PROTECTED]> > To: "'Rodrigo Pérez'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, May 03, 2002 2:23 PM > Subject: RE: Optimization > > > > [snip] > > I want to optimize one of my php scripts to acess mysql only once. Is > there > > anyway to put these two queries together: > > > > SELECT COUNT(*) from TABLE where name="JOHN" > > SELECT * from TABLE where name="JOHN" limit 10 > > [/snip] > > > > try > > > > select *, > > sum(if(name = 'JOHN', 1, 0)) AS COUNT > > from table > > where name = 'JOHN' > > group by name > > > > HTH! > > > > Jay > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB's inner workings + checkpoints
Hello Heikki, I have read up on checkpoint activity and innodb and there are still a few points I don't understand: -what is the chronological sequence of events for a write into the innodb tablespace? -Is it: 1. An insert sql statement is issued from a mysql client. 2. The record is stored in the log buffer. (no disk access here) 3. The record is stored in the innodb log and in the buffer pool simultaneously. (1st disk accesss) (checkpoint) 4. The record finally makes it to the innodb tablespace and is saved to disk. (2nd disk access) Can you please correct the above if it is wrong. Thanks in advance, Balteo. - 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
InnoDB's inner workings and checkpoints
Hello (Heikki), I have read up on checkpoint activity and innodb and there are still a few points I don't understand: -what is the chronological sequence of events for a write into the innodb tablespace? -Is it: 1. An insert sql statement is issued from a mysql client. 2. The record is stored in the log buffer. (no disk access here) 3. The record is stored in the innodb log and in the buffer pool simultaneously. (1st disk accesss) (checkpoint) 4. The record finally makes it to the innodb tablespace and is saved to disk. (2nd disk access) Can you please correct the above if it is wrong. Thanks in advance, Balteo. - 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
Help with mysql installation
Hello, I am trying to install mysql from RPMs. My installation guide requires: -Mysql server -Mysql shared -Mysql client However those files are not present on mysql's website. Where do I find them?? Is the file available at Mysql.com sufficient for a server + client installation? Thanks in advance, Balteo. - 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
What is the completion hash??
> > >Can anyone tell me what the completion hash is please? > >Where can I find documentation about the completion hash? > >Thanks in advance, > >Balteo. sql,query > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help restoring data with mysqlbinlog
Victoria, Thanks for replying. How does one know what parameter to pass on as "position", in other words how do I know from what point to start the roll-forward from the binlog? What's more what format is this parameter? (timestamp, integer??) Thanks, Balteo. P.S. I tried "mysqlbinlog --help" but It doesn't tell you much - 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
Help restoring data with mysqlbinlog
Hello all, I am trying to restore some data from the binary log and I am not sure on how to proceed. I understand restoring data is a two-stage process: 1. You start by restoring data saved with mysqldump. 2. Using mysqlbinlog, you restore the data logged in the binary log from the point where mysqldump stopped. It is on this second point that I would be grateful to get some help. My question is specifically: how does one know the value of the parameter "position" to pass on to mysqlbinlog? Thanks in advance, Balteo. (NOTE: this is a rephrased post of an earlier post that may have been confuse) - 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
mysqlbinlog: Duplicate entry '1' for key 1
Hello, I am trying to restore some data from the binary log but I get the following error: "Duplicate entry '1' for key 1" I understand restoring data is a two-stage process: 1. You do a "source myfile.sql" to restore the data saved with mysqldump 2. You restore the data logged in the binary log using mysqlbinlog I am having the above problem at the second stage and what's more, I don't understand how mysql is supposed to know from what point to start the restore from. Thanks in advance, Balteo. - 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: DESPERATE NEED FOR HELP!!!!!
Why don't you create a php script that generates SQL instead of HTML; i will repopulate your database acting as a dump? I know it will take some time to develop... Balteo, John Parsons wrote: >I have just been a complete muppet and trashed the tables in my database and >don't have a recent backup. > >The database is used for the phpBB system and still functions when I visit >the site via a web browser since the database is still cached. Is there any >way I can recover the database using the mysql cache? > >I would really appreciate some quick responses here. > >Cheers > >John 'the muppet' > > > > >- >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
InnoDB monitor
Hi, Can anyone tell me how to use the InnoDB monitor please. After creating the table with the following command: "CREATE TABLE innodb_monitor(a int) type = innodb;" I don't know where to watch the output from the InnoDB monitor. Can anyone help? Balteo. (sql,query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php