errors starting mysqld from 3.23.41 source (linux)
okay, I'm having problems here, probably something very simple I'm overlooking: ./configure --prefix=/usr/local/mysql --prefix=/usr/local \ --localstatedir=/usr/local/mysql/data make make install mkdir /usr/local/mysql/data mkdir /usr/local/mysql/tmp cd /usr/local/mysql/bin/ mysql_install_db /usr/local/mysql/bin/mysqladmin -u root -p password 'newpassword' /usr/local/mysql/bin/safe_mysql starts, but still doesn't let root connect via localhost = -- Anthony Ettinger [EMAIL PROTECTED] 415-504-8048 http://chovy.com/resume.doc __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to measure the size of MYSQL database?
hello how can we get the size of Mysql database. niraj BN3 Hosted Customer Service Solution, basic service FREE. CRM enable your web site in 5 minutes! http://www.bn3.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL/PHP
Try with $db=mysql_connect
(localhost.localdomain,myname,mypassword);
use the test database that i think that is the least restrictive database.
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Adams, Bill TQO
Enviado el: miercoles, 05 de septiembre de 2001 21:02
Para: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Asunto: Re: MySQL/PHP
Chakravarthy K Sannedhi wrote:
$db=mysql_connect (localhost,myname,mypassword);
mysql_select_db (newone,$db);
$result = mysql_query (select * from namelist);
[snip]
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/namelist.php on line 7
You could not connect (in case you did not figure that out) and:
Warning: Supplied argument is not a valid MySQL-Link resource in
/var/www/html/namelist.php on line 8
etc. are from the fact you do not have a valid $db.
$db = mysql_connect( ... );
if( $db ){
...
}
First, I would check the user/password with 'mysql', e.g.:
mysql newone myname mypassword
If that works, then it is a mystery to me as to why it is failing but you
may
want to connect using network sockets e.g. by specififying the host:
$db = mysql_connect( 'the.host.name', 'myname', 'mypassword );
shameless_plug
Also, you may want to check out class.DBI which abstracts the database like
the perl module by the same name: http://evilbill.org/php/DBI.php3
/shameless_plug
--Bill
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
you should try this
Dear [EMAIL PROTECTED] , You can earn $46,000 or more in next the 90 days sending e-mail. Seem impossible? Read on for details (no, there is no catch)... AS SEEN ON NATIONAL T.V. Thank you for your time and Interest. This is the letter you've been reading about in the news lately. Due to the popularity of this letter on the internet, a major nightly news program recently devoted an entire show to the investigation of the program described below, to see if it really can make people money. The show also investigated whether or not the program was legal. Their findings proved once and for all that there are, absolutely no laws prohibiting the participation in the program. This has helped to show people that this is a simple, harmless and fun way to make some extra money at home. The results of this show has been truly remarkable. So many people are participating that those involved are doing, much better than ever before. Since everyone makes more as more people try it out, its been very exciting to be a part of lately. You will understand once you experience it. HERE IT IS BELOW *** Print This Now For Future Reference *** The following income opportunity is one you may be interested in taking a look at. It can be started with VERY LITTLE investment and the income return is TREMENDOUS!!! $$$ If you would like to make at least $46,000 in less than 90 days! Please read the enclosed program...THEN READ IT AGAIN!!! THIS IS A LEGITIMATE, LEGAL, MONEY MAKING OPPORTUNITY. It does not require you to come into contact with people, do any hard work, and best of all, you never have to leave the house except to get the mail. If you believe that someday you'll get that big break that you've been waiting for, THIS IS IT! Simply follow the instructions, and your dreams will come true. This multi-level e-mail order marketing program works perfectly...100% EVERY TIME. E-mail is the sales tool of the future. Take advantage of this non-commercialized method of advertising NOW!!! The longer you wait, the more people will be doing business using e-mail. Get your piece of this action!!! MULTI-LEVEL MARKETING (MLM) has finally gained respectability. It is being taught in the Harvard Business School, and both Stanford Research and the Wall Street Journal have stated that between 50% and 65% of all goods and services will be sold through multi-level methods by the mid to late 1990's. This is a Multi-Billion Dollar industry and of the 3,500,000 millionaires in the WORLD, 20% ( 700,000) made their fortune in the last several years in MLM. Moreover, statistics show that over 100 people become millionaires everyday through Multi-Level Marketing. You may have heard this story before, but over the summer Donald Trump (A MULTI-BILLIONAIRE, ONE OF THE WEALTHIEST MEN IN THE WORLD) made an appearance on the David Letterman show. Dave asked him what he would do if he lost everything and had to start over from scratch. Without hesitating, Trump said he would find a good network marketing company and get to work. The audience started to hoot and boo him. He looked out at the audience and dead-panned his response That's why I'm sitting up here and you are all sitting out there! With network marketing you have two sources of income. Direct commissions from sales you make yourself and commissions from sales made by people you introduce to the business. Residual income is the secret of the wealthy. It means investing time or money once and getting paid again and again and again. In network marketing, it also means getting paid for the work of others. This program is currently being utilized in more than 50 different countries across the world. The enclosed INF0RMATION is something I almost let slip through my fingers. Fortunately, sometime later I re-read everything and gave some thought and study to it. My name is Johnathon Rourke. Two years ago, the corporation I worked at for the past twelve years down-sized and my position was eliminated. After unproductive job interviews, I decided to open my own business. Over the past year, I incurred many unforeseen financial problems. I owed my family, friends and creditors over $35,000. The economy was taking a toll on my business and I just couldn't seem to make ends meet. I had to refinance and borrow against my home to support my family and struggling business. AT THAT MOMENT something significant happened in my life and I am writing to share the experience in hopes that this will change your life FOREVER FINANCIALLY!!! In mid December, I received this program via e-mail. Six month's prior to receiving this program I had been sending away for
Re: how to measure the size of MYSQL database?
On Thu, Sep 06, 2001 at 12:31:34PM +0530, [EMAIL PROTECTED] wrote: hello how can we get the size of Mysql database. niraj BN3 Hosted Customer Service Solution, basic service FREE. CRM enable your web site in 5 minutes! http://www.bn3.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php If you are using Linux the following should help: du -hs /var/lib/mysql/ HTH, -- Mario Witte [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
1030: Got error 127 from table handler
Hello, I was working with Mysql an nerver had any problem, the suddenly from one moment to the other, some tables didn't work correctly any more. Any select command on them returns me : 1030: Got error 127 from table handler. But if I do a select command on a other table with a join on one of those tables everything works fine. Anyone an idea ? Lorang Jacques - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with grant for another user with password
Hello, I have a mysql (3.23) server running on a linux system. The server has several databases belonging to the (unix) user who created his database. So each Student may create his own database and usually only he himself may access/modify the data in this database. This creation of a new database is done by a web interface executed as the mysql-root user. The problem now is, that sometimes a database should not only be accessible by the owner himself but also by another user protected by a password. So the owner x of a database wants to do this: $ mysql -h mysqlserver -u x -p xyz mysql grant select on dbOfUserX.* to otherUser identified by 'otherPassword'; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' The user otherUser does not already exist in the mysql users table. The user x has the grant right and just saying: mysql grant select on dbOfUserX.* to otherUser; works just fine. But user x is unable to allow someone else to access his database with password protection. So the question is, how can the privilege system be set up, so that a user x can allow another user y to access his database by password (different from the password of the user x of course). Another question is, how can I (the db-admin) allow a user to access the mysql-DB (to allow the password change) without allowing him to change passwords of other users that already exist in the mysql user table (having their own databases)? Where is the information stored, that allows a user (execpt for root) to access the mysql database. Thanks for any help Rainer Krienke -- - Rainer Krienke [EMAIL PROTECTED] Universitaet Koblenz, http://www.uni-koblenz.de/~krienke Rechenzentrum, Voice: +49 261 287 - 1312 Rheinau 1, 56075 Koblenz, Germany Fax: +49 261 287 - 1001312 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 1030: Got error 127 from table handler
Hello, I was working with Mysql an nerver had any problem, the suddenly from one moment to the other, some tables didn't work correctly any more. Any select command on them returns me : 1030: Got error 127 from table handler. But if I do a select command on a other table with a join on one of those tables everything works fine. chris@phantasm:~$ perror 127 Error code 127: Unknown error: 127 127 = Record-file is crashed Try running myisamchk on the table, or REPAIR TABLE tblname with 3.23 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: mysql db replication security across the internet
Duc Chau ([EMAIL PROTECTED]) writes: Can anyone tell me or point me to documentation on how to securely do database replication over the internet? I need to replicate to machines in datacenters in diffrent states. How feasible is this? Has anyone done it? What are the security concerns with doing this via the net? Thanks Not a problem. Use secure shell's port forwarding feature (look in the VPN HOWTO at http://www.linuxdoc.org/HOWTO/VPN-HOWTO.html for more info). -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql CPU too high and sleeping process
Hello, I have trouble with mysql consuming too much CPU with a few number of threads running. How could I reduce the CPU usage ? I unterstand that, in plain charge the CPU is high but why does it stay at that level when the charge is becoming smaller ? The process seems in major to be sleeping and must die after few minutes (wait_timeout=250). Also other question is : Should I reduce the number of threads running (is it done by the way of reducing max_connections in my.cnf) ? Could someone help ? Config : mysql 3.23.36 Linux kernel 2.4 - 2 processors - 2 Go RAM (php+apache+mysql) - 100 max-links from on each 3 webservers (in php.ini) +--++ | Variable_name| Value | +--++ | Aborted_clients | 3608 | | Aborted_connects | 0 | | Bytes_received | 434183878 | | Bytes_sent | 1437881936 | | Connections | 12387 | | Created_tmp_disk_tables | 408| | Created_tmp_tables | 55294 | | Created_tmp_files| 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 524| | Handler_read_first | 16 | | Handler_read_key | 28629764 | | Handler_read_next| 1470906927 | | Handler_read_prev| 0 | | Handler_read_rnd | 2254162| | Handler_read_rnd_next| 451113758 | | Handler_update | 365596 | | Handler_write| 4046959| | Key_blocks_used | 20820 | | Key_read_requests| 146486605 | | Key_reads| 14735 | | Key_write_requests | 69859 | | Key_writes | 68907 | | Max_used_connections | 351| | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 91 | | Open_files | 123| | Open_streams | 0 | | Opened_tables| 97 | | Questions| 1742927| | Select_full_join | 0 | | Select_full_range_join | 1792 | | Select_range | 44809 | | Select_range_check | 0 | | Select_scan | 37202 | | Slave_running| OFF| | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 8 | | Sort_merge_passes| 0 | | Sort_range | 4146 | | Sort_rows| 2253757| | Sort_scan| 31084 | | Table_locks_immediate| 1686804| | Table_locks_waited | 2017 | | Threads_cached | 44 | | Threads_created | 441| | Threads_connected| 205| | Threads_running | 2 | | Uptime | 60481 | and /etc/my.cnf: [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock datadir = /data/sqldata/mysql log-slow-queries=/var/log/mysql_slow_queries.log log-bin #server-id=1 skip-locking set-variable= key_buffer=768M #set-variable= join_buffer_size=768M set-variable= max_allowed_packet=3M set-variable= table_cache=1024 set-variable= sort_buffer=768M set-variable= record_buffer=128M set-variable= thread_cache=80 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= myisam_sort_buffer_size=128M set-variable= max_connections=1000 #set-variable= wait_timeout=600 #set-variable= interactive_timeout=600 set-variable= wait_timeout=250 set-variable= interactive_timeout=250 set-variable= max_connect_errors=1000 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqldump] quick set-variable= max_allowed_packet=16M - Thanks in advance, Jerome - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Data submission - pl. advise
Hi list members, Pl. advise me in the following matter: I have a form (form.htm) on click its data is submitted in table using submission.php. its very simple. But, I want when any data is submitted into table, the same data is also emailed to me. That is on submission two tasks are done 1. data is inserted in table 2. same data is emailed to me. How it can be done efficiently. Thanks in advance Ajay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'tmp/mysql.sock' (2) error
BW (ST) ([EMAIL PROTECTED]) writes: I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've tried specifying socket=/path/to/socket in both [client] and [mysqld] sections of my.cnf, and I've tried to edit safe_mysqld directly with this path. In all cases, the mysql server appears to start (no error messages are generated when I run S99mysql start, anyway), but I get the ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) message. I'm guessing that some other file is overwriting the my.cnf settings so that the server still expects connections to come through the /tmp/mysql.sock socket. I can't, however, figure out which file that is/may be. No, Bob, that would be an incorrect guess. ;) 1. Is MySQL actually running? 2. If so, where is it putting mysql.sock? 3. If it's in /var/lib/mysql/mysql.sock, the quick fix is to do ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock. 4. Where is my.cnf located - you didn't say. 5. What application are you trying to run that gives the error - again, you didn't say. I'm sorry I can't help you without you providing more specific information about your problem. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Convert to MyISAM
Hello, I would be pleased if anyone could tell me hoe to convert my tables to MyISAM. I used to run an old MYsql version, but now got the newest one, but still my tables can't use the features of the new version and i guss it is because of the table type not being MyISAm. So how to convert ? Thankx for reply, Lorang Jacques - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Convert to MyISAM
use: alter table your_table type=myisam On Thu 06 Sep 2001 12:53, Lorang Jacques wrote: Hello, I would be pleased if anyone could tell me hoe to convert my tables to MyISAM. I used to run an old MYsql version, but now got the newest one, but still my tables can't use the features of the new version and i guss it is because of the table type not being MyISAm. So how to convert ? Thankx for reply, Lorang Jacques - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Roman Festchook Network Engineer ISP ORTA Polesye http://www.polesye.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 1030: Got error 127 from table handler
Thankx for reply. But if I use Table Repair it says : The handler for te table doesn't support Check/Repair. What does SHOW TABLE STATUS LIKE 'tablename'; say for the Type column? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 1030: Got error 127 from table handler
Solved the prob, thankx Lorang Jacques - Original Message - From: Chris Bolt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 11:56 AM Subject: RE: 1030: Got error 127 from table handler Thankx for reply. But if I use Table Repair it says : The handler for te table doesn't support Check/Repair. What does SHOW TABLE STATUS LIKE 'tablename'; say for the Type column? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL on RH5.2
Hi, I am trying to compile mysql on RH 5.2 and when I run ./configure i get message c++ can not write output files. Does anyone know how to help me? Thanks. __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
When configuring mysql, some errors happened.The report of config.log
and error messages are listed below.The environment I use is Sun Solaris
8(SunOS 5.8) with gcc 2.95.3.
config.log:
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
configure:813: checking host system type
configure:834: checking target system type
configure:852: checking build system type
configure:887: checking for a BSD compatible install
configure:940: checking whether build environment is sane
configure:975: checking whether make sets ${MAKE}
configure:1021: checking for working aclocal
configure:1034: checking for working autoconf
configure:1047: checking for working automake
configure:1060: checking for working autoheader
configure:1073: checking for working makeinfo
configure:1175: checking whether to enable maintainer-specific portions of Makefiles
configure:1217: checking whether build environment is sane
configure:1234: checking whether make sets ${MAKE}
configure:1302: checking for gawk
configure:1302: checking for mawk
configure:1302: checking for nawk
configure:1334: checking for gcc
configure:1447: checking whether the C compiler (gcc ) works
configure:1463: gcc -o conftest conftest.c 15
configure:1489: checking whether the C compiler (gcc ) is a cross-compiler
configure:1494: checking whether we are using GNU C
configure:1503: gcc -E conftest.c
configure:1522: checking whether gcc accepts -g
configure:1558: checking for c++
configure:1590: checking whether the C++ compiler (c++ ) works
configure:1606: c++ -o conftest conftest.C 15
configure:1632: checking whether the C++ compiler (c++ ) is a cross-compiler
configure:1637: checking whether we are using GNU C++
configure:1646: c++ -E conftest.C
configure:1665: checking whether c++ accepts -g
configure:1697: checking how to run the C preprocessor
configure:1718: gcc -E conftest.c /dev/null 2conftest.out
configure:1833: checking for ranlib
configure:1943: checking for ld used by GCC
configure:2005: checking if the linker (/usr/ccs/bin/ld) is GNU ld
configure:2021: checking for BSD-compatible nm
configure:2057: checking whether ln -s works
ltconfig:603: checking for object suffix
ltconfig:604: gcc -cconftest.c 15
ltconfig:629: checking for executable suffix
ltconfig:630: gcc -o conftest conftest.c 15
ltconfig:776: checking if gcc PIC flag -fPIC works
ltconfig:777: gcc -c -fPIC -DPIC conftest.c 15
ltconfig:829: checking if gcc supports -c -o file.o
ltconfig:830: gcc -c -o out/conftest2.o conftest.c 15
ltconfig:862: checking if gcc supports -c -o file.lo
ltconfig:863: gcc -c -c -o conftest.lo conftest.c 15
ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions
ltconfig:915: gcc -c -fno-rtti -fno-exceptions -c conftest.c conftest.c 15
ltconfig:958: checking if gcc static flag -static works
ltconfig:959: gcc -o conftest -static conftest.c 15
ltconfig:1653: checking if global_symbol_pipe works
ltconfig:1654: gcc -cconftest.c 15
ltconfig:1657: eval /usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT]\)[
][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1
\2\3 \3/p' conftest.nm
ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions conftest.c
conftstm.o 15
configure:2257: checking for a BSD compatible install
configure:2315: checking for bison
configure:2315: checking for byacc
configure:2348: checking for pdftex
configure:2376: checking return type of sprintf
==
error message:
checking return type of sprintf... configure: error: can not run test program while
cross compiling
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: EMS MySQL Manager
Dear Sirs and Madams, First, thanks to everyone who interested in our product -- EMS MySQL Manager -- and answered to our previous announce! This message intended for shed light on some questions regarding EMS MySQL Manager. On which operating system does MySQL Manager works? Currently, MySQL Manager works on Windows 95/98/NT/ME/2000 operating systems. Linux version will be available soon. How much does EMS MySQL Manager costs? Complete price list you can find at http://www.mysqlmanager.com/purchase.phtml Following to numerous suggetions, libmysql.dll is now included into distribution package, and now you won't have any problem occuring because of absence of this dynamic library. Help files is also included into distribution package. Unfortunaly, not all of help files are finished already. Complete help system will be available soon. You can download a new distribution package from http://www.mysqlmanager.com/download.phtml . Thanks again for your interest to our product! Best regards, EMS HiTech development team. http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table can't be named order
I just tried to create a table called order, with this command: create table order ( orderID INTnot null, constraint P_Key_6 primary key (orderID) ); It didn't work, I got an error message. When I qualified the name with the database, it worked though: create table trDB.order ( orderID INTnot null, constraint P_Key_6 primary key (orderID) ); Isn't this rather strange? GUIs won't understand to qualify it like that and thus fail on any operations performed on that table. My guess is that mySQL thinks I'm trying to write ORDER BY. Well, that's kind of stupid of it, don't you think? :) Kristoffer Larsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Performance Problem
On Thu, Sep 06, 2001 at 12:02:07AM +0200, Henning Schroeder wrote: All the updates to the table are of the style described above (one to three colums changed, row indexed by primary key). Well, with SELECTs it´s a different story: many queries join in different ways to the table. FYI, it´s the table where all user information is stored, so I need a join every time I need e.g. to find the name corresponding to an userid. Is that a bad idea? And how am I supposed to find the slow queries? Find all the queries that interact with this table. EXPLAIN them. Time them. If it was a contention problem, I could switch to another table type. Would that help? What do you think? Possibly, likely it would only make the symptoms a little less painful. select * from cookies left join users on cookies.uid=users.uid left join sessions on users.uid=sessions.uid where cookies.cookie=e3bd03382561eb3619b66fbea2af217d; select * from cookies left join users on cookies.uid=users.uid left join extended on users.uid=extended.uid where cookies.cookie=5226220e3b62cef71a13524ec7a413ac; (above queries have to be performed at the beginning of every webpage to find the current user. i don´t really think they are slow; they just lock because of something else.) i just tried the above query ten times. result: 7x 0.00sec, 1x0.01, 1x0.02, 1x0.04. does that spell slow? Yes. I wouldn't let queries with times like these near a busy production server I was responsible for unless I was positive they wouldn't and couldn't happen more than a handful of times a day. :-) Post the output of EXPLAIN for these queries. Along with the create defns for these other tables. update users set lastlogin=999697993, perstopre=f where uid=40651; update users set lastlogin=999698763, votescast=1514, prevvote=-8 where uid=54307; (the usual locked queries) When these are locked, not only are they waiting for the selects that came before them to finish, they are blocking selects behind them in the queue from executing simultaneously with selects ahead of them. Selects in the queue for the users table that join to other tables (and you have plenty of them) will block updates/inserts to those other tables. Imagine now that an insert arrives to one of these other tables and behind it comes another multi-table select, joining to other tables. On a busy database (thousands of queries per second), it doesn't take long for the whole database to get totally bogged down if a massive web of blocks happens like this. And mysqld doesn't always recover. Banning queries that take longer than 0.00 seconds at the mysql prompt (run them a few times - one or two 0.00s and it's suspect) is just a handy rule of thumb for measuring nastiness of queries. For proper measurements, one could benchmark queries - or one could stick a unique comment into every query and just watch processlists. You will come to recognise the common slow queries because you will see them in the processlists often! Wesley. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table can't be named order
On Thu, Sep 06, 2001 at 01:02:59PM +0200, Kristoffer Larsson wrote: I just tried to create a table called order, with this command: create table order ( orderID INTnot null, constraint P_Key_6 primary key (orderID) ); It didn't work, I got an error message. When I qualified the name with the database, it worked though: create table trDB.order ( orderID INTnot null, constraint P_Key_6 primary key (orderID) ); Isn't this rather strange? GUIs won't understand to qualify it like Such GUIs are broken. that and thus fail on any operations performed on that table. My guess is that mySQL thinks I'm trying to write ORDER BY. Well, that's kind of stupid of it, don't you think? :) Do I think it's stupid of MySQL? No. `order' is a reserverd word in MySQL. Wesley. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table can't be named order
On Thu, 6 Sep 2001, Wesley Darlington wrote: that and thus fail on any operations performed on that table. My guess is that mySQL thinks I'm trying to write ORDER BY. Well, that's kind of stupid of it, don't you think? :) Do I think it's stupid of MySQL? No. `order' is a reserverd word in MySQL. Too bad the documentation doesn't say so. Actually it implies the opposite: mysql select order.custid,customer.name,max(payments) from order,customer where order.custid = customer.custid GROUP BY order.custid; This is straight from the docs and such a query can't obviously work, can it? Kristoffer Larsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Trouble with auto start
Disregard this thread now as I got the answer in the Mandrake list. At 06:55 PM 9/5/2001, you wrote: I've poked around some more and realized I copied the wrong mysql.server file into the etc/rc.d/init.d folder, so that is all fine now, but I still can't get it to autostart. I'm using Mandrake 8.0 and set the paths up through webmin so I can stop and start it through the webmin interface. TIA! http://www.sindiis.com/index.htmlSindi is : On the Web http://www.sindiis.com/~incubus/index.htmlIncubus' Lair - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem in loading of mysql
Description:
configure:5454: checking LinuxThreads
configure:5495: checking DEC threads
configure:5723: checking named thread libs:
configure:5847: checking for strtok_r in -lpthread
configure:5866: gcc -o conftest conftest.c -lpthread -lpthread -lmach -lexc
-lm -lpthread -lmach -lexc 15
configure:6007: checking for strtok_r
configure:6035: gcc -o conftest conftest.c -lpthread -lmach -lexc -lm -lpth
read -lmach -lexc 15
configure:6069: checking for dlopen in -ldl
configure:6088: gcc -o conftest conftest.c -ldl 15
/usr/bin/ld:
Can't locate file for: -ldl
collect2: ld returned 1 exit status
configure: failed program was:
#line 6077 configure
#include confdefs.h
/* Override any gcc2 internal prototype to avoid an error. */
/* We use char because int might match the return type of a gcc2
builtin and then its argument prototype would still apply. */
char dlopen();
int main() {
dlopen()
; return 0; }
configure:6121: checking for restartable system calls
configure:6147: gcc -o conftest conftest.c -lpthread -lmach -lexc -lm -lpth
read -lmach -lexc 15
configure: In function `main':
configure:6139: warning: passing arg 2 of `signal' from incompatible pointer typ
e
configure: failed program was:
#line 6129 configure
#include confdefs.h
/* Exit 0 (true) if wait returns something other than -1,
i.e. the pid of the child, which means that wait was restarted
after getting the signal. */
#include sys/types.h
#include signal.h
ucatch (isig) { }
main () {
int i = fork (), status;
if (i == 0) { sleep (3); kill (getppid (), SIGINT); sleep (3); exit (0); }
signal (SIGINT, ucatch);
status = wait(i);
if (status == -1) wait(i);
exit (status == -1);
}
configure:6276: checking need of special linking flags
configure:6286: checking for working const
configure:6340: gcc -c -O3 -DDBUG_OFFconftest.c 15
configure:6361: checking for inline
configure:6375: gcc -c -O3 -DDBUG_OFFconftest.c 15
configure:6401: checking for off_t
configure:6434: checking for st_rdev in struct stat
configure:6447: gcc -c -O3 -DDBUG_OFFconftest.c 15
configure:6468: checking whether time.h and sys/time.h may both be included
configure:6482: gcc -c -O3 -DDBUG_OFFconftest.c 15
configure:6503: checking whether struct tm is in sys/time.h or time.h
configure:6516: gcc -c -O3 -DDBUG_OFFconftest.c 15
configure:6539: checking size of char
configure:6558: gcc -o conftest -O3 -DDBUG_OFF conftest.c -lpthread -lmach -
lexc -lm -lpthread -lmach -lexc 15
configure: failed program was:
#line 6547 configure
#include confdefs.h
#include stdio.h
main()
{
FILE *f=fopen(conftestval, w);
if (!f) exit(1);
fprintf(f, %d\n, sizeof(char));
exit(0);
}
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:system PRIVILEGED account
Organization:
MySQL support: none
Synopsis: problem in loading of mysql
Severity: critical
Priority: high
Category: mysql
Class: support
Release: mysql-3.23.41 (Source distribution)
Environment:
System: OSF1 cal3.vsnl.net.in V4.0 1091 alpha
Machine: alpha
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ccs/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/alphaev56-dec-osf4.0e/3.0.1/specs
Configured with: ./configure
Thread model: single
gcc version 3.0.1
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root system17 Apr 29 1999 /lib/libc.a - ../ccs/lib/libc.a
lrwxrwxrwx 1 root system17 Apr 29 1999 /usr/lib/libc.a -
../ccs/lib/libc.a
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client
--with-berkeley-db --with-innodb
Perl: This is perl, version 5.005_03 built for alpha-dec_osf
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error Compiling mysql under Solaris
David Turner writes: Does anyone have a good configure statement I could try for making MYSQL on Solaris for Sparc? I've got it compiling on X86 but I get a parser error I've only seen mention of once on the lists, and I did not see how to identify the reserved word I am using? I'll continue digging around, but if someone has a quick fix I would really appreciate it. Here's the error sql_yacc.yy, line 71: fatal: invalid escape, or illegal reserved word: pure_parser Os and mysql versions: 5.7 Generic_106541-09 sun4u sparc SUNW,UltraSPARC-IIi-cEngine mysql-3.23.41 Thanks, Dave You should use GNU bison in order to generate C++ out of sql_yacc.yy. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table can't be named order
Kristoffer Larsson wrote: On Thu, 6 Sep 2001, Wesley Darlington wrote: that and thus fail on any operations performed on that table. My guess is that mySQL thinks I'm trying to write ORDER BY. Well, that's kind of stupid of it, don't you think? :) Do I think it's stupid of MySQL? No. `order' is a reserverd word in MySQL. Too bad the documentation doesn't say so. Yes it does. Read ch. 7.39. It says that you generally cannot use reserved names as column names. Actually it implies the opposite: mysql select order.custid,customer.name,max(payments) from order,customer where order.custid = customer.custid GROUP BY order.custid; Here order is used as a table name, not column name. This is straight from the docs and such a query can't obviously work, can it? Obviously it can. / Carsten Carsten H. Pedersen Keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent
Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks, Sneha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to find the size of MYSQL database?
hello please if you can help in finding the size of MYSQL database. niraj BN3 Hosted Customer Service Solution, basic service FREE. CRM enable your web site in 5 minutes! http://www.bn3.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table can't be named order
On Thu, 6 Sep 2001, Carsten H. Pedersen wrote: `order' is a reserverd word in MySQL. Too bad the documentation doesn't say so. Yes it does. Read ch. 7.39. It says that you generally cannot use reserved names as column names. Correct, I must have missed that. Sorry. Although I was talking about table names, not column names. Actually it implies the opposite: mysql select order.custid,customer.name,max(payments) from order,customer where order.custid = customer.custid GROUP BY order.custid; Here order is used as a table name, not column name. Yes, I have never talked about order as a column name, only as a table name. In 7.40 (not 7.39) it says that most of [these keywords] are forbidden as column and/or table names. So, the above can't work, since a table can't be named order. Unless the above expects you to create the table by qualifying it with the database name ... Kristoffer Larsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ANN: EMS MySQL Manager
Igor Brynskich ([EMAIL PROTECTED]) writes: First, thanks to everyone who interested in our product -- EMS MySQL Manager -- and answered to our previous announce! This message intended for shed light on some questions regarding EMS MySQL Manager. On which operating system does MySQL Manager works? Currently, MySQL Manager works on Windows 95/98/NT/ME/2000 operating systems. Linux version will be available soon. How much does EMS MySQL Manager costs? Complete price list you can find at http://www.mysqlmanager.com/purchase.phtml Q. Why should I pay $95 for your product when I can download and use PHPMyAdmin (or any number of other products) for free? Q. Why should I pay a lot of attention to a company who spams a technical list in order to sell product under the guise of answering questions? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to do simple stuff
Let me rephrase that checkbox one:: TRUE or FALSE - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Mike Wexler [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 10:19 PM Subject: Re: How to do simple stuff Deryck Henson wrote: How do I:: Add a column ALTER TABLE myTable ADD COLUMN myColumn VARCHAR(27) Alter a table to fit a different character lengths (say...unlimited in a 1 column) ALTER TABLE myTable CHANGE COLUMN myColumn myColumn TEXT or alter column to accept an unlimited amount of characters ALTER TABLE myTable CHANGE COLUMN myColumn myColumn TEXT Make a column have a check box instead of characters(VARCHAR...) or date (DATE) mysql doesn't control your UI. You would have to reconfigure whatever software is presenting your UI. thanx - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Can't get MySQL running on Win2K
Marjolein, if you do not want to use transactional InnoDB tables, add skip-innodb to the [mysqld] section of your my.cnf or my.ini. Otherwise below are examples of setting: To use InnoDB tables you must specify configuration parameters in the MySQL configuration file in the [mysqld] section of the configuration file `my.cnf'. Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB hard disk. Below is an example of possible configuration parameters in `my.cnf' or 'my.ini' for InnoDB: [mysqld] # You can write your other MySQL server options here # ... # innodb_data_home_dir = c:\ibdata innodb_data_file_path = ibdata1:2000M;ibdata2:2000M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Note that data files must be 4G, and 2G on some file systems! The combined size of data files must be = 10 MB. InnoDB does not create directories: you have to create them yourself. Regards, Heikki http://www.innodb.com Configuration: multiboot system. C: is for DOS and System Commander, R: is for Win2K. \ (Most) applications go on F:, (most) data goes on P:. - I installed MySQL to F:\Development\Database\MySQL - I edited my-example.cnf and added [mysqld] basedir=F:/Development/Database/MySQL/datadir=P:/MySQL/ then Save as to C:\my.cnf (do I *really* have to store this on a drive that's \ reserved for DOS and multiboot?) The installation created databases 'mysql' and \ 'test' on F: - I copied these to the designated data location on P:. - I ran winmysqladmin.exe, created an .ini file and designated mysqld-nt.exe as the \ service, then tried to start it. The traffic light remains red. (The ini file is in \ the Windows directory: R:\WIN2000\my.ini ) - Tried MySqlManager.exe which wants to \ connect to localhost - but can't connect. - In the Services applet, mysqld-nt.exe is \ registered as a service, automatic, but not started. - After reboot, same situation: \ the service is automatic, but not started. Trying to start results in an error. - \ Removed the service with F:\Development\Database\MySQL\bin\mysqld-nt --remove - Tried \ to start mysqld in debug mode with F:\Development\Database\MySQL\bin\mysqld --debug \ --standalone this results in an error: Can't initialize InnoDB as \ 'innodb_data_file_path' is not set and mysqld hung - I had to kill it from task \ manager. - Tried to start mysqld (no debug) with \ F:\Development\Database\MySQL\bin\mysqld --standalone this results in the error - I \ had to kill it from task manager again. (Note: while mysqld hangs, \ winmysqladmin.exe's traffic light in the system tray is green, so it does detect if \ mysqld is running.)Now what?Thanks,Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help about date conversion ...
I want to write date type in the format DD/MM/ to the database? Can I do this with some parameter to mysql.ini? ** Amilton Martins Infosoft Informática Ltda. www.infosoft.inf.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help about date conversion ...
No. Amilton Martins wrote: I want to write date type in the format DD/MM/ to the database? Can I do this with some parameter to mysql.ini? ** Amilton Martins Infosoft Informática Ltda. www.infosoft.inf.br - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help about date conversion ...
At 9:27 AM -0300 9/6/01, Amilton Martins wrote: I want to write date type in the format DD/MM/ to the database? Can I do this with some parameter to mysql.ini? No. For storage, you must convert it to CCYY-MM-DD format. For display, you can format it to the style you want using DATE_FORMAT(d,'%d/%m/%Y'). ** Amilton Martins Infosoft Informática Ltda. www.infosoft.inf.br -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to do simple stuff
Deryck Henson wrote: How do I:: Add a column Did you read the manual? Alter a table to fit a different character lengths (say...unlimited in a 1 column) or alter column to accept an unlimited amount of characters The concept of unlimited characters does not exist in the real world. The closest you will get is varchar, text, or blob in its largest size. Make a column have a check box instead of characters(VARCHAR...) or date (DATE) Check boxes are an HTML thing, not SQL. Try PHP. Dates exist. Again, read the manual. thanx - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ANN: EMS MySQL Manager
At 6:54 AM -0500 9/6/01, Ed Carp wrote: Igor Brynskich ([EMAIL PROTECTED]) writes: First, thanks to everyone who interested in our product -- EMS MySQL Manager -- and answered to our previous announce! This message intended for shed light on some questions regarding EMS MySQL Manager. On which operating system does MySQL Manager works? Currently, MySQL Manager works on Windows 95/98/NT/ME/2000 operating systems. Linux version will be available soon. How much does EMS MySQL Manager costs? Complete price list you can find at http://www.mysqlmanager.com/purchase.phtml Q. Why should I pay $95 for your product when I can download and use PHPMyAdmin (or any number of other products) for free? Legitimate question. A feature comparison could be usefl. Q. Why should I pay a lot of attention to a company who spams a technical list in order to sell product under the guise of answering questions? I didn't read it as being under any guise, and the message does contain technical information (works under Windows, Linux users have to wait; it's obviously not free). Does your message mean we'll see no more Escapade announcements on this list? That would be unfortunate, but by the same token, should the EMS client become available in a Linux version, an announcement on this list might be of interest to several of the readers. It's certainly a more appropriate message than the perennial why can't this list use [mysql] in the header so I can filter my mail? :-) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQLGUI
First, if there is an FAQ or installation documentation please direct me there and I'll review before requesting assistance. If there is neither, I am unable to successfully run mysqlgui on the following platform: Sun Ultra 10 running Solaris 8 with current Recommended installed, mysql version MySQL3.23.41, and mysqlgui-solaris-2.7-sparc-static-1.6.gz. mysqlgui is installed in /usr/local/mysql/bin. I receive the following error when starting the gui: ld.so.1: mysqlgui: fatal: libstdc++.s0.2.10.0: open failed: No such file or directory Killed /usr/local/lib is in the PATH and this file exist with mod = 555. In advance, thank you for the assistance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: limit and order by issuse
Hello , There is no bug in MySQL 3.23.38 regarding limit / order by , problem lies in phpMyAdmin 2.1.0 Upgrade to phpMyAdmin 2.2.0 has resloved my problem. Basically limit portion of my query was conflicting with default limiting feature of myadmin for pageing. But in phpMyAdmin 2.2.0 this issue is solved. check change log here: http://phpmyadmin.sourceforge.net/ChangeLog.txt regards, shahzad -Original Message- From: Henning Schroeder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:23 PM To: [EMAIL PROTECTED] Subject: RE: limit and order by issuse sh Here is my query: sh SELECT sh articleId,arttitle,artsourceId,artstatus,artauthorId,arteventdate,artpre sh ss,artpageno,artrankId,artabstract, sh artfulltext,artisdisplay,arteditionId,arttypeid,artsubjectid , sh asubjectId,asubjectname , FLOOR((TO_DAYS(CURRENT_DATE()) - sh TO_DAYS(arteventdate))/365.25) as dif , atypeId, atypename, authorId, sh autname , sourceId, srcname ,usrfname ,usrlname from article ,asubject sh ,atype ,author, source left join user on user.userId = article.user sh where artstatus!='N' and artsourceId = sourceId and authorId = sh artauthorId and arttypeid = atypeId and asubjectId=artsubjectid and sh artauthorid=145 order by articleId desc limit 1 , 20 sh - When my application in php is getting data from mysql it gets some sh rows. And show no error. [ mysql_error() show no error] sh - When I run same query on phpmyadmin query prompt, it gives an error sh with no description. Technically there should be no big difference running the query in php or phpmyadmin, so I don't understand why this would return different answers. Yes there is, and it has caused me some grief a while ago. phpmyadmin (at least my installation) seems to add limit 0,30 to every select query you enter into the input field. i think this is to make sure that the result page is not extremely long. anyway, one *cannot* enter limit clauses in a phpmyadmin query. yes, it sucks. henning schroeder. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL startup problem - Linux 7.1
Mysql does not own its files. chown -R mysql /var/lib/mysql Dave Lake wrote: Hi folks, just signed up to the list so I hope this is the correct place to send such a question: I have recently upgraded to Red Hat Linux 7.1 from Red Hat 6.x I had successfully run MySQL under that distribution but am having problems with it under Red Hat 7.1 I have installed mysql-3.23.36 from the RPM file. When I attempt to run mysql from teh command line I get the following message: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) When I check my log file at /var/log/mysqld.log I get a message as follows: 010905 16:10:14 mysqld started 010905 16:10:14 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010905 16:10:14 mysqld ended I have checked /var/lib/mysql directory and have the following items: mysql mysql.sock test I am assuming the test directory is the test database though it doesn't contain anything. Inside the mysql directory (so inside /var/lib/mysql/mysql) I can see the following items: columns_priv.frm db.frm func.frm host.frm tables_priv.frm user.frm columns_priv.MYD db.MYD func.MYD host.MYD tables_priv.MYD user.MYD columns_priv.MYI db.MYI func.MYI host.MYI tables_priv.MYI user.MYI - I am not sure if I have included too little or too much information. above. I have attempted to figure out what I have done incorrectly by reading the installed mysql docs but can't figure out where I have gone wrong. Once I get MySQL running I more or less know what I am doing but to start it I am stumped. Any help would be appreciated. Dave Lake [EMAIL PROTECTED] p.s. Is it my imagination or did MySQL run when set up under Red Hat 6.x whereas there is more tweaking to do under Red Hat 7.1 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to do simple stuff
Deryck Henson wrote: Let me rephrase that checkbox one:: TRUE or FALSE ALTER TABLE myTable CHANGE COLUMN myColumn TINYINT(1) And you use 1 for TRUE and 0 for FALSE. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Mike Wexler [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 10:19 PM Subject: Re: How to do simple stuff Deryck Henson wrote: How do I:: Add a column ALTER TABLE myTable ADD COLUMN myColumn VARCHAR(27) Alter a table to fit a different character lengths (say...unlimited in a 1 column) ALTER TABLE myTable CHANGE COLUMN myColumn myColumn TEXT or alter column to accept an unlimited amount of characters ALTER TABLE myTable CHANGE COLUMN myColumn myColumn TEXT Make a column have a check box instead of characters(VARCHAR...) or date (DATE) mysql doesn't control your UI. You would have to reconfigure whatever software is presenting your UI. thanx - Deryck H - http://www.comp-u-exchange.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Minimal Mysql
Hi, I need to install Mysql on a 386 machine with 4 MB RAM and 32 MB Hard Drive (Flash Disk). I have small Linux running on it which has taken up about 10MB already. I need at lease 5-10 MB for the DB and my files. Is it possible to install Mysql Server (stripped) in this limited space? I surely don't want any documentation or other things that are not needed. It will be mainly used for select, insert, select and updates. Has anyone tried a similar thing (and succeeded ??) ?. Detailed document would be great if someone can direct me to that. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ANN: EMS MySQL Manager
Does your message mean we'll see no more Escapade announcements on this list? That would be unfortunate, but by the same token, should the EMS client become available in a Linux version, an announcement on this list might be of interest to several of the readers. No, simply because we don't sell Escapade - it's a freebie. You can go out and download it right now, in fact - no credit card needed, etc. Free download, free upgrades, free help. The engine is not where we make any money at all. Just because it's not OpenSource doesn't mean it's for sale. It's not a teaser product that you have to buy something else to make it work, it's not crippleware, it's not even expireware anymore. Free, free, FREE. Call me altruistic - maybe it's just my way of saying thank you to all the folks out there (including you, Paul) that have done so much to make MySQL the great, free database that it is. When we first started working on the engine, I jumped up and down to make it free and keep it free, and that's the way it will stay. It was a useful tool for me, and it's turned out to be a useful tool for a lot of other people, too. On the other hand, I didn't see any free downloads for the EMS product. It seems like it's completely for profit, and I resent the list used for trying to sell software. We even have a free version of a script that does what PHPMyAdmin does - completely written in Escapade. It's *one* Escapade script, not a bunch of PHP scripts and shell scripts like PHPMyAdmin is. It works, it does everything I do in my day-to-day MySQL maintenance, and you know what, Paul? It's also free. The only reason we haven't put out an announcement is because we're busy putting the graphics together so it looks nice :) I have no problem people posting announcements of free stuff to the list. But I draw the line at stuff that people want me to pay money for - I get enough of that in email. But that's just my opinion - others no doubt have different opinions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Can't get MySQL running on Win2K
Heikki, Thanks for the reply. Since I don't even know what InnoDB' is, obviously I don't want it ;-) I tried adding the line 'skip-innodb' to the [mysqld] section in C:\my.cnf as you suggested but it didn't make any difference. I wonder whether that file is actually read, since I next tried *moving* the whole [mysqld] section to R:\Win2000\my.ini - this time the error does not appear when I try mysqld --standalone. However, it still hangs: in the command-line window it never returns to the command prompt. (Though I can close the command-line window and mysqld remains loaded - it actually *should* return to the prompt. Buglet?) Should my.cnf actually be on R:\ on my system since that is the root of the _system_ drive when I run Win2K (while C: definitely isn't)? Cheers, At 15:11 2001-09-06 +0300, Heikki Tuuri wrote: Marjolein, if you do not want to use transactional InnoDB tables, add skip-innodb [snip] Heikki http://www.innodb.com Configuration: multiboot system. C: is for DOS and System Commander, R: is for Win2K. \ (Most) applications go on F:, (most) data goes on P:. - I installed MySQL to F:\Development\Database\MySQL - I edited my-example.cnf and added [mysqld] basedir=F:/Development/Database/MySQL/datadir=P:/MySQL/ then Save as to C:\my.cnf (do I *really* have to store this on a drive that's \ reserved for DOS and multiboot?) The installation created databases 'mysql' and \ 'test' on F: - I copied these to the designated data location on P:. - I ran winmysqladmin.exe, created an .ini file and designated mysqld-nt.exe as the \ service, then tried to start it. The traffic light remains red. (The ini file is in \ the Windows directory: R:\WIN2000\my.ini ) - Tried MySqlManager.exe which wants to \ connect to localhost - but can't connect. - In the Services applet, mysqld-nt.exe is \ registered as a service, automatic, but not started. - After reboot, same situation: \ the service is automatic, but not started. Trying to start results in an error. - \ Removed the service with F:\Development\Database\MySQL\bin\mysqld-nt --remove - Tried \ to start mysqld in debug mode with F:\Development\Database\MySQL\bin\mysqld --debug \ --standalone this results in an error: Can't initialize InnoDB as \ 'innodb_data_file_path' is not set and mysqld hung - I had to kill it from task \ manager. - Tried to start mysqld (no debug) with \ F:\Development\Database\MySQL\bin\mysqld --standalone this results in the error - I \ had to kill it from task manager again. (Note: while mysqld hangs, \ winmysqladmin.exe's traffic light in the system tray is green, so it does detect if \ mysqld is running.)Now what?Thanks,Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQLGUI
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: First, if there is an FAQ or installation documentation please direct me there and I'll review before requesting assistance. If there is neither, I am unable to successfully run mysqlgui on the following platform: Sun Ultra 10 running Solaris 8 with current Recommended installed, mysql version MySQL3.23.41, and mysqlgui-solaris-2.7-sparc-static-1.6.gz. mysqlgui is installed in /usr/local/mysql/bin. I receive the following error when starting the gui: ld.so.1: mysqlgui: fatal: libstdc++.s0.2.10.0: open failed: No such file or directory Killed /usr/local/lib is in the PATH and this file exist with mod = 555. Isn't there an ldconfig or similar for Solaris? You'd need to configure /etc/ld.so (or whatever the equivalent is on Solaris), then run ldconfig to tell the run-time library loaded where to look for the required libraries. Try man ldconfig. Good luck! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent
Your question is not clear. Show us what you entered, and what the error message was. snehalata wrote: Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks, Sneha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ANN: EMS MySQL Manager
Paul DuBois wrote: Complete price list you can find at http://www.mysqlmanager.com/purchase.phtml Q. Why should I pay $95 for your product when I can download and use PHPMyAdmin (or any number of other products) for free? Legitimate question. A feature comparison could be usefl. We consider that our product -- EMS MySQL Manager -- is better than any other free product of this kind. Above of that, we realize a technical support for all registered users, frequently update and improve this product. Moreover, for a while MySQL Manager costs $65, not $95. To pay or not to pay - let everyone think by themselves. Regards, Igor Brynskich --- mailto:[EMAIL PROTECTED] http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Can't get MySQL running on Win2K
Date: Thu, 06 Sep 2001 17:24:21 To: Marjolein Katsma [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re:Can't get MySQL running on Win2K X-Attachments: C:\MY.CNF; Hi! I think it is best to have only one my.ini or my.cnf in your system. Otherwise there will be confusion. If MySQL finds your my.* then the place is obviously ok. I am running .37 on NT. I got the following printout at command prompt: ... C:\trybuild\client_debugmysqld --standalone mysqld: ready for connections 010906 17:15:58 mysqld: Normal shutdown 010906 17:15:58 mysqld: Shutdown Complete C:\trybuild\client_debugmysqld --console mysqld: ready for connections 010906 17:16:14 mysqld: Normal shutdown 010906 17:16:15 mysqld: Shutdown Complete ... But when I deleted my.cnf, I got: ... C:\trybuild\client_debugmysqld --console Can't initialize InnoDB as 'innodb_data_file_path' is not set mysqld: ready for connections 010906 17:18:15 mysqld: Normal shutdown 010906 17:18:16 mysqld: Shutdown Complete C:\trybuild\client_debugmysqld --standalone Can't initialize InnoDB as 'innodb_data_file_path' is not set but I was not able to connect to the MySQL server. This suggests that your my.cnf is missing something. Look in the MySQL manual about startup options. Regards, Heikki At 03:53 PM 9/6/01 +0200, you wrote: Heikki, Thanks for the reply. Since I don't even know what InnoDB' is, obviously I don't want it ;-) I tried adding the line 'skip-innodb' to the [mysqld] section in C:\my.cnf as you suggested but it didn't make any difference. I wonder whether that file is actually read, since I next tried *moving* the whole [mysqld] section to R:\Win2000\my.ini - this time the error does not appear when I try mysqld --standalone. However, it still hangs: in the command-line window it never returns to the command prompt. (Though I can close the command-line window and mysqld remains loaded - it actually *should* return to the prompt. Buglet?) Should my.cnf actually be on R:\ on my system since that is the root of the _system_ drive when I run Win2K (while C: definitely isn't)? Cheers, At 15:11 2001-09-06 +0300, Heikki Tuuri wrote: Marjolein, if you do not want to use transactional InnoDB tables, add skip-innodb [snip] Heikki http://www.innodb.com Configuration: multiboot system. C: is for DOS and System Commander, R: is for Win2K. \ (Most) applications go on F:, (most) data goes on P:. - I installed MySQL to F:\Development\Database\MySQL - I edited my-example.cnf and added [mysqld] basedir=F:/Development/Database/MySQL/datadir=P:/MySQL/ then Save as to C:\my.cnf (do I *really* have to store this on a drive that's \ reserved for DOS and multiboot?) The installation created databases 'mysql' and \ 'test' on F: - I copied these to the designated data location on P:. - I ran winmysqladmin.exe, created an .ini file and designated mysqld-nt.exe as the \ service, then tried to start it. The traffic light remains red. (The ini file is in \ the Windows directory: R:\WIN2000\my.ini ) - Tried MySqlManager.exe which wants to \ connect to localhost - but can't connect. - In the Services applet, mysqld-nt.exe is \ registered as a service, automatic, but not started. - After reboot, same situation: \ the service is automatic, but not started. Trying to start results in an error. - \ Removed the service with F:\Development\Database\MySQL\bin\mysqld-nt --remove - Tried \ to start mysqld in debug mode with F:\Development\Database\MySQL\bin\mysqld --debug \ --standalone this results in an error: Can't initialize InnoDB as \ 'innodb_data_file_path' is not set and mysqld hung - I had to kill it from task \ manager. - Tried to start mysqld (no debug) with \ F:\Development\Database\MySQL\bin\mysqld --standalone this results in the error - I \ had to kill it from task manager again. (Note: while mysqld hangs, \ winmysqladmin.exe's traffic light in the system tray is green, so it does detect if \ mysqld is running.)Now what?Thanks,Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html Marjolein Katsma [EMAIL PROTECTED] Java Woman - http://javawoman.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
create database problem
Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to do simple stuff
http://www.anse.de/mysqlfront/ Use a GUI it's a lot easier - Original Message - From: Attila Soki [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, September 05, 2001 11:03 PM Subject: Re: How to do simple stuff hi | Add a column add an integer column: alter table sometable add somecolumn int; add an varchar column: alter table sometable add somecolumn varchar(255); see: mysql doc 7.8 Alter table syntax | Alter a table to fit a different character lengths |(say...unlimited in a 1 column) simply specify the new column parameters: alter table sometable modify tooshortcolumn varchar(255); note: unlimited column length not exists. if you need a realy BIG character type column try the text types (text mediumtext, etc...) see mysql doc: 7.3 Column types sorry i can't understand this: | Make a column have a check box instead of characters(VARCHAR...) bye, ati - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create database problem
Show us what you type, and what error message you get. Emiliano Carlesi wrote: Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help about date conversion ...
Paul DuBois wrote: At 9:27 AM -0300 9/6/01, Amilton Martins wrote: I want to write date type in the format DD/MM/ to the database? Can I do this with some parameter to mysql.ini? No. For storage, you must convert it to CCYY-MM-DD format. For display, you can format it to the style you want using DATE_FORMAT(d,'%d/%m/%Y'). Besides, dates like DD/MM/ are evil. Remember that Europe uses DD.MM. while we crazy americans use MM/DD/. That can cause lots of confusion esp. if the day of the month is less than 13. And, if your dates are of the form -MM-DD you can use strcmp( ) in C; eq/lt/gt in perl; or /=/ in PHP to compare dates. That alone is a big reason to use the -MM-DD form in my book. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help -- can't install mysql as service in win2k
Hi all, I have uninstall mysql3.23.39 from Win2k and after I install mysql3.23.41-max ... I was unable to run it as service. When I tried to start the service I receive the following message ... Could not start the MySql service on Local Computer Error 1067: The process terminated unexpectedly. Any idea how I can fix this? Many thanks to any suggestions. Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to do simple stuff
Mike Wexler wrote: Deryck Henson wrote: Let me rephrase that checkbox one:: TRUE or FALSE ALTER TABLE myTable CHANGE COLUMN myColumn TINYINT(1) And you use 1 for TRUE and 0 for FALSE. Or ENUM: ALTER TABLE myTable CHANGE COLUM myColumn ENUM( 'T', 'F' ); Of course if you are using this to drive a web page Mike's solution is better. Or you would want to enum( 1, 0 ) or enum( '1', '' ); --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Performance Problem
hi wesley and the gang, thank you very much for your help so far. i optimized the indexes and added another one i obviously forgot before, and the database is smoother now. a bit at least, it now maxes out at 65q/s instead of 50... At 13:12 06.09.01, you wrote: idea? And how am I supposed to find the slow queries? Find all the queries that interact with this table. EXPLAIN them. Time them. *all* of them? there are lots. as said before, it is the main user table. a user account is updated every time somebody request a page. and i need to join to that table very often to find out, when the corresponding user logged in last and what his name is. bad design? bad idea? what do you think? i could split these queries below into multiple queries, first getting the userid and then firing off another query to get the name (without a join). but i thought letting the database handle this should be faster. select * from cookies left join users on cookies.uid=users.uid left join sessions on users.uid=sessions.uid where cookies.cookie=e3bd03382561eb3619b66fbea2af217d; select * from cookies left join users on cookies.uid=users.uid left join extended on users.uid=extended.uid where cookies.cookie=5226220e3b62cef71a13524ec7a413ac; (above queries have to be performed at the beginning of every webpage to find the current user. i don´t really think they are slow; they just lock because of something else.) i just tried the above query ten times. result: 7x 0.00sec, 1x0.01, 1x0.02, 1x0.04. does that spell slow? Yes. I wouldn't let queries with times like these near a busy production server I was responsible for unless I was positive they wouldn't and couldn't happen more than a handful of times a day. :-) Post the output of EXPLAIN for these queries. Along with the create defns for these other tables. mysql explain select * from cookies left join users on cookies.uid=users.uid left join extended on users.uid=extended.uid where cookies.cookie=ee33c9ec7950a1e5c39f37bf72d2de51; +--+---+---+-+-+---+--+---+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+---+---+-+-+---+--+---+ | cookies | const | PRIMARY | PRIMARY | 32 | const |1 | | | users| const | PRIMARY | PRIMARY | 4 | const |1 | | | extended | const | PRIMARY | PRIMARY | 3 | const |1 | | +--+---+---+-+-+---+--+---+ 3 rows in set (3.35 sec) mysql explain select * from cookies left join users on cookies.uid=users.uid left join sessions on users.uid=sessions.uid where cookies.cookie=5c50d7a7319ae6c8529f535aa5f19109; +--+---+---+-+-+---+--+---+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+---+---+-+-+---+--+---+ | cookies | const | PRIMARY | PRIMARY | 32 | const |1 | | | users| const | PRIMARY | PRIMARY | 4 | const |1 | | | sessions | const | PRIMARY | PRIMARY | 4 | const |1 | | +--+---+---+-+-+---+--+---+ 3 rows in set (4.55 sec) doesn´t look too bad for me. except that timing information at the end :-(. but that´s because the database is almost completely locked up again (processlist full of queries with Locked status). the table definition is quite long, i´ll append it to the end of the mail. On a busy database (thousands of queries per second), it doesn't take long for the whole database to get totally bogged down if a massive web of blocks happens like this. And mysqld doesn't always recover. well, yes. i noticed that :-(. thank you for your good explanation though. but i think it´s probably not very fruitful to look for queries in the processlist that have locked status, because they are probably not the slow ones that caused the block. am i correct? Banning queries that take longer than 0.00 seconds at the mysql prompt (run them a few times - one or two 0.00s and it's suspect) is just a handy rule of thumb for measuring nastiness of queries. For proper measurements, one could benchmark queries - or one could stick a unique comment into every query and just watch processlists. You will come to recognise the common slow queries because you will see them in the processlists often! i also tried logging the queries that appear often with copying to temp table status and now have a nice set of them, though i don´t quite understand *why* the are copying. below are two: (the rows count is *way* to high, probably because the timestamps are ancient by the time i ran explain select) select count(*) from adviews where click=f and uid=7618 and cid=11 and datestamp=999782664 mysql explain
Re: fields query
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Adams, Bill TQO [EMAIL PROTECTED] writes:
I need to read the fields of a table dynamically using
DBI.pm
The resulting cgi script should be a form that has a
checkbox for each field...the user will then create a
temporary table based on which fields are checked in
the form.
my $dbh = DBI-connect( ... );
my $sth = $dbh-prepare( SHOW COLUMNS FROM $table ) or die;
$sth-execute( ) or die;
my @columns;
while( my( $column_name ) = $sth-fetchrow_array( )){
push @columns, $column_name;
}
$sth-finish( );
This is complicated and not portable. perldoc DBI shows a better method:
my @columns = @{$sth-{NAME}};
That only works if you have already done a select. I think the original
poster wanted to get the column names before a query was run so that the user
could choose via the web page which columns to download. The full code for
your portable solution would be:
my $dbh = DBI-connect( ... );
my $sth = $dbh-prepare( SELECE * FROM $table ) or die;
$sth-execute( ) or die;
my @columns = @{$sth-{NAME}};
$sth-finish( );
Which could be bad if the table was really big and the alternative database in
question was not smart enough to just start returning data. (And, of course,
LIMIT in MySQL is not portable either.) Or the table was locked for some
reason.
No, mine is not portable. (I am thinking of writing an addition to DBI to
abstract some of the non-portable things e.g. getting the column names from a
table, getting the table names, getting the ID of an auto-increment column,
etc..) But it also will not suffer from locking problems. And one could
surround the code with:
if( $dbh-{Driver}{Name} eq 'mysql' ){
...
}elsif( $dbh-{Driver}{Name} eq 'Informix' ){
...
} else {
die I do not know how to get column names from ,
$dbh-{Driver}{Name};
}
For reference here is how you do it in Infomix and InterBase:
my @list = $dbh-func( $table, '_columns' );
foreach my $column (@list) {
$column-[3] =~ s/\s+//g; #remove trailing space.
push @columns, $column-[3];
}
And PostgreSQL:
my @list = $dbh-func( $table, 'table_attributes' );
foreach my $x (@list) {
foreach my $column (@$x) {
$column-{NAME} =~ s/\s+//g; #remove trailing space.
push @columns, $column-{NAME};
}
}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions. Obviously, given the fact that the libraries are being called directly by the application, the amount of multi-threading done by the application is most emphatically relevant. cut Just a note about this; I have now updated the section 'How to Make a Thread-safe Client' with more information regarding this. This should be available on our web site shortly. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi! I have a small comment to this. Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: cut I have no interest in any other clients except possibly to investigate whether or not they produced anything like the same behaviour that I am observing with my own application. My only key objective is to fix my application, which, to repeat again, is coredumping during calls to DBUG functions within the mysqlclient and MyODBC libraries. Regards, Peter Sinisa Exactly what I mean. There are several multithreaded clients out there Sinisa all using libmysqlclient and some MyODBC and none of them experience Sinisa the problems you describe. Note that you will get crashes in the DBUG package if you call any MySQL function inside a thread that hasn't called mysql_init() or mysql_connect(). If you want to use MySQL functions in threads that doesn't call the above functions, you need to call my_thread_init() at the start of the thread and my_thread_end() before the thread ends. If you think that the DBUG functions are the ones that is causing problems, you can always recompile MySQL without --with-debug, in which the DBUG macros will not generate any code. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UNLOCK TABLES implementation question...
hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy I've run across a need that has made we want to extend the way UNLOCK Jeremy TABLES works. And after looking at the manual: Jeremy http://www.mysql.com/doc/L/O/LOCK_TABLES.html Jeremy I see that one of the reader comments gets at the same question I Jeremy have. Jeremy Why can't I unlock named tables? Why must I unlock them all at once? Jeremy I understand that you can NOT lock more tables once you have any table Jeremy locks (to prevent deadlocks), but is there any reason it would be Jeremy unsafe to selectively unlock tables? Not really; This could be done without compromising the locking mechanism. (MySQL actually already do this internally in some cases) Jeremy I've been thinking about it and poking at the code a bit, but I can't Jeremy think of any reason why it'd be a problem. There isn't. Jeremy I've looked at the code a bit and it doesn't seem to difficult to Jeremy implement, but if it just won't work for some reason, I'd rather know Jeremy now so that I don't spend any time on it. The only thing you need to do is to call: sql/lock.cc::mysql_unlock_some_tables() with the tables you want to unlock and then remove them from the thd-locked_tables list. Jeremy If anyone is interested, I can elaborate on the need for this. No need for it; I think I know why you would like to do this. If you need more input about this, don't be afraid to ask ;) Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23 and DELETRE FROM very long.
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa BAUMEISTER Alexandre writes: Bonjour, With 3.22 I used to do some queries like DELETE FROM TABLE. And this was very rapid as Mysql only deletes and re-create the files. I knew that DELETE was very long with InnoDB because it has to clear all the table space used by the table from which you DELETE. But I'm surprised to see that it's very long with MyISAM too ! This happens if you are using MySQL-Max and has Innodb activated. This is fixed in MySQL 4.0 When I do a DELETE FROM TABLE (without any where) on a big table, it takes many minutes. And if I look at the table files, while the table is empty, the files are still very big. The only way to reduce space used by the table is OPTIMIZE. Is this normal ? Is this a difference between ISAM an MyISAM ? I saw no notice about that in the documentation ... Regards, Alex. Sinisa Have you tried TRUNCATE command ?? Unfortunately this will not help in MySQL 3.23 as this is internally changed to DELETE FROM TABLE. In MySQL 4.0 TRUNCATE doesn't have this problem and should always be fast. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Password Issues with 3.23.41
Is anyone running into Database login problems with Mysql 3.23.41? -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Performance Problem
Henning Schroeder wrote: i also tried logging the queries that appear often with copying to temp table status and now have a nice set of them, though i don´t quite understand *why* the are copying. below are two: (the rows count is *way* to high, probably because the timestamps are ancient by the time i ran explain select) It is copying ALL of the results into the temp table. If you can (e.g. you know you will never want more than N records), add a LIMIT 0,N to the end of the SELECT so that when you have an old timestamp it will not hang the database. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help -- can't install mysql as service in win2k
At 08:27 06/09/2001 -0700, Michael Tam wrote: Hi, When you get this type of error, do the following process: - Verify in your SCM the state of the service. You should see that it isn't initiated. - Open a DOS screen at \mysql\bin - Remove the service: mysqld-max-nt --remove - Start the server as standalone: mysqld-max-nt --standalone - Take a look in the message error. Correct them. - Install again the service and start it as usual. Also, before to do the above, you can find the problem in the \mysql\data\mysql.err file. If you aren't able to resolve the problem. Send me the print of the message errors when you start the server as standalone and the last lines from mysql.err. Regards, Miguel Hi all, I have uninstall mysql3.23.39 from Win2k and after I install mysql3.23.41-max ... I was unable to run it as service. When I tried to start the service I receive the following message ... Could not start the MySql service on Local Computer Error 1067: The process terminated unexpectedly. Any idea how I can fix this? Many thanks to any suggestions. Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
finding out about mysql locks
Hi! Is there a way or command for mysql that shows me a) what tables are currently locked b) with what kind of lock c) which query caused the lock d) and maybe how long the lock exists? I usually try to figure out via mysqladmin processlist and look for the one query that isn´t locked as the cause, but sometimes it just seems like everything is locked. henning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access denied
How can one rectify the following? Warning: Access denied for user: 'myuser@localhost' (Using password: YES) in /usr/home/lee24/html/therapytables/new/lib/dblib.php on line 24 Can't connect to localhost as myuser MySQL Error: Access denied for user: 'myuser@localhost' (Using password: YES) This script cannot continue, terminating. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
small mysqlshow bug
I beleive this is a bug in mysqlshow: I have a database with an underscore in it's name (which is valid), but mysqlshow thinks I'm trying to do a wildcard and lists databases which match the pattern instead of showing what I want it to show. For instance: If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown. user@host - /ascend/sql/bin/mysqlshow --status ascend_logs Wildcard: ascend_logs +-+ | Databases | +-+ | ascend_logs | +-+ -- Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Performance Problem
At 17:52 06.09.01, you wrote: It is copying ALL of the results into the temp table. If you can (e.g. you know you will never want more than N records), add a LIMIT 0,N to the end of the SELECT so that when you have an old timestamp it will not hang the database. as i use select count (*) from blah where blahblah; (actually i am just interested whether there is a row or not matching the criterion. under normal operations there should never be more than one match) i don´t understand how a limit 0,1 would help here. wouldn´t it just say that no more than one count(*) result should be returned (which never the case anyway because count(*) returns exactly one row)? henning - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Auto Importing
Mike wrote: Is there a way to continualy update a MySQL database with an Excell file? Reason: Just to have some fun I am building a Code Red hall of shame in PHP and MySQL. I am anoyed from cleaning XX's and NN's all day in my Apache logs.And they call Open software Virul... And Instead of complaining I thought this might be better to point the ISP to a page they can see for themselves. I can do this daily but an automated way would be nice. Why would you pass the log through Excel? A perl script might be better. In answer to your first question: I do not know about directly from Excel but you could set up a macro in MS Access to get the data from Excel and then update the MySQL table. And then set that to run periodically. If you REALLY hate yourself and Apache/PHP are on the same machine as the Excel file, you could query the Excel spreadsheet via ODBC. But you loose all DBA Karma points if you do. ;-) --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to do simple stuff
At 17:25 06.09.01, you wrote:
Or ENUM:
ALTER TABLE myTable CHANGE COLUM myColumn ENUM( 'T', 'F' );
Of course if you are using this to drive a web page Mike's solution is better.
Or you would want to enum( 1, 0 ) or enum( '1', '' );
yes, but do *not* use enum('t','f') because with some fonts they are not
easily distinguised. it is not very funny to find the one f within a
column of 30 ts. :-)
and think about clever defaults here.
henning
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Performance Problem
Henning Schroeder wrote: At 17:52 06.09.01, you wrote: It is copying ALL of the results into the temp table. If you can (e.g. you know you will never want more than N records), add a LIMIT 0,N to the end of the SELECT so that when you have an old timestamp it will not hang the database. as i use select count (*) from blah where blahblah; (actually i am just interested whether there is a row or not matching the criterion. under normal operations there should never be more than one match) i don´t understand how a limit 0,1 would help here. wouldn´t it just say that no more than one count(*) result should be returned (which never the case anyway because count(*) returns exactly one row)? I misread your email. I thought you had a query that was 'copying into temp table' that was not the COUNT(*) query. Rereading your email, I see that for me it is better to remain silent than remove all doubt. ;-) Do your two queries both take a long time? What if you add a key on type and timestamp (in that order). select count(*) from adviews where click=f and uid=7618 and cid=11 and datestamp=999782664; select count(*) from chat where type=msg and timestamp999783881; --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ANN: EMS MySQL Manager
Paul DuBois wrote: At 6:54 AM -0500 9/6/01, Ed Carp wrote: Igor Brynskich ([EMAIL PROTECTED]) writes: First, thanks to everyone who interested in our product -- EMS MySQL Manager -- and answered to our previous announce! This message intended for shed light on some questions regarding EMS MySQL Manager. On which operating system does MySQL Manager works? Currently, MySQL Manager works on Windows 95/98/NT/ME/2000 operating systems. Linux version will be available soon. How much does EMS MySQL Manager costs? Q. Why should I pay a lot of attention to a company who spams a technical list in order to sell product under the guise of answering questions? It is common practice NOT to post such messages on a list such as this one... a development or support list. However; I do not consider an occasional ANN post a real problem... particularly for a 1st release of a 'relevant' product. Now about the getting [mysql] in the subject line... Peter BTW: Is libmysql.so/mysql.dll LGPL? In other words ok to distribute, alone, with a commercial product? -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:Can't get MySQL running on Win2K
Heikki, Thanks a lot for your help! This mail list is a great resource (but I knew that already ;-)) Now that I have moved the whole [mysqld] section from C:\my.cnf to R:\Win2000\my.ini and rebooted, everything has started to work - the service now starts automatically. (If something else will appear not to work, I know where to look now.) I've since tried MySQL-Front as a GUI client and that works perfectly as well. (Background: I only tried installing MySQL locally as a workaround because I could not get MyODBC working to connect from Access2000 to MySQL on my (web) server - and I did try _everything_ I found in the manual and on this list (latest versions, patches, etc.)! Now with MySQL running locally and MySQL-Front I will be able to do it the other way round: import from Access to local MySQL (using the ODBC sriver for Access rather than MyODBC, of course), and then export to MySQL on the server, both using MYSQL. That way I can design a database and enter basic (static) data with Access, and when done, export to the server. I haven't tested all the steps yet but I did successfully import a table from Access2000 and I can successfully connect to the server on my web host.) Thanks again - problem solved within one day! At 17:25 2001-09-06 +0300, Heikki Tuuri wrote: Date: Thu, 06 Sep 2001 17:24:21 To: Marjolein Katsma [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re:Can't get MySQL running on Win2K X-Attachments: C:\MY.CNF; Hi! I think it is best to have only one my.ini or my.cnf in your system. Otherwise there will be confusion. If MySQL finds your my.* then the place is obviously ok. [snip] But when I deleted my.cnf, I got: ... C:\trybuild\client_debugmysqld --console Can't initialize InnoDB as 'innodb_data_file_path' is not set mysqld: ready for connections 010906 17:18:15 mysqld: Normal shutdown 010906 17:18:16 mysqld: Shutdown Complete C:\trybuild\client_debugmysqld --standalone Can't initialize InnoDB as 'innodb_data_file_path' is not set but I was not able to connect to the MySQL server. This suggests that your my.cnf is missing something. Look in the MySQL manual about startup options. Regards, Heikki Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help -- can't install mysql as service in win2k
Michael, Have a look at the thread Can't get MySQL running on Win2K (started by me) - I have it working now (thanks Heikki!) and the solution might be of use to you as well. At 08:27 2001-09-06 -0700, Michael Tam wrote: Hi all, I have uninstall mysql3.23.39 from Win2k and after I install mysql3.23.41-max ... I was unable to run it as service. When I tried to start the service I receive the following message ... Could not start the MySql service on Local Computer Error 1067: The process terminated unexpectedly. Any idea how I can fix this? Many thanks to any suggestions. Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Marjolein Katsma HomeSite Help - http://hshelp.com/ Bookstore for Webmasters - http://hshelp.com/bookstore/bookstore.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQLGUI
As Ed said, you need to make sure that ld.so.1 is in your path. At 09:03 -0500 2001/09/06, Ed Carp wrote: Isn't there an ldconfig or similar for Solaris? You'd need to configure /etc/ld.so (or whatever the equivalent is on Solaris), then run ldconfig to tell the run-time library loaded where to look for the required libraries. In Solaris, the environment variable is LD_LIBRARY_PATH. Try man ld.so.1. [EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: First, if there is an FAQ or installation documentation please direct me there and I'll review before requesting assistance. If there is neither, I am unable to successfully run mysqlgui on the following platform: Sun Ultra 10 running Solaris 8 with current Recommended installed, mysql version MySQL3.23.41, and mysqlgui-solaris-2.7-sparc-static-1.6.gz. mysqlgui is installed in /usr/local/mysql/bin. I receive the following error when starting the gui: ld.so.1: mysqlgui: fatal: libstdc++.s0.2.10.0: open failed: No such file or directory Killed /usr/local/lib is in the PATH and this file exist with mod = 555. Try man ldconfig. Good luck! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'tmp/mysql.sock' (2) error
Ed, 1. Is MySQL actually running? Yes. 2. If so, where is it putting mysql.sock? It is putting it into /raid/mysql/data/mysql41.sock -- I specified this location in the socket variable(?) in both [client] and [mysqld] sections of the my.cnf file. my.cnf is located in /raid/mysql/data; there are no other my.cnf files in the filesystem. 3. If it's in /var/lib/mysql/mysql.sock, the quick fix is to do ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock. Actually, I want to specify the different location described in #2 in preparation for my setting up 3.23.41 on a box where 3.22.21 is already running. Because the older version uses /tmp/mysql.sock, I don't have the option of creating the symlink for 3.23.41. I know that I can run configure to set different socket and port locations, but I'd rather handle this through my.cnf if at all possible. I can get the port definition to work via my.cnf, but the socket gives the mysql client fits. 4. Where is my.cnf located - you didn't say. Again, /raid/mysql/data. 5. What application are you trying to run that gives the error - again, you didn't say. Just the command-line mysql client that is packaged with the binary. Thanks in advance for your help, Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQLGUI
[EMAIL PROTECTED] writes: First, if there is an FAQ or installation documentation please direct me there and I'll review before requesting assistance. If there is neither, I am unable to successfully run mysqlgui on the following platform: Sun Ultra 10 running Solaris 8 with current Recommended installed, mysql version MySQL3.23.41, and mysqlgui-solaris-2.7-sparc-static-1.6.gz. mysqlgui is installed in /usr/local/mysql/bin. I receive the following error when starting the gui: ld.so.1: mysqlgui: fatal: libstdc++.s0.2.10.0: open failed: No such file or directory Killed /usr/local/lib is in the PATH and this file exist with mod = 555. In advance, thank you for the assistance. You have to add /usr/local/lib to LD_LIBRARY_PATH. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'tmp/mysql.sock' (2) error
create a .my.cnf in the home directory of the user that will be running the clients, and enter a [client] paragraph that defines the socket. BW wrote: Ed, 1. Is MySQL actually running? Yes. 2. If so, where is it putting mysql.sock? It is putting it into /raid/mysql/data/mysql41.sock -- I specified this location in the socket variable(?) in both [client] and [mysqld] sections of the my.cnf file. my.cnf is located in /raid/mysql/data; there are no other my.cnf files in the filesystem. 3. If it's in /var/lib/mysql/mysql.sock, the quick fix is to do ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock. Actually, I want to specify the different location described in #2 in preparation for my setting up 3.23.41 on a box where 3.22.21 is already running. Because the older version uses /tmp/mysql.sock, I don't have the option of creating the symlink for 3.23.41. I know that I can run configure to set different socket and port locations, but I'd rather handle this through my.cnf if at all possible. I can get the port definition to work via my.cnf, but the socket gives the mysql client fits. 4. Where is my.cnf located - you didn't say. Again, /raid/mysql/data. 5. What application are you trying to run that gives the error - again, you didn't say. Just the command-line mysql client that is packaged with the binary. Thanks in advance for your help, Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: 'tmp/mysql.sock' (2) error
create a .my.cnf in the home directory of the user that will be running the clients, and enter a [client] paragraph that defines the socket. A better solution would be to do it in /etc/my.cnf, so that it will be system-wide for the database. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 'tmp/mysql.sock' (2) error
A better solution would be to do it in /etc/my.cnf, so that it will be system-wide. BINGO!!! That did it! The only additional question I have at this point, then, is what to do about my scenario where I want to run 3.22 and 3.23 concurrently on a box where the user will be the same for each one. I'm thinking that I'll have to configure the 3.23 source with port and socket options to make sure that 3.22 and 3.23 don't try to use the same port and socket values/files. If this is the case, what takes precedence, the my.cnf values, or the ones built in during configure? Thanks so much, Brian (mysql, database) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
index not incrementating
Hi, can someone tell me how the index number on the bin logs are incremented? When i update my master machine the changes are still going to $machine-name-bin.001 on my slave its looking for Log_file $machine-name-bin.002 can someone tell me how these number are incremented? the .00# how often, what causes them to increment? also another question is: what happends when the slave machine is rebooted? when it (slave) comes back up does the slave update the database with all the inserts, deletes that happended in the time it took to boot up? I tried rebooting the slave and updating the master and when the slave came back up it was just in a state of waiting for new changes...it did not populate the missing data. Did i do something wrong? I am fairly new to replication and researching weather it is a feasible and safe transition to go to for our production machines. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Virtualizing MySQL
Dear Kyle, Thank you for your response. What I was attempting actually led to a security hole for clients. I am implementing your method instead as it appears to be a solution which would work well. Thanks so much for such a detailed response. Best regards, Mustafa. - Original Message - From: Kyle Hayes [EMAIL PROTECTED] To: Mustafa Hashmi [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 31, 2001 9:08 AM Subject: Re: Virtualizing MySQL On Thursday 30 August 2001 14:09, Mustafa Hashmi wrote: Thanks for the response Joshua, That is an option - however not one I would be very comfortable with. I have a similar setup for virtual hosts generally - wanted something more flexible and powerful for a virtual server implementation without taxing the actual server too much. For example, the mail server (qmail) is not chrooted as such - however pop is chrooted via tcpserver, delivering messages to users in a virtual env. SMTP works the same way, chrooting to say /home/user/etc/tcp.cdb to check relay. Unfortunately, I know little about the actual how-does-it-work part of MySQL and need some direction :) I am going to try something in the next 3-4 days and hopefully I'll post a positive outcome. If this works, I'll write a HowTo :) anti-Spam: database, query, SQL, MySQL We run multiple instances of MySQL on the same machine. We use the ability of the MySQL server to get its configuration from a file. For instance, we have three instances on one machine that all run from different directories. We organize the directories like this: instance1: /...blah blah.../instance1/bin/ --- special scripts for this instance /...blah blah.../instance1/etc/ --- config for this instance /...blah blah.../instance1/log/ --- logs for this instance /...blah blah.../instance1/data/ --- database data for this instance /...blah blah.../instance1/run/ -- PID file + socket for this instance instance2: /...blah blah.../instance2/bin/ --- special scripts for this instance /...blah blah.../instance2/etc/ --- config for this instance /...blah blah.../instance2/log/ --- logs for this instance /...blah blah.../instance2/data/ --- database data for this instance /...blah blah.../instance2/run/ -- PID file + socket for this instance etc In each etc/ directory for each instance, we have a my.cnf file that defines all the data directories, socket files, log file paths etc. We also make sure that each instance runs on a different port. This allows us to connect to each instance remotely as well as locally. We use a base port address (say 5000) and add the instance number. Thus instance one runs at port 5001, instance two at 5002 etc. Each instance is started by a special version of safe_mysqld (only very mildly changed) that takes an extra argument. That argument is the instance to run. It then adds the following to the command line for the mysqld binary: /.../bin/mysqld --defaults-file=/...blah blah.../instanceX/etc/my.cnf where X is the instance number and my.cnf is the specific config file for that instance. We'd run it like this: /...bin/mysql_ctrl instance1 start We have also run MySQL in a completely chroot-ed environment where each instance has its own copy of the MySQL binaries, libraries etc. This is rather a pain to set up. MySQL does have some chroot capabilities of its own, but we haven't tried them yet. There is some information in the online manual if you look for it. The native MySQL chroot capabilities plus the different config files sound more like what you want. The fully chroot-ed environment lets us run different versions of MySQL simultaneously. The different instances above require the same binary for all instances. However, each instance can be controlled entirely separately with different configurations, stopping and starting them independently etc. One of the things that makes the instances very useful for us is that the special scripts in the instance bin directories are hardcoded to use that instance. Thus, we can just cd to the instance1/bin directory and use scripts to bring up and down that instance without having to know what instance it is. We were having problems with people forgetting which instance they wanted to bring up or down and taking the wrong one down The hardcoded scripts stopped that error. Best, Kyle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
Re: MySQL Performance Problem
The queries were... select * from cookies left join users on cookies.uid=users.uid left join sessions on users.uid=sessions.uid where cookies.cookie=e3bd03382561eb3619b66fbea2af217d; select * from cookies left join users on cookies.uid=users.uid left join extended on users.uid=extended.uid where cookies.cookie=5226220e3b62cef71a13524ec7a413ac; (above queries have to be performed at the beginning of every webpage to find the current user. i don´t really think they are slow; they just lock because of something else.) i just tried the above query ten times. result: 7x 0.00sec, 1x0.01, 1x0.02, 1x0.04. does that spell slow? Yes. I wouldn't let queries with times like these near a busy production server I was responsible for unless I was positive they wouldn't and couldn't happen more than a handful of times a day. :-) Uh, we've have a lot of luck when we don't use left joins at all. Left joins seem to often make things slower. Occasionally, much slower. Other points to consider are these: 1) if you don't have an index, inserts will fly. We do some logging in MySQL and we don't have many indexes on the tables. Other places, we need to do a lot of queries on the log, so we have indexes. We will often batch copy data from one table to another where the original table has few or no indexes and the target table has several indexes. 2) as many other people have pointed out, use explain. It will show you an estimated number of rows per table that it will work through. I generally multiply those number by each other. You can quickly determine if you are going to have a really long query this way. When these are locked, not only are they waiting for the selects that came before them to finish, they are blocking selects behind them in the queue from executing simultaneously with selects ahead of them. Selects in the queue for the users table that join to other tables (and you have plenty of them) will block updates/inserts to those other tables. It has taken us a while to tune our database to do what the other post above suggests. This is good advice. It has really made a difference for us. We regularly saw an order of magnitude performance increase for several of these steps. Best, Kyle -- Quicknet has just released the following new products: Internet SwitchBoard v5.5 and MicroTelco Gateway 2.0. We have also added a new low cost carrier, Blue Star Telecom to our award winning MicroTelco services. For more information visit: www.quicknet.net or www.microtelco.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Max_data_length
Shouldn't Max_data_length on a heap table be the same as the max_heap_table_size variable as long is max_rows is not set? My heap table can grow up to about 200mb. If I set the limit max_heap_table_size at 256MB, Max_data_length ends up being around 110MB. This gives me the 'table is full' error when it grows over (about) 110MB. I had to set it at 512MB to get it at it's current value. Is this a bug or am I missing something? show table status: Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length mydata| HEAP | Dynamic| 0 |187 | 0 | 237901961 show variables: Variable_name | Value max_heap_table_size | 536869888 mysql ver 3.23.41 SunOS 5.6 Generic_105181-15 sun4u sparc SUNW,Ultra-250 --Ian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Great Bridge LLC goes out of business
Hi! I found the following from www.greatbridge.com (the principal PostgreSQL support company). Regards, Heikki Innobase Oy ... Great Bridge ceases operations Open source pioneer closes after failing to identify a qualified investor or acquirer NORFOLK, Va., September 6, 2001 Great Bridge LLC, the company that pioneered commercial distribution and support of the PostgreSQL open source database, announced today that it has ceased business operations. Great Bridge, founded in May 2000 by Norfolk, Virginia-based media conglomerate Landmark Communications, Inc., initiated a search for additional investors or an acquirer in July of this year. This search did not generate a qualified investor or acquirer, and Great Bridges board decided to close the business. During its 16 months of operations, Great Bridge recorded an impressive list of accomplishments, including assembling the industrys deepest talent pool of PostgreSQL expertise; releasing the first-ever commercially distributed version of PostgreSQL; recording more than 19,000 downloads of its Great Bridge PostgreSQL software and 40,000 downloads of its Great Bridge PostgreSQL documentation; launching www.greatbridge.org, a development community which hosted more the 100 PostgreSQL-related projects; and being named to FORTUNE magazines 25 Coolest Global Companies. The company was not able, however, to turn this momentum into revenues that met its business plan milestones. We remain convinced that open source solutions, and in particular the PostgreSQL database, present compelling and viable alternatives for business computing, said Frank Batten Jr., chairman of Landmark Communications and founder of Great Bridge. The board was not convinced that, given the current economic climate, the company could generate revenues at a level to meet the required expenses of the business within the companys funding horizon. Great Bridge will retain a limited number of employees to manage its closure. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Password error
I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' so I did it, but now mysql won't let me log in as any user, not even root. I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? -Mike Ryerse __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Password error
Mike Ryerse wrote: I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' THis will fail since there was no password, so you probably still have no password for root. The manual has a section that explains how to reset the root password if you have forgotten it. so I did it, but now mysql won't let me log in as any user, not even root. I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? -Mike Ryerse __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stability of replication?
I just wanted to know how stable is mysql databse replication is? What we have in mind is a tiered system. $master (california)-(internet ssh tunnel) \$slave (texas) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (san fransisco) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (new york) 10 other slave machines on the same network (running 5 separate db per machine) How fesible would this be? and has anyone worked with replication on a large scale? We're dealing with 2500 tables about 65k total records Read/Write to the master will be like 50 per second Any input or links to documentation is much appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
List of aggregate functions? (aggregate concat?)
I was just browsing through the searchable online MySQL manual, trying to find a list of the aggregate functions (as I don't trust the list in the O'Reilly book, considering the number of typos and missing information in other sections), and couldn't find anything.. Is there a list in the manual? If not, someone should really think of adding a section to the Functions area to list out all of the aggregate ones. On that note, I'm curious if there is an aggregate version of CONCAT or CONCAT_WS (and if there isn't, make a suggestion for the creation of them). It might also be nice for whoever writes the manual to include the minimum MySQL version supporting the function (my ISP is still using 3.22 and it's annoying to learn of a cool function only to find out that it doesn't work when I try it)... Anyway, keep up the good work... -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Password error
Mike Ryerse wrote: I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' Note, do not put a space between the -p and the password normally: mysqladmin -h host -u root -ppassword OR mysqladmin -h host -u root --password=password That may be why you cannot connect. so I did it, but now mysql won't let me log in as any user, not even root. Did you really put a space in the password? Or was that for demonstration purposes only? I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? As Gerald Clark said, the manual has a section on how to reset the password. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create database problem
Hi !!! Scuse me if before I insert few data to analize the problem :-) Now at the shell I insert the command 'mysql' then at the prompt of mysql if I insert the command 'connect test' this work and I can use sql command to work on the database. If I else insert 'connect mysql' (the other db created by the script mysql_install_db) the result is this error ERROR 1044: Access denied for user: '@localhost' to database 'mysql' If I launch mysql and when appear me the prompt 'mysql' insert the command 'CREATE DATABASE pippo;' the result is ERROR 1044: Access denied for user: '@localhost' to database 'pippo' This problem exist using all user on the system (root included). Thanks in advance for your interesting Emiliano On Thursday 06 September 2001 17:05, you wrote: Show us what you type, and what error message you get. Emiliano Carlesi wrote: Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Auto Importing
Of course. you COULD use Python, cleaner that Perl(tm) [jk no flames please] The advantage of Python, is that if you are using excel, you could go from excel [via python] into MySQL. Or you could use Python in much the same way that one could use Perl to process the log file. Of course, Py or Perl could use regexp which would be nice =). Both Perl Python are easy. [I think Python is easier =p] How is your ex-hell [excel] file being generated? Is it a .csv or is it actually an XLS? We have an excellent csv reader for python js On Thursday 06 September 2001 10:10 am, you wrote: Mike wrote: Is there a way to continualy update a MySQL database with an Excell file? Reason: Just to have some fun I am building a Code Red hall of shame in PHP and MySQL. I am anoyed from cleaning XX's and NN's all day in my Apache logs.And they call Open software Virul... And Instead of complaining I thought this might be better to point the ISP to a page they can see for themselves. I can do this daily but an automated way would be nice. Why would you pass the log through Excel? A perl script might be better. In answer to your first question: I do not know about directly from Excel but you could set up a macro in MS Access to get the data from Excel and then update the MySQL table. And then set that to run periodically. If you REALLY hate yourself and Apache/PHP are on the same machine as the Excel file, you could query the Excel spreadsheet via ODBC. But you loose all DBA Karma points if you do. ;-) --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Last Inserted Record Question
Access and MS-SQL Server have a method called @@IDENTITY used in retrieving the last inserted ID of a recordset. Is mySQL ok with that command. I suppose I could try it, but I'm interested in views etc. also. Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti.net 717.464.2970 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris Optimizations
Hello - This week we moved from running MySQL 3.23.33 on a Dual PIII 750 machine to running MySQL 3.23.41 a Sun E220 Dual UltraSparc || 450 machine. Both machines have 1 Gb of RAM, both machines are dedicated to running MySQL, both keep data and log files on seperate SCSI drives, and both are running MySQL with the following variables tweaked in the my.cnf file: key-buffer=32M sort_buffer=4M record_buffer=1M max_connections=1000 table_cache=1000 Since we have cut to the Solaris box we have been running an average of 30 queries a second vs. around 50 queries a second on the Linux box running against the same data set. We added a couple of additional tables during the move, but there should be very few queries (~ 100 queries an hour) addressing those tables and none of them are being flagged as slow queries. Does anyone have an recommendations on how we can get our performance back to (or above) where it was? I have checked the online manual and the list archive, but I haven't found anything that addresses the situation we have run into. We have already tried recompiling w/ the Sun compiler, but we are still seeing less than expected performance. True, there is *always* room for refinement of our queries, but that doesn't explain why we are experienced such a severe performance drop on the new architecture. I should also mention the we are seeing a subsequent increase in server load. We used to run between .5 and 2: now we are running between 3 and 10. I have always been told that a 450 UltraSparc should outperform 750 PIII, but that does not appear to be proving true. Any recommendations would be greatly appreciated. -F +++ Floyd Mann, Webmaster, [EMAIL PROTECTED] 503.227.2571 x 227cell. 503.806.1194 TechTracker VersionTracker MacFixIt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: stability of replication?
I have never tested with your magnitude - no where near that. You obviously would have one maching connected to the master per sub-network-cluster. [thus calling it tiered =]. I have tested over a network, using artificial packet destuction (for good measure), from a Linux box, running the master, to another Linux box running pptp, to a Win2k box (of course via pptp), with a slave server, then to one more win2k box as a slave. I had no trouble at all. The one caveat that I would mention is that I would occasionally have a bad sql statement, that was painful. I had to go from host to host doing SET SQL_SLAVE_SKIP_COUNTER=n; slave start [http://www.mysql.com/doc/R/e/Replication_SQL.html] That was painful. Also, using concurrent inserts is unsupported, i.e.: insert into table b select * from table A -or- create table dump as select important_data from table A == Alias locking is not quite the same either, and I use lots of that. But, on a whole, my new setup will use replication, things that formerly used concurrent selects will now be using a less elegant setup. I have servers in 2 levels: master slave1 slave2 (eventually I will have an online testing system that will plug in below slave2.) I use master for writes reporting queries, slave 1 for reads, and slave 2 for alias locks. In my pre-live testing scenario everything work pretty well. + It keeps everyone working well. hope all this swallop helps. js On Thursday 06 September 2001 01:36 pm, you wrote: I just wanted to know how stable is mysql databse replication is? What we have in mind is a tiered system. $master (california)-(internet ssh tunnel) \$slave (texas) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (san fransisco) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (new york) 10 other slave machines on the same network (running 5 separate db per machine) How fesible would this be? and has anyone worked with replication on a large scale? We're dealing with 2500 tables about 65k total records Read/Write to the master will be like 50 per second Any input or links to documentation is much appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: create database problem
Ok The problem are that I have checked this command but after I insert the root (unix root) and not the db root. Thanks you very much ! Emiliano --- Sheena Sidhu [EMAIL PROTECTED] wrote: emiliano , the reason you cannot use mysql to connect to use mysql database but can use test is because you do not have permissions to use mysql database. try connecting as mysql -u root -p when prompted enter the root password. after being connected, look into the users and db table of mysql database. this will give you clues why you cannot do somethings that you mentioned in ur mail. Sheena. -Original Message- From: emiliano [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 12:55 PM To: [EMAIL PROTECTED] Subject: Re: create database problem Hi !!! Scuse me if before I insert few data to analize the problem :-) Now at the shell I insert the command 'mysql' then at the prompt of mysql if I insert the command 'connect test' this work and I can use sql command to work on the database. If I else insert 'connect mysql' (the other db created by the script mysql_install_db) the result is this error ERROR 1044: Access denied for user: '@localhost' to database 'mysql' If I launch mysql and when appear me the prompt 'mysql' insert the command 'CREATE DATABASE pippo;' the result is ERROR 1044: Access denied for user: '@localhost' to database 'pippo' This problem exist using all user on the system (root included). Thanks in advance for your interesting Emiliano On Thursday 06 September 2001 17:05, you wrote: Show us what you type, and what error message you get. Emiliano Carlesi wrote: Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem, but if I want to connect the 'mysql' db (with any user, root, mysql, etc) mysql give me the error 1004 say me that the user @locahost have no the permission to do this. This error appear me if I want create a new database. In the db 'test' I can create/delete and use table. I search on line and I see more people have this problem ... but I don't find the solution. I search on the documentation but this don't solve this problem. Excuse me if this is a stupid problem Thanks in advance at all Emiliano __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Password error
On Thu, Sep 06, 2001 at 12:50:47PM -0700, Adams, Bill TQO wrote: Mike Ryerse wrote: I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' Note, do not put a space between the -p and the password normally: mysqladmin -h host -u root -ppassword OR mysqladmin -h host -u root --password=password That may be why you cannot connect. I tried it with 3.23.41 and BACKFIRE. so I did it, but now mysql won't let me log in as any user, not even root. Did you really put a space in the password? Or was that for demonstration purposes only? I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? As Gerald Clark said, the manual has a section on how to reset the password. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Auto Importing
Joshua M. Schmidlkofer wrote: Of course. you COULD use Python, cleaner that Perl(tm) [jk no flames please] Sorry. If you don't program in hex assembly you are a wussy and you drink light beer. How is your ex-hell [excel] file being generated? Is it a .csv or is it actually an XLS? We have an excellent csv reader for python I think this is the real question. Why even put the data into Excel to begin with? Write or find a parser in your favorite language that can talk directly to MySQL and skip the Excel route. --Bill Are you lookin' at me? I don't see anyone else here, you MUST be lookin at me Adams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris Optimizations
I think what you see is the fact that x86systems have overtaken workstations in some respect. have a look at spec.org for specint (which should be most relevant for databases) the same is true for memory throughput (look out for streambench) At 01:13 PM 9/6/2001 -0700, Floyd Mann wrote: Hello - This week we moved from running MySQL 3.23.33 on a Dual PIII 750 machine to running MySQL 3.23.41 a Sun E220 Dual UltraSparc || 450 machine. Both machines have 1 Gb of RAM, both machines are dedicated to running MySQL, both keep data and log files on seperate SCSI drives, and both are running MySQL with the following variables tweaked in the my.cnf file: key-buffer=32M sort_buffer=4M record_buffer=1M max_connections=1000 table_cache=1000 Since we have cut to the Solaris box we have been running an average of 30 queries a second vs. around 50 queries a second on the Linux box running against the same data set. We added a couple of additional tables during the move, but there should be very few queries (~ 100 queries an hour) addressing those tables and none of them are being flagged as slow queries. Does anyone have an recommendations on how we can get our performance back to (or above) where it was? I have checked the online manual and the list archive, but I haven't found anything that addresses the situation we have run into. We have already tried recompiling w/ the Sun compiler, but we are still seeing less than expected performance. True, there is *always* room for refinement of our queries, but that doesn't explain why we are experienced such a severe performance drop on the new architecture. I should also mention the we are seeing a subsequent increase in server load. We used to run between .5 and 2: now we are running between 3 and 10. I have always been told that a 450 UltraSparc should outperform 750 PIII, but that does not appear to be proving true. Any recommendations would be greatly appreciated. -F +++ Floyd Mann, Webmaster, [EMAIL PROTECTED] 503.227.2571 x 227cell. 503.806.1194 TechTracker VersionTracker MacFixIt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Recursive same-table lookup, operator precedence (?)
Hi, Please help me with a query. I looked in the documentation w/o success. Consider this table: mysql SELECT receiver_id, associate_of, user_name FROM receivers; +-+--+-+ | receiver_id | associate_of | user_name | +-+--+-+ | 1 |0 | arnold | | 2 |0 | barney | | 3 |0 | cecilia | | 4 |2 | diana | | 5 |2 | elmer | | 6 |3 | fred| +-+--+-+ 6 rows in set (0.00 sec) It is a recursive table design, meaning that a person can have a boss. The boss' id is stored in the associate_of column. Eg. elmer is barney's associate, barney is boss of elmer, and diana Let's say I only know the user_name 'barney', and I would like to select all his associates. I tried a subquery, as it was most logical: SELECT receiver_id, associate_of, user_name FROM receivers WHERE associate_of IN (SELECT receiver_id FROM receivers where user_name='barney'); But that returned an error. Then I tried this: SELECT receiver_id, associate_of, user_name FROM receivers where associate_of=user_name='barney'; but this gave me a bad recordset... Also, is this a legal expr.? What does it do? associate_of=(user_name='barney') How about: (associate_of=user_name)='barney' Any help is appreciated. Also, if someone could point me to the right section in the on-line doc. I did not find stuff on operator precedence or more than one '=' signs in the same expression. Thanks in advance. Yours, Balazs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
