What does optimize mean?
Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the optimize command mean? What does it do? The help file says that the -o option optimizes, but what does that mean?? I ran it on one of my databases, and most of them said OK, and some of them said table is already up to date. But I still have no idea what it did, if anything. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does optimize mean?
read the manual: http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Jesse wrote: Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the optimize command mean? What does it do? The help file says that the -o option optimizes, but what does that mean?? I ran it on one of my databases, and most of them said OK, and some of them said table is already up to date. But I still have no idea what it did, if anything. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does optimize mean?
OK, I missed it this time because I partially typed in something when searching for this in the manual. I searched for optimiz, and stopped there and ran across optimization But missed the OPTIMIZE TABLE entry. Sorry about that. I'll read through that. Thanks, Jesse - Original Message - From: Martin Jespersen [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Friday, July 28, 2006 7:59 AM Subject: Re: What does optimize mean? read the manual: http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Jesse wrote: Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the optimize command mean? What does it do? The help file says that the -o option optimizes, but what does that mean?? I ran it on one of my databases, and most of them said OK, and some of them said table is already up to date. But I still have no idea what it did, if anything. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what does Rows_examined mean exactly?
slow.log: # Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327 SELECT * FROM `post` LIMIT 771297, 30; i dp have privmary key on table `post` does 'Rows_examined: 771327' means mysqlserver read through those 771327 rows to get 30 rows? it takes 14 seconds! possible to show 'Rows_examined' in a explain or other commands? slow log is hard to debug.. and possible to optimize? _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what does Rows_examined mean exactly?
tinys xuefer wrote: slow.log: # Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327 SELECT * FROM `post` LIMIT 771297, 30; i dp have privmary key on table `post` does 'Rows_examined: 771327' means mysqlserver read through those 771327 rows to get 30 rows? it takes 14 seconds! possible to show 'Rows_examined' in a explain or other commands? slow log is hard to debug.. and possible to optimize? But you didn't use the primary key! In fact, you didn't ask for any order at all. Mysql does not try to guess that you meant to order by the primary key, it simpply does what you tell it. Your query, in effect, tells mysql to pick 771327 rows from post in any order and send you the last 30. Assuming your primary key column is named id, you need to change this query to SELECT * FROM post ORDER BY id LIMIT 771297, 30; With the explicit ORDER BY on the primary key, mysql will use the index to quickly find the 30 rows you want. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what does Rows_examined mean exactly?
hrm.. but i tried SELECT * FROM post ORDER BY postdate DESC LIMIT 771297, 30 postdate is not primary key but just an INDEX it still examined 771297 rows From: Michael Stassen [EMAIL PROTECTED] To: tinys xuefer [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: what does Rows_examined mean exactly? Date: Sun, 25 Jul 2004 10:32:49 -0400 MIME-Version: 1.0 Received: from out014.verizon.net ([206.46.170.46]) by mc4-f19.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Sun, 25 Jul 2004 07:32:49 -0700 Received: from verizon.net ([68.163.178.105]) by out014.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id [EMAIL PROTECTED]; Sun, 25 Jul 2004 09:32:49 -0500 X-Message-Info: JGTYoYF78jFocj+u73FHpy/MHvLpLYvD Message-ID: [EMAIL PROTECTED] User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 X-Accept-Language: en-us, en References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] X-Authentication-Info: Submitted using SMTP AUTH at out014.verizon.net from [68.163.178.105] at Sun, 25 Jul 2004 09:32:49 -0500 Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 25 Jul 2004 14:32:50.0020 (UTC) FILETIME=[43016240:01C47254] tinys xuefer wrote: slow.log: # Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327 SELECT * FROM `post` LIMIT 771297, 30; i dp have privmary key on table `post` does 'Rows_examined: 771327' means mysqlserver read through those 771327 rows to get 30 rows? it takes 14 seconds! possible to show 'Rows_examined' in a explain or other commands? slow log is hard to debug.. and possible to optimize? But you didn't use the primary key! In fact, you didn't ask for any order at all. Mysql does not try to guess that you meant to order by the primary key, it simpply does what you tell it. Your query, in effect, tells mysql to pick 771327 rows from post in any order and send you the last 30. Assuming your primary key column is named id, you need to change this query to SELECT * FROM post ORDER BY id LIMIT 771297, 30; With the explicit ORDER BY on the primary key, mysql will use the index to quickly find the 30 rows you want. Michael _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SHOW PROCESSLIST State Locked - what does this mean?
Hi, Currently, I have a situation where an app makes connections (via JDBC) to a mysql server, 50 connections at once, and everything just becomes super-slow. For instance, a SELECT that should take 0.01 sec takes several minutes. SHOW PROCESSLIST says that these threads that are connections from the app are in a state Locked. The mysql manual doesn't explain this option, or even list it as a possibility (maybe I'm looking at the wrong place: http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html) The other question is what one can do about this, to prevent this locking, or even diagnose it. Thanks for your help. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What Does This Mean
OK I got the database created and stuff; When in the MySQLAdmin screen under databases it doesn't show under databases. That is the first problem. And for some reason the MYSQLadmin screen list the local user name as Administrator and will not let me change it. But I can get into the mysql shell and see the database I created and I did the GRANT ALL ON MariluMessageBoards.* TO [EMAIL PROTECTED]; I also try the MySqlCC and try to get on the server and it won't let me. This is what it tells me: ERROR 1130: Host 'NapMarilu' is not allowed to connect to this MySQL server. Do I need to do something to allow me to connect? Sorry for asking so many questions, but I am puzzled... Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What Does This Mean
It says I am not allowed to connect to the mySQL server. I am trying root and admin and it won't let me in. Have I done something wrong and what do I check? Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]
Re: What Does This Mean
Did you set a password for the root account? MySQL comes with a root user that (initially) has no password and all privileges. Most setup instructions have you assign a password to the root account pretty early on. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What does this Mean
C:\MySQL\binmysql show ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using password: YES) C:\MySQL\binmysql show -u root ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\binmysql show -u root -p Enter password: ** ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\binmysql show -u administrator -p Enter password: ** ERROR 1045 (28000): Access denied for user: 'administrator'@'localhost' (Using p assword: YES) C:\MySQL\bin Also here is my.ini file below: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] password=xx port=3306 socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location # basedir = c:/mysql/ # datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe user=administrator password= QueryInterval=5 Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]
Re: What does this Mean
Chris L. White said: C:\MySQL\binmysql show ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using password: YES) C:\MySQL\binmysql show -u root ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) Your musql setup requires a password for root and you didn't include the -p so that mysql client will ask you for the password on the next line. C:\MySQL\binmysql show -u root -p Enter password: ** ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) Did you enter the password which was configured or mysqld that you are runnning? C:\MySQL\binmysql show -u administrator -p Enter password: ** ERROR 1045 (28000): Access denied for user: 'administrator'@'localhost' (Using p assword: YES) Administrator is windows OS equivalent to *nix 'root' but mysql expects its all powerful user to be called 'root' NOT administrator. C:\MySQL\bin Ah you are on widows.. on the right of the bottom bar (the one which can be hidden) is an icon which looks like a traffic signal(should have its green light on). Click on it and then click on 'Show Me' in the popup Go to the my.ini Setup tab and look for the root password. Also here is my.ini file below: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] password=xx port=3306 socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location # basedir = c:/mysql/ # datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-nt.exe user=administrator password= QueryInterval=5 Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What Does This Mean
You know what is even more screwed up now. I did this command and when it prompted me for the password I just hit enter and wallah look what I got. But I am sure there is other stuff messed up now: C:\MySQL\binmysql -u root -p Enter password: ** ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\binmysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.0-alpha-max-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]
RE: What Does This Mean
Chris L. White said: You know what is even more screwed up now. I did this command and when it prompted me for the password I just hit enter and wallah look what I got. But I am sure there is other stuff messed up now: SET YOUR ROOT PASSWORD it its blank it will behave as you describe. Sorry for the shouting but this is a safety issue. C:\MySQL\binmysql -u root -p Enter password: ** ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\binmysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.0-alpha-max-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what does it mean? bug or feature?
Hello mysql, mysql version: 4.0.14-standard for linux linux kernel: 2.4.21 mysqladmin -umef -p shutdown Enter password: ./bin/mysqld_safe: line 1: 31500 Segmentation fault nohup /usr/local/mysql/bin/mysqld --defaults-file=/var/lib/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/sight2.pid --skip-locking --log-slow-queries /var/lib/mysql/server.err 21 Number of processes running now: 1 mysqld process hanging, pid 31502 - killed 030730 00:45:52 mysqld restarted -- Best regards, Andrey mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Resource temporarily unavailable - What does that mean?
While accessing MySQl data base by means of perl the value of variable $! sometimes equals Resource temporarily unavailable. At the mean time everything works correct. What does that mean? ___ http://chat.bigmir.net/ - ñàìûé óäîáíûé ÷àò ñ ôîòîàëüáîìàìè -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What does this mean? : Warning: thr_alarm queue is full
Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung query. Chung I happened to find out that the lots of following error messages are Chung stored Chung error log file: Chung Warning: thr_alarm queue is full Chung What's this? Is it serious problem? The above is a very strange error; Basicly something that should never happen. It means that somehow you have more threads wanting to request for a alarm (used to timeout connections) than was registered when mysqld started. This should be impossible as we init the alarms with the following code in mysqld.cc init_thr_alarm(max_connections+max_insert_delayed_threads) In other words, we reserve as many alarms as we can have connections + insert delay threads; As a thread can only have one alarm and and no other threads than a connection or insert delay thread uses alarms I can't understand how you can get this error. Note that even if the alarm call fails, mysqld will work normally with the exception that a long lived connection will not time out. If you cando a new bug report, preferably with the 'mysqlbug' script, that includes the following information, I could try to dig deeper into this problem. Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: Operating system: Regards, Monty -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: What does this mean? : Warning: thr_alarm queue is full
Chung, Warning: thr_alarm queue is full What's this? Is it serious problem? Looking for thr_alarm in the MySQL Manual, I find this: If mysqld is compiled with -DUSE_ALARM_THREAD, a dedicated thread that handles alarms is created. This is only used on some systems where there are problems with sigwait() or if one wants to use the thr_alarm() code in ones application without a dedicated signal handling thread. Link to this manual part: http://www.mysql.com/doc/en/MySQL_threads.html So, I guess all it means is that the thr_alarm queue is full ;-) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschaftsfuhrer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Chung Ha-nyung [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 27, 2002 3:49 AM Subject: What does this mean? : Warning: thr_alarm queue is full query. I happened to find out that the lots of following error messages are stored error log file: Warning: thr_alarm queue is full What's this? Is it serious problem? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
What does this mean? : Warning: thr_alarm queue is full
query. I happened to find out that the lots of following error messages are stored error log file: Warning: thr_alarm queue is full What's this? Is it serious problem? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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: newbie question - what does test\_% mean
At 20:55 -0700 5/10/02, Frederick Shaul wrote: I understand what test% might mean, but don't know what test\_% means. It's a SQL pattern string that matches a literal test followed by a literal _ followed by anything. _ in SQL patterns normally matches any single character. \_ escapes it to represent a literal _. % is a SQL pattern character that matches any sequence of characters, including the empty string. Following is from a fresh MySQL install ... mysql use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from db; +--+-+--+-+-+-+-+-+---++-+++ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +--+-+--+-+-+-+-+-+---++-+++ | %| test| | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | %| test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | +--+-+--+-+-+-+-+-+---++-+++ 2 rows in set (0.00 sec) - 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
newbie question - what does test\_% mean
I understand what test% might mean, but don't know what test\_% means. Following is from a fresh MySQL install ... mysql use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from db; +--+-+--+-+-+-+-+-+---++-+++ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +--+-+--+-+-+-+-+-+---++-+++ | %| test| | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | %| test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | +--+-+--+-+-+-+-+-+---++-+++ 2 rows in set (0.00 sec)
[Fwd: what does it mean Open_files?]
Hi, can somebody answer my question? Subject: what does it mean Open_files? Date: Mon, 22 Oct 2001 06:41:03 +0200 From: Michal ejdl [EMAIL PROTECTED] To: MySQL list [EMAIL PROTECTED] Hi, after some testing on a new db, I have this status: [root@rachab /root]# mysqladmin e | grep "onn\|pen.*es" | Aborted_connects | 12 | | Connections | 150194 | | Max_used_connections | 24 | | Open_tables | 0 | | Open_files | 7909 | | Opened_tables| 222981 | | Slave_open_temp_tables | 0 | | Threads_connected| 1 | Option open-files-limit is set to 8192. But why Open_files is 7909 when Open_tables is 0 and only one connection (own mysqladmin) is estabilished? Is there any relation in Open_files, Open_tables and Threads_connected? Manual says yes, but these numbers doesn't agree with. Could it rather be Opened_files than Open_files? Kernel shows in /proc/sys/fs/file-nr: 2155180616384 AFAIK there are about 350 open files in system. Output from lsof coresponds with kernel status: [root@rachab /root]# lsof | grep mysqld | wc 1131005 10028 RH 7.1, kernel 2.4.3-12enterprise, mysql-3.23.42-1 (rawhide) with modified convert.cc (#define DEFINE_ALL_CHARACTER_SETS). File my.conf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-character-set=czech language=czech log set-variable = key_buffer_size=16M set-variable = max_allowed_packet=10M set-variable = max_connections=200 set-variable = record_buffer=1M set-variable = sort_buffer=4M set-variable = table_cache=512 set-variable = tmp_table_size=8M skip-innodb [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open-files-limit=8192 -- Ing. Michal ejdl e-mail: [EMAIL PROTECTED] Sokolovsk uheln, a.s. tel.: +420 168 46-5418 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what does it mean Open_files?
Hi, after some testing on a new db, I have this status: [root@rachab /root]# mysqladmin e | grep "onn\|pen.*es" | Aborted_connects | 12 | | Connections | 150194 | | Max_used_connections | 24 | | Open_tables | 0 | | Open_files | 7909 | | Opened_tables| 222981 | | Slave_open_temp_tables | 0 | | Threads_connected| 1 | Option open-files-limit is set to 8192. But why Open_files is 7909 when Open_tables is 0 and only one connection (own mysqladmin) is estabilished? Is there any relation in Open_files, Open_tables and Threads_connected? Manual says yes, but these numbers doesn't agree with. Could it rather be Opened_files than Open_files? Kernel shows in /proc/sys/fs/file-nr: 2155180616384 AFAIK there are about 350 open files in system. Output from lsof coresponds with kernel status: [root@rachab /root]# lsof | grep mysqld | wc 1131005 10028 RH 7.1, kernel 2.4.3-12enterprise, mysql-3.23.42-1 (rawhide) with modified convert.cc (#define DEFINE_ALL_CHARACTER_SETS). File my.conf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-character-set=czech language=czech log set-variable = key_buffer_size=16M set-variable = max_allowed_packet=10M set-variable = max_connections=200 set-variable = record_buffer=1M set-variable = sort_buffer=4M set-variable = table_cache=512 set-variable = tmp_table_size=8M skip-innodb [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid open-files-limit=8192 -- Ing. Michal ejdl e-mail: [EMAIL PROTECTED] Sokolovsk uheln, a.s. tel.: +420 168 46-5418 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what does this mean please?
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and how you fix it? 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: what does this mean please?
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and how you fix it? It means you have no local socket for mysql to connect through. Meaning, something/someone either deleted or mangled /tmp/mysql.sock or mysqld isn't running to begin with. Try to connect with the -host flag to connect (so it won't use the socket) and shutdown and try to restart the mysqld - hopefully this will recreate mysql.sock Take care, seth --- Seth Northrop Manager of Information Technology Reflectivity, Inc. 3910 Freedom Circle, Suite 103 Santa Clara, CA 95054 voice: 408-970-8881 x147 fax:408-970-8840 http://www.reflectivity.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
What does this mean
Found this message from mysql in my root mailbox. What does it mean? "errors occured while rotating /var/lib/mysql/mysqld.log { ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script" -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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: What does this mean
On Fri, 16 Mar 2001 13:35:18 -0500, Hardy Merrill ([EMAIL PROTECTED]) wrote: Sure it's easier, but which is safer? I don't have Charles first message on this topic, but I believe his error message was from logrotate which is a cron job. If Charles put mysqladmin -uuser -ppassword into a cron job, then the user's(root?) password would be in open view to anybody who could view the crontab - granted, you would have to be root to view the root crontab, but putting the password to the MySQL user right in the cron command is just a little too "loose" for me. A safer method would be to "hide" the user/pw in the Unix user's home directory in the ..my.cnf file, as I outlined below. Uh... root can read those too. If you're imagining a situation where someone just rooted you in order to get access to MySQL, I guess it's possible that doing it this way will slow him down by about 5 minutes, but I don't really think it's an issue. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What Does This Mean?
Hi; I'm getting this error: Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 = 3.0.8 What does it mean and what should I do about it (if anything)? TIA, BenO - 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: [PHP] What Does This Mean?
I am not very sure of what exactly does this this mean but I guess that the particular module that you are installing requires a cversion of PHP that has to be greater than 3.0.8. This is just a guess. I aplogize if it's wrong. regards Ankur Verma HCL Technologies A1CD, Sec -16 Noida, UP India - Original Message - From: "Ben Ocean" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 3:28 PM Subject: [PHP] What Does This Mean? Hi; I'm getting this error: Unsatisfied dependencies for mod-php3-mysql-3.0.8-2: mod-php3 = 3.0.8 What does it mean and what should I do about it (if anything)? TIA, BenO -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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: What does this mean ?
This patch will make it into 4.0.5, I believe. 4.0.4pl1 fixes only two bugs (one security issue, and one that make the PDF plugin work again). My patches could have side effects, since it will run code that has never been run before (like actually closing those persistent connections). They are in CVS. If you are using Apache (most of us are with PHP), note that persistent connections are per process, not per machine. Mod_ssl can use an Apache extension to keep shared memory across processes, but PHP does not. Read the docs (or the PHP list) to find out more. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e That is what I suspected. I suffer the same. The problem is buggy PHP persistent connection code. The "almost good" solution was presented to PHP people by Steven Roussey (http://marc.theaimsgroup.com/?l=php-devm=97562841130973w=2) and (http://marc.theaimsgroup.com/?l=php-devm=97858730928909w=2) and according to Andi Gutmans (http://marc.theaimsgroup.com/?l=php-devm=97858932431876w=2) the patch was committed to PHP CVS. However the patch is absent even from PHP 4.0.4pl1 (its zend_list.c is dated 2000-10-20). You might try to patch your PHP by yourself. Or try the latest snapshot from http://snaps.php.net (though I don't know if the patch is there). Sincerely speaking I don't know why Steven's patches haven't been incorporated into PHP 4.0.4pl1. Maybe Andi (Cc:ed) could explain this? Maciek -Original Message- From: Denis Gasparin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 8:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: What does this mean ? I use php 4.0.3 with persistent connections. MySQL is installed on Linux RedHat 7.0. The problem is that the Mysql exists and I don't know exactly what appends to the php process Denis At 19.21 15/01/01, Maciek Uhlig wrote: Could you describe what exactly software connects to MySQL in your case? Maciek -Original Message- From: Denis Gasparin [mailto:[EMAIL PROTECTED]] Sent: Monday, January 15, 2001 6:00 PM To: [EMAIL PROTECTED] Subject: What does this mean ? From when I installed the mysql 3.23.30gamma I have mysql reporting these warnings: 10115 17:51:22 Aborted connection 2886 to db: 'db_name' user: 'user' host: `www.host' (Got an error reading communication packets) 010115 17:51:36 Aborted connection 3754 to db: 'db_name' user: 'user' host: `www.host' (Got an error reading communication packets) We have 700-800 contemporary connections to mysql and these warnings are given periodically every 5-10 minutes... Why does Mysql generate these logs? Denis - 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_pconnect still broken (was: RE: What does this mean ?)
OK. Look at a quick report. I've just installed php4-200101152345. It runs with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 (remote connection). What I can see is: the offending messages didn't vanish at all (both hosts are involved): 010116 20:52:30 Aborted connection 36021 to db: '***' user: '***' host: `***' (Got an error reading communication packets) So, I think it's not fixed yet. Steven, you wrote about 99,8. I suppose every Apache process here makes this error while ending. I just see it. Steven, thank you for your efforts. Hope you can fix even that. Please let me know about patches: I'll happily test them. I'm not able to fix it by myself, but I'd like at least be helpful. Maciek [stuff deleted] - 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: [PHP-DEV] RE: mysql_pconnect still broken (was: RE: What does this mean ?)
Yep, you're right. Fixed. Thanks, Zeev At 23:24 16/1/2001, Steven Roussey wrote: OK. Look at a quick report. I've just installed php4-200101152345. It runs with mysql-3.23.27-beta. Apache 1.3.12, Solaris 2.6 (local host) and 2.4 (remote connection). What I can see is: the offending messages didn't vanish at all (both hosts are involved): So, I think it's not fixed yet. Steven, you wrote about 99,8. I suppose every Apache process here makes this error while ending. I just see it. :) Andi, I hope you are reading this. I looked at the CVS, and my patch was not properly applied. Andi has it looking through the non-persistant destructors, rather than the persistent ones (meaning that plist_entry_destructor is identical to list_entry_destructor). In file zend_list.c replace the plist_entry_destructor definition with: void plist_entry_destructor(void *ptr) { zend_rsrc_list_entry *le = (zend_rsrc_list_entry *) ptr; zend_rsrc_list_dtors_entry *ld; if (zend_hash_index_find(list_destructors, le-type,(void **) ld)==SUCCESS) { switch (ld-type) { case ZEND_RESOURCE_LIST_TYPE_STD: if (ld-plist_dtor) { (ld-plist_dtor)(le-ptr); } break; case ZEND_RESOURCE_LIST_TYPE_EX: if (ld-plist_dtor_ex) { ld-plist_dtor_ex(le); } break; EMPTY_SWITCH_DEFAULT_CASE() } } else { zend_error(E_WARNING,"Unknown persistent list entry type in module shutdown (%d)",le-type); } } Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e -- PHP Development Mailing List http://www.php.net/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Zeev Suraski [EMAIL PROTECTED] CTO co-founder, Zend Technologies Ltd. http://www.zend.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