Autorepair bug
Hello monty, It seems like something changed in 3.23.31 and 32 in auto_repair there. I see on many servers after crash (i've resently got unexpected powerdown for 10 of my machines so it worked like a good testcase) I got tables failed to be repaired (or well selects fail on them) 28.Jan 12:26:34 : pid:13836 counter:61005 AllInOne MySqlEr Query - #1016 [ruby.local] - Can't open file: 'g06layers_stat_providers.MYD'. (errno: 144) select id from layers_st45.g06layers_stat_providers where type=2 and begin=2001011700 and counter=61005 and page_group=255 28.Jan 12:26:34 : pid:13836 h -- 61005/0 AllInOne rec:0 l:0 tm:5.54 28.Jan 12:26:34 : pid:13836 h 61005/0 [17.1 18:34] - [] q:0.28 i:0.00 a:5.13 the check table for this table also reports mysql check table layers_st45.g06layers_stat_providers; +--+---+--+---+ | Table| Op| Msg_type | Msg_text | | +--+---+--+---+ | g06layers_stat_providers | check | warning | Table is marked as crashed |and last repair failed | | g06layers_stat_providers | check | error| Key 1 doesn't point at all |records| | layers_st45.g06layers_stat_providers | check | error| Corrupt | | +--+---+--+---+ 3 rows in set (6.60 sec) It seems like this message is similar for many tables (I've checked about 10 tables I found in my applicatin error log file) mysql check table layers_st27.g07layers_stat_framepages; +---+---+--+---+ | Table | Op| Msg_type | Msg_text || +---+---+--+---+ | g07layers_stat_framepages | check | warning | Table is marked as |crashed and last repair failed | | g07layers_stat_framepages | check | error| Key 1 doesn't point at |all records| | layers_st27.g07layers_stat_framepages | check | error| Corrupt || +---+---+--+---+ 3 rows in set (2.94 sec) therefore the logfiles indicates the table was checked and has no notes about it afterwards: 010127 13:11:48 Warning: Checking table: './layers_st27/g07layers_stat_framepages' As far then I check and repear all the tables explictly no error messages appears in a log files - this points to the auto repair procedure. Also I found that after even single crash I got the followings case, so this is not connected to crash during repair and so on... -- Best regards, Peter mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication stops
Hallo ... I tried to create simple replication: 2 machines mysql-3.23.32 master - name register slave - nane proxy master configuration: [mysqld] set-variable = max_connections=300 log-bin server-id=1 slave configuration: [mysqld] master-host=register master-user=replicate_user master-password= server-id=2 replicate-do-table=db1.tbl1 replicate-do-table=db1.tbl2 replicate-do-table=db1.tbl3 this is log from my slave: 010127 21:44:39 mysqld started /opt/mysql-3.23.32/libexec/mysqld: ready for connections 010127 21:44:42 Slave: connected to master 'replicate_user@register:3306', replication started in log 'FIRST' at position 4 010128 0:07:04 Error reading packet from server: Could not open log file (read_errno 0,server_errno=2) 010128 0:07:04 Slave: Failed reading log event, reconnecting to retry, log 'register-bin.004' position 86 010128 0:07:05 Slave: reconnected to master 'replicate_user@register',replication resumed in log 'register-bin.004' at position 86 010128 0:07:05 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) 010128 0:08:05 Slave: Failed reading log event, reconnecting to retry, log 'register-bin.004' position 86 directly in this time ( when slave stoped replication) im restarting master #killall -HUP mysqld next interesting think is that .. when I started replication, I had on master 3 event logs (register-bin.001, register-bin.002, register-bin.001) and they were written in register-bin.index now (after restart) I have there only register-bin.001 (and only this one is in register-bin.index file) I thought my problem is same as in thread [EMAIL PROTECTED] so I tryied * cat /path/to/datadir/master.info * get the log name and the offset * start the slave server * CHANGE MASTER TO MASTER_LOG_POS=saved_position, MASTER_LOG_FILE='saved_log_name' but, in the master.info on slave machine was register-bin.004 86 which doesn't exist on master any more so I tryied to change it to the register-bin.001, position 1 and it didn't helped is there a possibility to start this replication ? or I must take a snap of master and start again from begin ? Jan Matis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL problems on OpenBSD?
Running the standard (brand-new) OpenBSD install of MySQL from /usr/ports/databases/mysql/ Version 3.23.32 - the port that Brad made just a few days ago. No options. Just "make install". It works fine exceptI keep getting this error: ERROR 2006: MySQL server has gone away It comes back immediately (1 second later), but still it worries me. Before I put this OpenBSD/MySQL server live to our high-traffic site, I thought I should ask the OpenBSD and MySQL lists: Ever heard of this error? Know what might cause it, or fix it? Is it *BSD-specific? (The only mention of it I see in old old MySQL list archives always seems to be on a *BSD server.) I'm on the newest OpenBSD 2.8 with all current patches, freshly installed this week. Nothing but the newest Apache, MySQL, and PHP on the server. Though we can't blame Apache or PHP, because I was getting this error in MySQL command-line mode. [If I need to report a bug, let me know. A "bug-reporting URL" would be nice, since I'm a kinda-newbie and never reported a bug before.] Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication won't start
On the slave err log I have: 010128 11:04:28 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010128 11:04:28 Slave: reconnected to master 'repl@glenastle:3306',replication resumed in log 'FIRST' at position 4 010128 11:04:28 Slave: received 0 length packet from server, apparent master shutdown: (0) The master hasn't shutdown and seems quite happy 010128 11:04:17 21 Connect[EMAIL PROTECTED] on 22 Connect[EMAIL PROTECTED] on 21 Binlog Dum 22 Quit Where do I start? Thanks, Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL problems on OpenBSD?
You might take a look at my message about MySQL 3.23.32 and FreeBSD 4.2-stable try doing what i did there. I did it only yersterday but so far not sig 11. Me message is posted yersterday and it has FreeBSD 4.2-stable in the subject and it is from me (Artem Koutchine). Search for it. - Original Message - From: "Derek Sivers" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 2:09 PM Subject: MySQL problems on OpenBSD? Running the standard (brand-new) OpenBSD install of MySQL from /usr/ports/databases/mysql/ Version 3.23.32 - the port that Brad made just a few days ago. No options. Just "make install". It works fine exceptI keep getting this error: ERROR 2006: MySQL server has gone away It comes back immediately (1 second later), but still it worries me. Before I put this OpenBSD/MySQL server live to our high-traffic site, I thought I should ask the OpenBSD and MySQL lists: Ever heard of this error? Know what might cause it, or fix it? Is it *BSD-specific? (The only mention of it I see in old old MySQL list archives always seems to be on a *BSD server.) I'm on the newest OpenBSD 2.8 with all current patches, freshly installed this week. Nothing but the newest Apache, MySQL, and PHP on the server. Though we can't blame Apache or PHP, because I was getting this error in MySQL command-line mode. [If I need to report a bug, let me know. A "bug-reporting URL" would be nice, since I'm a kinda-newbie and never reported a bug before.] Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to avoid ERROR :1045
Dear Sir, Hello, We have installed MySql in Windows NT Server. MysqlAdmin services are doing fine and but when we try to enter the prompt of mysql.we are getting the follwing error ERROR :1045 Access denied for user 'odbc@localhost )using password yes port is:3306 and user is :root How to rectify this. Anticipating promptly, Thanking you, __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to avoid ERROR :1045
i don't know exactly, but based on the message it seems to be a permission problem in the mysql rights. So, RTFM on the mysql permission model and commands. - Original Message - From: "Velamarthy Murthy" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 3:08 PM Subject: How to avoid ERROR :1045 Dear Sir, Hello, We have installed MySql in Windows NT Server. MysqlAdmin services are doing fine and but when we try to enter the prompt of mysql.we are getting the follwing error ERROR :1045 Access denied for user 'odbc@localhost )using password yes port is:3306 and user is :root How to rectify this. Anticipating promptly, Thanking you, __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Start from scratch
Why not just reinit the database as specified in the last step on install (after make install) in the manual. No need to delete your database, just back them up somewhere else. Then delete eveyrthing in your localstatedir (where thedatabases are) including 'mysql' dir. Do reinit, and copy back all databases except the 'mysql' database. Now you are at the original start position. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:17 PM Subject: Start from scratch Hello all I have made a mess of the grant table and have no way now of gaining access to any of the databases I have set up or tables. Is there any way I can start from scratch with the grant table by going back to a situation were all databases are deleted and no access privileges are set up. is it nessassary to reinstall mysql to achieve this or is there another way. I am running debian potato. If I do need to reinstall how do I completely UN install first. Many thanks in advance John-Mark -- John-Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Wierd mysqlgui problem
David Wilde writes:
Hello All,
I am new to MySQL and I am sure you have all heard this question a million
times, so I appologize in advance. My question is, I have installed MySQL
on a slackware 7.1 box, as well as a SuSE 7.0 box, and both seem to be
running fine with one minor exception. When using mysqlgui from a windows
machine I get the error "Error in database function: Access Denied for user:
'[EMAIL PROTECTED]" (Using password: YES)" I have added the username to
the mysql database using the command "GRANT ALL ON *.* TO user@"%"
IDENTIFIED BY "password" WITH GRANT OPTION" and have also added the
[EMAIL PROTECTED] and removed all of the anonymous entries (just in case).
Since I am new to this I am not sure what I am doing wrong. The user can
create databases and tables using the mysql command on the linux box.
Thanks in advance for the help.
Hi!
As you have a password set for that user, you should enable "Ask for
password" button in Options page, so that you can enter password.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Start from scratch
OK I get what you mean except that I installed on debian potato and therefore do not have the reinit step since I used apt-get. Do you have any ideas on this one. Thanks again jm - Original Message - From: "Artem Koutchine" [EMAIL PROTECTED] To: "John-Mark" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 1:35 PM Subject: Re: Start from scratch Why not just reinit the database as specified in the last step on install (after make install) in the manual. No need to delete your database, just back them up somewhere else. Then delete eveyrthing in your localstatedir (where thedatabases are) including 'mysql' dir. Do reinit, and copy back all databases except the 'mysql' database. Now you are at the original start position. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:17 PM Subject: Start from scratch Hello all I have made a mess of the grant table and have no way now of gaining access to any of the databases I have set up or tables. Is there any way I can start from scratch with the grant table by going back to a situation were all databases are deleted and no access privileges are set up. is it nessassary to reinstall mysql to achieve this or is there another way. I am running debian potato. If I do need to reinstall how do I completely UN install first. Many thanks in advance John-Mark -- John-Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Start from scratch
I have no idea what 'apt-get' is. MySQL, IMHO, should always be installed from the sources by compiling by hands. Get the sources and learn to install it correctly. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: "Artem Koutchine" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:56 PM Subject: Re: Start from scratch OK I get what you mean except that I installed on debian potato and therefore do not have the reinit step since I used apt-get. Do you have any ideas on this one. Thanks again jm - Original Message - From: "Artem Koutchine" [EMAIL PROTECTED] To: "John-Mark" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 1:35 PM Subject: Re: Start from scratch Why not just reinit the database as specified in the last step on install (after make install) in the manual. No need to delete your database, just back them up somewhere else. Then delete eveyrthing in your localstatedir (where thedatabases are) including 'mysql' dir. Do reinit, and copy back all databases except the 'mysql' database. Now you are at the original start position. - Original Message - From: "John-Mark" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 28, 2001 4:17 PM Subject: Start from scratch Hello all I have made a mess of the grant table and have no way now of gaining access to any of the databases I have set up or tables. Is there any way I can start from scratch with the grant table by going back to a situation were all databases are deleted and no access privileges are set up. is it nessassary to reinstall mysql to achieve this or is there another way. I am running debian potato. If I do need to reinstall how do I completely UN install first. Many thanks in advance John-Mark -- John-Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SSL - is it there?
Hello I realised several SSL keywords in the Makefiles but cannot find a way to activate SSL/TLS via ./configure. Did I miss something or is there no SSL support implemented yet? Can I expect it for the future? (Would be great!) bye, -christian- -- Save the forests, eat more beavers! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL problems on OpenBSD?
Unfortunately, the OpenBSD threads library has been known to be problematic at the moment, try using MySQL with the Pth threads library in the meantime. This can be automated quite easily by using the pth FLAVOR of the MySQL port. "make FLAVOR=pth install". // Brad [EMAIL PROTECTED] [EMAIL PROTECTED] Running the standard (brand-new) OpenBSD install of MySQL from /usr/ports/databases/mysql/ Version 3.23.32 - the port that Brad made just a few days ago. No options. Just "make install". It works fine exceptI keep getting this error: ERROR 2006: MySQL server has gone away It comes back immediately (1 second later), but still it worries me. Before I put this OpenBSD/MySQL server live to our high-traffic site, I thought I should ask the OpenBSD and MySQL lists: Ever heard of this error? Know what might cause it, or fix it? Is it *BSD-specific? (The only mention of it I see in old old MySQL list archives always seems to be on a *BSD server.) I'm on the newest OpenBSD 2.8 with all current patches, freshly installed this week. Nothing but the newest Apache, MySQL, and PHP on the server. Though we can't blame Apache or PHP, because I was getting this error in MySQL command-line mode. [If I need to report a bug, let me know. A "bug-reporting URL" would be nice, since I'm a kinda-newbie and never reported a bug before.] Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: simple problem with mysql install
I posted the solution a couple of nights ago. The mysql folder and some of the files within have the owner set to root. You need to change that to mysql. From: anthony ortega [EMAIL PROTECTED] Date: 27 Jan 2001 22:46:25 -0800 To: [EMAIL PROTECTED] Subject: simple problem with mysql install I recently upgraded to linux 7.0 which comes with mysql. Everytime that i try and start the mysql server it starts up then stops. when I try the mysql -user command it gives me a cant connect to mysql.sock error. any idea what is going wrong? Anthony Ortega (512)444-6238 6700 B. Deatonhill Austin Tx, 78745 Find the best deals on the web at AltaVista Shopping! http://www.shopping.altavista.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB and MySQL Example Request
Good Evening! I've been working with VB and MySQL for awhile now, but not together. I've used VB to use the built in database that comes with VB, but I doubt I'm using it to its full potential. I like the way PHP and MySQL interface, very naturally actually. I was hoping that I could take my knowledge of MySQL to use it with VB. I've been looking through documentation and archives tonight, and I've gotten the general idea, but I would really love an example. Can anyone share, or point me at, a great example of using VB to access MySQL and using the data. Any help is appreciated in advance. Jon === The lack of humility before nature thats being displayed here staggers me. === /Jon
really really new
and dumb too! if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i manipulate MySQL? if you say "RTFM" -where is that? or a site perhaps? thank you. (seems kind of broad for a list archive search.) p.s. i know there are front-end GUIs available, which do you folks recommend? (OS X pb.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: really really new
there is the mysql command-line client, it's under bin under the mysql base directory, it's called mysql on UNIX and mysql.exe on win32 :-) command line all the way! On Sun, 28 Jan 2001 [EMAIL PROTECTED] wrote: and dumb too! if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i manipulate MySQL? if you say "RTFM" -where is that? or a site perhaps? thank you. (seems kind of broad for a list archive search.) p.s. i know there are front-end GUIs available, which do you folks recommend? (OS X pb.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and GUI or CLI, was: really really new
can one 'get in' and control MySQL through OS X pb's Terminal app? (various Unix shells.) i think i need a GUI to start though, don't you? At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote: there is the mysql command-line client, it's under bin under the mysql base directory, it's called mysql on UNIX and mysql.exe on win32 :-) command line all the way! On Sun, 28 Jan 2001 [EMAIL PROTECTED] wrote: and dumb too! if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i manipulate MySQL? if you say "RTFM" -where is that? or a site perhaps? thank you. (seems kind of broad for a list archive search.) p.s. i know there are front-end GUIs available, which do you folks recommend? (OS X pb.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and GUI or CLI, was: really really new
no I started with the command line client and you don't need a shell, if you have the client you can connect to remote mySQL servers if they allow outside connections On Sun, 28 Jan 2001 [EMAIL PROTECTED] wrote: can one 'get in' and control MySQL through OS X pb's Terminal app? (various Unix shells.) i think i need a GUI to start though, don't you? At 11:48 AM -0700 1/28/01, Andrei Cojocaru wrote: there is the mysql command-line client, it's under bin under the mysql base directory, it's called mysql on UNIX and mysql.exe on win32 :-) command line all the way! On Sun, 28 Jan 2001 [EMAIL PROTECTED] wrote: and dumb too! if(?) there is no app to launch, i.e., no GUI (Mac OS Xpb) -how do i manipulate MySQL? if you say "RTFM" -where is that? or a site perhaps? thank you. (seems kind of broad for a list archive search.) p.s. i know there are front-end GUIs available, which do you folks recommend? (OS X pb.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -Spinlock EmpireQuest Creator http://www.empirequest.com -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
needed: smart SQL statement
Hello smart people, Here's the situation: table: books |BookNumber |Author|Title | | ... | || | 312 |'TWAIN, MARK' |'Huckleberry Finn' | | ... | || The books table consists of more than 1 million records, so wildcard searches are very slow. To speed up searches for any appearing words, I've created a dictionary containing all occuring words: table: words - |WordNumber |Word | - | ... | | | 457 | 'Finn'| | ... | | | another table lists which words occur in which books: table: wordlinks -- |WordNumber |BookNumber | -- | ...| | | 457| 312 | | ...| | |- The table wordlinks contains 30 million records (!) All nessesary fields are indexed. When I search for a title or a couple of keywords, a search is done in the words table to retrieve the associated WordNumber values. Secondly, these WordNumber values are searched in the wordlinks table, and the associated BookNumber values are retrieved. Only the BookNumber values which appear for each searched word are retrieved. Thirdly, the books are then located by BookNumber and displayed in a search result. My question is: Is this three stage action possible with one SQL statement? Any help is much appreciated. Thanks! Jelle Samshuijzen Rockingstone Information Technology http://www.rockingstone.com http://www.boekenvondst.nl http://www.nvva.nl http://www.ilab-lila.com http://www.interstad.nl [EMAIL PROTECTED] Tel. 0317-425550 Bergstraat 18a 6701 AD Wageningen the Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: needed: smart SQL statement
Here's the situation: table: books |BookNumber |Author|Title | | ... | || | 312 |'TWAIN, MARK' |'Huckleberry Finn' | | ... | || cut table: words - |WordNumber |Word | - | ... | | | 457 | 'Finn'| | ... | | | cut table: wordlinks -- |WordNumber |BookNumber | -- | ...| | | 457| 312 | | ...| | |- cut When I search for a title or a couple of keywords, a search is done in the words table to retrieve the associated WordNumber values. Secondly, these WordNumber values are searched in the wordlinks table, and the associated BookNumber values are retrieved. Only the BookNumber values which appear for each searched word are retrieved. Thirdly, the books are then located by BookNumber and displayed in a search result. My question is: Is this three stage action possible with one SQL statement? I would try something like: SELECT DISTINCT books.* FROM books, words, wordlinks WHERE (books.BookNumber = wordlinks.BookNumber) AND (wordlinks.WordNumber = words.WordNumber) AND ( (words.Word = 'word1') OR (words.Word = 'word2') OR ... ) / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: needed: smart SQL statement
Hello smart people,
My question is:
Is this three stage action possible with one SQL statement?
Yes you can do a query like:
select books.title from
words as w1,words as w2, wordlinks as v1,wordlinks as v2,books
WHERE (w1.WordNumber =v1.WordNumber ) AND (w2.WordNumber =v2.WordNumber
)
AND (books.BookNumber = v1.BookNumber ) AND
(titel.BookNumber=v2.BookNumber)
AND (w1.word = 'Finn') AND w2.word = 'Huckleberry';
As you see the query get complexer with every word you add. In my
expirience the query gets very slow if you ask for more then 6 words. So
i restrict my searches to not more than 6 words. It depends how often a
word is mentioned in the wordlinks table, if you hit two words or more
words with many rows in wordlinks, the query becomes slow. So it also
depends on how good you filter out the noise words in your database, and
also in your query
In my application i check the number of links a word has before, and if
it is more then 2000 i delete the word from the search. (my words as a
column count, which holds the number of wordlinks it is in)
Because of this i use in some applications the fulltext index of mysql:
SELECT
DISTINCT books.title from titel";
WHERE match(titel) against ('huckelberry finn')";
But fulltext index behaves different than the reverse index. The major
thing is that it only indexes words longer than 3 Characters. So if you
search for "Lee" you would get no result (see
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html )
---
Wim Bonis ,+'^'+, Telefon:0631-31662-0
Internet Solution Service GmbH Technik:0631-31662-15
+,.,+ privat:0631-36071-80
email: [EMAIL PROTECTED] 67655 Kaiserslautern
Karl-Marx-Str. 13 --== DPN-POP KL ==--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changes in 3.23.3x
Where can I see a list of changes that were made in 3.23.3x versions of mySQL? -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index text without Match/against
Your TEXT does not appear to be defined as a fixed-length variable. As I understand it, you can't index and search on a variable-length TEXT field. On 28 Jan 2001, at 21:46, Richard Heyes wrote: Hi, Having trouble with indexing TEXT column types, for the purpose of a basic search engine (without match/against). I've got the following table structures, the second being the index table containing an entry for each word in the TEXT (from the first table), minus stop-list type words. The column in the second is an int as I'm md5()ing the word, taking the first 8 chars and converting from hex to decimal, (faster?). CREATE TABLE articles ( article_id smallint(5) unsigned NOT NULL auto_increment, article_text text NOT NULL, PRIMARY KEY (article_id) ) TYPE=MyISAM; CREATE TABLE articles_word_index ( article_id smallint(5) unsigned NOT NULL default '0', word int(11) NOT NULL default '0', KEY article_id_idx (article_id), KEY word_idx (word) ) TYPE=MyISAM; Problem is, using this table structure and the following sort of query: SELECT DISTINCT a.article_id, article_text, COUNT(a.article_id) AS hits FROM articles a, articles_word_index b WHERE a.article_id = b.article_id AND b.word = 12345789 GROUP BY a.article_id Is turning out to be about 3 times slower than a LIKE based query like so: SELECT article_text FROM articles WHERE article_text LIKE '%protocol%' Am I missing something? Or is it due to my limited dataset (~20 articles in the TEXT field, indexing ~15,000 words). Ie. if the dataset was scaled up to 1000s would the join still be as slow? Cheers! -- (A rather drunken) Richard Heyes http://www.heyes-computing.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changes in 3.23.3x
On Sun, Jan 28, 2001 at 02:59:21PM -0700, Andrei Cojocaru wrote: Where can I see a list of changes that were made in 3.23.3x versions of mySQL? They are listed in the manual. Check the table of contents. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3 million+ records problems.
Are you sure that your select is in fact using the index on that column? Could you please explain select for us. John Jensen wrote: To: "Scott Gerhardt" [EMAIL PROTECTED] From what I have heard from a local guru. you shoud double that again. I had mysql working fine on 150 meg for development purposes, but I was warned that as soon it had to support any kind of traffic, anything less than 500 meg would be quickly maxed out. Anybody else got feedback on this? On 27 Jan 2001, at 12:46, Scott Gerhardt wrote: Adding another 192megs of ram or so would really boost performance. When I increased the RAM on my PIII 450Mhz from 128 to 256Mb, performance almost doubled for most queries on a 72k record table. From a mysqldump: # # Table structure for table 'names' # CREATE TABLE names ( id int(10) unsigned DEFAULT '0' NOT NULL, name varchar(80) DEFAULT '' NOT NULL, KEY id (id) ); The machine is an Intel Celeron 533Mhz, with 64 mb of RAM, with dual 10 GB EIDE hard drives (doing RAID), running FreeBSD 3.4-Release. Artem Koutchine wrote: Well then, be so kind and tell us your index configuration and your hardware configuration. - Original Message - From: "Manuel Capinha" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, January 27, 2001 9:10 PM Subject: 3 million+ records problems. Hi! I've got a table with 3 million+ records. This table has only to columns: an int and a varchar(80). I need to periodically execute a statement like: "SELECT id,count(*) FROM names GROUP bY id", which takes very long time to end. I'm using perl (DBI) to access this table. When I do a select by id (SELECT name FROM names WHERE id=1) it hangs forever for very large results (1million). I'm running mysql 3.22.29 on FreeBSD 3.4. Would an upgrade to the latest 3.23 help ? Would an upgrade to FreeBSD 4 or maybe Linux help ? The id column is indexed, but i believe this is A Good Thing(tm). I've checked past messages of this mailing list and i couldn't find anything that seemed relevant to my case. Can anyone give me some suggestions to speed things up ? Thanks in advance. Manuel Capinha, who as just seen his weekend ruined. -- -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using MySQL for web authentication and others..
I just want to ask a quick question which is probably only indirectly related to this group. Where can I find some useful info on how to integrate MySQL into Apache authentication scheme? Basically, I want to use MySQL database to store users' ids and passwords rather than .htpasswd file generated by Apache's htpasswd program. Thanks. -- Bolek, URL: http://www.bolek.com URL: http://slash.bolek.com e-mail: [EMAIL PROTECTED] ICQ: 4086197, Address: 402905326 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: select-Problem
so you want to list all of them starting with the highest level and going up to the lowest level? On Mon, 29 Jan 2001, Oliver Joa wrote: Hi, I have a recursive Problem. I have a Table with columns "id", "name" and "pid". E.g: name1 name11 name12 name121 name122 name13 name2 name21 In the Table it would look like: id, name, pid 1 name1 0 2 name11 1 3 name12 1 4 name121 3 5 name122 3 6 name13 1 7 name2 0 8 name21 7 Is there any select statement, which give me the path e.g to the id 5? I want to provide the 5 and will get the following: id5 (pid3) - id3 (pid1) - id1 (pid0) name122 - name12 - name1 Do you have any idea? Oliver -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
seeing I cannot send the whole file...
I think I have stuffed up the installation of the MySQL thing. I am trying to get it installed onto a Debian box and am not having alot of luck :o| http://www.scanners.8m.com/config.html Any help would be appreciated, Cheers Dan Clark Information Systems System Support HealthCare Otago 5046 8450 (025) 336 296 ## Attention: This e-mail is privileged and confidential. If you are not the intended recipient please delete the message and notify the sender. Any views or opinions presented are solely those of the author. ## - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changes in 3.23.3x
Hello there, We have a number of Sun sparcs connected to 2 NetApp file servers, and are currently using 1 sparc running mysql with the databases residing on one of the NetApps. I would like to run a 2nd sparc mysql server, also serving the same databases (read-only) from the same NetApp. Is this possible using replication without duplicating the databases in seperate directories (ie. /usr/local/mysql/hostname/var/*)? Thanks. Bob Cottrell [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dual servers on one NetApp
Hello there, We have a number of Sun sparcs connected to 2 NetApp file servers, and are currently using 1 sparc running mysql with the databases residing on one of the NetApps. I would like to run a 2nd sparc mysql server, also serving the same databases (read-only) from the same NetApp. Is this possible using replication without duplicating the databases in seperate directories (ie. /usr/local/mysql/hostname/var/*)? Thanks. Bob Cottrell [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert problem in MYSQL with PHP
On Wed, 24 Jan 2001, Xinkun Wang wrote: | |I've got a problem about Mysql table. if I insert several records in a |certain order, firstly it is ok, but when I delete them and insert those |records again (in the same sequence), But the order in MySql is totally |different. For instance, I have 78 records, when I do insert |secondly, it dispalys 58th record firstly and others in reverse order. |Anybody know why? (I use PHP script) Depends on what way you have set up your script. -- === Adrian D'Costa [EMAIL PROTECTED] www.pcsadvt.com === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql++ and first tutorial example
HI I am trying to install mysql++. I did automake, autoconf ./configure, make and make install. When I add this row in kdevelopp / C++ #include sqlplus.hh this message appears: "In file inclued from /usr/local/include/sqlplus.hh:9, from main.cpp:24: /usr/local/include/defs:5: mysql.h: No folder or directory in this type" What can I do??? Thanks a lot Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
