Re: BDB table error
Dana, if you have page level locking, you can easily get a deadlock from an atomic insert done as a single transaction, and another user doing an atomic select in another single transaction. It happens this way: User A User B insert recordselect record from secondary to primary index index, get S-lock on page 2 get X-lock on page 1 select record from primary index get X-lock on page 1 - MUST WAIT insert record to secondary index get X-lock on page 2 -MUST WAIT - DEADLOCK Regards, Heikki http://www.innodb.com Ok, so the problem Im seeing is that any table that has an index other than the primary key is prone to deadlocks. I cant think of any reason that this is acceptable behaviour ( i.e. not a bug ), because I am doing 4 atomic operations on a single table with no user level locks.Here is a test: CREATE TABLE bdb_test ( id int unsigned not null auto_increment primary key, key1 char(32) not null, val1 char(32), unique (key1) ) TYPE=BDB; ( replacing unique(key1) with index(key1) also results in deadlocks ). Now run the following 4 queries in parallel: ## Insert a new row with 2 key values - 1 auto_incremented and 1 specified INSERT INTO bdb_test (key1) VALUES(CONCAT(CONNECTION_ID(),' - some extratext')); ## Update a non key column in row UPDATE bdb_test SET val1='test val' WHERE id=LAST_INSERT_ID(); ## Select based on secondary key SELECT * FROM bdb_test WHERE key1=CONCAT(CONNECTION_ID(),' - some extratext'); ## Select based on primary keySELECT * FROM bdb_test WHERE id=LAST_INSERT_ID(); I get deadlocks on my machine ( Intel w/ Dual 400 + 512MB RAM, running linux ) with 64 simultaneous threads. It appears that as the table gets larger ( and more pages created for locking, hehe ), the probability that we get a deadlock grows. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't connect to host
Hello everybody. Excuse my english, please. I have several computers in my network. Every minit I give from 2 to 10 commands INSERT INTO ... from each host to mysql server. From time to time (1 or 3 ones per month) i give errror from clients. This error is Can't connect to host Why I give this and how can I solve this problem. (Only repeat query if it failed or not ?) Thank all of you if you answer me. Where can I search the answer? [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
Threads problem on a new server :(
Hi, I encounter a problem with a new freshly installed server : it seems MySQL-4.0 doesn't want to create more than 254 threads. Once I have reached this number, MySQL displays this error : ERROR 1135: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug. A debian distribution is installed on the server with a 2.4.7 kernel. Of course I'm not out of available memory :) I'm running mysql with skip-locking enabled. Any idea of what could be wrong with the OS configuration ? Thank you ! Jocelyn Fournier Presence-PC - 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 newbie?
Greetings I teach beginning programming to High School students at Pasco High in Pasco, WA. I recently went to receive some training at the Oracle Internet Academy in California and found Oracle to be a big stretch for me and my students. We've downloaded MySQL and the MySQL client. We would like to run mySQL gui client and mySQl locally first then from a server. How do I access the mySQL database from mySQL gui. Is their another gui I could use to populate a mySQL database? Thank You, Craig Coleman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and Ultradev
Hi all, Can anyone point me to a good Macromedia Ultradev Extension for live connection to MySQL? Mike - 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 newbie?
Hi, Is their another gui I could use to populate a mySQL database? my personal opinion - the best MySQL GUI by far I've seen is the EMS MyManager: http://ems-hitech.com/mymanager/ Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ 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: intro mysql book
another oracle dba [EMAIL PROTECTED] wrote: Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL Like you I too have come from an Oracle background to Mysql. Two main sources of information as far as I'm concerned: 1. The MySQL manual that comes with the source install, (also available on the site). I've got the HTML version readily accessible on the servers that are running MySQL. If it was multiple page HTML rather than a single file it'd be great. 2. MySQL by Paul DuBois. Like I've said on AmazonUK, I regard this as being the 'Kernighan and Ritchie' of MySQL. It's well written, reasonable concise, easy to follow and pretty good value-for-money. I could do without the chapters on installation and the API's myself, (I prefer to use the online manual as books tend to date in these areas fast), but I can see a use for them, (maybe less of the installation please in the revision for MySQL4.0 please Mr Dubois?). As an aside I also found 'PHP and MySQL' and 'SQL in a nutshell' (O'Reilly) quite useful. The Nutshell book is quite nice if you are an experienced code warrior with one of the other implementations of SQL. Just my random meanderings Bob Cross Disclaimer 1: writing for myself * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - 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 newbie and confused
Hi, I've just downloaded and install mySQL on my server but only seem able to connect to the server across my network if the server is connected to the internet. Any ideas why and how to stop it. btw I'm running windows. TIA Alex - 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
Syntax Help
I've been trying to figure out where I might be going wrong with this SQL syntax: select format(sum(p.badcheck)+ (count(p.badcheck)*-15)) as Badcheck from payout p,payhistory ph where ph.paydate between '2001-09-20' and '2001-09-30' and (p.payid = ph.payid and p.badcheck != '0.00') MySQL said: You have an error in your SQL syntax near ') as Badcheck from payout p,payhistory ph where ph.paydate between '2001-09-2' at line 1 If I remove the format() from the query, it works prefectly! I'm trying to format the result. Any help, appreciated! ;) mysql database. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Syntax Help - CANCEL
Cancel this, I spotted the problem, forgot the format(..,2); This query works as expected: select format(sum(p.badcheck)+ (count(p.badcheck)*-15),2) as Badcheck from payout p,payhistory ph where ph.paydate between '2001-09-20' and '2001-09-30' and (p.payid = ph.payid and p.badcheck != '0.00') I've been trying to figure out where I might be going wrong with this SQL syntax: select format(sum(p.badcheck)+ (count(p.badcheck)*-15)) as Badcheck from payout p,payhistory ph where ph.paydate between '2001-09-20' and '2001-09-30' and (p.payid = ph.payid and p.badcheck != '0.00') MySQL said: You have an error in your SQL syntax near ') as Badcheck from payout p,payhistory ph where ph.paydate between '2001-09-2' at line 1 If I remove the format() from the query, it works prefectly! I'm trying to format the result. Any help, appreciated! ;) mysql database. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Sharing pws between UNIX and MySQL?
Hi, By looking in the documentation and the FAQ I can't find out how one should do to share passwords (in e.g. MD5 format) between UNIX (e.g. Linux) and MySQL. I like to setup a MySQL database for 20 of my users on a Linux box and it would be nice if they could retain their UNIX passwords. Is there a tool to transfer the passwords from the UNIX accounts to MySQL? Best regards, Jonap _ Hämta MSN Explorer kostnadsfritt på http://explorer.msn.se - 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 transfer data from Paradox to mysql?
Hello, Miguel! I have Paradox and copy Paradox tables to mySQL all the time. Just use the copy table function. This is assuming you have installed the MySQLODBC and have created an ODBC mySQL DSN. Most all data types will copy correctly. You will have to alter the tables to recreate the keys. When you say move your apps, I'm assuming your just referring to the tables. But yes, you can just change your table alias to point to a mySQL table instead of your Paradox table. Very little change to your Pal code will be necessary. Fredrick Fredrick Miguel Enriquez Alvarado wrote: i use the paradox and i want move my apps to mysql, but how? Regards otro correo: [EMAIL PROTECTED] --- Runbox Mail Manager - www.runbox.com Free online email application - 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: Sharing pws between UNIX and MySQL?
At 7:21 PM + 9/16/01, Jonas Larsson wrote: Hi, By looking in the documentation and the FAQ I can't find out how one should do to share passwords (in e.g. MD5 format) between UNIX (e.g. Linux) and MySQL. I like to setup a MySQL database for 20 of my users on a Linux box and it would be nice if they could retain their UNIX passwords. Is there a tool to transfer the passwords from the UNIX accounts to MySQL? There is no connection between the two. Besides, how would you decrypt their passwords? :-) (You can't just transfer the encrypted form from /etc/passwd or /etc/shadow or whatever into the user.user table, because MySQL doesn't use the same encryption algorithm.) Best regards, Jonap -- 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
NUMERIC field contents
Does anyone have an opinion about the following? Are people using decimal type fields? Is it important for the database to allow only allowed data? From http://www.mysql.com/doc/N/u/Numeric_types.html The NUMERIC and DECIMAL types are implemented as the same type by MySQL, as permitted by the SQL92 standard. They are used for values for which it is important to preserve exact precision, for example with monetary data. When declaring a column of one of these types the precision and scale can be (and usually is) specified; for example: salary DECIMAL(9,2) In this example, 9 (precision) represents the number of significant decimal digits that will be stored for values, and 2 (scale) represents the number of digits that will be stored following the decimal point. In this case, therefore, the range of values that can be stored in the salary column is from -999.99 to 999.99. (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) First I am not sure if you intended 999.99 to be .99 in (MySQL can actually store numbers up to 999.99 in this column because it doesn't have to store the sign for positive numbers) If so then I do not think this is correct. I think that decimal(9,2) means there is an optional sign character, up to 7 whole digits, a decimal point and up to two decimal digits. I think the whole parenthetical statement should be removed. Red Hat Linux 7.1 2.96-85 mysql-3.23.42 (Official MySQL RPM) Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' This shows the problem: mysql -p dickensn Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 to server version: 3.23.42 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create table t1 (num1 numeric(9,2)); Query OK, 0 rows affected (0.00 sec) mysql insert into t1 values (1234567.12); Query OK, 1 row affected (0.00 sec) mysql select * from t1; ++ | num1 | ++ | 1234567.12 | ++ 1 row in set (0.00 sec) mysql update t1 set num1=12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | 12345678.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-1234567.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select * from t1; +-+ | num1| +-+ | -1234567.12 | +-+ 1 row in set (0.00 sec) mysql update t1 set num1=-12345678.12; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql select * from t1; +-+ | num1| +-+ | -999.99 | +-+ 1 row in set (0.00 sec) mysql quit Bye I think the first update should get an error as I specified a maximum of 9 digits. Per your description of numeric() the value should be set to 999.99. The fact that there is room for a sign character should not increase the number of digits allowed in the field. -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.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 count the number of ,br's in multiple records
ASP - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 5:45 PM Subject: Re: How to count the number of ,br's in multiple records On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote: How do I count the number br's in each record in a field? Using what programming language? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec. avg) - 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: BDB table error
Certainly I understand how the deadlock can occur, but the question is why
is this acceptable behaviour? Is the application developer expected to
handle this case? If so, how? and shouldnt this be included in the manual
under BDB problems? If Im supposed to wrap _every_ sql call I make to a BDB
table with something like: 'do { query } while ( !deadlock );' why would I
even bother trying to use BDB tables? This seems to me like a _fundamental_
weakness of the BDB table type, and should at least be documented as such...
dpk
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, September 16, 2001 2:14 AM
Subject: Re: BDB table error
Dana,
if you have page level locking, you can easily
get a deadlock from an atomic insert done as
a single transaction, and another user doing
an atomic select in another single transaction.
It happens this way:
User A User B
insert recordselect record from secondary
to primary index index, get S-lock on page 2
get X-lock on page 1
select record from primary index
get X-lock on page 1 - MUST WAIT
insert record to
secondary index
get X-lock on page 2 -MUST WAIT - DEADLOCK
Regards,
Heikki
http://www.innodb.com
Ok, so the problem Im seeing is that any table that has an index other
than
the primary key is prone to deadlocks.
I cant think of any reason that this is acceptable behaviour ( i.e. not a
bug ), because I am doing 4 atomic operations on a single table with no
user
level locks.Here is a test:
CREATE TABLE bdb_test ( id int unsigned not null auto_increment primary
key,
key1 char(32) not null, val1 char(32), unique (key1) ) TYPE=BDB;
( replacing unique(key1) with index(key1) also results in deadlocks ).
Now run the following 4 queries in parallel:
## Insert a new row with 2 key values - 1 auto_incremented and 1
specified
INSERT INTO bdb_test (key1) VALUES(CONCAT(CONNECTION_ID(),' - some
extratext'));
## Update a non key column in row
UPDATE bdb_test SET val1='test val' WHERE id=LAST_INSERT_ID();
## Select based on secondary key
SELECT * FROM bdb_test WHERE key1=CONCAT(CONNECTION_ID(),' - some
extratext');
## Select based on primary keySELECT * FROM bdb_test WHERE
id=LAST_INSERT_ID();
I get deadlocks on my machine ( Intel w/ Dual 400 + 512MB RAM, running
linux ) with 64 simultaneous threads.
It appears that as the table gets larger ( and more pages created for
locking, hehe ), the probability that we get a deadlock grows.
-
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]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to count the number of ,br's in multiple records
At 5:59 PM -0500 9/16/01, Deryck Henson wrote: ASP You tell us, then. MySQL doesn't have a function to count the number of instances of a substring within a string. At least I don't think it does. Does ASP have some kind of function for that? If so, you can run a SELECT that looks for records containing br, then use the ASP function to count instances, summed over each matching record. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 5:45 PM Subject: Re: How to count the number of ,br's in multiple records On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote: How do I count the number br's in each record in a field? Using what programming language? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec. avg) -- 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
MySQL Spawning Tons of Processes
I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know how I can stop this from happening? Thanks so much. RedHat 7.1 Kernel 2.4.9 Database Size =~ 2 gigs = my.cnf [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=256M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=2 log-bin server-id = 1 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=10 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:1000M #innodb_data_home_dir = /usr/local/var/ #innodb_log_group_home_dir = /usr/local/var/ #innodb_log_arch_dir = /usr/local/var/ #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 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [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=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout Extra start parameters Max_Connections=2000 Max_Connect_Errors=2000 - 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 count the number of ,br's in multiple records
something like this (assuming vbscript): Dim pos = 1 Dim cnt = 0 Do pos = InStr(field, br, pos) If pos 0 Then cnt = cnt + 1 pos = pos + 3 'get past the current one Else break End If Loop 'at this point, cnt holds your answer -Original Message- From: Deryck Henson [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 7:00 PM To: [EMAIL PROTECTED] Subject: Re: How to count the number of ,br's in multiple records Importance: High ASP - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 5:45 PM Subject: Re: How to count the number of ,br's in multiple records On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote: How do I count the number br's in each record in a field? Using what programming language? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec. avg) - 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: How to count the number of ,br's in multiple records
On Sun, Sep 16, 2001 at 05:59:48PM -0500, Deryck Henson wrote: Using what programming language? ASP That's a framework (or API), not a language. (see Paul's answer anyway) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 201,122,168 queries (215/sec. avg) - 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 Spawning Tons of Processes
On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote: I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know how I can stop this from happening? Is what you're asking for an easy query? How many processes do you get? Significantly more than 400? (I hope not.) Have you run vmstat to see if the system is swapping like mad? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 201,269,490 queries (215/sec. avg) - 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: surely an easy quick one
Use the DISTINCT keyword and count the returned rows - Original Message - From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 9:08 AM Subject: surely an easy quick one Hello again :o) This is surely an easy quick one but my brain wont work! I have a table (ref, name, team, seminar_ref) like: 1billsupport100 2billsupport101 3billsupport102 4ben development 201 5ben development 103 6ben development 204 7bob support 104 8bob support102 9bob support107 7pat support 102 8pat support 202 9pat support 105 I need to get a count of how many individual people are in the table, that belong to a certain group. So if I wanted to find all individual people in support the answer in this case it would be 3 (bill, bob and pat). I dont need their names, just the count. Thanks, Jamie. - 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: surely an easy quick one
I suggest: select count(*) from table your_table_name group by team ; The MySQL documentation at www.mysql.com certainly contains good documentation regarding the group by clause within it. However, it doesn't really provide a motivation for using it... nor should it. It is documentation regarding how MySQL implements SQL and RDMS in general, and not a general SQL tutorial or reference. I suggest you look a bit further afield for this kind of material. I got started with this stuff back oh 5-6 years ago with Teach Yourself Transact-SQL in 21 Days. (I was working with MS SQL Server 6.5 at the time.) It did a pretty good job at handling this kind of topic (group by), having clause, joins, cross-tab reports, etc. (It also did views, stored procedures, batch programming... all sorts of stuff I hope MySQL has one of these days. :-) ) I'm not saying that this is the book that you should get. But if you want to increase your SQL knowledge, you should look into getting something. Cheers, Richard From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 14, 2001 9:08 AM Subject: surely an easy quick one Hello again :o) This is surely an easy quick one but my brain wont work! I have a table (ref, name, team, seminar_ref) like: 1billsupport100 2billsupport101 3billsupport102 4ben development 201 5ben development 103 6ben development 204 7bob support 104 8bob support102 9bob support107 7pat support 102 8pat support 202 9pat support 105 I need to get a count of how many individual people are in the table, that belong to a certain group. So if I wanted to find all individual people in support the answer in this case it would be 3 (bill, bob and pat). I dont need their names, just the count. -- Richard Dice ShadNet Creator * http://shadnet.shad.ca/ * [EMAIL PROTECTED] Occasional Writer, HotWired * http://www.hotwired.com/webmonkey/ squeeze the world 'til it's small enough to join us heel to toe - jesus jones - 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 Spawning Tons of Processes
On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote: I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know how I can stop this from happening? Is what you're asking for an easy query? A very simple select statement How many processes do you get? Significantly more than 400? (I hope not.) A few less than 400 Have you run vmstat to see if the system is swapping like mad? 0 Swapping just a CPU Idle of 0 and almost all my ram eaten up. - 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 Spawning Tons of Processes
On Sun, Sep 16, 2001 at 06:58:05PM -0700, Michael McConnell wrote: On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote: I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know how I can stop this from happening? Is what you're asking for an easy query? A very simple select statement Good. How many processes do you get? Significantly more than 400? (I hope not.) A few less than 400 That's expected, then. You get one thread per connection, so this makes sense. Have you run vmstat to see if the system is swapping like mad? 0 Swapping just a CPU Idle of 0 and almost all my ram eaten up. Very good. No swapping. And the CPU ought to be busy. How long does the situation persist? Are you using MyISAM tables? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 201,979,372 queries (214/sec. avg) - 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.42 (Source distribution) Environment: System: Linux dev.nzym.fi 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 16 07:29 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 7 00:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 22:27 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 22:27 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql - 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
Problems...
I can´t start Mysql (I use Slack and compiled mysql). I´ve followed all instructions in INSTALL text, and i´ve got this in the .err file: 010914 16:19:02 mysqld started 010914 16:19:02 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:02 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010914 16:19:02 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:02 mysqld ended 010914 16:19:26 mysqld started 010914 16:19:26 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:26 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010914 16:19:26 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:19:26 mysqld ended 010914 16:27:59 mysqld started /usr/local/mysql/libexec/mysqld: File './darkstar-bin.1' not found (Errcode: 13) 010914 16:27:59 Could not use darkstar-bin for logging (error 13) 010914 16:27:59 /usr/local/mysql/libexec/mysqld: Can't create/write to file '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:27:59 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010914 16:27:59 /usr/local/mysql/libexec/mysqld: Error on delete of '/usr/local/mysql/var/darkstar.pid' (Errcode: 13) 010914 16:27:59 mysqld ended 010914 16:30:12 mysqld started /usr/local/mysql/libexec/mysqld Ver 3.23.42 for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB, by Monty and others This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Someone help please? 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
Syntax errors when creating HEAP tables and using IF NOT EXISTS
We developed a site using PHP and MYSQL on an online shared server. We used HEAP tables extensively and everything worked fine. When we moved the site to our dedicated server prior to launching the site, the queries that should create the HEAP tables return syntax errors (when submitting the queries with phpMyAdmin). Also, other queries having to do with table creation return syntax errors. Anyone have ideas? We've thought maybe there are permission problems, or else our build of MySQL doesn't support these queries? Or something is wrong in the server config, or in how the host company compiled their MySQL build? The version we developed with was 3.23.21 beta and the version on the shared box is MySQL 3.22.30. Is it possible there are version incompatibilities? On the dedicated server, this query will create a table without errors: CREATE TABLE test (test1 TINYINT (4) UNSIGNED not null ) However, this triggers a syntax error: CREATE TABLE IF NOT EXISTS test (test1 TINYINT (4) UNSIGNED not null ) Here are some other examples of queries that result in errors. 2) This should create a table that is an exact copy of blocking table: CREATE TABLE newtable2 SELECT * FROM blocking Instead of creating the table, it reports a syntax error. 3) This also reports a syntax error: CREATE TABLE test3 TYPE=HEAP MAX_ROWS = 30 SELECT * FROM blocking
trying to reset auto-increment
I manually entered into my database several rows with high values in the auto-increment column. I subsequently deleted the high value rows. I now am trying to reset the auto-increment. How do I reset it to the Max of the currently existing values? -matt [EMAIL PROTECTED] Ecosandals.com Making sandals, enriching lives Kutengeneza akala, kuinua maisha - 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
Syntax errors when creating HEAP tables and using IF NOT EXISTS
We developed a site using PHP and MYSQL on an online shared server. We used HEAP tables extensively and everything worked fine. When we moved the site to our dedicated server prior to launching the site, the queries that should create the HEAP tables return syntax errors (when submitting the queries with phpMyAdmin). Also, other queries having to do with table creation return syntax errors. Anyone have ideas? We've thought maybe there are permission problems, or else our build of MySQL doesn't support these queries? Or something is wrong in the server config, or in how the host company compiled their MySQL build? The version we developed with was 3.23.21 beta and the version on the shared box is MySQL 3.22.30. Is it possible there are version incompatibilities? On the dedicated server, this query will create a table without errors: CREATE TABLE test (test1 TINYINT (4) UNSIGNED not null ) However, this triggers a syntax error: CREATE TABLE IF NOT EXISTS test (test1 TINYINT (4) UNSIGNED not null ) Here are some other examples of queries that result in errors. 2) This should create a table that is an exact copy of blocking table: CREATE TABLE newtable2 SELECT * FROM blocking Instead of creating the table, it reports a syntax error. 3) This also reports a syntax error: CREATE TABLE test3 TYPE=HEAP MAX_ROWS = 30 SELECT * FROM blocking - 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 MySQL 3.23.40 Install..Source Compiled
Can someone help me?? I have been trying out MySQL beginning in June of 2001. I use Caldera Linux and have a 4 machine LAN. The Lan includes 3 Linux and 1 WinNT install. I compiled the Source and installed version: 3.22.32-log on all machines. This runs fine but I was needing the newer features of version 3.23.40. So, I downloaded and installed to the first Linux machine. Now, no matter what I do safe_Mysqld continues to start version: 3.22.32-log .. Here are the steps I took to compile and install ver 3.23.40. to the same directory as ver. 3.22.32 which I hoped would be overwritten. I installed both versions to /usr/share/mysql.. cd /usr/src/OpenLinux/SOURCES/ tar zxvf mysql-3.23.40.tar.gz cd /usr/src/OpenLinux/SOURCES/mysql-3.23.40 ./configure --prefix=/usr/share/mysql make make install ( I did not run scripts as I had a previous installation, Right??) I noticed 3.23.40 installed mysqld to a libexec directory, not bin.. Also 3.23.40 did not make a mysql/var directory, by but continued to use /var/lib/mysql for data and pid.. In an effort to get 3.23.40 to load at boot I changed /etc/rc.d/init.d/mysql and /etc/rc.d/init.d/mysql_server and it's link /etc/rc5.d/S35mysql.. Like So basedir=/usr/share/mysql/libexec bindir=/usr/share/mysql/bin pid_file=/var/lib/mysql/mysqld.pid Still comes up 3.22.32. I've obviously missed Something. Also I expected the prefix= switch in the ./configure to overwrite version 3.22.32..Instead it created a sub/sub directory like SO.. /usr/share/mysql/share/mysql Whats That I have a lot of house cleaning to do... Please IF someone can shed some light on all or some of this mess.. BOb T. - 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 Spawning Tons of Processes
So what your saying is MySQL is supposed to fork a new processes for every connection? I don't think so... I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know how I can stop this from happening? Is what you're asking for an easy query? A very simple select statement Good. How many processes do you get? Significantly more than 400? (I hope not.) A few less than 400 That's expected, then. You get one thread per connection, so this makes sense. Have you run vmstat to see if the system is swapping like mad? 0 Swapping just a CPU Idle of 0 and almost all my ram eaten up. Very good. No swapping. And the CPU ought to be busy. How long does the situation persist? Are you using MyISAM tables? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 201,979,372 queries (214/sec. avg) - 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 Spawning Tons of Processes
At 10:21 PM -0700 9/16/01, Michael McConnell wrote: So what your saying is MySQL is supposed to fork a new processes for every connection? I don't think so... ... based on? Lemme guess. Running Linux? I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know how I can stop this from happening? Is what you're asking for an easy query? A very simple select statement Good. How many processes do you get? Significantly more than 400? (I hope not.) A few less than 400 That's expected, then. You get one thread per connection, so this makes sense. Have you run vmstat to see if the system is swapping like mad? 0 Swapping just a CPU Idle of 0 and almost all my ram eaten up. Very good. No swapping. And the CPU ought to be busy. How long does the situation persist? Are you using MyISAM tables? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 10 days, processed 201,979,372 queries (214/sec. avg) -- 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: trying to reset auto-increment
At 11:05 PM -0400 9/16/01, [EMAIL PROTECTED] wrote: I manually entered into my database several rows with high values in the auto-increment column. I subsequently deleted the high value rows. I now am trying to reset the auto-increment. How do I reset it to the Max of the currently existing values? ALTER TABLE tbl_name AUTO_INCREMENT = 1 -matt [EMAIL PROTECTED] Ecosandals.com Making sandals, enriching lives Kutengeneza akala, kuinua maisha -- 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: sqld core dump after power failure
Thanks for the idea - I had a look for mysql.sock, but it was already gone (I think the startup script must have deleted it) For the record, to get mysqld to start again we had to run the startup command from the mysql user account. The linux startup script runs as root, it calls safe_mysqld, which uses the option --user=mysql, but that's not enough, you must actually *be* the user mysql for startup to work properly, at least on this particular system. Gerald Clark wrote: Did you try deleting the mysql.sock before starting the server? fsck seems to have changed its file type. Katrina Maffey wrote: Description: After a brief power failure, I rebooted the mysql server machine, and got this error on startup: Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: line 254: 1844 Segmentation fault (core dumped) $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 010910 13:32:48 mysqld ended I tried running myisamchk -re on every *.MYI file under /var/lib/mysql, and they seemed to repair successfully, however the crash still occurs. From the strace output, I don't think mysqld even gets as far as opening these files. What else can I try to get mysqld running again? Extra info: - 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
