MYWA.NET - New WEB-based MySQL Data Manipulation Tool

2003-06-10 Thread Tor Rune Skoglund
gards Tor Rune Skoglund, CEO [EMAIL PROTECTED] -- DataKompaniet as Teknobyen Innovasjonssenter, Abelsgt. 5 Tel: +47 73 51 51 51 N-7030 Trondheim, NorwayFax: +47 73 94 38 61 WWW:http://www.datakompaniet.no E-mail: [EMAIL PROTECTED] -- MySQL General Mailing List For

Making UPDATE return the no. of rows matched

2002-03-14 Thread Rune Steinseth
causes problems. Is there an easy way to get MySQL always return the number of rows matched in an UPDATE? Regards, Rune Steinseth __ Sjekk snørapporter... fra 500 ski-destinasjoner i Europa på http://no.snow.yahoo.com

Help! Hanging mysql

2002-01-25 Thread Rune Sandbakken
p and down around 20. Any ideas? Rune Sandbakken Solfaktor.com Gran Canaria - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

Re: Checking if Replication really works

2002-01-18 Thread Rune Sandbakken
cause after a mass update of records the subsequent diff used all memory an swap space. I think the size of the files should be less than the total RAM if you want to be sure that it will always work with the standard unix diff utility Rune

Re: What should I set in the mysql.user?

2002-01-18 Thread Rune Sandbakken
afest and easiest way is to use the --skip-networking option to mysqld. Rune - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: auto_increment

2002-01-15 Thread Rune Sandbakken
autoincremented one. You can insert a NULL in the autoincrement value field, which causes it to auto-increment. There are good reasons to rather explicitly specify fields: $dbh->do("INSERT INTO timein(employeeID,time,date) VALUES('$employeeID','$timein','$da

Max query size

2001-02-06 Thread Rune
Hello! I was wondering if anyone knows how big a qury can be in MySQL 2.23.14??? Rune Lanton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: Mysqld eats up RAM and CPU

2001-01-31 Thread Rune Hansen
with INTEL pro100 ethernet cards).. /rune On Tue, 30 Jan 2001, Matis, Jan wrote: > what about this ? > > 2*PII 450 MHZ > 1G RAM > data on hardware raid > > port= 3306 > socket = /tmp/mysql.sock > user= mysql > skip-locking > set-

High-load/SMP/Linux/sql-bench

2001-01-24 Thread Rune Hansen
er test will be appreciated. regards Rune Hansen [EMAIL PROTECTED] Viventus AS Liaveien 11, 1411 Kolbotn +4766812280/86 "It's a damn poor mind that can only think of one way to spell a word." --Andrew Jackson

Re: Warning: Can't create a new thread (errno 11).

2001-01-11 Thread Rune Hansen
# echo "8192" > /proc/sys/fs/file-max At the same time you will want to adjust your "inode-max" with: # echo "24576" > /proc/sys/fs/inode-max There shouldn't be any problems with threads on a RedHat 7.0 syst

slow queries -> crash [2]

2001-01-11 Thread Rune Hansen
ess operation for 4 months with these servers my guess is as the load on the server and amount of data grows replication fails. Please, tell me that I'm wrong. regards Rune Hansen [EMAIL PROTECTED] Viventus AS +4766812280/91 We are but