Capacity/Load question

2007-02-10 Thread Gary W. Smith
Hello, Just looking for a little feedback before deciding on a data engine path and configuration. We're working on an application that is expected to have a high growth rate over the coming years. We're at the stage of designing the backend databases to maximize performance while keeping costs

RE: Server Load Question

2006-06-19 Thread Robinson, Eric
Cc: mysql@lists.mysql.com Subject: Re: Server Load Question Eric, I sent you a note about hardware this morning as well, but here's a further thought - Don't know if this is the case, but is this the exact same application served to 100 different customers? And are Database-2 and Dat

Re: Server Load Question

2006-06-19 Thread Dan Buettner
Eric, I sent you a note about hardware this morning as well, but here's a further thought - Don't know if this is the case, but is this the exact same application served to 100 different customers? And are Database-2 and Database-3 the same for every customer? Some kind of reference info per

Re: Server Load Question

2006-06-19 Thread Brent Baisley
ng performance issues. - Original Message - From: "Robinson, Eric" <[EMAIL PROTECTED]> To: Sent: Monday, June 19, 2006 1:01 PM Subject: Server Load Question I asked this question previously but didn't get much response so I'll try again. Our server will be home

Re: Server Load Question

2006-06-19 Thread Chris White
On Monday 19 June 2006 10:01 am, Robinson, Eric wrote: > Q: In terms of performance, is it better for each customer to have its > own instance of MySQL, each serving 3 databases, or is it better to have > one instance of MySQL serving 300 databases? > > --Eric Can you clarify a bit on instance? A

Server Load Question

2006-06-19 Thread Robinson, Eric
I asked this question previously but didn't get much response so I'll try again. Our server will be home to 100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. Each client has 3 databases. Database-1: 500 tables. 13 t

Re: Deleting column data & LOAD question

2003-11-19 Thread William Fong
ut security. -will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) - Original Message - From: "Patrick Larkin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 19, 2003 11:47 AM Subject: Deleting column data &

Deleting column data & LOAD question

2003-11-19 Thread Patrick Larkin
Hello - what would the syntax be to delete all the data in a column for every record but still maintain the column? In other words, I don't want to delete the column, just the data in it. Second, is there a way I can LOAD a file of plain text passwords into a mysql database and encrypt them d

Re: Load question

2001-02-09 Thread Eric Fitzgerald
antana" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 09, 2001 9:08 AM Subject: Load question > We are currently running Blackboard 5 level 1 (an online course management > package) which utilizes MySQL v3.22.32. Our previous semesters saw a course > loa

Load question

2001-02-09 Thread Jesse Santana
We are currently running Blackboard 5 level 1 (an online course management package) which utilizes MySQL v3.22.32. Our previous semesters saw a course load of approximately 85 courses under which, MySQL performed extremely well. This semester, we have skyrocketed to 768 courses. Now, our server