Re: [vchkpw] Mysql Threads
X-Istence wrote: Adam Hooper wrote: Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance. Last i checked Slashdot was running PostGreSQL. http://www.mysql.com/press/user_stories/slashdot.html Naturally, Slashdot has been running on the world's most popular open source database, MySQL, since the site's inception in 1997 (published April 2002). Have they switched more recently? I never heard of it if they have -- Adam Hooper [EMAIL PROTECTED]
Re: [vchkpw] Mysql Threads
On Monday 24 November 2003 19:57, Mandy wrote: Hello, I saw, that on the mailserver there are 10 Mysqltreads waiting for requests. Everyone of the use 10MB RAM (standard installation of the rpms) Is this nessesary, our would 2 threads be enought. If yes, where can i change this ? Because 10 Threads -- 10 MB Ram -- 100MB RAM only for mysql ?? threads ? or processes? usually threads share memory, processes don't. so 10 processes with 10mb ram each = 100mb 10 threads with 10mb ram = 10mb but as vpopmail doesn't use threads, this is quite offtopic. -- Mit internetten Grüßen / Best Regards --- Justin Heesemannionium Technologies [EMAIL PROTECTED]www.ionium.org
Re: [vchkpw] Mysql Threads OT
Sorry for the OT. But maybe you can help me elsewhere ;-) This is an output of top. Maybe this help you (and me). Only the Mailsystem is running . 8:09pm up 5 days, 22:00, 0 users, load average: 0,00, 0,02, 0,00 52 processes: 51 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 0,2% user, 0,4% system, 0,0% nice, 99,4% idle Mem: 514488K av, 474188K used, 40300K free, 0K shrd, 102196K buff Swap: 498004K av, 15948K used, 482056K free 273092K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 22044 spamd 8 0 19572 16M 3584 S 0,0 3,3 0:05 spamd 1765 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:10 mysqld 1784 mysql 12 5 1 9988 1268 S N 0,0 1,9 0:15 mysqld 1785 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:00 mysqld 1786 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:00 mysqld 1787 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:00 mysqld 1788 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:00 mysqld 1789 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:00 mysqld 1790 mysql 13 5 1 9988 1268 S N 0,0 1,9 1:28 mysqld 1791 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:00 mysqld 1792 mysql 13 5 1 9988 1268 S N 0,0 1,9 0:03 mysqld 9106 www9 0 8924 8924 3780 S 0,0 1,7 0:00 httpd Justin Heesemann wrote: threads ? or processes? I think processes ?! usually threads share memory, processes don't. so 10 processes with 10mb ram each = 100mb 10 threads with 10mb ram = 10mb but as vpopmail doesn't use threads, this is quite offtopic. regards mandy
Re: [vchkpw] Mysql Threads
They're threads, they share the same memory. So all the MySQL threads are sharing, among them, 10 megs. For an RDBMS, MySQL is quite lightweight. -- Adam Hooper [EMAIL PROTECTED] Mandy wrote: Hello, I saw, that on the mailserver there are 10 Mysqltreads waiting for requests. Everyone of the use 10MB RAM (standard installation of the rpms) Is this nessesary, our would 2 threads be enought. If yes, where can i change this ? Because 10 Threads -- 10 MB Ram -- 100MB RAM only for mysql ?? regards mandy.
Re: [vchkpw] Mysql Threads
I don't quite follow you. Why is it not relational? Note that MySQL's InnoDB table storage supports transactions, row-level locks, and foreign keys. -- Adam Hooper [EMAIL PROTECTED] Erik Bourget wrote: Adam Hooper [EMAIL PROTECTED] writes: They're threads, they share the same memory. So all the MySQL threads are sharing, among them, 10 megs. For an RDBMS, MySQL is quite lightweight. Then again, it's not an RDBMS (note the lack of 'relational'). SQL syntax doesn't make an RDB. - Erik
RE: [vchkpw] Mysql Threads
InnoDB and MyISAM (and others) are the storage engines behind Mysql. As far as performance goes, InnoDB is very fast was well. We have been using it on Production servers for over a year now and it works great. Ross Davis DataAnywhere.net 250-470-9192 ChaletsOnline.com is coming soon Don't you deserve a vacation! -Original Message- From: Erik Bourget [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:13 PM To: Adam Hooper Cc: Mandy; VCHKPW Mailinglist Subject: Re: [vchkpw] Mysql Threads Adam Hooper [EMAIL PROTECTED] writes: I don't quite follow you. Why is it not relational? Note that MySQL's InnoDB table storage supports transactions, row-level locks, and foreign keys. To be fair, I don't count InnoDB as mysql. Perhaps I should. Is it production-ready (I assume so)? How is the speed compared to featureless myisam? - Erik
Re: [vchkpw] Mysql Threads
I've never had problems with InnoDB in the past 1-2 years. In one case it's being used for some fairly computationally intense PHP website calculations. Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance. It's around the same speed as MyISAM. One thing it's missing is fulltext searching... but you can't win 'em all It's not really all that useful for vpopmail, because all the data's in one table anyway. But using InnoDB wouldn't cause all that much harm. InnoDB is installed and initialized by default on MySQL 4.x. To use it, just ALTER TABLE table_name TYPE=InnoDB (could take a while if it's a big table -- you might want to create a separate InnoDB table and copy a few thousand rows at a time), or when CREATE-ing, CREATE TABLE table_name (blah blah blah) TYPE=InnoDB. -- Adam Hooper [EMAIL PROTECTED] Erik Bourget wrote: Adam Hooper [EMAIL PROTECTED] writes: I don't quite follow you. Why is it not relational? Note that MySQL's InnoDB table storage supports transactions, row-level locks, and foreign keys. To be fair, I don't count InnoDB as mysql. Perhaps I should. Is it production-ready (I assume so)? How is the speed compared to featureless myisam? - Erik
Re: [vchkpw] Mysql Threads
Adam Hooper wrote: I've never had problems with InnoDB in the past 1-2 years. In one case it's being used for some fairly computationally intense PHP website calculations. Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance. It's around the same speed as MyISAM. One thing it's missing is fulltext searching... but you can't win 'em all It's not really all that useful for vpopmail, because all the data's in one table anyway. But using InnoDB wouldn't cause all that much harm. InnoDB is installed and initialized by default on MySQL 4.x. To use it, just ALTER TABLE table_name TYPE=InnoDB (could take a while if it's a big table -- you might want to create a separate InnoDB table and copy a few thousand rows at a time), or when CREATE-ing, CREATE TABLE table_name (blah blah blah) TYPE=InnoDB. Last i checked Slashdot was running PostGreSQL.
