Re: open source shema relationship diagram tool
none of these are open source and its under windows http://www.minq.se/products/dbvis/images/screens/graph.html this is what i want to do , except its on myisam tables not inondb so there is no foreign key relations i join them in the query or can i still do this ? Hi Daniel, The question was asked many times within the last 24 hours. look for these threats - Open-Source/Freeware Tool To Generate ER Diagrams From SQL Sc ripts ? - ImportER (ER Tool: Dezign) - mysql GUIs - www.datanamic.com/download/index.html www.minq.se (DbVisualizer -c harting software included) (any OS) www.lysator.liu.se/~alla/dia/ Best regards Nils Valentin Tokyo/Japan 2003年 6月 13日 金曜日 11:17、Daniel Rossi さんは書きました: hi there i was wondering if there was a table relationship diagram open source tool around anywhere ? i am trying to document a project at the moment please let me know thanks. -- --- 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]
tables locked during connection failure processes not auto killed after timeout
Am I missing a configuration setting somewhere? I have been working on a MySQL Max (3.23.52-max-nt) database running on W2K Server. I am using a MySQL client remotely over a VPN but unfortunately the client's internet connection is severely overloaded and the connection dies on occasion. When this occurs the server process responsible for servicing the connection lingers around forever and if this occurs during an update there are table locks that also linger forever. I have set the following variables in my.cnf and restarted the server to have the server auto kill processes/connections after 60 seconds of inactivity. I have confirmed the variable settings after the server restart with SHOW VARIABLES wait_timeout=60 (seconds) interactive_timeout=60 (seconds) BUT the server never KILLS the processes! Even when the SHOW PROCESSLIST command indicates that the process has been around for 3000+ seconds. Way longer than the timeout values. Am I missing some variable or command line setting to enable the server to auto KILL processes? ** Reproduce as follows... 1) Configure server for short timeouts in my.cnf and restart server set-variable= wait_timeout=60 set-variable= interactive_timeout=60 2) Start and connect a MySQL client to the server OVER A NETWORK LINK 3) Run the STATUS command to find your connection/process id so you know which process to watch in step 8 4) Disconnect your network cable 5) Stop the MySQL client (so the server can't see the client shutdown, same as if VPN hangs) 6) Reconnect the network cable 7) Start and connect a new MySQL client to the server 8) Run SHOW PROCESSLIST and watch the entry for your previous process id, it never goes away! and its time just keeps incrementing. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: open source shema relationship diagram tool
Hi Daniel, sorry for mistaken your request. So I guess you are a developer and want to modify and create your own source code ? 2003 6 13 15:[EMAIL PROTECTED] : none of these are open source and its under windows http://www.minq.se/products/dbvis/images/screens/graph.html this is what i want to do , except its on myisam tables not inondb so there is no foreign key relations i join them in the query or can i still do this ? Nope , works only for foreign key relations (yet) - it will change in future versions. (This point was discussed with Minq) Hi Daniel, The question was asked many times within the last 24 hours. look for these threats - Open-Source/Freeware Tool To Generate ER Diagrams From SQL Sc ripts ? - ImportER (ER Tool: Dezign) - mysql GUIs - www.datanamic.com/download/index.html O.K this one runs only on Windows, my mistake;-( www.minq.se (DbVisualizer -c harting software included) (any OS) O.K They are not open source but offer a free version with only a few options disabled. They run on almost any OS - please see the download page - they run on Mac, Windows and several Linux,Unix version - so that can't be too bad can it ? www.lysator.liu.se/~alla/dia/ I was unaware that windows is running under GPL and with GTK ;-) Taken from their homepage: ..Welcome to Dia's homepage. Dia is a gtk+ based diagram creation program released under the GPL license. Best regards Nils Valentin Tokyo/Japan Best regards Nils Valentin Tokyo/Japan 2003 6 13 11:17Daniel Rossi : hi there i was wondering if there was a table relationship diagram open source tool around anywhere ? i am trying to document a project at the moment please let me know thanks. -- --- 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]
Help please
Hi people. Installing MySQL 3.23.54 under Windows 2000 (according to instructions in Next handbook 'Introduction to MySQL.', and from CD attached to book) Installing MySQL - worked fine. Starting the Server c:\mysql\bin\mysqld-nt - worked fine. Running the MySQL command line interface c:\mysql\bin\mysql - fails with message ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Have installed / uninstalled / tried several times, always fails at this point. Can you assist please? Thanks very much, Huw Parker -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MODBC compoent
Hello, I develop with C++Builder 5 and 6. I replaced BDE by MODBC component. It was working fine with MySQL 2.5.0. It seems it is no more compatible with version 3. I get the following error : 42000[ODBC 3.51 Driver][You have an error in your SQL syntax near] followed by the beginning of the SELECT clause. Any idea ? Otherwise, does somebody know a free replacement of BDE that works well with MySQL ? Thanks. = Patrick DUMOLEYN CVM S.A. - PARIS Tel. 33 1 43 67 09 03 Fax 33 1 43 67 35 40 mailto:[EMAIL PROTECTED] http://www.cvm.fr =
Spatial Support on MySQL
Hi, I develop applications that about GIS. I am using Oracle Database for our projects. We store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't like Oracle, i want to change my company's database policy. Because Oracle is too complex(in bad mean), expensive, its UI is very bad What am i want? I want to learn more about MySQL Spatial Support for Mapinfo(www.mapinfo.com) Products. Mehmet KADAYIFI GIS Software Specialist
Re: Spatial Support on MySQL
Hi Mehmet, I am not sure excactly what you are looking for as spatial data is quite new for MySQL I believe. How about this info ? http://localhost/xoops/manuals/mysql/en/GIS_spatial_extensions_in_MySQL.html 2003 6 13 17:24Mehmet KADAYIFI : Hi, I develop applications that about GIS. I am using Oracle Database for our projects. We store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't like Oracle, i want to change my company's database policy. Because Oracle is too complex(in bad mean), expensive, its UI is very bad What am i want? I want to learn more about MySQL Spatial Support for Mapinfo(www.mapinfo.com) Products. Mehmet KADAYIFI GIS Software Specialist -- --- 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: Spatial Support on MySQL
Mehmet KADAYIF?I [EMAIL PROTECTED] wrote: I develop applications that about GIS. I am using Oracle Database for our projects. We store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't like Oracle, i want to change my company's database policy. Because Oracle is too complex(in bad mean), expensive, its UI is very bad What am i want? I want to learn more about MySQL Spatial Support for Mapinfo(www.mapinfo.com) Products. MySQL supports spatial data formats only since 4.1 wich is currently alpha. More info about spatial extention you can find in the manual: http://www.mysql.com/doc/en/GIS_spatial_extensions_in_MySQL.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: left join
Fabio Bernardo [EMAIL PROTECTED] wrote: Hi there... I have this situation: table_A table_B id name id name 1 A 1 A 2 B 2 B 3 C If i run this statement : SELECT table_A.* FROM table_A outer join table_B ON table_A.id=table_B.id WHERE table_B.id is null and I got: id name 3C But now i wanna use i join which i dont know, to results: idname 1 A 2 B I mean the rows which are exactly the same is there a fast type of join to make it? SELECT table_A.* FROM table_A, table_B WHERE table_A.id=table_B.id; -- 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: Weird problem with differences MySQL 3.23.38 und 4.0.12
Axel Tietje [EMAIL PROTECTED] wrote: Hi everyone... I actually have two servers: 1. Server: MySQL 4.0.12 2. Server: MySQL 3.23.38 This query: SELECT o_obj, MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431, MAX(CASE WHEN o_key = '69B96431' THEN o_typ END) AS T_69B96431, MAX(CASE WHEN o_key = 'AA0887CB' THEN o_val END) AS _AA0887CB, MAX(CASE WHEN o_key = 'AA0887CB' THEN o_typ END) AS T_AA0887CB FROM TBL_32BF90B0 WHERE ( (o_key = '69B96431' AND o_val = '01') OR (o_key = 'AA0887CB' AND o_val = '1') ) GROUP BY o_obj HAVING (_69B96431 = '01') shows on server 1 (4.0.12): +--+---++---++ | o_obj| _69B96431 | T_69B96431 | _AA0887CB | T_AA0887CB | +--+---++---++ | 1672BE70 | 01| S | 1 | B | | D27518B1 | 01| S | 1 | B | +--+---++---++ 2 rows in set (0.01 sec) but on server 2 (3.23.38): +--+---++---++ | o_obj| _69B96431 | T_69B96431 | _AA0887CB | T_AA0887CB | +--+---++---++ | 1672BE70 | 01| S | NULL | NULL | | D27518B1 | 01| S | NULL | NULL | +--+---++---++ Please note the differences in fourth and fifth column while having absolutely identical tables and data. The following query works on 1. Server (4.0.12), but not on 2. Server (3.23.38): [skip] 3.23.38 was released about 2,5 years ago. Since that time many bugs were fixed. No wonder that query doesn't work on 3.23.38. -- 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: Installation: mysqladmin and mysqlshow missing
John Telford [EMAIL PROTECTED] wrote: I have had a problem with my install of MySQL on Rehat7.0 and I wonder if anyone has any advice. Here is what I have done. 1. When I installed RedHat, I installed the MySQL libraries from the RedHat CD. I think it was version 3.23 2. I installed the shared compat lib using rpm 3. I upgraded to version 4.0 using RPM I do have some of the scripts and the daemon, but I don't have any /usr/local/mysql directory. Do I need to just start completely from scratch? If so what would be the best approach. Any help anyone could provide would be appreciated. If more information is needed, please let me know. Thanks. You don't have /usr/local/mysql because you install MySQL server using RPM. Did you install only shared libraries? If you want to use mysqladmin and mysqlshow as mentioned in the subject, you need to install client package, too. -- 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: Spatial Support on MySQL
Hi Mehmet, Sorry I send you the worng link. Try this one please http://www.mysql.com/doc/en/GIS_spatial_extensions_in_MySQL.html Best regards 2003 6 13 17:24Mehmet KADAYIFI : Hi, I develop applications that about GIS. I am using Oracle Database for our projects. We store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't like Oracle, i want to change my company's database policy. Because Oracle is too complex(in bad mean), expensive, its UI is very bad What am i want? I want to learn more about MySQL Spatial Support for Mapinfo(www.mapinfo.com) Products. Mehmet KADAYIFI GIS Software Specialist -- --- 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]
Replication troubles
I thought I had most things figured out for our challenging replication setup. However this morning we have a failure I can't figure out... Here are the errors: 030613 5:13:50 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'binary-log.035' at position 11496356 030613 5:13:50 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 030613 5:13:50 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log 030613 5:13:50 Slave I/O thread exiting, read up to log 'binary-log.035', position 11496356 In the case of both the master and the slave the max_allowed_packet is set to 1047552. In both cases I raised it to 2047552 just to be generous. Same failure. I can stop and start this slave as it's not in live production, I can't stop and start the master which feeds live discussion boards. Any ideas? Best Regards, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication problems
That got me greping through my Master's log and I came accross the following : Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (server_errno=65535) This seems to have happened in the date ranges where replication was failing. I cant confirm it is related but is it possible this would cause replication to fail on the server ? Also a new table is created every day therefore a single failure cant have been the reason for replication failure over a period of time. It also brings me to a critical question what do I set as the max_allowed_packet so that I will successfully save all updates to a TEXT field? TEXT fields dont have a size limit so how do I make sure I will never see this error ? Mithun Jeremy Zawodny wrote: I can successfully run the SQL on the slave manually and it obviously has run successfully on the master. Why is that obvious? It's telling you that the slave expected to get an error but didn't. Those expectations come from the master's binlog. I'd repair the table on the master, since it's likely in some sort of trouble. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication troubles
Hi Bruce, I dont know the solution, but error 1236 is a server issue as described below. Starting and stopping the slave wont help anything. Are you sure that the servers binary log is not corrupted ? Try to reset the master. 4.10.7.5 RESET MASTER (master) Deletes all binary logs listed in the index file, resetting the binlog index file to be empty. Previously named FLUSH MASTER . By doing this you eliminate all old master file and start over at FILENAME-bin-001 position 79. Best regards Nils Valentin Tokyo/Japan 2003 6 13 21:23Bruce Dembecki : I thought I had most things figured out for our challenging replication setup. However this morning we have a failure I can't figure out... Here are the errors: 030613 5:13:50 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'binary-log.035' at position 11496356 030613 5:13:50 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 030613 5:13:50 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log 030613 5:13:50 Slave I/O thread exiting, read up to log 'binary-log.035', position 11496356 In the case of both the master and the slave the max_allowed_packet is set to 1047552. In both cases I raised it to 2047552 just to be generous. Same failure. I can stop and start this slave as it's not in live production, I can't stop and start the master which feeds live discussion boards. Any ideas? Best Regards, Bruce -- --- 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: Replication troubles
In the case of both the master and the slave the max_allowed_packet is set to 1047552. In both cases I raised it to 2047552 just to be generous. In order for changes to the max_allowed_packet to take effect, you'll need to restart mysqld on that server. Cheers, Andrew -Original Message- From: Bruce Dembecki [mailto:[EMAIL PROTECTED] Sent: Friday 13 June 2003 13:24 To: [EMAIL PROTECTED] Subject: Replication troubles I thought I had most things figured out for our challenging replication setup. However this morning we have a failure I can't figure out... Here are the errors: 030613 5:13:50 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'binary-log.035' at position 11496356 030613 5:13:50 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 030613 5:13:50 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log 030613 5:13:50 Slave I/O thread exiting, read up to log 'binary-log.035', position 11496356 In the case of both the master and the slave the max_allowed_packet is set to 1047552. In both cases I raised it to 2047552 just to be generous. Same failure. I can stop and start this slave as it's not in live production, I can't stop and start the master which feeds live discussion boards. Any ideas? Best Regards, Bruce -- 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]
Loading Date DATA
I have a question, when loading dates into mysql I have found I can always use MMDD or -MM-DD, but frequently I need to load data from ASCII csv files where the date is M/D/. Currently, I am using perl to read the datafile and insert each record after converting the date data. I would prefer to be able to use 'LOAD FROM INFILE', but the dates do not convert correctly. Is there any way to use the data in M/D/ format? Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or888-638-6963 Fax: 724-489-4386 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Loading Date DATA
Patrick Shoaf [EMAIL PROTECTED] wrote: I have a question, when loading dates into mysql I have found I can always use MMDD or -MM-DD, but frequently I need to load data from ASCII csv files where the date is M/D/. Currently, I am using perl to read the datafile and insert each record after converting the date data. I would prefer to be able to use 'LOAD FROM INFILE', but the dates do not convert correctly. Is there any way to use the data in M/D/ format? Nope, if you want to store as a DATE type. -- 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: Problem with MAX()
Chris Boget [EMAIL PROTECTED] wrote: What's going on with the MAX() function? Why did it return NULL in the first query above. There were no adding/deleting data between the above queries and yet MySQL didn't pull the MAX from the table until I added the AND assets IS NOT NULL to the query. And yet after I ran that query, attempting to run the first query yields the proper results. Is this a bug with MySQL? I wasn't able to repeat it on my test table. Could you provide a test case? Here is what our table looks like: [skip] SELECT MAX(assets) as assets FROM do_deductibles WHERE currency = 'usd' AND assets IS NOT NULL; SELECT MAX(assets) as assets FROM do_deductibles WHERE currency = 'usd'; First SELECT query above returns NULL, the second returns the proper value as does the third. Yup, I was able to repeat it, but this bug is related only to ISAM table. ISAM table is no longer supported. On MyISAM table MAX() works fine. mysql SELECT MAX(assets) as assets FROM do_deductibles WHERE currency = 'usd'; +--+ | assets | +--+ | 1000 | +--+ 1 row in set (0.00 sec) -- 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]
Receive Makefile.in when trying to compile MySql
I receive the following error when trying to compile MySQL 3.23.56 on Solaris 9: config.status: creating readline/Makefile config.status: error: cannot find input file: readline/Makefile.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query error log
Hello. How can I recover query errors done on a mysql server? Is there a log file? It's very important to me to know about this. Thanx so much!!! Lorenzo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
index question
Hello Guys, I have the following table: CREATE TABLE tempo_resposta ( id int(11) NOT NULL auto_increment, idmaquina int(11) NOT NULL default '0', tempo int(11) NOT NULL default '0', horario datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (id) ) TYPE=MyISAM; In this table, I'll be running this query: select tempo,unix_timestamp(now())-unix_timestamp(horario) as diferenca from tempo_resposta where idmaquina=SOMEID order by diferenca desc Right now, seems table is being completly scanned with this query: mysql explain select tempo,unix_timestamp(now())-unix_timestamp(horario) as diferenca from tempo_resposta where idmaquina=23 order by diferenca desc; ++--+---+--+-+--+--+ -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++--+---+--+-+--+--+ -+ | tempo_resposta | ALL | NULL | NULL |NULL | NULL | 9216 | Using where; Using filesort | ++--+---+--+-+--+--+ -+ 1 row in set (0.00 sec) rows=9216, exactly all rows in the table Question: is there a way of creating an index for helping that kind of query ? I've tried creating index on horario, but it doesnt helped. Sincerily, Leonardo Rodrigues -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied
Hi All, I created a user dfn and I granted access to only the database dfn. Now, if I log as dfn user query for SHOW DATABASES, mysql returns me the error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Would anybody know what could be wrong? Thank's Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access denied
Did you GRANT SHOW DATABASES to the user? If not then they will not be able to use the command. The SHOW DATABASES GRANT clause is a new addition. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 8:34 AM To: [EMAIL PROTECTED] Subject: Access denied Hi All, I created a user dfn and I granted access to only the database dfn. Now, if I log as dfn user query for SHOW DATABASES, mysql returns me the error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Would anybody know what could be wrong? Thank's Ronan -- 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: Access denied
Try using [EMAIL PROTECTED] (assuming you're connecting from localhost) to grant permission. I had similar problems and doing that fixed it for me. Steven:) Ronan Lucio wrote: Hi All, I created a user dfn and I granted access to only the database dfn. Now, if I log as dfn user query for SHOW DATABASES, mysql returns me the error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Would anybody know what could be wrong? Thank's Ronan -- ++ Steven Hong [EMAIL PROTECTED] CISSP, RHCE, CCNA, SCNA, SCJP, MCSE, MCSD, MCT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied
Mike, On Fri, 13 Jun 2003 08:38:32 -0600 Mike Hillyer [EMAIL PROTECTED] wrote: Did you GRANT SHOW DATABASES to the user? If not then they will not be able to use the command. The SHOW DATABASES GRANT clause is a new addition. I'm sorry but I don't have experience with MySQL. Actually, I installed PhpMyAdmin in an ISP for the clients manage his/her own database. So, I created the account with the command: GRANT ALL PRIVILEGES ON dfn.* TO [EMAIL PROTECTED] IDENFIED BY 'password'; GRANT ALL PRIVILEGES ON dfn.* TO dfn@% IDENFIED BY 'password'; Now, when I access PhpMyAdmin with user dfn, it shows some errors in the left frame, where should show the client's database (dfn). If I grant SHOW DATADABES to this user, Will he see all databases or just the databases that he has permissions? Thank's Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access denied
GRANT SHOW DATABASES will allow a user to see all databases, whether the user can access them or not. -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 8:56 AM To: Mike Hillyer Cc: [EMAIL PROTECTED] Subject: Re: Access denied Mike, On Fri, 13 Jun 2003 08:38:32 -0600 Mike Hillyer [EMAIL PROTECTED] wrote: Did you GRANT SHOW DATABASES to the user? If not then they will not be able to use the command. The SHOW DATABASES GRANT clause is a new addition. I'm sorry but I don't have experience with MySQL. Actually, I installed PhpMyAdmin in an ISP for the clients manage his/her own database. So, I created the account with the command: GRANT ALL PRIVILEGES ON dfn.* TO [EMAIL PROTECTED] IDENFIED BY 'password'; GRANT ALL PRIVILEGES ON dfn.* TO dfn@% IDENFIED BY 'password'; Now, when I access PhpMyAdmin with user dfn, it shows some errors in the left frame, where should show the client's database (dfn). If I grant SHOW DATADABES to this user, Will he see all databases or just the databases that he has permissions? Thank's Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: index question
Hi, You need to index the column that is used in the where clause try this ALTER TABLE tempo_resposta ADD INDEX idmaquina (idmaquina); HTH Dobromir Velev - Original Message - From: Leonardo Rodrigues Magalhães [EMAIL PROTECTED] To: MySQL ML [EMAIL PROTECTED] Sent: Friday, June 13, 2003 17:21 Subject: index question Hello Guys, I have the following table: CREATE TABLE tempo_resposta ( id int(11) NOT NULL auto_increment, idmaquina int(11) NOT NULL default '0', tempo int(11) NOT NULL default '0', horario datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (id) ) TYPE=MyISAM; In this table, I'll be running this query: select tempo,unix_timestamp(now())-unix_timestamp(horario) as diferenca from tempo_resposta where idmaquina=SOMEID order by diferenca desc Right now, seems table is being completly scanned with this query: mysql explain select tempo,unix_timestamp(now())-unix_timestamp(horario) as diferenca from tempo_resposta where idmaquina=23 order by diferenca desc; ++--+---+--+-+--+--+ -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++--+---+--+-+--+--+ -+ | tempo_resposta | ALL | NULL | NULL |NULL | NULL | 9216 | Using where; Using filesort | ++--+---+--+-+--+--+ -+ 1 row in set (0.00 sec) rows=9216, exactly all rows in the table Question: is there a way of creating an index for helping that kind of query ? I've tried creating index on horario, but it doesnt helped. Sincerily, Leonardo Rodrigues -- 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: index question
Something else to consider here: MySQL can use indexes to optimize order by as well, but your order by value can't be indexed since it is derived from a database lookup/calculation. If you really need to order by diferenca you may have to live with it, although you may still see Using filesort(which would indicate a slower query) in your explain since MySQL may have to make a second pass to sort the order by. Check out: http://www.mysql.com/doc/en/ORDER_BY_optimisation.html http://www.mysql.com/doc/en/MySQL_indexes.html Dobromir Velev [EMAIL PROTECTED] 06/13/03 10:03AM Hi, You need to index the column that is used in the where clause try this ALTER TABLE tempo_resposta ADD INDEX idmaquina (idmaquina); HTH Dobromir Velev - Original Message - From: Leonardo Rodrigues Magalhães [EMAIL PROTECTED] To: MySQL ML [EMAIL PROTECTED] Sent: Friday, June 13, 2003 17:21 Subject: index question Hello Guys, I have the following table: CREATE TABLE tempo_resposta ( id int(11) NOT NULL auto_increment, idmaquina int(11) NOT NULL default '0', tempo int(11) NOT NULL default '0', horario datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (id) ) TYPE=MyISAM; In this table, I'll be running this query: select tempo,unix_timestamp(now())-unix_timestamp(horario) as diferenca from tempo_resposta where idmaquina=SOMEID order by diferenca desc Right now, seems table is being completly scanned with this query: mysql explain select tempo,unix_timestamp(now())-unix_timestamp(horario) as diferenca from tempo_resposta where idmaquina=23 order by diferenca desc; ++--+---+--+-+--+--+ -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++--+---+--+-+--+--+ -+ | tempo_resposta | ALL | NULL | NULL |NULL | NULL | 9216 | Using where; Using filesort | ++--+---+--+-+--+--+ -+ 1 row in set (0.00 sec) rows=9216, exactly all rows in the table Question: is there a way of creating an index for helping that kind of query ? I've tried creating index on horario, but it doesnt helped. Sincerily, Leonardo Rodrigues -- 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]
mysqld_safe process
Hi all, is it ok, that the mysqld_safe process runs under the root account! Shouldn´t that be the mysql account, too? 10317 root 9 0 1060 1060 876 S 0.0 0.0 0:00 mysqld_safe 10359 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld 10361 mysql 8 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld 10362 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld Greetings Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Latest version of MySQL for windows
What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless expressly stated to the contrary, the views expressed in this email are not necessarily the views of National Grid Transco plc or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees make no representation and accept no liability for its accuracy or completeness. This e-mail, and any attachments are strictly confidential and intended for the addressee(s) only. The content may also contain legal, professional or other privileged information. If you are not the intended recipient, please notify the sender immediately and then delete the e-mail and any attachments. You should not disclose, copy or take any action in reliance on this transmission. You may report the matter by calling us on + 44(0) 1455 230999 Please ensure you have adequate virus protection before you open or detach any documents from this transmission. The Group Companies do not accept any liability for viruses. An e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
fulltext searching and query order question
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1-field1,field2,field3
index2-fulltext field4
If I do a select:
select * from table where match(index2)
against ('word1 word2' in boolean mode);
I get a very fast result.
Essentially I want to do the following:
If I do a select field1,field2,field3 from table
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
I can't seem to get it right that the query can return
quickly, as it does a table scan to sort the table,
which takes forever.
How do I get a fulltext search to be able to sort according
to a different field ???
Thanks for all assistance :-)
Regards,
Herbert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: index failure, cannot generate.
The answer is that a fulltext index can only be built on a TEXT field. Even though the mysql documentation describes MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..', they can not be used. On Fri, 2003-06-06 at 09:36, H M Kunzmann wrote: Hi all. I am running RH9.0 with MySQL 4.0.13 I am trying to create a fulltext index on a 1.5GB table with 400 records. Whenever I do a create index (retried this a couple of times), the index size grows to only 8MB before the index completes. When using this index in fulltext searches, the search takes 1.5 Minutes. It seems to me like MySQL fails to generate the index correctly. Is this a bug ? Does anyone know what's going on ? Thanks in advance. Herbert -- Herbert Michael Kunzmann Binary Chaos Magician signature.asc Description: This is a digitally signed message part
Re: REPOST: FULLTEXT searching help needed. Please somebody help.
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote:
Hello All.
I am using Redhat 9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where to look next.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a fulltext index on the table, with
alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out the index size, which is 8,722 KB...
If I do a fulltext search against this table, it takes about
1.5 minutes.
select filename from table2002 where match(data) against ('whatever')
If I do an explain on my query, it confirms that the index is used
+--+-+-++---+---++---+
|table |type |possible_keys|key |key_len|ref|rows|extra |
+--+-+-++---+---++---+
|table2002 |fulltext |data |data| 0| | 1 |using where|
+--+-+-++---+---++---+
I have another table, sized at only about 50MB, which I use the same
query and index on, which takes less than a second to do. One thing I
have noticed, is that the index size on this much smaller table is
larger than the bigger table (about 9MB).
This is a shot in the dark, but it seems to me that the index size is
_way_ too small and as such obviously cannot really help. If this is the
case, how do I increase it ?
Here are some of my mysql settings:
max_sort_length=16M
table_cache=256M
key_buffer=128M
sort_buffer=4M
read_buffer_size=1M
Should I set anything else ?
What can I do to get respectable return times ?
Please lend me a helping hand...
Thanks in advance.
H M Kunzmann
--
Herbert Michael Kunzmann
Binary Chaos Magician
signature.asc
Description: This is a digitally signed message part
RE: fulltext searching and query order question
Have you tried adding force index on your fulltext index?
Something similar to this:
select field1,field2,field3 from table FORCE INDEX(index2)
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: H M Kunzmann [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: fulltext searching and query order question
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1-field1,field2,field3
index2-fulltext field4
If I do a select:
select * from table where match(index2)
against ('word1 word2' in boolean mode);
I get a very fast result.
Essentially I want to do the following:
If I do a select field1,field2,field3 from table
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
I can't seem to get it right that the query can return
quickly, as it does a table scan to sort the table,
which takes forever.
How do I get a fulltext search to be able to sort according
to a different field ???
Thanks for all assistance :-)
Regards,
Herbert
--
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]
Please help me!
Hi!
I am new here and wonder if anyone could help me with a problem in my community.
The adress is http://trashankarna.net/community/default.php
I can't figure this out. I get this message when I choose to read a message in my
outbox/utkorg:
Warning: 1 is not a valid MySQL-Link resource in
C:\apache\htdocs\community\meddelanden\lasaut.php on line 69
I can read the message, anyway.
My lasaut.php looks like this:
?php @session_start();
@$user = $iwcuser;
@$pass = $iwcpass;
if(!$user) {
echo(script language=JavaScript);
echo(self.location.replace('http://trashankarna.net/community/login/ouch.php'));
echo(/script);
}
$open = mysql_connect(localhost, community, tarot);
$info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username =
'$user', $open);
$rad = mysql_fetch_array($info);
if($user == $rad[username] $pass == $rad[password]) { ?
?php // top.inc ?
?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ?
?php // Innehåll ?
table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color:
#00; border-style: solid align=left
tr
td class=menux width=20/td
td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg
src=/community/_media/line.gif vspace=5 height=1 width=100%/td
td class=menux width=10/td
/tr
tr
td class=menux width=10/td
td class=menux width=600 height=200 valign=topspan class=brodtext
a href=/community/meddelanden/skriv.php class=bodylankSkriv ett
e-postmeddelande/a |
a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a |
a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a |
p
?php $open = mysql_connect(localhost, community, tarot);
$db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id');
$rad = mysql_fetch_array ($db);
print $rad[subject];
print | ;
print $rad[datum];
print brbr;
print pre class=body;
print $rad[body];
print /pre;
print Tillbaka till a href=/community/meddelanden/default.php
class=bodylankinkorgen/a;
mysql_close($open);
?
p
?php // bottom.inc ?
?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ?
?php mysql_close($open); ?
?php } ?
My lasa.php looks like this:
?php @session_start();
@$user = $iwcuser;
@$pass = $iwcpass;
if(!$user) {
echo(script language=JavaScript);
echo(self.location.replace('http://trashankarna.net/community/login/ouch.php'));
echo(/script);
}
$open = mysql_connect(localhost, community, tarot);
$info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username =
'$user', $open);
$rad = mysql_fetch_array($info);
if($user == $rad[username] $pass == $rad[password]) { ?
?php // top.inc ?
?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ?
?php // Innehåll ?
table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color:
#00; border-style: solid align=left
tr
td class=menux width=20/td
td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg
src=/community/_media/line.gif vspace=5 height=1 width=100%/td
td class=menux width=10/td
/tr
tr
td class=menux width=10/td
td class=menux width=600 height=200 valign=topspan class=brodtext
a href=/community/meddelanden/skriv.php class=bodylankSkriv ett
e-postmeddelande/a |
a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a |
a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a |
p
?php $open = mysql_connect(localhost, community, tarot);
$db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id');
$rad = mysql_fetch_array ($db);
print $rad[subject];
print | ;
print $rad[datum];
print brbr;
print pre class=body;
print $rad[body];
print /pre;
print Tillbaka till a href=/community/meddelanden/default.php
class=bodylankinkorgen/a;
mysql_close($open);
$open = mysql_connect(localhost, community, tarot);
mysql_db_query(iwepost, UPDATE meddelanden SET last = 'j' WHERE id =
'$id');
?
p
?php // bottom.inc ?
?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ?
?php mysql_close($open); ?
?php } ?
Someone has tried my community from another computer that isn't within the network,
and every seem to work, but not E-post. When they did choose to read a message in the
inbox they got this message:
Warning: MySQL Connection Failed: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) in
C:\apache\htdocs\community\meddelanden\lasa.php on line 43
I have made changes from localhost to my domain http://trashankarna.net in the
httpd.conf file, so this
Re: soft real-time database
What's the client running on? Curtis On Thu, 12 Jun 2003, Chris Webster wrote: Curtis Maurand wrote: I'd write a perl script to pool the device and send the data to the database. Sorry for not being clearer. I can get the data into the database fine. Assuming new values or rows are added once per second, how would a client program go about polling the database to see when a new value was ready? Check # of rows for a column and when it's incremented grab the latest value? --Chris -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Please help me!
As this is really a PHP specific question, you may get a better response on the PHP
general mailing list at http://www.php.net/mailing-lists.php
Anyway, if my limited experience in PHP serves correctly, you may need to call
echo(mysql_error()); near the potentially troublesome code.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Varghonan [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:36 AM
To: [EMAIL PROTECTED]
Subject: Please help me!
Hi!
I am new here and wonder if anyone could help me with a problem in my community.
The adress is http://trashankarna.net/community/default.php
I can't figure this out. I get this message when I choose to read a message in my
outbox/utkorg:
Warning: 1 is not a valid MySQL-Link resource in
C:\apache\htdocs\community\meddelanden\lasaut.php on line 69
I can read the message, anyway.
My lasaut.php looks like this:
?php @session_start();
@$user = $iwcuser;
@$pass = $iwcpass;
if(!$user) {
echo(script language=JavaScript);
echo(self.location.replace('http://trashankarna.net/community/login/ouch.php'));
echo(/script);
}
$open = mysql_connect(localhost, community, tarot);
$info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username =
'$user', $open);
$rad = mysql_fetch_array($info);
if($user == $rad[username] $pass == $rad[password]) { ?
?php // top.inc ?
?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ?
?php // Innehåll ?
table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color:
#00; border-style: solid align=left
tr
td class=menux width=20/td
td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg
src=/community/_media/line.gif vspace=5 height=1 width=100%/td
td class=menux width=10/td
/tr
tr
td class=menux width=10/td
td class=menux width=600 height=200 valign=topspan class=brodtext
a href=/community/meddelanden/skriv.php class=bodylankSkriv ett
e-postmeddelande/a |
a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a |
a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a |
p
?php $open = mysql_connect(localhost, community, tarot);
$db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id');
$rad = mysql_fetch_array ($db);
print $rad[subject];
print | ;
print $rad[datum];
print brbr;
print pre class=body;
print $rad[body];
print /pre;
print Tillbaka till a href=/community/meddelanden/default.php
class=bodylankinkorgen/a;
mysql_close($open);
?
p
?php // bottom.inc ?
?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ?
?php mysql_close($open); ?
?php } ?
My lasa.php looks like this:
?php @session_start();
@$user = $iwcuser;
@$pass = $iwcpass;
if(!$user) {
echo(script language=JavaScript);
echo(self.location.replace('http://trashankarna.net/community/login/ouch.php'));
echo(/script);
}
$open = mysql_connect(localhost, community, tarot);
$info = mysql_db_query(iwcusers, SELECT * FROM users WHERE username =
'$user', $open);
$rad = mysql_fetch_array($info);
if($user == $rad[username] $pass == $rad[password]) { ?
?php // top.inc ?
?php require ('c:\\apache\htdocs\community\_inc\top.inc'); ?
?php // Innehåll ?
table cellpadding=0 cellspacing=0 style=border-width: 1pt; border-color:
#00; border-style: solid align=left
tr
td class=menux width=20/td
td class=menuxbrspan class=rubrikLäs e-postmeddelande/spanbrimg
src=/community/_media/line.gif vspace=5 height=1 width=100%/td
td class=menux width=10/td
/tr
tr
td class=menux width=10/td
td class=menux width=600 height=200 valign=topspan class=brodtext
a href=/community/meddelanden/skriv.php class=bodylankSkriv ett
e-postmeddelande/a |
a href=/community/meddelanden/adressbok.php class=bodylankMin adressbok/a |
a href=/community/meddelanden/mappar.php class=bodylankSkapa mapp/a |
p
?php $open = mysql_connect(localhost, community, tarot);
$db = mysql_db_query(iwepost, SELECT * FROM meddelanden WHERE id = '$id');
$rad = mysql_fetch_array ($db);
print $rad[subject];
print | ;
print $rad[datum];
print brbr;
print pre class=body;
print $rad[body];
print /pre;
print Tillbaka till a href=/community/meddelanden/default.php
class=bodylankinkorgen/a;
mysql_close($open);
$open = mysql_connect(localhost, community, tarot);
mysql_db_query(iwepost, UPDATE meddelanden SET last = 'j' WHERE id =
'$id');
?
p
?php // bottom.inc ?
?php require ('c:\\apache\htdocs\community\_inc\bottom.inc'); ?
?php mysql_close($open);
4.1 not using btree index on heap table on an UPDATE
Any reason why a SELECT which finds no matches returns instantly but an update which has the same where clause takes about 2 secs to return. explain reports that the select is exaninng 10 rows in a 300,000 row table. which is exactly what i am expecting. are there any know issues? -Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld_safe process
At 17:44 +0200 6/13/03, Dingfelder Andy wrote: Hi all, is it ok, that the mysqld_safe process runs under the root account! It should be okay. Shouldn´t that be the mysql account, too? 10317 root 9 0 1060 1060 876 S 0.0 0.0 0:00 mysqld_safe 10359 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld 10361 mysql 8 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld 10362 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld Greetings Andy -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied
Mike, On Fri, 13 Jun 2003 08:59:09 -0600 Mike Hillyer [EMAIL PROTECTED] wrote: GRANT SHOW DATABASES will allow a user to see all databases, whether the user can access them or not. How should I securely grant SHOW DATABASES to an user? GRANT SHOW DATABASES ON mysql.db to [EMAIL PROTECTED]; GRANT SHOW DATABASES ON mysql.db to dfn@%; Is this right? Thank's Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: REPOST: FULLTEXT searching help needed. Please somebody help.
Hi! On Jun 13, H M Kunzmann wrote: The answer is that a fulltext index can only be built on a TEXT field. Even though the mysql documentation describes MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..', they can not be used. No, this is wrong. Any xxxTEXT field can be used in FULLTEXT index. TEXT, MEDIUMTEXT, LONGTEXT, TINYTEXT - they all work. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied
Mike, I forgot to say I'm using mysql-3.23.52 Perhaps, this GRANT option do not work for this version, look: - mysql grant show databases to dfn@%; ERROR 1064: You have an error in your SQL syntax near 'show databases to dfn@%' at line 1 mysql grant show databases on mysql.* dfn@%; ERROR 1064: You have an error in your SQL syntax near 'show databases on mysql.* dfn@%' at line 1 - Looking for the command syntax in the MySQL manual, it allows the follow options: - ALL PRIVILEGES FILERELOAD ALTER INDEX SELECT CREATE INSERT SHUTDOWN DELETE PROCESS UPDATE DROPREFERENCES USAGE - Do you have any idea about what could be wrong? Thank's again, Ronan On Fri, 13 Jun 2003 11:07:24 -0600 Mike Hillyer [EMAIL PROTECTED] wrote: I find the @localhost line redundant if you havd a @% line, as the wildcard includes localhost. I think the syntax is GRANT SHOW DATABASES TO dfn@%; But I personally do not use it. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 11:04 AM To: Mike Hillyer Cc: [EMAIL PROTECTED] Subject: Re: Access denied Mike, On Fri, 13 Jun 2003 08:59:09 -0600 Mike Hillyer [EMAIL PROTECTED] wrote: GRANT SHOW DATABASES will allow a user to see all databases, whether the user can access them or not. How should I securely grant SHOW DATABASES to an user? GRANT SHOW DATABASES ON mysql.db to [EMAIL PROTECTED]; GRANT SHOW DATABASES ON mysql.db to dfn@%; Is this right? Thank's Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied
At 14:20 -0300 6/13/03, Ronan Lucio wrote: Mike, I forgot to say I'm using mysql-3.23.52 The SHOW DATABASES privilege is not relevant until MySQL 4.0.2. Perhaps, this GRANT option do not work for this version, look: - mysql grant show databases to dfn@%; ERROR 1064: You have an error in your SQL syntax near 'show databases to dfn@%' at line 1 mysql grant show databases on mysql.* dfn@%; ERROR 1064: You have an error in your SQL syntax near 'show databases on mysql.* dfn@%' at line 1 - Looking for the command syntax in the MySQL manual, it allows the follow options: - ALL PRIVILEGES FILERELOAD ALTER INDEX SELECT CREATE INSERT SHUTDOWN DELETE PROCESS UPDATE DROPREFERENCES USAGE - Do you have any idea about what could be wrong? Thank's again, Ronan On Fri, 13 Jun 2003 11:07:24 -0600 Mike Hillyer [EMAIL PROTECTED] wrote: I find the @localhost line redundant if you havd a @% line, as the wildcard includes localhost. I think the syntax is GRANT SHOW DATABASES TO dfn@%; But I personally do not use it. Regards, Mike Hillyer www.vbmysql.com -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: soft real-time database
Curtis Maurand wrote: What's the client running on? Not the same machine as the server. Could either be a windows or linux box across ethernet. --Chris Curtis Maurand wrote: I'd write a perl script to pool the device and send the data to the database. Sorry for not being clearer. I can get the data into the database fine. Assuming new values or rows are added once per second, how would a client program go about polling the database to see when a new value was ready? Check # of rows for a column and when it's incremented grab the latest value? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: fulltext searching and query order question
I think I need to clarify :
The fulltext indexing searching here works great.
The search completes in good time, but then I want it in a different
order, as described by index1 down below. This resorting step is the one
that takes forever, not the fulltext search.
So essentially, a FORCE INDEX(index1) is more appropriate, but if I do
that, then the order is fast, but the fulltext search takes forever !
On Fri, 2003-06-13 at 18:32, Mike Hillyer wrote:
Have you tried adding force index on your fulltext index?
Something similar to this:
select field1,field2,field3 from table FORCE INDEX(index2)
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: H M Kunzmann [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: fulltext searching and query order question
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1-field1,field2,field3
index2-fulltext field4
If I do a select:
select * from table where match(index2)
against ('word1 word2' in boolean mode);
I get a very fast result.
Essentially I want to do the following:
If I do a select field1,field2,field3 from table
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
order by field1,field2,field3
I can't seem to get it right that the query can return
quickly, as it does a table scan to sort the table,
which takes forever.
How do I get a fulltext search to be able to sort according
to a different field ???
Thanks for all assistance :-)
Regards,
Herbert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP, MySQL and Apache
The httpd.conf connects PHP to Apache. What connects PHP to MySQL? I've looked through google and I can't find anything that makes since to me. Can someone point me in a direction as to where I can find this out? The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46. I have a page that is trying to connect to MySQL via PHP. The error is: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ww3.polkmechanical.com/test/mysql_test.php on line 8 The code on line 8 is: $link = mysql_connect( localhost, user, password ) or die(mysql_error()); I can log on through mysql at a telnet prompt with the database, user and password. Ty... When governments fear the people there is liberty. When the people fear the government there is tyranny. -Thomas Jefferson, third US president, architect and author (1743-1826) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL-Max
I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL-Max
Jon Miller wrote: I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? From the MySQL/downloads page for 4.0: The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. http://www.mysql.com/downloads/mysql-4.0.html --V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL-Max
Since we are on the subject Why is mysql-max(16meg) mysql(25meg) (for x86 v4.1)? No docs or something? -Original Message- From: V. M. Brasseur [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 1:00 PM To: Jon Miller Cc: [EMAIL PROTECTED] Subject: Re: MySQL-Max Jon Miller wrote: I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking that I use MySQL-Max. Does this have to be installed along with the regular MySQL version or is it a single product on it's own? From the MySQL/downloads page for 4.0: The Standard binaries are recommended for most users, and includes the InnoDB storage engine. The Max version includes additional features such as the Berkeley DB storage engine and other features that have not been exhaustively tested or are not required for general usage, such as user-defined functions (UDFs), and BIG_TABLE support. When these features have matured and proven to be stable, they will be incorporated into future releases of the Standard binaries. http://www.mysql.com/downloads/mysql-4.0.html --V -- 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]
Rename/Create Database from Existing Database
Hi 1- Is there a command to rename an existing database ? 2- If not, how does one create a new database from an existing database ? could you show me the steps? Any help is appreciated. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Rename/Create Database from Existing Database
Wong Zach-CHZ013 wrote: Hi 1- Is there a command to rename an existing database ? 2- If not, how does one create a new database from an existing database ? could you show me the steps? Any help is appreciated. Thanks Have you tried the mysqlhotcopy util? http://www.mysql.com/doc/en/mysqlhotcopy.html --V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Why are my sorts so slow?
I'm having a problem with some very slow queries that spend a very long time in the 'Sorting result' state and I'm wondering how sorts are implemented in mysql and what I can do to optimize these types of queries. The query looks something like this: SELECT col1,col2,col3 from table1 where col1 = 0 ORDER BY col2 DESC LIMIT 10; Both col1 and col2 have individual indexes (idx_1, idx_2) Running an EXPLAIN on the query gives me the following information: table: table1 type: ref possible_keys: idx_1 key:idx_1 key_len:4 ref:const rows: 10269 extra: where used; Using filesort I understand that this is retrieving a lot of rows which is slow, but after the rows have been retrieved shouldn't the sort execute very quickly using the index on the sorted column? I notice that the EXPLAIN makes no mention at all of the index on the column being sorted. What is a filesort and what are the different ways that mysql can sort a result set? thanks, --brl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Machine requirements
I think something is definitely wrong with your setup or your query. A query for a count of the number of rows should be almost instantaneous. How are your querying? You should be using: select count(*) from tablename Any other query that you filter on should have a index on the search field. At 3 million rows, nothing is going to be fast without creating indexes. Try to doing an explain before your query to see what MySQL is doing. I develop on a 300Mhz G3 Mac Portable width 384MB RAM, and while slow, nothing as slow as what you are seeing on a far faster system. On Friday, June 13, 2003, at 01:37 PM, blackrat wrote: I've just started using mySql. I'm an experience programmer with SQL based database, but know nothing about mySql. I'm setting up a single user database to be accessed with some Perl programs, with one main table, which will contain about 3 million lines. I'm running on an Athlon 1250 with 384meg ram, and finding the response time too slow. Just getting a count of the number of records by typing in an SQL query [not using Perl] takes over a minute, also when access is going on, I can't do anything else on them machine like access the web, it becomes too slow to be usable. Am I better setting up the database on another computer and accessing it through TCP/IP. I have available a spare machine which is a Celeron 450. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Why are my sorts so slow?
Sorts don't use indexes, for the most part, only the search part does. Someone correct me if I'm wrong on that, I think I recall reading it in SQL for Smarties. The index is on the entire database, not on the subset that you have selected. If you know that your query is going to return most of the database, you may want to use HAVING instead of WHERE. Then the index can be used on the sort and the filter will be applied after the sort. Keep in mind that the index won't be used on the filter then. On Friday, June 13, 2003, at 02:08 PM, Bruce Leidl wrote: I'm having a problem with some very slow queries that spend a very long time in the 'Sorting result' state and I'm wondering how sorts are implemented in mysql and what I can do to optimize these types of queries. The query looks something like this: SELECT col1,col2,col3 from table1 where col1 = 0 ORDER BY col2 DESC LIMIT 10; Both col1 and col2 have individual indexes (idx_1, idx_2) Running an EXPLAIN on the query gives me the following information: table: table1 type: ref possible_keys: idx_1 key:idx_1 key_len:4 ref:const rows: 10269 extra: where used; Using filesort I understand that this is retrieving a lot of rows which is slow, but after the rows have been retrieved shouldn't the sort execute very quickly using the index on the sorted column? I notice that the EXPLAIN makes no mention at all of the index on the column being sorted. What is a filesort and what are the different ways that mysql can sort a result set? thanks, --brl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Machine requirements
MySQL should have no problems running on your system, and if it runs better on another box, that would indicate a configuration problem or background processes clogging up the works. If you post your my.cnf file, someone here might be able to rule out the former. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: blackrat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 13 June, 2003 13:37 Subject: Machine requirements I've just started using mySql. I'm an experience programmer with SQL based database, but know nothing about mySql. I'm setting up a single user database to be accessed with some Perl programs, with one main table, which will contain about 3 million lines. I'm running on an Athlon 1250 with 384meg ram, and finding the response time too slow. Just getting a count of the number of records by typing in an SQL query [not using Perl] takes over a minute, also when access is going on, I can't do anything else on them machine like access the web, it becomes too slow to be usable. Am I better setting up the database on another computer and accessing it through TCP/IP. I have available a spare machine which is a Celeron 450. -- 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: Latest version of MySQL for windows
Losing your mind, perhaps? http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.1%2Fmysql-4 .1.0-alpha.zipmirror=http%3A%2F%2Fmysql.secsup.org%2F Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 13 June, 2003 11:57 Subject: Latest version of MySQL for windows What's the latest version of MySQL for windows? Mysql.com says it's 4.1 alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no version 4.1 available for Windows? Many thanks, rajendra Unless expressly stated to the contrary, the views expressed in this email are not necessarily the views of National Grid Transco plc or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees make no representation and accept no liability for its accuracy or completeness. This e-mail, and any attachments are strictly confidential and intended for the addressee(s) only. The content may also contain legal, professional or other privileged information. If you are not the intended recipient, please notify the sender immediately and then delete the e-mail and any attachments. You should not disclose, copy or take any action in reliance on this transmission. You may report the matter by calling us on + 44(0) 1455 230999 Please ensure you have adequate virus protection before you open or detach any documents from this transmission. The Group Companies do not accept any liability for viruses. An e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. -- 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: Why are my sorts so slow?
MySQL can use indexes to sort, but not when your WHERE clause contains a column other than the one being sorted on. I think the MySQL manual has a good section on what 'filesort' means and when MySQL uses it. Basically it's selecting all the rows that meet your WHERE clause, then running a quicksort algorithm over the results. One thing you can do to speed up this kind of query is reducing the number of rows it has to sort before it can select the last 10, by using a more restrictive WHERE. For example, I had a query very much like this that displayed the last 50 records to be put in the database sorted by time. Since I knew more than 50 records a day came in, I added a 'WHERE Time ' clause to only select records from the last 24 hours. This made a huge difference because it was only selecting a couple hundred records instead of a million or so before doing the sort and throwing away all but the last 50. I don't know if that was clear or not, but what I'm trying to say is, if you can limit the amount of data that matches the WHERE that you're going to be throwing out anyway, do it. :) -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sorts don't use indexes, for the most part, only the search part does. Someone correct me if I'm wrong on that, I think I recall reading it in SQL for Smarties. On Friday, June 13, 2003, at 02:08 PM, Bruce Leidl wrote: I'm having a problem with some very slow queries that spend a very long time in the 'Sorting result' state and I'm wondering how sorts are implemented in mysql and what I can do to optimize these types of queries. The query looks something like this: SELECT col1,col2,col3 from table1 where col1 = 0 ORDER BY col2 DESC LIMIT 10; Both col1 and col2 have individual indexes (idx_1, idx_2) Running an EXPLAIN on the query gives me the following information: table: table1 type: ref possible_keys: idx_1 key:idx_1 key_len:4 ref:const rows: 10269 extra: where used; Using filesort I understand that this is retrieving a lot of rows which is slow, but after the rows have been retrieved shouldn't the sort execute very quickly using the index on the sorted column? I notice that the EXPLAIN makes no mention at all of the index on the column being sorted. What is a filesort and what are the different ways that mysql can sort a result set? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP, MySQL and Apache
If PHP was built without MySQL support, you need to recompile it. It should be in there, though, so check the php.ini file. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Subscriptions [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 13 June, 2003 13:49 Subject: PHP, MySQL and Apache The httpd.conf connects PHP to Apache. What connects PHP to MySQL? I've looked through google and I can't find anything that makes since to me. Can someone point me in a direction as to where I can find this out? The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46. I have a page that is trying to connect to MySQL via PHP. The error is: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ww3.polkmechanical.com/test/mysql_test.php on line 8 The code on line 8 is: $link = mysql_connect( localhost, user, password ) or die(mysql_error()); I can log on through mysql at a telnet prompt with the database, user and password. Ty... When governments fear the people there is liberty. When the people fear the government there is tyranny. -Thomas Jefferson, third US president, architect and author (1743-1826) -- 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: Machine requirements
What table type is this? If it's MyISAM select count(*) should be instantaneous. If it's InnoDb and you've got a large dataset (say 1 million+) then select count(*) will be slow b/c it doesn't store the # of records in the table, thus it has to count records. MyISAM does store the count so it will be much faster. Becoming Digital [EMAIL PROTECTED] 06/13/03 01:49PM MySQL should have no problems running on your system, and if it runs better on another box, that would indicate a configuration problem or background processes clogging up the works. If you post your my.cnf file, someone here might be able to rule out the former. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: blackrat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 13 June, 2003 13:37 Subject: Machine requirements I've just started using mySql. I'm an experience programmer with SQL based database, but know nothing about mySql. I'm setting up a single user database to be accessed with some Perl programs, with one main table, which will contain about 3 million lines. I'm running on an Athlon 1250 with 384meg ram, and finding the response time too slow. Just getting a count of the number of records by typing in an SQL query [not using Perl] takes over a minute, also when access is going on, I can't do anything else on them machine like access the web, it becomes too slow to be usable. Am I better setting up the database on another computer and accessing it through TCP/IP. I have available a spare machine which is a Celeron 450. -- 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]
table creation - arrays ?
table creation - arrays ? how are rows as ARRAYS specified and created on a table ? wbrgds hans _ Die aktuellsten Computer News gibts auf MSN! http://www.msn.at/computer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table creation - arrays ?
Arrays are not currently supported in any production-release versions of MySQL. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Hans Nerdell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, 10 June, 2003 09:25 Subject: table creation - arrays ? table creation - arrays ? how are rows as ARRAYS specified and created on a table ? wbrgds hans _ Die aktuellsten Computer News gibts auf MSN! http://www.msn.at/computer -- 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]
identifying foreign keys
I'm working on a system that will allow me to perform operations on a table using a web form, and I would like to know if a table has a foreign key, however I don't seem to see this information listed in any of the show commands output (or describe). Any idea how I could identify what colums are foreign keys and what they reference without having to tell the code? I use 'describe table' to get most of the information out I need. Oh yes, MySQL 4.0.12 on FreeBSD using INNODB tables. Thanks much. -- Michael Conlen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP, MySQL and Apache
Subscriptions wrote: The httpd.conf connects PHP to Apache. What connects PHP to MySQL? I've looked through google and I can't find anything that makes since to me. Can someone point me in a direction as to where I can find this out? The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46. I have a page that is trying to connect to MySQL via PHP. The error is:# When you install PHP you need to ensure that MySQL support is built in. This is fairly straightforward when building PHP from source, although you may have to tell the PHP build where your MySQL libraries are. Remember that PHP is implemented as an Apache module or 'plug-in', make sure that when Apache starts up, it also knows where the MySQL libraries are.[On Solaris this means setting LD_LIBRARY_PATH suitably.] Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ww3.polkmechanical.com/test/mysql_test.php on line 8 The code on line 8 is: $link = mysql_connect( localhost, user, password ) or die(mysql_error()); I can log on through mysql at a telnet prompt with the database, user and password. Ty... When governments fear the people there is liberty. When the people fear the government there is tyranny. -Thomas Jefferson, third US president, architect and author (1743-1826) -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP, MySQL and Apache
Peter, When you get everything working please let me know how you did it. I have been trying for days without any luck. Regards, Jay ---Original Message--- From: Peter Burden Date: vrijdag 13 juni 2003 22:46:20 To: Subscriptions Cc: [EMAIL PROTECTED] Subject: Re: PHP, MySQL and Apache Subscriptions wrote: The httpd.conf connects PHP to Apache. What connects PHP to MySQL? I've looked through google and I can't find anything that makes since to me. Can someone point me in a direction as to where I can find this out? The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46. I have a page that is trying to connect to MySQL via PHP. The error is:# When you install PHP you need to ensure that MySQL support is built in. This is fairly straightforward when building PHP from source, although you may have to tell the PHP build where your MySQL libraries are. Remember that PHP is implemented as an Apache module or 'plug-in', make sure that when Apache starts up, it also knows where the MySQL libraries are.[On Solaris this means setting LD_LIBRARY_PATH suitably.] Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ww3.polkmechanical.com/test/mysql_test.php on line 8 The code on line 8 is: $link = mysql_connect( "localhost", "user", "password" ) or die(mysql_error()); I can log on through mysql at a telnet prompt with the database, user and password. Ty... When governments fear the people there is liberty. When the people fear the government there is tyranny. -Thomas Jefferson, third US president, architect and author (1743-1826) -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] . IncrediMail - Email has finally evolved - Click Here
Re: PHP, MySQL and Apache
Peter Burden wrote: Subscriptions wrote: The httpd.conf connects PHP to Apache. What connects PHP to MySQL? I've looked through google and I can't find anything that makes since to me. Can someone point me in a direction as to where I can find this out? The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46. I have a page that is trying to connect to MySQL via PHP. The error is:# When you install PHP you need to ensure that MySQL support is built in. This is fairly straightforward when building PHP from source, although you may have to tell the PHP build where your MySQL libraries are. Remember that PHP is implemented as an Apache module or 'plug-in', make sure that when Apache starts up, it also knows where the MySQL libraries are.[On Solaris this means setting LD_LIBRARY_PATH suitably.] Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ww3.polkmechanical.com/test/mysql_test.php on line 8 The code on line 8 is: $link = mysql_connect( localhost, user, password ) or die(mysql_error()); I can log on through mysql at a telnet prompt with the database, user and password. Ty... If you're installing php from souce, use '--with-mysql' when configuring php, and if you're using RPM's, make sure you have installed the php-mysql packages. If you're using WindowsI'm not sure, but I think you have to uncomment the line in the php.ini file to load the dynamic library. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql-php link failure
I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am getting following error: //usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1: size = 512 collect2: ld returned 1 exit status make: *** [sapi/cli/php] Error 1 I'm compiling on SCO OperServer 5.0.6 using: gcc-2.95.2 make-3.80 php-4.3.2 mysql-4.0.13 apache_1.3.27 MySQL builds and installs fine. PHP configure fine and is making it through 95 percent build. The configure command to produce the problem in it's simplest form: configure --with-mysql=path to mysql install If I don't specify MySQL in the build then PHP builds fine. I'm not sure if it's a MySQL or PHP problem, or if it's a SCO library problem. So, I'm posting this question to all. If anyone has any idea or needs any additional information please let me know. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-php link failure
On Fri, 13 Jun 2003, Grimes, Dean wrote: I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am getting following error: //usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1: size = 512 collect2: ld returned 1 exit status make: *** [sapi/cli/php] Error 1 I'm compiling on SCO OperServer 5.0.6 using: gcc-2.95.2 make-3.80 php-4.3.2 mysql-4.0.13 apache_1.3.27 What OS's patches have you installed. This a known problem with older versions and is fixed in the latest patches. Don't install oss646 till they release some other oss. There may be a security patch as well. Take a look at ftp.sco.com/pub/security/OpenServer tt, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 1042 East Fort Union #135, Midvale Utah 84047 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Big Mistake Need Help, can I undo an action I did?
Hi guys, I had updated a field for all the entries in a table by mistake, I need to undo that step. I dont have the database back up to an stisfactory level. Is there a way in MySQL I can step one action back? or undo one command that I just did?? Thanks a lot guys!? __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP, MYSQL and persistant authentication
Hi, Does anyone know of a good tutorial on setting up a login page, and passing the login primary key to other pages so that other tables will be able to refernce the unique login thanks steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query takes long time to execute
I'm querying a table of approximately 42 records based on 3 criteria. The results are then displayed in a pop-up window. When the query is executed the first time - the window opens and stalls for about 3 seconds before the results are displayed. An example query would be : select * from $table_name where email ='$id'; I'm using the * to retreive about 16 cols of information per row. In this case I have indexed the email column. I'm looking for faster performance. Any help is appreciated. Mark
Re: identifying foreign keys
SHOW CREATE TABLE tblname; Best regards Nils Valentin Tokyo/Japan 2003 6 14 05:22Michael Conlen : I'm working on a system that will allow me to perform operations on a table using a web form, and I would like to know if a table has a foreign key, however I don't seem to see this information listed in any of the show commands output (or describe). Any idea how I could identify what colums are foreign keys and what they reference without having to tell the code? I use 'describe table' to get most of the information out I need. Oh yes, MySQL 4.0.12 on FreeBSD using INNODB tables. Thanks much. -- Michael Conlen -- --- 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: table creation - arrays ?
I have read that Arrays are not coming before 5.0. have a look in the Documentation and the UC presentations. Best regards NIls Valentin Tokyo/Japan 2003 6 10 22:25Hans Nerdell : table creation - arrays ? how are rows as ARRAYS specified and created on a table ? wbrgds hans _ Die aktuellsten Computer News gibts auf MSN! http://www.msn.at/computer -- --- 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: Query takes long time to execute
On Friday 13 June 2003 09:29 pm, Mark Stringham wrote: I'm querying a table of approximately 42 records based on 3 criteria. The results are then displayed in a pop-up window. When the query is executed the first time - the window opens and stalls for about 3 seconds before the results are displayed. Try running your query from the MySQL command line client, and see how it takes then. The querying you describe is quite simple, and shouldn't be taking MySQL 3 secs to run. If the query runs in 0.01 secs on the command line, then you know MySQL is not the cause of the delay. :) If, OTOH, the query actually does take 3 secs to run, start by running 'explain select * ...', which will tell you how the query is being processed. More info in optimizing queries can be found at http://www.mysql.com/doc/en/Query_Speed.html . Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Set no root password
How do I set no password for root? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql -- Putting user databases under user directory
I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Regards __ 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: Mysql -- Putting user databases under user directory
Hello Suba, I assume that yo are using any linux OS and MyISAM tables. I think you have several options. The two most common are: 1) you use the datadir option 2) you create symbolic links (ls command) to the users home directory and copy the data (shutdown mysql server before ;-) I havent yet tried them all myself, but they should work at least for the MyISAM tables. Best regards Nils Valentin Tokyo/Japan 2003 6 14 13:19Suba Arunkumar : I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Regards __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.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: Set no root password
At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql -- Putting user databases under user directory
At 21:19 -0700 6/13/03, Suba Arunkumar wrote: I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Don't do it. There is no advantage to doing this. The database directories must be owned by the server in order for it to properly access them anyway (not owned by your users), and putting database directories under user home directories will tempt them to mess around with the files there -- which they shouldn't be doing. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql -- Putting user databases under user directory
Paul is right (I should have metnioned it as well ;-) Best regards Nils Valentin Tokyo/Japan 2003 6 14 13:40Paul DuBois : At 21:19 -0700 6/13/03, Suba Arunkumar wrote: I want to put some of my users database under their home directory, is it possible to do that. If so can any one point me to the right source. Don't do it. There is no advantage to doing this. The database directories must be owned by the server in order for it to properly access them anyway (not owned by your users), and putting database directories under user home directories will tempt them to mess around with the files there -- which they shouldn't be doing. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- --- 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: Set no root password
I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/
Re: Set no root password
John Chang wrote: I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ If you changed it to have no root password, you need to edit the config.inc.php file in your phpmyadmin directory. Get rid of the password there. With that being said, why would you want an empty root password -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Set no root password
Try 'mysqladmin flush-privileges' --cut-- flush-privileges Reload grant tables (same as reload) --end cut-- then login (been there... Stuck there too...) chris -Original Message- From: John Chang [mailto:[EMAIL PROTECTED] Sent: Saturday, June 14, 2003 12:17 AM To: [EMAIL PROTECTED] Subject: Re: Set no root password I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Set no root password
It worked!!. Thanks. Now how do I protect it so that not anyone who points to it cannot get to it without putting in a username/password? At 12:24 AM 6/14/2003 -0500, John Nichel wrote: John Chang wrote: I changes the password but it still doesn't work. This is the error I get when I try to connect to MySQL using phpmyadmin using a browser. What do I need to change? Thanks. Error MySQL said: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) At 11:37 PM 6/13/2003 -0500, Paul DuBois wrote: At 0:10 -0400 6/14/03, John Chang wrote: How do I set no password for root? mysql -u root -p Enter password: (your current root password here) mysql SET PASSWORD = ''; mysql quit -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ If you changed it to have no root password, you need to edit the config.inc.php file in your phpmyadmin directory. Get rid of the password there. With that being said, why would you want an empty root password
