Re: Can anyone tell me what GLIBC version is causing Mysql to crash?
glibc ver. 2.2.40 In fact is the gethostby* functions which is create problems. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: David Kramer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 11:33 PM Subject: Can anyone tell me what GLIBC version is causing Mysql to crash? Can anyone tell me what GLIBC version is causing Mysql to crash? Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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
How much data can MySQL push out?
We are experiencing some issues with performance on a non-MySQL box and are looking for alternatives (and alternative methods). Once of the issues that we seem to be facing, is that the pure volume of data which needs to be pushed out. The other database is pushing out (at peak) 12.5 megabytes per second and is being hit with 30-45 queries per second. If we rework the application, we end up with one of two solutions: 1) move to MySQL for the database engine (it currently is MSSQL) 2) Rework the application, so that the application still talked to MSSQL, but we generate static pages (this is for a website) and store them in MySQL, which are then served. This will reduce both bandwidth and queries per second. Bandwidth is unknown, but the queries per second are estimated at 15-25 queries per second. The select statements would be very generic though (select * from table where ID='abc123') This leaves one major question. How much data can MySQL push out? Can MySQL handle 12.5 megabytes (not megabits) per second of data? Will MySQL handle 20 queries per second? I know a lot of this also determined by OS/hardware. MySQL would be running on a 2-CPU Sun box. Any information with regards to this would be of use. If anyone also has such information on MSSQL (what is the Application Limit of MSSQL) it would also be helpful. thanks benji --- Ben Spencer Web Support [EMAIL PROTECTED] x 2288 - 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 much data can MySQL push out?
Sorry, I do not have much experience with MySQL on Suns (at least not in pushing it to the limits). On an Athlon 700Mhz selecting 1 random rows out of 6, I get over 330MB/sec (1000 queries/sec) on localhost and about 5.5MB/sec via a 100MBit TCP connection using the mysql command line client like this: this helps A LOT. MySQL doesn't have to be on the Sun Box. What OS where you using? We could put MySQL on a Windows box. I don't know that I could convince them to put it on a Linux box though. --- Ben Spencer Web Support [EMAIL PROTECTED] x 2288 - 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 much data can MySQL push out?
The government has a white paper on this. Just !google benchmark MySQL -Original Message- From: Benji Spencer [mailto:ben.spencer;moody.edu] Sent: Thursday, October 31, 2002 9:36 AM To: Benjamin Pflugmann Cc: [EMAIL PROTECTED] Subject: Re: How much data can MySQL push out? Sorry, I do not have much experience with MySQL on Suns (at least not in pushing it to the limits). On an Athlon 700Mhz selecting 1 random rows out of 6, I get over 330MB/sec (1000 queries/sec) on localhost and about 5.5MB/sec via a 100MBit TCP connection using the mysql command line client like this: this helps A LOT. MySQL doesn't have to be on the Sun Box. What OS where you using? We could put MySQL on a Windows box. I don't know that I could convince them to put it on a Linux box though. --- Ben Spencer Web Support [EMAIL PROTECTED] x 2288 - 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: UPS (Was: Mysql in Innodb)
Almost all modern unix type systems come with the powerd daemon. -Original Message- From: Jan Steinman [mailto:Jan;Bytesmiths.com] Sent: Thursday, October 31, 2002 10:46 AM To: [EMAIL PROTECTED] Subject: UPS (Was: Mysql in Innodb) From: gerald_clark [EMAIL PROTECTED] A UPS is of little use if you dont have software installed to shut the computer down when AC power is lost. That may be true of un-attended operation, but if someone is around to shut down when the UPS starts making noise, Bob's your uncle! But such software is standard issue with most UPS's these days, no? -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - 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 much data can MySQL push out?
They've been using Replication for a long time at Slashdot. Really? If I were to go by their Alexa traffic rating of 1390, I'd think it would not even be necessary. Our traffic ranking is 859 and we don't need to do anything like that. Maybe Alexa is not a good measure. :( I like our ranking there... I'll check what our bandwidth utilization is. We don't have a problem yet. Sql query Sincerely, Steven Roussey http://Network54.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql fills the disk with temporary files?
From: Lars Andersson [EMAIL PROTECTED] Thanks for your advices, but I don't want to solve this problem on the OS/shell level. Assuming MySQL is installed properly, with its own user and group, I don't see why you should not want to solve the problem this way. -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - 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
Replication with rewriting
I've got, in my slave my.cnf: replicate-wild-do-table = RemoteTableName replicate-rewrite-db = RemoteTableName-LocalTableName ... and the slave thread seems to be happily following along with the sequence numbers on the master, but when I insert data into the master's RemoteTableName, nothing shows up on the slave. Any thoughts (SQL)? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
Creating users through SQL
How do I create users for a specific database using SQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
data modeling question
Hello all, I have an 'items' table with 2 'types' of items -- 'foo' 'bar' Say that items of type 'bar' may be further classified as 'subtypes' 'baz', 'quux', etc. Now I build an online store so that visitors may buy items. Contstraints 1.) I would like to, as much as possible, use the same code for ordering 'foo'-items and 'bar'-items. 2.) If a user orders a 'bar'-item, they MUST specify a subtype. I.e. -- one may buy a 'bar-baz', or a 'bar-quux', but NEVER a 'bar'. My questions are these: 1.) Does it make more more sense to split the 'items' table into a 'foos' table and a 'bars' table? This means I will often have to recombine them using more than one query: select * from foos where foos.id in (shoppingcart) + select * from bars where bars.id in (shoppingcart) 2.) If I DON'T split into 2 tables, I must then keep the '#inStock' in both the 'items' table (for 'foo'-items) and in the 'subtypes' table (for 'bar'-items). This doesn't feel right. Any suggestions? Thanks, all! -- WF - 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
subquerys?
Hi! mysql experts, I'm migrating my access db's to mysql but some querys in Access need sub querys. I know that is n't possible with mysql but maybe with the beta distribution I could do it. can some body helpme, maybe there are other way to do it. thanks, Victoria - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to query a varchar column's value staring with a string?
Hi there, how can I query all the values starting with 'test'? I tried the following query, but it didn't work select * from theTable where ( ( theColumn || '%' ) like 'test' ); Thanks, Andre mySQL __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Still not getting a mysql prompt
- Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'CM Miller' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, November 01, 2002 3:16 AM Subject: RE: Still not getting a mysql prompt In order to perform these tasks you may need to stop the mysqld daemon with killall -9 mysqld (may need to enter it a couple of times it tends to try to restart. Never kill mysqld with -9; you may lose data that way. Kill it regularly; like this: kill -TERM `cat /var/run/mysqld.pid` (Or wherever your pid resides). Actually, no UNIX process should ever be killed with -9, unless it became totally stuck. Always allow a graceful closure. - Mark System Administrator Asarian-host.org - 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: Multiple MySQL Instances...
Hello Matt You probably already thought of this - but why not just set up a database or table for each department and set up separate users with privileges to their corresponding database or table? It would virtually accomplish the same thing. They would have their own database that could only be accessed by them and couldn't be squashed (or even accessed) by other departments. Just a thought! jeff -- Hey All, On Redhat Linux is there an easy way to have an ISP style setup where each user has their own database directory? Long story short, we have to implement a small in house server that will allow multiple departments to create their own little web pages. Perhaps I've missed something on MySQL.com and I know I've looked high and low on Google and haven't been able to find anything that matches. We're trying to avoid each of the departments squashing the other's data somehow and thought this would be the best way if it's possible? I'm looking for any pointers or How-To's or just a simple You missed section X in the documentation... Thanks in advance! Matt - 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