Re: SQL: Shared hosting and innodb support
Greetings Michael: Thank you for your prompt response. When you state, "With InnoDB tables, all the data is stored in monolithic files" does that mean every database, every database table, etc. all reside within the same file systems? Thank you. At 10:17 AM 11/29/2002 -0500, you wrote: On Fri, Nov 29, 2002 at 08:59:22AM -0500, Peter M. Perchansky wrote: > > I've seen posts in a variety of forums where it states a lot of hosting > companies do not offer support for Innodb SQL type tables. AFAIK, there is no easy way to do space management on a per-customer basis with InnoDB tables. With MyISAM tables you can easily set a user's drive space limitations and the tables won't grow anymore at that point. With InnoDB tables, all the data is stored in monolithic files. -- Michael T. Babcock ____________ Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web: http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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
SQL: Shared hosting and innodb support
Greetings: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. Is there a reason for this issue? What are the reason(s)? Thank you! - 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
SQL: Shared hosting and innodb support
Greetings: I've seen posts in a variety of forums where it states a lot of hosting companies do not offer support for Innodb SQL type tables. Is there a reason for this issue? What are the reason(s)? Thank you! - 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
Help with delete query
Greetings: Thanks to Jay from this list and doing some reading, I resolved the insert issue when trying to insert records using a select where the tables are the same. Now I'm trying to clean up the old records, and no matter what delete statement I try, it fails: DELETE FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; DELETE Content, Customer FROM Content, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; I've read http://www.mysql.com/doc/D/E/DELETE.html several times and don't know what I'm doing wrong. Here's an example with the error message: DELETE Content, Customer FROM Content, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; ERROR 1064: You have an error in your SQL syntax near 'Content, Customer FROM Content, Customer WHERESUBSTRING(Server_ID, 5,4) = Custo' at line 1 Thoughts on how to fix? Thank you. - 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 query help please
Greetings Jay: RE: mySQL query help please I love rules that don't make sense ;-) So if the end result is to have the records selected appended to the Customer_Equipment table, I have to make a temporary table based on the characteristics of the Customer_Equipment table... then insert from that temporary table. Correct? Thank you. At 12:29 PM 6/24/2002 -0500, you wrote: >[snip] >INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, >Configuration, Equipment_Type, Group_ID, Location, Rack_Location, >Network_Status_Name, Creator_ID, Primary_IP_Address FROM >Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = >Customer.User_ID; > >The select statement works perfectly, but when I try to combine the select >statement with an INSERT INTO statement (I've done this in the past), I get >the error message: > > ERROR 1066: Not unique table/alias: 'Customer_Equipment' >[/snip] > >You cannot INSERT into a table that you have SELECT 'ed from; > >INSERT INTO Customer_Equipment SELECT ... >FROM Customer_Equipment, Customer Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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
mySQL query help please
Greetings: RE: mySQL query help please INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID, Configuration, Equipment_Type, Group_ID, Location, Rack_Location, Network_Status_Name, Creator_ID, Primary_IP_Address FROM Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) = Customer.User_ID; The select statement works perfectly, but when I try to combine the select statement with an INSERT INTO statement (I've done this in the past), I get the error message: ERROR 1066: Not unique table/alias: 'Customer_Equipment' What does this error message mean, and how should I accomplish my insert into statement so I can use the results of the select statement above? Thank you. ________ Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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: Question on mySQL replication
Hi Jeremy: Thank you. At 02:05 AM 12/16/2001 -0800, you wrote: >On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote: > > Greetings everyone: > > > > RE: http://www.mysql.com/doc/R/e/Replication.html > > > > How frequently does each slave get data from the master? > >The slaves have a thread running (the "slave thread") which is always >connected to the master, waiting for new queries. - 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
Question on mySQL replication
Greetings everyone: RE: http://www.mysql.com/doc/R/e/Replication.html How frequently does each slave get data from the master? If the server the master was on went down unexpectedly, how much data would still be on the master that the slave(s) may not have picked up? Thank you. - 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
Can mySQL log files be located on another server?
Greetings: http://www.mysql.com/doc/B/i/Binary_log.html Is it possible to place this and the error log file generated by mySQLd on the hard drive on another server? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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
Linux vs. Sun and getting Linux to behave like Sun
Greetings everyone: I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will be two processes running (safe_mysqld and mysqld). And this number of processes running will very rarely change, if at all, without concern over the number of connections or how heavily mySQL is being utilized. On Linux there appears to be a correlation to the number of mysqld processes and how heavily mySQL is being hit (connections, queries, etc.). Questions: 1. Are my observations correct? 2. Is there a way to compile mySQL on Linux so that it behaves like on Sun where by there is the safe_mysqld and mysqld process only no matter the activity? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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: Databases and ADODB
Greetings: We have been using it with great success for our enterprise level network monitoring system. We use mySQL as the back end database server, PHP for the user interface, and a combination of Perl / C++ for the actual monitoring. At 04:32 PM 8/18/2001 +0200, you wrote: >Anyone made good experiences >with the ADODB Library for PHP4? ____ Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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
Help with complex SQL Query
Greetings: Prelude: We have five tables all sharing a very similar structure (each has a Customer_ID and Server_ID field for example). Each table can contain zero to many records with duplicate Server_ID values allowed. Need: I need to be able to count the distinct Server_ID's across all of the tables. Problems: A customer can have one Server_ID in one table, ten Server_ID's (some duplicate) in another table and so on. The customer will have the same Customer_ID in all tables. I've tried inner joins, left joins, et all to no avail. The syntax below will only show two Server_ID's for a customer that has close to 10. SELECT DISTINCT Application.Server_ID FROM Application LEFT JOIN Content ON Application.Customer_ID = Content.Customer_ID LEFT JOIN Performance ON Content.Customer_ID = Performance.Customer_ID LEFT JOIN Ping ON Performance.Customer_ID = Ping.Customer_ID LEFT JOIN Port ON Ping.Customer_ID = Port.Customer_ID WHERE Application.Customer_ID = 1 OR Content.Customer_ID = 1 OR Performance.Customer_ID = 1 OR Ping.Customer_ID = 1 OR Port.Customer_ID = 1; What is the correct SQL to get a list of all of the distinct Server_ID's across the five tables? Thank you. ________ Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.wemanageservers.com/
Order by clause for datetime stamp format
Greetings: I'm using the datetime format and the data is stored in mySQL as CCYY-MM-DD HH:MM:SS I want to use a SELECT statement where the ORDER BY clause is based on the date portion (CCYY-MM-DD). How would I write the clause to ignore the time portion? Thank you. Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 109 East High Street PO Box 86 Womelsdorf, PA 19567 Voice: 1-610-589-2262 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.wemanageservers.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: Need examples of companies using mysql
Greetings Steve: At 12:01 AM 3/31/2001 +0100, Steve Allsopp wrote: >"Dexterus (www.dexterus.com) is a VC-funded company set up to provide >application services to the banking industry in the City of London. While >we are still in the pre-launch stages (we launch Tuesday!), we are aiming >for a 99.999% SLA service agreement, so our systems *have* to be reliable. >Now, if I can just figure out a mirroring/failover setup for MySQL, I >could shut the Oracle types up for good - OPS is really rather *too* >heavyweight for what we need! :-)" I'm not sure if it helps or even applies, but Verio and other companies (including ours) have been using the advanced server monitoring at http://www.wemanageservers.com/ to handle SLA reporting and compliance. ________ Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 109 East High Street PO Box 86 Womelsdorf, PA 19567 Voice: 1-610-589-2262 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.wemanageservers.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: Need examples of companies using mysql
Greetings: We Manage Servers (http://www.wemanageservers.com/) - Their ASP-based advanced monitoring service utilizes the power of mySQL. While I don't have the institutions name, I was told by Verio Advanced they have a financial institution running mySQL. XOXO Clothes (http://www.xoxo.com/) Many others... Other: http://www.mysql.com/news/article-57.html http://www.mysql.com/news/article-51.html http://www.mysql.com/news/article-62.html Peter M. Perchansky, Microsoft FrontPage MVP Dynamic Net, Inc. Helping companies do business on the Net 109 East High Street PO Box 86 Womelsdorf, PA 19567 Voice: 1-610-589-2262 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.wemanageservers.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