Re: MySQL Password
mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The 2GB Memory Limit, AWE, and HEAP tables
I've read a lot about the 32-bit/malloc-induced 2GB memory limit on MySQL for the innodb_buffer_pool_size. Does this apply to HEAP table size as well? In other words, if I have enough RAM can I set max_heap_table_size 2 GB and have a 2GB heap table sitting in memory? I've used AWE with innodb tables with embedded MySQL on Win2K. Will this be implemented on MySQL on Linux? Would this affect HEAP tables? If it will be implemented, is there a timetable? Will it require something to be done to the Linux kernel? Thanks, Michael
Re: max_allowed_packet error
No, nothing of the sort in the my.cnf file. :( - Original Message - From: Dathan Vance Pattishall [EMAIL PROTECTED] To: 'Tina Motaye' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 8:33 PM Subject: RE: max_allowed_packet error Do you have a waittimeout set in you're my.cnf file? If so mysql would of forced closed a connection that it determines was inactive for waittimeout seconds. ---Original Message- --From: Tina Motaye [mailto:[EMAIL PROTECTED] --Sent: Tuesday, July 01, 2003 5:28 AM --To: [EMAIL PROTECTED] --Subject: max_allowed_packet error -- --hello, -- --I'm exporting a very big table from ACCESS to MySQL using ODBC. -- --I was able to do it by increasing the value of the max_allowed_packet --variable in mysql since otherwise ODBC lost the connection and I was --getting an error. --But the thing is I dropped the table for a test and now I'm not being --able to export it back. -- --Wehn I try exporting from ACCESS I get the error : --(mysqld-4.013 -max-debug]Lost connection to MYSQL server during query --(#2013) -- --I don't understand why I'm getting this again even if I change the value --of the max_allowed_packet!! -- --Any help would be welcome. -- --Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to initialize a new Innodb file (without server restart)
Hi Mysql fans ;-), does anybody know how to initialize a new added Innodb file without restarting the server ? Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which is better: big SQL statement or bigger db?
I need to have a user input a city and have MySQL pull up any records with that city OR nearby cities (within 10 mi). Which of the following would be the most efficient way to do this: Case A: When a user enters a city, an array of nearby cities is created so that an SQL statement like the following is generated: SELECT * FROM bc_posts WHERE post_citysoundex = 'A265' OR post_citysoundex = 'A415' OR post_citysoundex = 'A453' OR post_citysoundex = 'A430' OR post_citysoundex = 'A624' OR post_citysoundex = 'A350' OR . . . This statement would probably be much larger (upto 150 lines) and would query one table without additional joins. Case B: Here, when a user enters a city, the soundex of it is created and then queries a table that contains every city in the db PLUS all surrounding cities (calculated and inserted with each new city insert). Obviously, here the table would get large while my actual SQL statement is pretty straightforward but would require a join. I'm not sure which of these is the more elegant approach or would scale up much easier. Any input from the DB gurus would be appreciated! Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Hi harsh, perhaps I made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003 7 2 17:02harsh : I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which is better: big SQL statement or bigger db?
Hi,
May the following sql statement is more efficient.
SELECT * FROM bc_posts WHERE
post_citysoundex IN('A265','A415',.)
Armand
motorpsychkill wrote:
I need to have a user input a city and have MySQL pull up any records with
that city OR nearby cities (within 10 mi). Which of the following would be
the most efficient way to do this:
Case A:
When a user enters a city, an array of nearby cities is created so that an
SQL statement like the following is generated:
SELECT * FROM bc_posts WHERE
post_citysoundex = 'A265' OR
post_citysoundex = 'A415' OR
post_citysoundex = 'A453' OR
post_citysoundex = 'A430' OR
post_citysoundex = 'A624' OR
post_citysoundex = 'A350' OR
.
.
.
This statement would probably be much larger (upto 150 lines) and would
query one table without additional joins.
Case B:
Here, when a user enters a city, the soundex of it is created and then
queries a table that contains every city in the db PLUS all surrounding
cities (calculated and inserted with each new city insert). Obviously, here
the table would get large while my actual SQL statement is pretty
straightforward but would require a join.
I'm not sure which of these is the more elegant approach or would scale up
much easier. Any input from the DB gurus would be appreciated! Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB logfile question
Hello Heikki other Mysql Fans ;-); Does anybody know which requests or data the below logfils actually keep ?? If I understood correct than they are all in binary format (not readable in a text editor. log.01 ib_arch_log_00 ib_logfile0 ib_logfile1 Unfortunately I was unable to to find sufficient info here http://www.innodb.com/ibman.html. Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A quick help
harsh [EMAIL PROTECTED] wrote: Two databases data1 data2 data1 has table1 and data2 has table2 both the tables have uid field common I want to list out common uid's from table1 annd table2 Tried many commands as i understood from documentations but somewhere i m always wrong. Something like: SELECT data1.table1.uid FROM data1.table1, data2.table2 WHERE data1.table1.uid=data2.table2.uid; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to initialize a new Innodb file (without server restart)
Nils Valentin [EMAIL PROTECTED] wrote: does anybody know how to initialize a new added Innodb file without restarting the server ? You can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: privileges not updating
me [EMAIL PROTECTED] wrote: i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE should take effect immediately but they don't. i'm using command line How did you exactly update privileges? Show me the output of SHOW GRANTS for those users. also if i create a database, grant privileges on it and then delete the db if i check grants - it still appears... It's normal behaviour: http://www.mysql.com/doc/en/GRANT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Persistent annoying slave binlog corruption...
Michael Loftis [EMAIL PROTECTED] wrote: Recently, and pretty consistently our slave's relay logs have been getting garbage that is not in the master. The symptom is usually a truncated query with a few characters of garbage. The solution for now is to change master to to the errored master bin log and position and have it start replication from the spot where it is. When this happens the IO and SQL thread are found choked, with no error on show slave status, but the MySQL .err log shows the error. What version of master and slave do you use? Which OS? Did you install MySQL server from binary or from source? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help harsh -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Nils Valentin wrote: Hi harsh, perhaps I made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003年 7月 2日 水曜日 17:02、harsh さんは書きました: I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB logfile question
Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:04 PM Subject: InnoDB logfile question Hello Heikki other Mysql Fans ;-); Does anybody know which requests or data the below logfils actually keep ?? If I understood correct than they are all in binary format (not readable in a text editor. log.01 this is a BDB log I think. ib_arch_log_00 InnoDB archived log which is produced in log file creation. Not needed for anything, just a relic from the past. ib_logfile0 ib_logfile1 These are the InnoDB redo logs it uses in crash recovery. It writes circularly to these files. Unfortunately I was unable to to find sufficient info here http://www.innodb.com/ibman.html. Best regards -- --- Valentin Nils Regards, Heikki Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which is better: big SQL statement or bigger db?
* [EMAIL PROTECTED] Case A: ... This statement would probably be much larger (upto 150 lines) and would query one table without additional joins. Case B: Here, when a user enters a city, the soundex of it is created and then queries a table that contains every city in the db PLUS all surrounding cities (calculated and inserted with each new city insert). Obviously, here the table would get large while my actual SQL statement is pretty straightforward but would require a join. I'm not sure which of these is the more elegant approach or would scale up much easier. Any input from the DB gurus would be appreciated! Thanks! Most elegant is case B I would think. Let the database system do the work it is designed for. Scalability and performance in mysql I do not know. What about a test? -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
specific records
Hi, Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? Regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB logfile question
Hi Heikki, 2003 7 2 18:10Heikki Tuuri : Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:04 PM Subject: InnoDB logfile question Hello Heikki other Mysql Fans ;-); Does anybody know which requests or data the below logfils actually keep ?? If I understood correct than they are all in binary format (not readable in a text editor. log.01 this is a BDB log I think. ib_arch_log_00 InnoDB archived log which is produced in log file creation. Not needed for anything, just a relic from the past. ib_logfile0 ib_logfile1 These are the InnoDB redo logs it uses in crash recovery. It writes circularly to these files. Do I assume correctly that it writes into this files a) all successful transactions (requests, status A and B - before ad after the request) b) nothing else ?? Best regards Nils Valentin Tokyo/Japan Unfortunately I was unable to to find sufficient info here http://www.innodb.com/ibman.html. Best regards -- --- Valentin Nils Regards, Heikki Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Hi Harsh, Hi MySQL AB ;-) I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:08harsh : Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help harsh --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Nils Valentin wrote: Hi harsh, perhaps I made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003 7 2 17:02harsh : I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to initialize a new Innodb file (without server restart)
Hi Egor, Thanks for the straight and short answer. Much appreciated. Best regards Nils Valentin Tokyo/Japan 2003 7 2 17:44Egor Egorov : Nils Valentin [EMAIL PROTECTED] wrote: does anybody know how to initialize a new added Innodb file without restarting the server ? You can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: specific records
SELECT * FROM tablename where column5 AND column12; Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:26Maciej Bobrowski : Hi, Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? Regards, Maciej Bobrowski -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: specific records
Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; No, no. I have no numerical fileds in the table. Your example is not good. Even if I could add the 'id' column to the table, then when I will remove some records from the middle part o the table I will have holes, and the next select will give me wrong data. Regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: specific records
SELECT * FROM tablename LIMIT 5, 6 Me fail English? That's unpossible ###___Archon___### - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Maciej Bobrowski [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:47 PM Subject: Re: specific records SELECT * FROM tablename where column5 AND column12; Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:26Maciej Bobrowski : Hi, Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? Regards, Maciej Bobrowski -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: specific records
O.K. I found the way: select * from tablename limit 5,6; it will select 6 records counting from 6. Let's say I have 1000 records in a 'table'. I want to select rows from6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; Best regards, Maciej Bobrowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: specific records
Maciej Bobrowski wrote: Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; No, no. I have no numerical fileds in the table. Your example is not good. Even if I could add the 'id' column to the table, then when I will remove some records from the middle part o the table I will have holes, and the next select will give me wrong data. Regards, Maciej Bobrowski Maybe: SELECT * FROM tablename LIMIT 5,5; See: http://www.mysql.com/doc/en/SELECT.html for details Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB logfile question
Nils, InnoDB writes to ib_logfiles all tablespace modifying operations (= mini-transactions), whether they belong to a successful or an unsuccessful transaction. In crash recovery we redo everything, then roll back based on undo logs inside the tablespace. The best reference is Gray and Reuter: Transaction Processing, published around 1992. Regards, Heikki - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 12:34 PM Subject: Re: InnoDB logfile question Hi Heikki, 2003 7 2 18:10Heikki Tuuri : Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:04 PM Subject: InnoDB logfile question Hello Heikki other Mysql Fans ;-); Does anybody know which requests or data the below logfils actually keep ?? If I understood correct than they are all in binary format (not readable in a text editor. log.01 this is a BDB log I think. ib_arch_log_00 InnoDB archived log which is produced in log file creation. Not needed for anything, just a relic from the past. ib_logfile0 ib_logfile1 These are the InnoDB redo logs it uses in crash recovery. It writes circularly to these files. Do I assume correctly that it writes into this files a) all successful transactions (requests, status A and B - before ad after the request) b) nothing else ?? Best regards Nils Valentin Tokyo/Japan Unfortunately I was unable to to find sufficient info here http://www.innodb.com/ibman.html. Best regards -- --- Valentin Nils Regards, Heikki Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: specific records
Actually, this will *not* necessarily work. Without an ORDER BY clause, the database is free to return records in any order; after some deletions insertions, your select below may return different records, in a different order. I would recommend adding an explicit record number to the table, using an auto_increment column; it may be more work now, but it will be best in the long run. steve At 12:02 PM +0200 7/2/03, Maciej Bobrowski wrote: O.K. I found the way: select * from tablename limit 5,6; it will select 6 records counting from 6. Let's say I have 1000 records in a 'table'. I want to select rows from6 to 11. How can I do this? SELECT * FROM tablename where column5 AND column12; Best regards, Maciej Bobrowski -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | ++ | [EMAIL PROTECTED]: 1001 Work units on 23 oct 2002 | | 3.152 years CPU time, 3.142 years SETI user... and STILL no aliens... | ++ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_connections being ignored/overridden?
Gary Huntress [EMAIL PROTECTED] wrote: I have some simple user quotas set to help balance my server load. I think I've implemented them properly because people do whine to me when they reach the query limit. I have max_connections set to 200, but right now I'm watching connections for 1 user scroll by at an alarming rate. 7800 in less than 5 minutes. What could I have done wrong for this user such that his max_connections value of 200 is being ignored? Does SHOW GRANTS show you 200 as MAX_CONNECTIONS_PER_HOUR value for this user? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Nils Valentin [EMAIL PROTECTED] wrote: I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? What exactly is not clear enough for you? --skip-grant-tables is option of mysqld, not safe_mysqld. safe_mysqld is the script that runs mysqld. 2003? 7? 2? ??? 18:08?harsh : Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: specific records
Maciej Bobrowski [EMAIL PROTECTED] wrote: Let's say I have 1000 records in a 'table'. I want to select rows from 6 to 11. How can I do this? Use ORDER BY and LIMIT clauses: http://www.mysql.com/doc/en/SELECT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Date query optimization
Hi Karl-
I often use a unix timestamp value for my dates (an unsigned mediumint is
adequate) and index that. However, using date/time functions in the where
clause does have a significant impact on the execution times, even when the
index is used and the EXPLAIN output appears the same. See example below -
I have a table called 'warn' (that currently has ~26,000,000 rows) with an
index on an unsigned mediumint column call unixts that reflects a unix
timestamp. See the results:
select count(*) from warn where unixts between unix_timestamp('2003-07-01')
and unix_timestamp('2003-07-02');
count(*)
438146
+++---++-+++
+
| table | type | possible_keys | key| key_len | ref| rows |
Extra |
+++---++-+++
+
| warn | range | unixts| unixts | 4 | [NULL] | 327512 |
where used; Using index|
+++---++-+++
+
1 row in set (75.41) sec
-
select count(*) from warn where unixts between 1057032000 and 1057118400;
count(*)
438146
+++---++-+++
+
| table | type | possible_keys | key| key_len | ref| rows |
Extra |
+++---++-+++
+
| warn | range | unixts| unixts | 4 | [NULL] | 327514 |
where used; Using index|
+++---++-+++
+
1 row in set (2.19) sec
As you can see, same plan but a major difference in execution time (over an
order of magnitude). Moral - be cautious using functions in your where
clause - you might get surprised.
Best of luck,
Rick
-Original Message-
From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 12:25 PM
To: [EMAIL PROTECTED]
Subject: Date query optimization
Hi folks,
I do a considerable amount of queries based on a date, and or date range. I
have not had much luck with optimizing these queries. In some cases I use a
date field and others a datetime field.
The following query searches through 34,000 + records, while specifiying the
exact date searches through 9 records.
'ROWS: 9 SEARCHED
explain
select
a.submitid,a.url,a.submitdate,a.name,a.company,a.address1,a.city,a.state,a.z
ipcode,a.country,a.email,a.phone,a.keywords,a.title,a.description,a.submitte
dby
from submit as a inner join re_idx as b on a.submitid = b.submitid
where a.submitdate = '2003-07-01';
ROWS: 34,000 + searched
explain
select
a.submitid,a.url,a.submitdate,a.name,a.company,a.address1,a.city,a.state,a.z
ipcode,a.country,a.email,a.phone,a.keywords,a.title,a.description,a.submitte
dby
from submit as a inner join re_idx as b on a.submitid = b.submitid
where year(a.submitdate)=2003 and month(a.submitdate)=7 and
dayofmonth(a.submitdate)=1;
--and year(a.submitdate)=2003 and month(a.submitdate)=7 and
dayofmonth(a.submitdate)15;
Notice the 2nd where statement, this is how I typically do my date queries
(and it is slow). This is because I might also be searching for a range of
dates (as in the commented out and clause above).
Is the to_days function faster than these date functions, or have any effect
whatsoever?
Thanks for the help.
Karl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Weird Query results.
Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output has that field blank as in the example below ID, Name, date, time 12345, , 11/02/02, 13:54 98384, bob1, 12/30/01, 04:16 88492, sally, 04/12/03, 01:01 99381, scott, 05/08/01, 08:19 Now when I do a lookup on the first returned records ID (12345) it turns out to be a record with a Name field value like zzJason If I further modify the query to the following; SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz% ID NOT LIKE 12345 I'll get the same results but with a different record that has a zzSomething value for the name field. Any ideas if this is a bug or if I'm doing something wrong in my query? Thanks, Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. Thank You.*** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ? restarting mysqld or starting safe_mysqld ?? Don't get me wrong the manual is not bad, but it leaves a lot of interpretation or vague guessing room for some descriptions. Anyway having spoken to somebody from MySQL AB I understand that they are working on it and hopefully make the manual better than it already is. ;-) Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:57Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? What exactly is not clear enough for you? --skip-grant-tables is option of mysqld, not safe_mysqld. safe_mysqld is the script that runs mysqld. 2003? 7? 2? ??? 18:08?harsh : Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't start MySQL on Mac OS X
Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA INFILE syntax
Hi all, I'm quite new in mysql. Despite i've read a part of the doc, i can't fix my prob. Here is my question: I want to convert a DBASE IV file into mysql table: 1) Have i to convert the dbf into flat file then use the LOAD DATA INFILE cmd ? or 2) Can i directly use the LOAD DATA INFILE cmd with my dbf file ? I've tried the second point but it doesn't seem to work. Thanx in advance. fabrice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication problem: Slave not starting
Andrew Staples wrote: I've setup my my.cnf file on the slave as: [mysql.server] user=mysql basedir=/var/lib socket=/var/lib/mysql/mysql.sock server-id=2 master-host=206.xxx.xxx.xxx master-user=replicateuser master-password=replicatepassword Master.info is: tux-bin.001 3109 206.xxx.xxx.xxx replicateuser replicatepassword 3306 60 This indicates that replication is running. Show slave status indicates NO under Slave_running, and I get: mysql slave start; ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO You would get this message on the master. You are running this command on the slave? Server has been restarted. Version is 3.23.56 Any ideas? Andrew Instead of trying to build newer and bigger weapons of destruction, we should be thinking about getting more use out of the ones we already have. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with mysqlimport.
Hi all, I've just started using mysql and I'm sure that my all problems are something todo with my oracle-ness, so please bear with me if I use case-insensitive table names or somthing ;) Ok. I've been using the mysql interactive command-line interface for a few days now, and there's no problem there. I've made myself a ~/.my.cnf file and it appears to work: [client] user=idries_wedding password=** Since creating it I no longer need to enter username or password details when I run mysql :) Now, I'm trying to use mysqlimport: idries ~/src/wedding/database$ mysqlimport idries_Wedding GUEST.txt mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO), when using table: GUEST The problem here seems to be that mysqlimport is not reading the password from the .my.cnf file. I had a similar problem with it not liking the database option to be specified in the .my.cnf file, so I removed that. I have tried several combinations of removing the password from the .my.cnf file and removing the .my.cnf file completly. For example: idries ~/src/wedding/database$ mv ~/.my.cnf ~/..my.cnf idries ~/src/wedding/database$ mysqlimport --user=idries_wedding --password= idries_Wedding GUEST.txt mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO), when using table: GUEST idries ~/src/wedding/database$ The only way in which I can stop (Using password:NO) from being displayed is to tell mysqlimport to prompt me for the password *AND* not specify a username: idries ~/src/wedding/database$ mysqlimport -p idries_Wedding GUEST.txt Enter password: mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) idries ~/src/wedding/database$ Here the username is not specified, and so it obviously doesn't work, but it does say (Using password:YES) However: idries ~/src/wedding/database$ mysqlimport -uidries_wedding -p idries_Wedding GUEST.txt Enter password: mysqlimport: Error: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO), when using table: GUEST idries ~/src/wedding/database$ Can anyone tell me where I am going wrong? What is the correct syntax for calling mysqlimport while specifying a username and password and why doesn't it use the .my.cnf file in the same was a mysql? I've consulted the manual and everything that I've done seems to be in keeping with what's required. Please help! Also: idries ~/src/wedding/database$ mysqlimport -V mysqlimport Ver 3.4 Distrib 4.0.13, for pc-linux (i686) idries ~/src/wedding/database$ mysql -V mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) idries ~/src/wedding/database$ Thanx in advance, Idries -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RedHat 9 - MySQL 3.23.56
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 25 Jun 2003, Luc Foisy wrote: Something interesting that may be my problem This is a known working install # mysql --version mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686) # find /etc/rc.d -name *mysql /etc/rc.d/init.d/mysql /etc/rc.d/rc0.d/K90mysql /etc/rc.d/rc1.d/K90mysql /etc/rc.d/rc2.d/S90mysql /etc/rc.d/rc3.d/S90mysql /etc/rc.d/rc4.d/S90mysql /etc/rc.d/rc5.d/S90mysql /etc/rc.d/rc6.d/K90mysql This is the broken one # mysql --version mysql Ver 11.18 Distrib 3.23.56, for pc-linux (i686) ]# find /etc/rc.d -name *mysql /etc/rc.d/init.d/mysql /etc/rc.d/rc0.d/K90mysql /etc/rc.d/rc1.d/K90mysql /etc/rc.d/rc2.d/S90mysql /etc/rc.d/rc3.d/K90mysql /etc/rc.d/rc4.d/S90mysql /etc/rc.d/rc5.d/K90mysql /etc/rc.d/rc6.d/K90mysql Anyone else see the possible problem? Where there a reason this was changed? See the following bug report: http://bugs.mysql.com/search.php?cmd=displaysearch_for=chkconfig Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/At93SVDhKrJykfIRAo7+AJ4kOvVemndAbYyYBVQi/fkuFoo1kACdEdup SaALj183HxT4DkIjrWYvwSg= =6Wwd -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: defunct mysql threads
Does the client close the connection before exiting? Joshua Shapiro wrote: Hello, I am running the binary mysql 4.0.13 pclinux i686 with a linux 2.4.19 kernel. I have the problem that every time a client connects to the server and then exits, a defunct thread is left behind. Eventually the system prevents any further threads from being created. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
If you did not shutdown the server prior to the upgrade, you could have left mysqld running, even after its socket was removed. Use ps to see if mysqld is still running, and kill it if necessary. Todd O'Bryan wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA INFILE syntax
1 will work. 2 will not work. 3 Use dbf2mysql. ( It should be in the downloads section on mysql.com ) fab wrote: Hi all, I'm quite new in mysql. Despite i've read a part of the doc, i can't fix my prob. Here is my question: I want to convert a DBASE IV file into mysql table: 1) Have i to convert the dbf into flat file then use the LOAD DATA INFILE cmd ? or 2) Can i directly use the LOAD DATA INFILE cmd with my dbf file ? I've tried the second point but it doesn't seem to work. Thanx in advance. fabrice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with mysqlimport.
Idries Hamadi wrote: Hi all, I've just started using mysql and I'm sure that my all problems are something todo with my oracle-ness, so please bear with me if I use case-insensitive table names or somthing ;) Ok. I've been using the mysql interactive command-line interface for a few days now, and there's no problem there. I've made myself a ~/.my.cnf file and it appears to work: [client] user=idries_wedding password=** Since creating it I no longer need to enter username or password details when I run mysql :) Now, I'm trying to use mysqlimport: How about [mysqlimport] user=idries_esdding password=** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Nils Valentin [EMAIL PROTECTED] wrote: Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ? restarting mysqld or starting safe_mysqld ?? Start mysqld with --skip-grant-tables option :) safe_mysqld hasn't option --skip-grant-tables. You can start mysqld using safe_mysqld and mysql.server scripts or mysqld directly. There is another section in the MySQL manual that describes how to start MySQL server. Don't get me wrong the manual is not bad, but it leaves a lot of interpretation or vague guessing room for some descriptions. Anyway having spoken to somebody from MySQL AB I understand that they are working on it and hopefully make the manual better than it already is. ;-) Sure. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Weird Query results.
Jeff McKeon [EMAIL PROTECTED] wrote: Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output has that field blank as in the example below ID, Name, date, time 12345, , 11/02/02, 13:54 98384, bob1, 12/30/01, 04:16 88492, sally, 04/12/03, 01:01 99381, scott, 05/08/01, 08:19 Now when I do a lookup on the first returned records ID (12345) it turns out to be a record with a Name field value like zzJason If I further modify the query to the following; SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz% ID NOT LIKE 12345 I'll get the same results but with a different record that has a zzSomething value for the name field. Any ideas if this is a bug or if I'm doing something wrong in my query? Worked fine for me. Could you provide a repeatable test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is mysql.soc and where is it located
Hi, The following message appeared when I installed mysql server on Linux,,, [2] 10804 [1] Exit 1 ./bin/mysqld -user-mysql [EMAIL PROTECTED] mysql]$ Starting mysqld daemon with databases from /var/lib/mysql 030701 19:59:18 mysqld ended And also sometime the message can't find mysql.sock in /var/lib/mysql/mysql.sock despite that the installation directory and the daemon is in /usr/local/mysql/bin I performed standard installation and also this message appeared if I install the MySql server as part of Redhat installed. Thanks Suboh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: freebsd 5.1 + mysql 4.0.13
Richard, Welcome to the wonderful world of FreeBSD. FreeBSD-5.1 is not release code. It is alpha quality (thought pretty good quality as Alpha goes). I understand that the website doesn't make this abundantly clear on the homepage. FreeBSD 4.8 is the current production quality code. It will probably be much faster for you as well, since debugging options are turned off by default. You can get from 5.1 to 4.8 without having to reinstall the OS by, well, reinstalling the OS. By following the instructions in the handbook for upgrading you can also downgrade to FreeBSD-4.8 by downgrading your source tree in /usr/src, building and installing world. It's actually not quite as bad as it seems in the docs and I've managed upgrades and downgrades with minimum of downtime. Most of the steps can be done while the system is running. The steps that should be done in single user mode (and I recomend this since your not familiar with FreeBSD yet) are pretty quick. FreeBSD is actually fairly nice once you know what's going on. The Handbook is http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/index.html and the chapter you want is http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/cutting-edge.html Substitude old for cutting edge and your on your way. The CVS tag you would want is RELENG_4_8 I would recomend rebuilding anything you built in ports after you upgrade the system, since this downgrade is considerable, but again much of that compile time will be while the system is running. Your really only looking at the time to do a make install and make installkernel, and rebuilding the database server as your downtime. Much less considerable than reinstalling an entire OS and getting everything installed that you want. If you need more assistance shoot me a line, off the MySQL list (as it's no longer a MySQL issue) and I'll answer what I can. -- Michael Conlen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replicating FLUSH LOGS
Under MySQL 3.23, FLUSH LOGS was replicated. Under 4.0.13, this appears to no longer be the case. Was this intentional? Could it be put back the way it was? We do backups by, at a time of low usage, (1) FLUSH LOGS on the master, (2) Dump the master database, (3) repeat 1 and 2 until there were no updates during the dump. (We've only had to repeat once.) It was useful to know that both the master and the slave had a binlog starting from the time of the dump. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrading MySQL on RedHat 9
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to go from the version that came with the distro (version 3.23.54) to the latest (verion 4.0). Just thought I'd post to get a heads-up on any known issues or prerequisites. I just hate it when I try something like this and screw up my whole installation. My planned steps are to: 1. mysqldump everything to a backup file 2. stop the service 3. uninstall all the current rpm's 4. install the fresh rpm's 5. startup 6. \. the file from step 1 Anything I need to lookout for? Thanks. Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL/INNODB speed on large databases
Thanks to everyone who has helped and/or made suggestions so far. I'll try to provide some answers to your further queries and report back on some testing I've done. Jeremy asked for explains of some of the problem queries: Here is a particularly troublesome one that gets ran quite a lot: mysql SELECT InstNum FROM TBL_Transactions WHERE ((IndexStatus '2' OR Scanned'Y') OR (MoneyStatus '1')) AND ((VoidStatus = 'N') AND (IndexType 'CP') AND (Year '2001')) ORDER BY InstNum ASC LIMIT 1; +--+ | InstNum | +--+ | 03128665 | +--+ 1 row in set (6.59 sec) mysql explain SELECT InstNum FROM TBL_Transactions WHERE ((IndexStatus '2' OR Scanned'Y') OR (MoneyStatus '1')) AND ((VoidStatus = 'N') AND (IndexType 'CP') AND (Year '2001')) ORDER BY InstNum ASC LIMIT 1; +--+--++ +-+---+++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--++ +-+---+++ | TBL_Transactions | ref | Year,VoidStatus,IndexStatus,Year_2 | VoidStatus | 2 | const | 150804 | where used; Using filesort | +--+--++ +-+---+++ 1 row in set (0.00 sec) Thanks to Joseph Bueno for suggesting the 4.x query cache: I took the above query and on a test server running 4.0.13 I setup a 1MB query cache and tried it out. It took 6 seconds first time and 0.00 seconds on subsequent times. I'm assuming this cache is smart enough to re-perform the query if any data pertaining to it changes, yeah surely... So on often-executed queries where the data is very cachable this will help. After a few minutes of monitoring this one floats to the top of a mytop output screen as taking the longest to run: mysql explain SELECT DISTINCT LastName, FirstName, PAName FROM TBL_AllNames WHERE PAName LIKE 'WHITE%' AND NameType'2' ORDER BY LastName, FirstName; +--+---+-++-+--+ ---+-+ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+---+-++-+--+ ---+-+ | TBL_AllNames | range | PAName,NameType | PAName | 81 | NULL | 41830 | where used; Using temporary | +--+---+-++-+--+ ---+-+ 1 row in set (0.00 sec) mysql Running the actual query returned 4000 rows and took (58.20 sec) Here's some details of that table: mysql describe TBL_AllNames; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | InstNum | varchar(8) | | PRI | | | | Year | varchar(4) | | PRI | | | | NameType | char(2) | | PRI | | | | NameClass | char(1) | YES | MUL | NULL| | | NameAP| char(1) | YES | | NULL| | | Ncount| int(11) | | PRI | 0 | | | LastName | varchar(80) | YES | MUL | NULL| | | FirstName | varchar(60) | YES | MUL | NULL| | | TypeofName| varchar(20) | YES | | NULL| | | PAName| varchar(80) | YES | MUL | NULL| | | SoundKeyFirst | varchar(12) | YES | MUL | NULL| | | SoundKeyLast | varchar(12) | YES | MUL | NULL| | | RecDate | varchar(8) | | MUL | | | | InstCode | varchar(10) | | MUL | | | | IndexType | varchar(4) | | | | | | XrefGroup | varchar(8) | | | | | +---+-+--+-+-+---+ 16 rows in set (0.00 sec) mysql select count(*) from TBL_AllNames; +--+ | count(*) | +--+ | 6164129 | +--+ 1 row in set (50.17 sec) Thanks in advance! PS. I'm still very interested in *paying* MySQL to help analyze and suggest ways we can make the queries faster. Again though, I just want to point *soon* hardware upgrade purchases in the right direction and get that all settled down first. Opterons look nice but with a database size topping 29GB today I think enough ram to cache a sizable portion of it will be cost prohibitive. Could still be a possibility though... I'm still leaning towards a load-balanced setup with backend/real servers having either 15K SCSI drives RAID-0'ed or possibly SATA 10K drives for cost reasons. Again, thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To
Count Rows?
Is there a simple MySQL command that will give a Row Count (# of records) WITHOUT running a select (huge database) Thanks! Roy
RE: Count Rows?
If your table is MyISAM, then SELECT COUNT(*) FROM tablename Will return a rowcount without a major performance hit as the rowcount is stored and a table scan is not needed. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Roy W [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 9:57 AM To: [EMAIL PROTECTED] Subject: Count Rows? Is there a simple MySQL command that will give a Row Count (# of records) WITHOUT running a select (huge database) Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
possible query #2
Hello dear all, on MySQL 3.23.54 i have a table that list the number of user-time days like: 35 whellbased on curdate() function can i able to make a select wich display the sum (150-35) where 150 is date_format(curdate(), '%j') in a format like (%d/%m/%y) ? this kind of query is possible? ...if yes how? ...or there is only a madness? :) thanks in advance, fabrizio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Weird Query results.
Vitoria, Thanks for the feedback. I should have done this first but it turns out that there are actually bad records with: MobileName LIKE Mystery solved... Thanks, Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209 ***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. Thank You.*** -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:01 AM To: [EMAIL PROTECTED] Subject: Re: Weird Query results. Jeff McKeon [EMAIL PROTECTED] wrote: Version 3.23.56, for pc-linux on i686 When I issue query as such... SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz%; I get a result that has as it's first record, a record where the Name field data IS LIKE zz% but the actual output has that field blank as in the example below ID, Name, date, time 12345, , 11/02/02, 13:54 98384, bob1, 12/30/01, 04:16 88492, sally, 04/12/03, 01:01 99381, scott, 05/08/01, 08:19 Now when I do a lookup on the first returned records ID (12345) it turns out to be a record with a Name field value like zzJason If I further modify the query to the following; SELECT ID, Name, date, time FROM table WHERE Name NOT LIKE zz% ID NOT LIKE 12345 I'll get the same results but with a different record that has a zzSomething value for the name field. Any ideas if this is a bug or if I'm doing something wrong in my query? Worked fine for me. Could you provide a repeatable test case? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is mysql.soc and where is it located
Check the error log in your mysql data directory. This should explain why mysqld ended. suboh wrote: Hi, The following message appeared when I installed mysql server on Linux,,, [2] 10804 [1] Exit 1 ./bin/mysqld -user-mysql [EMAIL PROTECTED] mysql]$ Starting mysqld daemon with databases from /var/lib/mysql 030701 19:59:18 mysqld ended And also sometime the message can't find mysql.sock in /var/lib/mysql/mysql.sock despite that the installation directory and the daemon is in /usr/local/mysql/bin I performed standard installation and also this message appeared if I install the MySql server as part of Redhat installed. Thanks Suboh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
More tables or more joins
I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to control the fields that it is storing for it's contacts. I am considering giving each user it's own table for storing contacts. In this scenerio I would provide a means for editing the columns in the table. The other scenerio is to have a table to store field names, their type, and their default value and their account relationship. Then another table would store the contacts for all accounts with an account relationship. A final table would store relationships and values of contacts and the fields. I am mostly concerned with speed. My guess is that the first scenerio will be faster as long as all the queries only search the contacts for one account (i.e. one table). However I am a little concerned about having hundreds (and eventually thousands) of tables. Does anyone have experience with this kind of situation? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: More tables or more joins
You don't want to have a separate table for each user. That would cause a maintenance nightmare. Try normalizing your data user table -- user_id cont_id user_name Contract lookup cont_id Cont_Name Contract Column Lookup -- col_id col_name Contract table user_id Cont_id col_id qty This should be a good start... Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Wed, 2 Jul 2003, Jackson Miller wrote: I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to control the fields that it is storing for it's contacts. I am considering giving each user it's own table for storing contacts. In this scenerio I would provide a means for editing the columns in the table. The other scenerio is to have a table to store field names, their type, and their default value and their account relationship. Then another table would store the contacts for all accounts with an account relationship. A final table would store relationships and values of contacts and the fields. I am mostly concerned with speed. My guess is that the first scenerio will be faster as long as all the queries only search the contacts for one account (i.e. one table). However I am a little concerned about having hundreds (and eventually thousands) of tables. Does anyone have experience with this kind of situation? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OS X downloads
There are two sets of binary downloads at mysql.com for Mac OS X. They're different sizes, but both say OS 10.2. Is that a typo? Is one of the two for OS 10.1, and could I have downloaded the wrong one and could that be the reason I can't get mysql to start? Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: More tables or more joins
I appreciate the idea of normalizing, but those tables wouldn't meet the spec. There would also have to be a column value table at the very least. Also, why would you have user_id and cont_id in both the user_table and the contract table. Also if you read my post you would see that I am talking about a minimum of 200 users each with an average of 20,000 contacts (with no overlap). This means that the contact table would have a minimum of 2,000,000 rows just to get started. The alternative would be to have 200 tables with 20,000 rows each. I understand that having this many tables is crazy, but I don't understand why it is not better. -Jackson On Wednesday 02 July 2003 11:49 am, Jake Johnson wrote: You don't want to have a separate table for each user. That would cause a maintenance nightmare. Try normalizing your data user table -- user_id cont_id user_name Contract lookup cont_id Cont_Name Contract Column Lookup -- col_id col_name Contract table user_id Cont_id col_id qty This should be a good start... Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Wed, 2 Jul 2003, Jackson Miller wrote: I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to control the fields that it is storing for it's contacts. I am considering giving each user it's own table for storing contacts. In this scenerio I would provide a means for editing the columns in the table. The other scenerio is to have a table to store field names, their type, and their default value and their account relationship. Then another table would store the contacts for all accounts with an account relationship. A final table would store relationships and values of contacts and the fields. I am mostly concerned with speed. My guess is that the first scenerio will be faster as long as all the queries only search the contacts for one account (i.e. one table). However I am a little concerned about having hundreds (and eventually thousands) of tables. Does anyone have experience with this kind of situation? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: More tables or more joins
Well, lets say that you suddenly remember that you need column X in the user table. In the normalized model you have to do one ALTER TABLE statement. In the design you have in place you need n ALTER TABLE statements where n = the number of users. It can also be easier to program against and manage normalized data. That being said, if your users have security concerns you need to maintain separate tables, as there are no views in MySQL (yet) and therefore you cannot prevent users from seeing each other's data in a normalized model. On another note, 2 million rows should not pose any performance issues, I can search tables with millions of rows and get back results quickly as long as I practice proper indexing (having fixed length rows also helps and is not hard to achieve). I would say that as long as contact privacy is not a concern, use the normalized approach for management ease. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Jackson Miller [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:47 AM To: Jake Johnson Cc: [EMAIL PROTECTED] Subject: Re: More tables or more joins I appreciate the idea of normalizing, but those tables wouldn't meet the spec. There would also have to be a column value table at the very least. Also, why would you have user_id and cont_id in both the user_table and the contract table. Also if you read my post you would see that I am talking about a minimum of 200 users each with an average of 20,000 contacts (with no overlap). This means that the contact table would have a minimum of 2,000,000 rows just to get started. The alternative would be to have 200 tables with 20,000 rows each. I understand that having this many tables is crazy, but I don't understand why it is not better. -Jackson On Wednesday 02 July 2003 11:49 am, Jake Johnson wrote: You don't want to have a separate table for each user. That would cause a maintenance nightmare. Try normalizing your data user table -- user_id cont_id user_name Contract lookup cont_id Cont_Name Contract Column Lookup -- col_id col_name Contract table user_id Cont_id col_id qty This should be a good start... Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Wed, 2 Jul 2003, Jackson Miller wrote: I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to control the fields that it is storing for it's contacts. I am considering giving each user it's own table for storing contacts. In this scenerio I would provide a means for editing the columns in the table. The other scenerio is to have a table to store field names, their type, and their default value and their account relationship. Then another table would store the contacts for all accounts with an account relationship. A final table would store relationships and values of contacts and the fields. I am mostly concerned with speed. My guess is that the first scenerio will be faster as long as all the queries only search the contacts for one account (i.e. one table). However I am a little concerned about having hundreds (and eventually thousands) of tables. Does anyone have experience with this kind of situation? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Newbie SELECT problem
Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor userID are keys or unique. Obviously this isn't working. Can someone suggest how this should be done? Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115
problems with insert method on INNODB tables
I have the wierdest problem an I am at a loss.
The insert function, as for the code underneath, partially works. I say
partially, as I can see that the primary key is actually incremented. But
sometimes the new record fails to show in the table, and when it does
other records are removed. The behaviour is random to the point that I
cannot give a better description. My first thought was that this might
have been related to the use of INNODB tables and the cascade delete
option. But if I insert the record directly from the mysql consolle then
everything works fine ..
What is going on ?
Here is my java code:
Statement st = connection.createStatement();
String sql = INSERT INTO bb_replies
VALUES('+userName+','+email+','+subject+','+content+','+dateString+',+bbclass+,+rootIndex+,+rootIndex+,+replyIndex+,NULL);
try {
st.executeUpdate(sql);
}catch(SQLException se){
out.println( se);
}
---
here is my mysql INNODB tables
---
create table institutions (
institution char(30) NOT NULL,
i_key INT NOT NULL auto_increment,
primary key(i_key)
) TYPE=INNODB;
create table classes (
i_key INT,
owner_key INT,
classname char(20) NOT NULL,
auditorium_schedule text,
c_key INT NOT NULL auto_increment,
primary key (c_key),
INDEX p_key (owner_key),
FOREIGN KEY (owner_key) REFERENCES institutions (i_key)
ON DELETE CASCADE
) TYPE=INNODB;
create table bboard (
userName char(40),
email char(20) NOT NULL,
subject text NOT NULL,
content text NOT NULL,
fontType char(20) NOT NULL,
pinColor char(10) NOT NULL,
date char(10) NOT NULL,
c_key INT,
owner_key INT,
m_key INT NOT NULL auto_increment,
primary key(m_key),
INDEX p_key (owner_key),
FOREIGN KEY (owner_key) REFERENCES classes (c_key)
ON DELETE CASCADE
) TYPE=INNODB;
create table bb_replies (
userName char(40),
email char(20) NOT NULL,
subject text NOT NULL,
content text NOT NULL,
date char(10) NOT NULL,
class INT NOT NULL,
m_key INT NOT NULL,
owner_key INT NOT NULL,
dependency_key INT NOT NULL,
r_key INT NOT NULL auto_increment,
primary key(r_key),
INDEX p_key (owner_key),
FOREIGN KEY (owner_key) REFERENCES bboard (m_key)
ON DELETE CASCADE
) TYPE=INNODB;
---
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: More tables or more joins
If you want to add another column name, just insert a new record into Contract Column Lookup -- col_id col_name Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Wed, 2 Jul 2003, Mike Hillyer wrote: Well, lets say that you suddenly remember that you need column X in the user table. In the normalized model you have to do one ALTER TABLE statement. In the design you have in place you need n ALTER TABLE statements where n = the number of users. It can also be easier to program against and manage normalized data. That being said, if your users have security concerns you need to maintain separate tables, as there are no views in MySQL (yet) and therefore you cannot prevent users from seeing each other's data in a normalized model. On another note, 2 million rows should not pose any performance issues, I can search tables with millions of rows and get back results quickly as long as I practice proper indexing (having fixed length rows also helps and is not hard to achieve). I would say that as long as contact privacy is not a concern, use the normalized approach for management ease. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Jackson Miller [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:47 AM To: Jake Johnson Cc: [EMAIL PROTECTED] Subject: Re: More tables or more joins I appreciate the idea of normalizing, but those tables wouldn't meet the spec. There would also have to be a column value table at the very least. Also, why would you have user_id and cont_id in both the user_table and the contract table. Also if you read my post you would see that I am talking about a minimum of 200 users each with an average of 20,000 contacts (with no overlap). This means that the contact table would have a minimum of 2,000,000 rows just to get started. The alternative would be to have 200 tables with 20,000 rows each. I understand that having this many tables is crazy, but I don't understand why it is not better. -Jackson On Wednesday 02 July 2003 11:49 am, Jake Johnson wrote: You don't want to have a separate table for each user. That would cause a maintenance nightmare. Try normalizing your data user table -- user_id cont_id user_name Contract lookup cont_id Cont_Name Contract Column Lookup -- col_id col_name Contract table user_id Cont_id col_id qty This should be a good start... Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Wed, 2 Jul 2003, Jackson Miller wrote: I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to control the fields that it is storing for it's contacts. I am considering giving each user it's own table for storing contacts. In this scenerio I would provide a means for editing the columns in the table. The other scenerio is to have a table to store field names, their type, and their default value and their account relationship. Then another table would store the contacts for all accounts with an account relationship. A final table would store relationships and values of contacts and the fields. I am mostly concerned with speed. My guess is that the first scenerio will be faster as long as all the queries only search the contacts for one account (i.e. one table). However I am a little concerned about having hundreds (and eventually thousands) of tables. Does anyone have experience with this kind of situation? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Having MySQL Server and databases on different computers
I am wondering if it is possible to run MySQL Server on one computer on a LAN, but have all the databases be stored on another computer on that LAN (such that the other machine is like a data repository that the MySQL server machine can access when needed without having to store any of the data in itself). In the case this is not possible, what operation can achieve something that is closest to what I have described? Thank you very much in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: More tables or more joins
Jackson Miller wrote: I understand that having this many tables is crazy, but I don't understand why it is not better. Several reasons. One is complexity, another is administration. Using one table per user is nasty because it's too complicated. You have 200 tables to keep track of, each with its own structure. Administration becomes a problem because everything is multiplied by 200. You decide next year that you need to track another field? No problem... just modify 200 tables! A new key? 200 times! You also end up with difficulties when you want to generate cross-user reports, for instance to show all contacts that multiple users are dealing with. And then you need to build a new table each time you get a new user, and presumably drop tables when users go away. It won't be pretty, even if you automate as much as you can. On Wed, 2 Jul 2003, Jackson Miller wrote: I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to control the fields that it is storing for it's contacts. If you get more specific about this requirement, we may find a better solution. For instance, if each user is interested in a different subset of fields from some universal common set, you can have a common table with everything, and store (in another table) the fields that each user is interested in, to build a customized display for each user at run-time. Or, you could have a 'custom field definition' table keyed by userid and fieldname, and a 'custom field value' table keyed by userid, fieldname, and contactid, and create customization that way. This is probably similar to what you were describing in your second scenario; I'm not sure, because I don't know what an 'account relationship' is. Bruce Feist -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Newbie SELECT problem
Well, it is important to remember that SELECT DISTINCT simply restricts that the WHOLE ROW is distinct, therefore it takes into account all columns, not just the sessionID column, when deciding if a row is distinct. One way to do this would be to do SELECT sessionID, userID, date, time FROM sti_tracking WHERE sessionID IN (SELECT DISTINCT sessionID FROM sti_tracking WHERE userID = 99); Assuming you have MySQL 4.1 that is (which supports subselects). Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 10:56 AM To: [EMAIL PROTECTED] Subject: Newbie SELECT problem Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor userID are keys or unique. Obviously this isn't working. Can someone suggest how this should be done? Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie SELECT problem
Tim Winters wrote: Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor userID are keys or unique. Obviously this isn't working. Can someone suggest how this should be done? If I understand you properly, you want only a single line for each of userID 999's sessions, is that right? Is there some specific date and time that you are interested in for that session, for instance, the first? If so, try: SELECT sessionID, userID, min(date), min(time) FROM sti_tracking WHERE userID = 999 GROUP BY userI, sessionID Even if I misunderstood, you can probably adapt this into what you really want. Bruce Feist -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Having MySQL Server and databases on different computers
Well, if we are talking about a one to one relationship between MySQL and repository, you can always share the folder the data files will be stored in using NFS or SMB, and then just adjust the datadir entry in the my.cnf file appropriately. The performance of such a solution will probably be degraded though. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Aleksandr Zingorenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 11:05 AM To: [EMAIL PROTECTED] Subject: Having MySQL Server and databases on different computers I am wondering if it is possible to run MySQL Server on one computer on a LAN, but have all the databases be stored on another computer on that LAN (such that the other machine is like a data repository that the MySQL server machine can access when needed without having to store any of the data in itself). In the case this is not possible, what operation can achieve something that is closest to what I have described? Thank you very much in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie SELECT problem
Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor userID are keys or unique. Obviously this isn't working. Can someone suggest how this should be done? Tim Winters Creative Development Manager Sampling Technologies Incorporated Had a similar experience, and I've been doing it long enough to know better. 'DISTINCT' would work only if date and time returned the same values. Are '999' and '99' supposed to be the same? Let me see if I can rephrase what you are looking for: a. For user '999' give me the information where there is only one record with a given SessionID? b. For user '999' for each sessionID give me the unique Date and Time values. c. something else entirely. Also, are you running this in a procedureal language (e.g., perl, java)? This will give us other options. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Convert Row Data to Coulmns which are not duplicated (Left Joins and Group BY)
I have multiple tables and require to retrieve data
from the tables. Though this is quite achieved, what
problem i see is that two of my result sets are stored
in a table as rows and i would like to retrieve them
as columns.
The query that i am executing is...
---
SELECT
u.user_id,
ul.location_desc,
YEAR(CURDATE())-YEAR(ud.date_of_birth) as age,
if(udo.option_type='employed',udo.option_value,'')
as emplyed,
if(udo.option_type='married',udo.option_value,'') as
married
FROM
user AS u
LEFT JOIN user_location ul ON u.user_id=ul.user_id
LEFT JOIN user_detail ud ON u.user_id=ud.user_id
LEFT JOIN user_detail_option_map udom ON
udom.user_detail_id=ud.user_detail_id
LEFT JOIN user_detail_option udo ON
udo.option_id=udom.option_id
WHERE option_type IN('employed','married')
ORDER BY
modify_date
LIMIT 10
The issue here is that i get the rows correctly with
valid data but since i get the 'employed' and
'married' option types as rows i get duplicate rows
for each user which i need to avoid.
This is the current result set with the above query.
--
uid | location | age | employed | married
--
111 | INDIA| 44 | yes |
--
111 | INDIA| 44 | | NO
--
112 | INDIA| 24 | No |
--
112 | INDIA| 24 | | Yes
I would like to retrieve the rows with consolidate
results like.
--
uid | location | age | employed | married
--
111 | INDIA| 44 | yes | NO
--
112 | INDIA| 24 | No | Yes
Any reference in this regard would really help..
Paresh Parihar
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
Check your permissions in /usr/local/mysql, I think the package leaves some incorrectly set. The exact problem is usually logged in /usr/local/mysql/data/hostname.err this file is invaluable Cheers! --s On Wednesday, July 2, 2003, at 09:24 AM, Todd O'Bryan wrote: OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: Todd O'Bryan [EMAIL PROTECTED] wrote: Something bad has happened. MySQL was up and running on my machine, but now it's not and I have a chicken and egg problem that I can't seem to solve... I uninstalled any old versions of MySQL and I'm using the package installer of version 4.0.13 on Mac OS 10.2.6. When I cd /usr/local/ and sudo ./bin/mysqld_safe I get the following: Starting mysqld daemon with databases from /usr/local/mysql/data 030702 08:43:04 mysqld ended So, I check the log and here's what it says: 030702 08:43:04 mysqld started 030702 8:43:04 Can't start server : Bind on unix socket: Permission denied 030702 8:43:04 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 030702 8:43:04 Aborting 030702 8:43:04 /usr/local/mysql/bin/mysqld: Shutdown Complete 030702 08:43:04 mysqld ended But, I'm pretty sure nothing's running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Check with ps ax| grep mysqld if mysqld is running. If mysqld is running, find mysql.sock file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Having MySQL Server and databases on different computers
I think a network filesystem would add a LOT of latency, perhaps you need a SAN type solution? This way the data could be off on some other device, possibly accessible to more than one host. --s On Wednesday, July 2, 2003, at 10:11 AM, Mike Hillyer wrote: Well, if we are talking about a one to one relationship between MySQL and repository, you can always share the folder the data files will be stored in using NFS or SMB, and then just adjust the datadir entry in the my.cnf file appropriately. The performance of such a solution will probably be degraded though. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Aleksandr Zingorenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 11:05 AM To: [EMAIL PROTECTED] Subject: Having MySQL Server and databases on different computers I am wondering if it is possible to run MySQL Server on one computer on a LAN, but have all the databases be stored on another computer on that LAN (such that the other machine is like a data repository that the MySQL server machine can access when needed without having to store any of the data in itself). In the case this is not possible, what operation can achieve something that is closest to what I have described? Thank you very much in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: privileges not updating
On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote: me [EMAIL PROTECTED] wrote: i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE should take effect immediately but they don't. i'm using command line How did you exactly update privileges? Show me the output of SHOW GRANTS for those users. ok... here is the output of the show grants before i try to change the privileges: mysql show grants for [EMAIL PROTECTED]; +--- --+ | Grants for [EMAIL PROTECTED] | +--- --+ | GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD 'moo' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `mydb`.* TO 'myuser'@'localhost' | +--- --+ 4 rows in set (0.00 sec) to change the privileges for mydb - to add FILE - i do: mysql grant SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,FILE,INDEX,ALTER on mydb.* to [EMAIL PROTECTED] this returns no errors after that i check privileges again: mysql show grants for [EMAIL PROTECTED]; and i get exactly the same output as before (see up).. if i try: mysql revoke INDEX on mydb to [EMAIL PROTECTED]; that one works - and if i grant it again - it works too... apparently the FILE privilege is not getting registered and i'm not sure why.. if any other suggestions - will be appreciated.. thanks... also if i create a database, grant privileges on it and then delete the db if i check grants - it still appears... It's normal behaviour: http://www.mysql.com/doc/en/GRANT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Newbie SELECT problem
Hello, Very sorry to everyone about the confusing message. I should have read it over again before pressing send. First of all I'm looking for userID 999. A typo in the message not in the code. The table is set up like this. Table name sti_tracking hitID (primary key) (autonumber) userID sessionID date time pageName What it's for is a simple page tracing counter for a FLash site. Each time a section is accessed a new row is written in the table. userID identifies the user. So if the user comes to the site today and comes back again tomorrow the userID will be maintained. sessionID identifies 1 visit to the site. During 1 visit a user may view many sections within the site but as long as he doesn't close the browser the session number remains the same. Date and time will always be different (as will the hitID obviously). So what I want to be able to do is single out a user (999) and retrieve all the sessions he was involved in. But I don't want duplicate session numbers (one is enough). Make any more sense? Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: July 2, 2003 2:13 PM To: [EMAIL PROTECTED] Subject: Re: Newbie SELECT problem Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor userID are keys or unique. Obviously this isn't working. Can someone suggest how this should be done? Tim Winters Creative Development Manager Sampling Technologies Incorporated Had a similar experience, and I've been doing it long enough to know better. 'DISTINCT' would work only if date and time returned the same values. Are '999' and '99' supposed to be the same? Let me see if I can rephrase what you are looking for: a. For user '999' give me the information where there is only one record with a given SessionID? b. For user '999' for each sessionID give me the unique Date and Time values. c. something else entirely. Also, are you running this in a procedureal language (e.g., perl, java)? This will give us other options. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie SELECT problem
Tim Winters wrote: So what I want to be able to do is single out a user (999) and retrieve all the sessions he was involved in. But I don't want duplicate session numbers (one is enough). Make any more sense? Yes. The solution I posted earlier should work. Bruce Feist -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie SELECT problem
select sessionID,userID,date,time from sti_tracking where userID=99 group by sessionID; hope that works ,though i didn't clearly got your question,may be some expert suggest better regards harsh On Wed, 2 Jul 2003, Tim Winters wrote: Hello everyone, I have the following select statement SELECT DISTINCT sessionID, userID, date, time FROM sti_tracking WHERE userID = 999 What I want is to have only records with the userID of 99 and where the sessionID is distinct (meaning only on of each session id). Neither sessionID nor userID are keys or unique. Obviously this isn't working. Can someone suggest how this should be done? Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: License?
I would recomend reading up on the copyright laws in your country. publishing and distribution are legally defined terms. IANAL but IIRC publishing means to create a copy of something on a medium and distribution means to deliver that medium to someone else. These concepts get tricky in a legal sense, and the issue of presedence of contract law and copyright law needs to be determined. You may have rights granted to you through copyright law. In the context of doing things at work you are your company, not you as an individual, so your company is not 'distributing' it if you put it on a bunch of machines as you might be doing if you put it on a bunch of machines for other companies. This gets tricky when your a consultant and you have been hired to install MySQL... You should be able to ask MySQL for a clear answer to a clear question. Like all legal things, talk to a lawyer if there's a license issue. -- Michael Conlen Joel Rees wrote: What does internal distribution mean? Is it another thing than copying? I've wondered that myself. See http://www.gnu.org or http://www.fsf.org to get more information on the GPL. Licensing, etc., is explained on their site, http://www.mysql.com/doc/en/Licensing_and_Support.html and they tend to be willing to answer questions if you send mail to their sales crew. Remember that publishing and distribution are two separate things. I think they used not to be very concerned about internal distribution, except in cases where the numbers were large, but I think their lawyers and business people having been pushing them to avoid ambiguities. Consider this example: A company has 2 database servers and want to install MySQL on both servers. Is MySQL free for the first server, but require a license for the second server? Or are MySQL free for both servers? Don't get me started. http://www.mysql.com/doc/en/Using_the_MySQL_software_under_a_commercial_license.html http://www.mysql.com/doc/en/Using_the_MySQL_software_for_free_under_GPL.html It looks to me as if distributing a modified version of MySQL appears to require either the use of the GPL on your modifications or the purchase of a license for each copy distributed. Modification includes linking an application to either MySQL or to one of the MySQL provided drivers. A GPL compatible license may also be used, I think, and if that path is chosen, it must be applied to all of your application source. Previously, the drivers were under the LGPL, which allowed linking an application that was not GPL compatibly licensed, and that was significantly easier to work with. Apparently (without further elucidation from MySQL) you can't distribute PHP linked with the new versions of the drivers (or even to libraries designed to work only with parts of the driver API that are uniquely MySQL's and therefore covered by MySQL's copyright). As a result, PHP 4 is distributed with libraries linked to the old drivers, and PHP 5 is distributed without the MySQL specific drivers directly linked. So the end user of an app written for PHP 5 must install MySQL and its drivers; separately install PHP and either compile the MySQL libraries in or, for MSWindows, set it up to use the MySQL shared libraries dll; and then install the app. You could provide an installer to install both PHP and the app, I think, but the installer for MySQL would have to be separate. (And if you built your own separate installer for MySQL, the installer would have to be under the GPL.) This would be because PHP is not under the GPL license, but under the PHP license, which does not require modifications to be published under a GPL compatible license in order to be distributed. If you use a generic driver, you may be able to avoid the GPL effects, but that's really beside the point. If it makes you money, and if you want it to continue to make you money, logic itself requires you to send some of the action back to the people that build it. In MySQL's case, the people who build it have set up a licensing program to make it easier to cooperate financially and technically. rant If you used, for instance, PostGreSQL, even though that license does not place any publishing or licensing requirements on linked code, the logic remains. Support the developers, or expect to find yourself stuck without support. Vote with your money, so to speak. (As I see it, the two specific advantages of open source and free software are, first, you can legally modify it to your own purposes, and, second, you can usually set up some way to get a good start without paying through the teeth just for the right to find out if your project is going to roll like a tank or roll in the tank. The concept of making money with no expenses at all is a mirage, and a dangerous one, and when you hear the suits talk about frictionless economy, tell them to take their manure generators elsewhere.) /rant -- MySQL General Mailing List For list archives:
mysqld_multi fails on Solaris 8
Hello, Has anyone had success using the mysqld_multi startup script at boot on Solaris 8? I can start mysqld manually, but not automatically at boot time. Any help or advice is apprciated. Thanks a lot, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: NFS or replication?
Steven, Don't use NFS, bad idea. You can do the master writer/multi reader, but it's always been a problem making sure every reader is up to date. You need to have a way to verify this manually. If your really going to max out your platform there's other platforms to look at, but the costs go up FAST. Instead of looking at a 10k machine you start looking at a 100k to 1mil machine, but it all depends on your needs. If you need to have the data correct that instant, you need it, but for a web profile it might be much more cost effictive to say updates to your profile may take a few moments or some such. Sun, HP and IBM make some very good hardware using their own designs (Sparc, PA-RISC and Power4) -- Michael Conlen Steven Balthazor wrote: I am interested in any thoughts that people may have for creating a scalable mysql infrastructure. I have a web application which runs on several front end web servers which hit one backend mysql server. Presently I can continue to grow by adding front end webservers -- the mysql server is not close to maxed out. Looking toward the future I will have to make a decision about how to grow the mysql serving capability and have several ideas on how to do it. Now some questions for the group: 1. I can guess that my select to insert/update ratio is probably on the order of 4:1 but is there a simple tool to use to determine the actual ratio. 2. When I want to scale up the mysql server what are the pros/cons of each of the following: a. Create an NFS server on the backend and load balance several mysql servers all accessing the same database files via NFS (is this even possible/desirable?) b. Make one big server the primary insert/update server and replicate the data out to many read-only slaves (at what ratio of read to writes in conjunction with number of slaves does this start to limit scalability). c. Buy one big monster server every year and hope to stay ahead of my needs (and have the previous years machine as a backup) 3. With a replication strategy how does one make sure that the current information is displayed to a user? For example, a frequent action in a web application is to update information in a user's profile. Typically the way this is done is for the user to enter the information into a web form submit the form and then the user gets a page with the current data displayed in a read-only format (so the user knows the update was successful). How do most people handle this to make sure that the current data is displayed? Do you just perform the select from the write server for this one case? Or is replication fast enough that performing the select from one of the slaves is ok? 4. Replication (choice b) seems to be the preferred way to go, based on what I have seen on the list; is there a reason why NFS is not an option? Also is the choice determined by the type of database (InnoDB vs. MyIsam). I am interested in any comments/experience people may have on this issue. I have many thoughts of my own regarding ease of maintenance, backup, reliability, ease of expansion, cost, performance, etc. However I have not had time or hardware to test the different possibilities and would greatly appreciate hearing what others have to say. Thank you for your comments, Steven Balthazor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: simplify query?
What you want to do is reduce the query. Logic is reduced using similar rules to algebra. Think of or operations as addition and and operations as multiplication and you can manipulate them using the same rules as you do in algebra. select * from t where (a and b) or (a and c); where a, b and c are conditions this query could be restated as select * from t where a and (b or c); your query is of the form (a or b or c) and (d or e or f), which I don't think can be reduced any further, but it can certainly be made more complicated as in (a and d) or (a and e) or (a and f) or (b and d) ... -- Michael Conlen Reto Baudenbacher wrote: hi Sorry for this newbie-question: is it possible to simplifiy the following (working) query? SELECT * FROM mytable WHERE ((col1 LIKE '%test%') OR (col2 LIKE '%test%') OR (col3 LIKE 'test%')) AND (col5 = 'y' OR col6 = 'y' OR col7 = 'y') ORDER BY col1 Thanks for any suggestions! Reto Baudenbacher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unexpected empty table performance problem with MySQL and InnoDB
Hi, I wanted to post a follow-up question to the inquiry below. I've done some more research since my last post and now think that the performance problem is related to something other than uncommitted transactions. More specifically, I think the culprit is the lack of timely synchronization (or merging) of the purge list. As I mentioned below, we insert and delete a large number of rows into the DB in a rapid fashion. The newly deleted rows get marked for deletion, but are not physically purged. This seems to be indicated by 'show table status' reporting over 800K rows in the table in question, while in reality the table is empty. Restarting the DB forced the purge list to be either merged on shutdown (with an earlier version of MySQL/InnoDB) or to start being merged when restarted. We've looked at the source a little and it seems that the scheduling algorithm for the purging tries to initiate the purge process after a period of inactivity (10 sec?). Once started, the process completes, but in our case, it seems that something's preventing it from starting, and so it essentially starves, leaving the purge list full and forcing its scans to answer queries. Does that sound right? If so, can someone shed some light on the scheduling algorithm used to merge the purge list? We originally thought that we just had to make sure there was some idle period for it to get started, but that doesn't seem to be the case. We would make sure that our applications didn't send any queries and wait for about a minute, and the purge process still wouldn't begin. On the other hand, a few seconds after we shut down our application, the process would kick off and after a while correctly sync up the purge list with the database. (We can leave a 'mysql' client console session open, and it doesn't seem to affect the merge operation, as long as we don't send any queries for a while.) We're using the MMMySQL JDBC driver version 2.0 in our application, in case it makes a difference. Can someone give any insights on what could be done to allow MySQL/Innodb to process the purge list in a timely manner? Thanks in advance, Alex Zeltser Tom Dangler [EMAIL PROTECTED] wrote: Is there any way to tell whether MySQL/InnoDB think that there are still uncommitted transactions? Yes - show innodb status will give you this information. -snipped from show innodb status-- ---TRANSACTION 0 8627445, ACTIVE 6809 sec, OS thread id 503835 MySQL thread id 11328, query id 107361 xxx.xxx.xxx.xxx user Trx read view will not see trx with id = 0 8627446, sees 0 8627446 - Check out http://www.mysql.com/doc/en/Innodb_Monitor.html for more info. Also of interest is the innodb_lock_monitor which gives some additional information on your transactions - described at the above link. [EMAIL PROTECTED] 05/21/03 11:26AM Thank you to all who has replied to my original question. It seems that the current working theory is that the behavior I've observed is due to transactions not having been committed. This could of course be the case, and I will double-check the code, but I'm reasonably sure that we commit each individual insert or delete as soon as it happens. (We only take advantage of transactions to make certain physically separate operations logically atomic.) Is there any way to tell whether MySQL/InnoDB think that there are still uncommitted transactions? Since I still have a server in that state, it would be possible for me to get more information about this problem, if I knew what to look for... If I see in our code that we do, in fact, commit all transactions right away, what could lead to them remaining physically uncommited? Furthermore, if it turns out that uncommited transactions weren't the cause, can anyone think of anything else that may have contributed to the server ending up in that state? Finally, is there a way to defragment the table 'live'--i.e. without dumping the data and recreating the table? Thank you in advance. Best regards, Alex __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
Table Name as UserName with a Blank Password
I recently stumbled onto the ability to log into a mysql server from the command line with any table name, and a blank password. ie: mysql -u mysql My root account has a password set, and a few users with limited access but I haven't done much else as far security goes. I've tried this on a 3.23 and 4.0 mysql server running on RedHat and FreeBSD. Is there a setting I need to change to stop this? Thanks in advance, Dan Ullom
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication / table copy question
Hello, I have two mysql databases running on different hosts - the database are similiar in structure. I would like to copy specific tables from one db to another db on a scheduled basis. Is there a command to replicate a table from one db to another on a different host? TIA -roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unexpected empty table performance problem with MySQL and InnoDB
Alex,
why you do not look with SHOW INNODB STATUS if there are dangling
transactions which could still see the delete-marked rows? Purge cannot
remove them then.
The main InnoDB thread tries to run a full purge even when the server is
active. This snippet is from srv0srv.c of 4.0.14:
/* We run a full purge every 10 seconds, even if the server
were active */
n_pages_purged = 1;
last_flush_time = time(NULL);
while (n_pages_purged) {
if (srv_fast_shutdown srv_shutdown_state 0) {
goto background_loop;
}
srv_main_thread_op_info = (char*)purging;
n_pages_purged = trx_purge();
current_time = time(NULL);
if (difftime(current_time, last_flush_time) 1) {
srv_main_thread_op_info = (char*) flushing log;
log_write_up_to(ut_dulint_max, LOG_WAIT_ONE_GROUP,
TRUE);
last_flush_time = current_time;
}
}
Regards,
Heikki
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 12:10 AM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
Hi,
I wanted to post a follow-up question to the inquiry below. I've done some
more research since my last post and now think that the performance problem
is related to something other than uncommitted transactions. More
specifically, I think the culprit is the lack of timely synchronization (or
merging) of the purge list. As I mentioned below, we insert and delete a
large number of rows into the DB in a rapid fashion. The newly deleted rows
get marked for deletion, but are not physically purged. This seems to be
indicated by 'show table status' reporting over 800K rows in the table in
question, while in reality the table is empty. Restarting the DB forced the
purge list to be either merged on shutdown (with an earlier version of
MySQL/InnoDB) or to start being merged when restarted.
We've looked at the source a little and it seems that the scheduling
algorithm for the purging tries to initiate the purge process after a period
of inactivity (10 sec?). Once started, the process completes, but in our
case, it seems that something's preventing it from starting, and so it
essentially starves, leaving the purge list full and forcing its scans to
answer queries. Does that sound right?
If so, can someone shed some light on the scheduling algorithm used to
merge the purge list? We originally thought that we just had to make sure
there was some idle period for it to get started, but that doesn't seem to
be the case. We would make sure that our applications didn't send any
queries and wait for about a minute, and the purge process still wouldn't
begin. On the other hand, a few seconds after we shut down our application,
the process would kick off and after a while correctly sync up the purge
list with the database. (We can leave a 'mysql' client console session open,
and it doesn't seem to affect the merge operation, as long as we don't send
any queries for a while.)
We're using the MMMySQL JDBC driver version 2.0 in our application, in
case it makes a difference.
Can someone give any insights on what could be done to allow MySQL/Innodb
to process the purge list in a timely manner?
Thanks in advance,
Alex Zeltser
Tom Dangler [EMAIL PROTECTED] wrote:
Is there any way to tell whether MySQL/InnoDB think that there are
still uncommitted transactions?
Yes - show innodb status will give you this information.
-snipped from show innodb status--
---TRANSACTION 0 8627445, ACTIVE 6809 sec, OS thread id 503835
MySQL thread id 11328, query id 107361 xxx.xxx.xxx.xxx user
Trx read view will not see trx with id = 0 8627446, sees 0 8627446
-
Check out http://www.mysql.com/doc/en/Innodb_Monitor.html for more info.
Also of interest is
the innodb_lock_monitor which gives some additional information on your
transactions - described at the above link.
[EMAIL PROTECTED] 05/21/03 11:26AM
Thank you to all who has replied to my original question. It seems that
the current working theory is that the behavior I've observed is due to
transactions not having been committed. This could of course be the case,
and I will double-check the code, but I'm reasonably sure that we commit
each individual insert or delete as soon as it happens. (We only take
advantage of transactions to make certain physically separate operations
logically atomic.)
Is there any way to tell whether MySQL/InnoDB think that there are still
uncommitted transactions? Since I still have a server in that state, it
would be possible for me to get more information about this problem, if I
knew what to look for...
If I see in our code that we do, in fact, commit all transactions right
RE: Newbie SELECT problem
Table name sti_tracking hitID (primary key) (autonumber) userID sessionID date time pageName this might work select userID,sessionID from sti_tracking where userID=999 group by sessionID; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
I found that file in /usr/libexec/mysqld hope that helps -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003 [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie SELECT problem
Tim:
Assuming that in your ealier posting the 99 was supposed to be 999, then
the solution given by Mike Hillyer is excellent and should work.
However, when I read your new posting, I seem to get confused. The
scenario sounds totally different - excuse me - from the earlier one and
would therefore need a different solution. You might help us by giving
sample data.
Or is this what you mean by But I don't want duplicate session numbers
(one is enough)? == In a single session (sessionID) user 999 (userID
999) may visit 3 pages. This results in three inserts being made into
table sti_tracking all having same sessionID and userID. Correct? When
retrieving you do not want to retrieve all these three records. Correct?
You just want one of the records. Which one? The first, second or third
because they each probably have a different time and pageName (even
date!!). If you did not want the date, time and pageName then the
solution is simple SELECT DISTINCT userID, sessionID FROM sti_tracking
WHERE userID = 999.
If you do not care which of the entries (3 in my example) is returned
and you still want the date, time and pageName (my guess is the first
will be returned), then you need to generate all the distinct userID and
sessionID pairs using the above SQL. Then for each pair (use a loop) run
SELECT userID, sessionID, date, time, pageName FROM sti_tracking WHERE
userID = {provide from loop} AND sessionID = {provide from loop} LIMIT 1.
Peter Aganyo
Tim Winters wrote:
Hello,
Very sorry to everyone about the confusing message. I should have read
it over again before pressing send.
First of all I'm looking for userID 999. A typo in the message not in
the code.
The table is set up like this.
Table name sti_tracking
hitID (primary key) (autonumber)
userID
sessionID
date
time
pageName
What it's for is a simple page tracing counter for a FLash site. Each
time a section is accessed a new row is written in the table.
userID identifies the user. So if the user comes to the site today and
comes back again tomorrow the userID will be maintained.
sessionID identifies 1 visit to the site. During 1 visit a user may
view many sections within the site but as long as he doesn't close the
browser the session number remains the same. Date and time will always
be different (as will the hitID obviously).
So what I want to be able to do is single out a user (999) and retrieve
all the sessions he was involved in. But I don't want duplicate session
numbers (one is enough).
Make any more sense?
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
1600 Bedford Highway, Suite 212
Bedford, Nova Scotia
B4A 1E8
www.samplingtechnologies.com
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Office: 902 450 5500
Cell: 902 430 8498
Fax:: 902 484 7115
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: July 2, 2003 2:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Newbie SELECT problem
Hello everyone,
I have the following select statement
SELECT DISTINCT sessionID, userID, date, time
FROM sti_tracking
WHERE userID = 999
What I want is to have only records with the userID of 99 and where
the
sessionID is distinct (meaning only on of each session id). Neither
sessionID nor userID are keys or unique.
Obviously this isn't working.
Can someone suggest how this should be done?
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
Had a similar experience, and I've been doing it long enough to know
better. 'DISTINCT' would work only if date and time returned the
same
values.
Are '999' and '99' supposed to be the same?
Let me see if I can rephrase what you are looking for:
a. For user '999' give me the information where there is only one
record
with a given SessionID?
b. For user '999' for each sessionID give me the unique Date and Time
values.
c. something else entirely.
Also, are you running this in a procedureal language (e.g., perl, java)?
This will give us other options.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with [EMAIL PROTECTED]
http://shopnow.netscape.com/
Re: Newbie SELECT problem
Tim:
Assuming that in your ealier posting the 99 was supposed to be 999, then
the solution given by Mike Hillyer is excellent and should work.
However, when I read your new posting, I seem to get confused. The
scenario sounds totally different - excuse me - from the earlier one and
would therefore need a different solution. You might help us by giving
sample data.
Or is this what you mean by But I don't want duplicate session numbers
(one is enough)? == In a single session (sessionID) user 999 (userID
999) may visit 3 pages. This results in three inserts being made into
table sti_tracking all having same sessionID and userID. Correct? When
retrieving you do not want to retrieve all these three records. Correct?
You just want one of the records. Which one? The first, second or third
because they each probably have a different time and pageName (even
date!!). If you did not want the date, time and pageName then the
solution is simple SELECT DISTINCT userID, sessionID FROM sti_tracking
WHERE userID = 999.
If you do not care which of the entries (3 in my example) is returned
and you still want the date, time and pageName (my guess is the first
will be returned), then you need to generate all the distinct userID and
sessionID pairs using the above SQL. Then for each pair (use a loop)
run SELECT userID, sessionID, date, time, pageName FROM sti_tracking
WHERE userID = {provide from loop} AND sessionID = {provide from loop}
LIMIT 1.
Peter Aganyo
Tim Winters wrote:
Hello,
Very sorry to everyone about the confusing message. I should have read
it over again before pressing send.
First of all I'm looking for userID 999. A typo in the message not in
the code.
The table is set up like this.
Table name sti_tracking
hitID (primary key) (autonumber)
userID
sessionID
date
time
pageName
What it's for is a simple page tracing counter for a FLash site. Each
time a section is accessed a new row is written in the table.
userID identifies the user. So if the user comes to the site today and
comes back again tomorrow the userID will be maintained.
sessionID identifies 1 visit to the site. During 1 visit a user may
view many sections within the site but as long as he doesn't close the
browser the session number remains the same. Date and time will always
be different (as will the hitID obviously).
So what I want to be able to do is single out a user (999) and retrieve
all the sessions he was involved in. But I don't want duplicate
session numbers (one is enough).
Make any more sense?
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
--snip--
While I was trying to figure an elegant solution to this I noticed that
you have a separate date and time field. Is there a reason for this. It
would be easier to get single row for each sessionID if they were one
field. Otherwise I think you will have to go with the method Peter
proposed above.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie SELECT problem
Tim:
Assuming that in your ealier posting the 99 was supposed to be 999,
then
the solution given by Mike Hillyer is excellent and should work.
However, when I read your new posting, I seem to get confused. The
scenario sounds totally different - excuse me - from the earlier one
and
would therefore need a different solution. You might help us by
giving
sample data.
Or is this what you mean by But I don't want duplicate session
numbers (one is enough)? == In a single session (sessionID) user 999
(userID 999) may visit 3 pages. This results in three inserts being
made into table sti_tracking all having same sessionID and userID.
Correct? When retrieving you do not want to retrieve all these three
records. Correct?
You just want one of the records. Which one? The first, second or
third because they each probably have a different time and pageName
(even
date!!). If you did not want the date, time and pageName then the
solution is simple SELECT DISTINCT userID, sessionID FROM sti_tracking
WHERE userID = 999.
If you do not care which of the entries (3 in my example) is returned
and you still want the date, time and pageName (my guess is the first
will be returned), then you need to generate all the distinct userID
and
sessionID pairs using the above SQL. Then for each pair (use a loop)
run SELECT userID, sessionID, date, time, pageName FROM sti_tracking
WHERE userID = {provide from loop} AND sessionID = {provide from
loop} LIMIT 1.
Peter Aganyo
Tim Winters wrote:
Hello,
Very sorry to everyone about the confusing message. I should have
read
it over again before pressing send.
First of all I'm looking for userID 999. A typo in the message not in
the code.
The table is set up like this.
Table name sti_tracking
hitID (primary key) (autonumber)
userID
sessionID
date
time
pageName
What it's for is a simple page tracing counter for a FLash site. Each
time a section is accessed a new row is written in the table.
userID identifies the user. So if the user comes to the site today and
comes back again tomorrow the userID will be maintained.
sessionID identifies 1 visit to the site. During 1 visit a user may
view many sections within the site but as long as he doesn't close
the browser the session number remains the same. Date and time will
always be different (as will the hitID obviously).
So what I want to be able to do is single out a user (999) and
retrieve
all the sessions he was involved in. But I don't want duplicate
session numbers (one is enough).
Make any more sense?
Tim Winters
Creative Development Manager
Sampling Technologies Incorporated
--snip--
While I was trying to figure an elegant solution to this I noticed that
you have a separate date and time field. Is there a reason for this.
It would be easier to get single row for each sessionID if they were one
field. Otherwise I think you will have to go with the method Peter
proposed above.
--Somedays I just need more tea.. ok how about this:
select sessionID,max(concat(idate,' ',itime)) from test group by sessionID
Note I thought date and time were reserved so I substituted..
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Make sure the permissions on the file are set to executable. Assuming your platform is some *nix variant, login as root or owner. Change to the directory where your mysqld is located (/usr/local/mysql/libexec) and execute the following command: chmod 755 * This will ensure the binaries and scripts are executable. I hope this helps. Pat... CocoNet Corporation - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 5:18 PM Subject: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't start MySQL on Mac OS X
I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL/INNODB speed on large databases
For the first query below--if you really run it often enough to mess with indexes, and it really has a limit 1 or a small limit--an index on (VoidStatus, InstNum) ought to avoid having MySQL create a big temporary table and then sort it. In addition, you could add to the index any of columns in the other AND clauses, if doing so would allow a lot of records to be skipped over during the index scan, rather than read in their entirety. From: Wendell Dingus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL/INNODB speed on large databases Date: Wed, 2 Jul 2003 11:51:05 -0400 Thanks to everyone who has helped and/or made suggestions so far. I'll try to provide some answers to your further queries and report back on some testing I've done. Jeremy asked for explains of some of the problem queries: Here is a particularly troublesome one that gets ran quite a lot: mysql SELECT InstNum FROM TBL_Transactions WHERE ((IndexStatus '2' OR Scanned'Y') OR (MoneyStatus '1')) AND ((VoidStatus = 'N') AND (IndexType 'CP') AND (Year '2001')) ORDER BY InstNum ASC LIMIT 1; +--+ | InstNum | +--+ | 03128665 | +--+ 1 row in set (6.59 sec) mysql explain SELECT InstNum FROM TBL_Transactions WHERE ((IndexStatus '2' OR Scanned'Y') OR (MoneyStatus '1')) AND ((VoidStatus = 'N') AND (IndexType 'CP') AND (Year '2001')) ORDER BY InstNum ASC LIMIT 1; +--+--++ +-+---+++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--++ +-+---+++ | TBL_Transactions | ref | Year,VoidStatus,IndexStatus,Year_2 | VoidStatus | 2 | const | 150804 | where used; Using filesort | +--+--++ +-+---+++ 1 row in set (0.00 sec) Thanks to Joseph Bueno for suggesting the 4.x query cache: I took the above query and on a test server running 4.0.13 I setup a 1MB query cache and tried it out. It took 6 seconds first time and 0.00 seconds on subsequent times. I'm assuming this cache is smart enough to re-perform the query if any data pertaining to it changes, yeah surely... So on often-executed queries where the data is very cachable this will help. After a few minutes of monitoring this one floats to the top of a mytop output screen as taking the longest to run: mysql explain SELECT DISTINCT LastName, FirstName, PAName FROM TBL_AllNames WHERE PAName LIKE 'WHITE%' AND NameType'2' ORDER BY LastName, FirstName; +--+---+-++-+--+ ---+-+ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+---+-++-+--+ ---+-+ | TBL_AllNames | range | PAName,NameType | PAName | 81 | NULL | 41830 | where used; Using temporary | +--+---+-++-+--+ ---+-+ 1 row in set (0.00 sec) mysql Running the actual query returned 4000 rows and took (58.20 sec) Here's some details of that table: mysql describe TBL_AllNames; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | InstNum | varchar(8) | | PRI | | | | Year | varchar(4) | | PRI | | | | NameType | char(2) | | PRI | | | | NameClass | char(1) | YES | MUL | NULL| | | NameAP| char(1) | YES | | NULL| | | Ncount| int(11) | | PRI | 0 | | | LastName | varchar(80) | YES | MUL | NULL| | | FirstName | varchar(60) | YES | MUL | NULL| | | TypeofName| varchar(20) | YES | | NULL| | | PAName| varchar(80) | YES | MUL | NULL| | | SoundKeyFirst | varchar(12) | YES | MUL | NULL| | | SoundKeyLast | varchar(12) | YES | MUL | NULL| | | RecDate | varchar(8) | | MUL | | | | InstCode | varchar(10) | | MUL | | | | IndexType | varchar(4) | | | | | | XrefGroup | varchar(8) | | | | | +---+-+--+-+-+---+ 16 rows in set (0.00 sec) mysql select count(*) from TBL_AllNames; +--+ | count(*) | +--+ | 6164129 | +--+ 1 row in set (50.17 sec)
Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
That's exactly what I had to do as well. I wouldn't even start in rc.local unless I put in exactly what is shown below. Ed On Wed, 2 Jul 2003, Todd O'Bryan wrote: Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Todd, It didn't help. Here is the message: $ cd /usr/local/mysql $ ./bin/mysqld_safe The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. $ --- It worked fine until yesterday. SA told me he had rebuilt /user/local directory this morning. All the files are still there after the build. Actually I have two versions of mysql. I would like to start mysqld using different version of mysql that I installed in a different location. I wonder where the path '/usr/local/mysql/libexec/mysqld' stored in the system. Can we change this path somewhere in the parameter file? Thanks, song -Original Message- From: Todd O'Bryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 6:56 PM To: Xu, Song PH/US/EXT Cc: [EMAIL PROTECTED] Subject: Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe [1] 22717 $ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. --- Can anyone help me to resolve this? It is emergency. Regards, song -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Possible OT: ADONewConnection Error
Anyone here familiar with the following error: ADONewConnection: Unable to load database driver '' Fatal error: Call to a member function on a non-object in /wwwroot/htdocs/webdev/nubiint/includes/pnAPI.php on line 486 I get this error when trying to configure multisites in my postnuke site. I thought it was an ODBC issue but I've installed both MyODBC iODBC and still get the error. Anyone have any ideas on what else could be causing this? Any responses are appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication / table copy question
On Wed, Jul 02, 2003 at 02:28:38PM -0700, Kevin wrote: Hello, I have two mysql databases running on different hosts - the database are similiar in structure. I would like to copy specific tables from one db to another db on a scheduled basis. Is there a command to replicate a table from one db to another on a different host? Have a look at MySQL's replication docs. It can likely do what you need. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 29 days, processed 919,384,699 queries (357/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB logfile question
Uups must have forgotten to copy the list ;-) Thanks Heikki, Also I dont fully understand the resulting context yet, I appreciate the reply. Best regards Nils Valentin Tokyo/Japan 2003 7 3 00:07Heikki Tuuri : Nils, at the lower level all mini-transactions always succeed. They all have to be logged. Regards, Heikki - Alkuperinen viesti - Lhettj: Nils Valentin [EMAIL PROTECTED] Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED] Lhetetty: Wednesday, July 02, 2003 1:39 PM Aihe: Re: InnoDB logfile question Hi Heikki, I trust your info. However, I am currently waiting for MySQL Transactions and Replication Handbook ISBN: 1861008384 http://www.amazon.com/exec/obidos/ASIN/1861008384/103-2494567-5987851 to be publised, which hopefully contains similar and newer information. Wouldn't it make sense not to log unsuccessful requests ? Isn't that useless overhead ? Best regards Nils Valentin Tokyo/Japan 2003 7 2 19:25Heikki Tuuri : Nils, InnoDB writes to ib_logfiles all tablespace modifying operations (= mini-transactions), whether they belong to a successful or an unsuccessful transaction. In crash recovery we redo everything, then roll back based on undo logs inside the tablespace. The best reference is Gray and Reuter: Transaction Processing, published around 1992. Regards, Heikki - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 12:34 PM Subject: Re: InnoDB logfile question Hi Heikki, 2003 7 2 18:10Heikki Tuuri : Nils, - Original Message - From: Nils Valentin [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 02, 2003 12:04 PM Subject: InnoDB logfile question Hello Heikki other Mysql Fans ;-); Does anybody know which requests or data the below logfils actually keep ?? If I understood correct than they are all in binary format (not readable in a text editor. log.01 this is a BDB log I think. ib_arch_log_00 InnoDB archived log which is produced in log file creation. Not needed for anything, just a relic from the past. ib_logfile0 ib_logfile1 These are the InnoDB redo logs it uses in crash recovery. It writes circularly to these files. Do I assume correctly that it writes into this files a) all successful transactions (requests, status A and B - before ad after the request) b) nothing else ?? Best regards Nils Valentin Tokyo/Japan Unfortunately I was unable to to find sufficient info here http://www.innodb.com/ibman.html. Best regards -- --- Valentin Nils Regards, Heikki Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
