Re: Administrative limitation
On Fri, 2004-04-02 at 08:30, David Fleming wrote: (newbie question) Our web host provides one (1) MySQL database for our account, and phpmyadmin as the admin interface. We don't have privileges to create a new database. We would like to install 2 or 3 unrelated applications that will utilize the database (forum, image gallery, product catalog). Is the fact that we can't create a separate database for each application going to be a problem? As long as there's no duplication of table names, can multiple applications safely use a single database? Thanks for the help. -- David Fleming [EMAIL PROTECTED] If multiple databases are not an option, quite a few applications (phpbb, oscommerce, etc) support installations with prefixed table names (IE phpbb_thistable, phpbb_thattable) Dan Vande More -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Auditing
/* repost: considering I have no answers, is it safe to conclude it's not feasible?*/ I'd like to be able to audit connections to mysql databases. Here is what I'd like to see: Who connected to the server. What IP did they come from. When they disconnected. Any permission denied errors they may have had. The only thing that comes close to that is the general log, which is quite a bit of overhead. Has anyone come up with a solution for this? Does anyone see this in future versions? I've attempted the general query log, but it's not really in the best format for generating reports. Additionally, it's quite bloated when you do 300q/s. I've tried pushing it to a fifo, so I can have a daemon get the information, but mysql doesn't support that either. (my.cnf:log=/var/log/mysql.fifo) or (my.cnf:log=|/var/log/mysql.fifo, like syslog.conf) Has anyone else found solutions for this? Thanks! Dan Vande More -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Auditing
I'd like to be able to audit connections to mysql databases. Here is what I'd like to see: Who connected to the server. What IP did they come from. When they disconnected. Any permission denied errors they may have had. The only thing that comes close to that is the general log, which is quite a bit of overhead. Has anyone come up with a solution for this? Does anyone see this in future versions? I've attempted the general query log, but it's not really in the best format for generating reports. Additionally, it's quite bloated when you do 300q/s. I've tried pushing it to a fifo, so I can have a daemon get the information, but mysql doesn't support that either. (my.cnf:log=/var/log/mysql.fifo) Has anyone else found solutions for this? Thanks! Dan Vande More -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Cut Copy Paste
Mysqlfront works well, though I don't believe you can cut. -Original Message- From: Mark Herzog [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:02 AM To: [EMAIL PROTECTED] Subject: Cut Copy Paste Cut, Copy, and Paste functions are not available in the SQL Query tool in my MySQLManager tool. Any ideas? Thanks. Mark Herzog Contour Systems Phone: (952) 935-0141 Cell:(612) 207-6530 Email: [EMAIL PROTECTED] - 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
FW: Automatic timestamping
Yes, just change the row in some way(or insert a row), and it will insert the date automatically. (be sure to insert null in the timestamp field, or leave it out of your update query) I use the feature for many things. Thanks dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 9:50 AM To: [EMAIL PROTECTED] Subject: Automatic timestamping Hi all, As I'm not very experienced with DB technology, I'm very sorry if my question seems stupid. I have set up a MySQL server as a central data repository where various clients are to write and read data concurrently. One of the attrbutes of the tables that are going to be managed by the MySQL is a TIMESTAMP. However, it is important to me that ALL clients use the same time source when they create records onto these tables. My question is: is it possible to use the clock of the MySQL machine as an unique time source for every table update ? I mean, can I simply leave to the MySQL server to automatically fill the TIMESTAMP attribute when new records are inserted ? Thnks for any help. F Lucchese - 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: why does MySQL need to access the internet? my firewall wants to know
Yes, it is most certainly because mysql wants to open port 3306. If it's zone alarm, it probably says it's trying to access 127.0.0.1. -Original Message- From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 7:26 AM To: Matthew K. Gold; MySQL Subject: Re: why does MySQL need to access the internet? my firewall wants to know Hi, Are you sure that is trying to access the internet. It may be trying to open the port, remember that MySQL needs 3306 (by default) to communicate with the server. I think if you just open that port, everything will be ok. Bye and Good Luck. --- Matthew K. Gold [EMAIL PROTECTED] wrote: Hi, When I try to start MySQL, I get alerts from my personal firewall that MySQL is trying to access the internet...why would this happen? I'm currently using (or trying to use) Abriasoft's Merlin desktop, which includes apache. I would have thought that if I'm running a apache on my own computer, there would be no need to access the internet. I would guess that this has something to do with Abriasoft, except that this also happened to me when i was running MySQL without the aid of merlin or anything else. I'd appreciate it if anyone could shed some light on this matter... Thanks, 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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.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 - 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: Lost root password
http://www.mysql.com/doc/C/o/Command-line_options.html See --skip-grant-tables -Original Message- From: michael johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:33 AM To: Support at Mysql; mysql@lists. mysql. com Subject: Lost root password We have a support contract with you. One of my clients has lost his root password. How can we access his mysql? Michael Johnson - 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 - 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: help !
Do a telnet 10.10.10.250 3306 then a ctrl-] to end it. What do you see? -Original Message- From: Brett Whittaker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:29 AM To: [EMAIL PROTECTED] Cc: Brett Whittaker Subject: help ! I was trying to connect into an MYSQL database, and I keep getting the error message Can't connect to MySQL server on '10.10.10.250' (10054) but I know that the database is running and I can connect fine on the server itself! Any suggestions would be greatly appreciated. - 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
Binary File in DB vs. File in directory --looking for archived discussion
I'm trying to find any and all thoughts on whether to store files in the db (PDF's, word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead because of new folders, each client having thier own folder(and subfolders) etc. And then htaccess'ing the dir's independently along with the overhead of keeping track of the htaccess files. I admit php has good classes for htaccess stuff, but the intergration between apache and php security isn't at that level yet. Right now I'm developing on my own server, but it will be moved to a hosting co, so I'm not sure if they will have mod_auth_mysql ,probably not due to the limitations for required settings in the conf file. So I started developing with the htaccess stuff, and am now pondering the use of the db to store the files, I did some searching and found several people saying there was a huge discussion on the mailing list about the middle of 2001, but I've been unable to find it. Does anyone know where this is? Can anyone throw out a few drawbacks/advantages other than the ones I'm thinking of? Will anyone elighten me? Thank you, Dan sql, query - 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
Binary File in DB vs. File in directory --looking for archived discussion
I'm trying to find any and all thoughts on whether to store files in the db (PDF's, word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead because of new folders, each client having thier own folder(and subfolders) etc. And then htaccess'ing the dir's independently along with the overhead of keeping track of the htaccess files. I admit php has good classes for htaccess stuff, but the intergration between apache and php security isn't at that level yet. Right now I'm developing on my own server, but it will be moved to a hosting co, so I'm not sure if they will have mod_auth_mysql ,probably not due to the limitations for required settings in the conf file. So I started developing with the htaccess stuff, and am now pondering the use of the db to store the files, I did some searching and found several people saying there was a huge discussion on the mailing list about the middle of 2001, but I've been unable to find it. Does anyone know where this is? Can anyone throw out a few drawbacks/advantages other than the ones I'm thinking of? Will anyone elighten me? Thank you, Dan sql, query - 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
multiple db, multiple table join
Good evening all, I have a strange situation which I cannot think myself out of. To make it simple my db looks like this (hr db, emp_master table) ++---+ | emp_id | last_name | ++---+ | 1 | smith | | 3 | wesson| | 4 | doe | | 6 | clinton | | 7 | bush | ++---+ (tools db, orders table) ++-+-+ | order_id | emp_id |approved_by | ++-+-+ | 1 | 1| 6 | | 2 | 4| 7 | | 3 | 3| 4 | | 4 | 7| 3 | | 5 | 6| 1 | ++-+-+ I want my query results to be similiar to this: if I'm selecting all, this is what I want: 1 smith clinton 2 doe bush 3 wesson doe 4 bush wesson 5 clintonsmith It seems so easy, but I've tried hard and cannot get it to work I've been going along the lines (changed several times) of Select tools.orders.order_id, hr.emp_master.last_name as ordered_by, hr.emp_master.last_name as approved_by from tools.orders, hr.emp_master where ((tools.orders.emp_id=hr.emp_master.emp_id) and (tools.orders.approved_by=hr.emp_master.emp_id)) (I hope I wrote that right, it was freehand, not in db) Thank you for any direction you can give me! Dam - 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: SubSelect Problem
Perhaps I am missing something right in front of me, or I have not been in the loop, but it is my understanding that MySQL does not support sub-selects, yet. http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html BTW, you may receive lots of replies of this very nature, because it is something everyone knows, and everyone will want to comment on. Good luck, Dan -Original Message- From: Alex Speed [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 5:13 PM To: [EMAIL PROTECTED] Subject: SubSelect Problem SELECT textid, title, description from structure where textid in (select subtopicid from subtopic where topicid='Top'); this gives an error at the opening bracket.. I am assuming that mysql realises that structure.textid=subtopic.subtopicid ...any ideas on getting this working? thanks for any help! Alex - 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: problem running the mysql server!
A lot of us here use simple techniques for troubleshooting. For errors, I first look in the log file for mysql. But almost always, I google it. Google turned up A LOT of results for a 1067, with tons of fixes. The query I used was mysqld-nt 1067 The first results it pulled were from mysql's site, from the manual. If you dared to look farther down, you would see a medium quantity of people complaining and wanting somebody to hold their hand. At least 3 or 4 fixes were VERY well documented, a simple search for 2 words and 3 paragraphs of reading could have solved your problem. The 5th google result took me to phpbuilder where the fix was again, well documented by a very nice guy. We do try to help, but cannot help you when you're not willing to try yourself. Ignorance has never helped anyone. Remember, google indexes mysql, php, phpbuilder.net and TONS of other sites, even MS. I never use the MS KB tool to search anymore because it totallty blows. Instead I use google, because it indexes MS. Also keep in mind that the third tab of google contains google groups, a 20 year archive of newsgroup posts, that contain every question you ever plan on asking, and quite possibly answers. If you ever get really bored, I suggest taking 5 minutes and skimming here: http://www.google.com/googlegroups/archive_announce_20.html It contains many many cool things, such as the first post about MS, Linus Torvalds post introducing Linux. Some dude beating on Linux and defending minix, and arguing with Linus Torvalds. Post showing Jeff Bezos hiring programmers for amazon.com(before amazon.com) and lots of other great stuff. Sorry this went OT, but perhaps we could point out to some people in this list the tremendous amount of resources available to them. PS I don't work for google, nor have anything to do with them, but I am waiting for them to set up a donation thing, because they've saved me a huge amount of time and made me a lot of money. Dan Aleksander, what does your log file say? Does the mysqld have permissions to write to the directory it's creating the DB's in? -Original Message- From: Alexander Hampel [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 9:57 AM To: [EMAIL PROTECTED] Subject: Re: problem running the mysql server! Hi Aleksander, Seems to be a problem to get MySQL started. = but no one of the advanced users/admins in this newsgroup is interested in helping other users out :-( Can't help you with your problem but probably will find it out together. Did you get error messages like mine too? Include here my problem here again (Win2000, MySQL 3.23.49): Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 17. März 2002 10:11 An: [EMAIL PROTECTED] Betreff: New to MySQL - can't start server :-( Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Do you know if there exists a document where error messages are listed? I installed 4.0.1-alpha-win and I could start the server - strange, isn't it? Try this version too - probably it helps :-) So long A:lex -Ursprüngliche Nachricht- Von: Aleksander Gziut [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 17. März 2002 18:24 An: [EMAIL PROTECTED] Betreff: problem running the mysql server! i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on an i686) and ran mysql_install_db script. then i tried to start the server: [root@localhost]# safe_mysqld enter [1] 1360 [root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql 020317 hh:mm:ss mysqld ended one question - what's that? why i can't run the server? can anybody help me? - 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 - 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:
FW: problem running the mysql server
-Original Message- From: Dan Vande More Sent: Sunday, March 17, 2002 10:20 AM To: [EMAIL PROTECTED] Subject: RE: problem running the mysql server! A lot of us here use simple techniques for troubleshooting. For errors, I first look in the log file for mysql. But almost always, I google it. Google turned up A LOT of results for a 1067, with tons of fixes. The query I used was mysqld-nt 1067 The first results it pulled were from mysql's site, from the manual. If you dared to look farther down, you would see a medium quantity of people complaining and wanting somebody to hold their hand. At least 3 or 4 fixes were VERY well documented, a simple search for 2 words and 3 paragraphs of reading could have solved your problem. The 5th google result took me to phpbuilder where the fix was again, well documented by a very nice guy. We do try to help, but cannot help you when you're not willing to try yourself. Ignorance has never helped anyone. Remember, google indexes mysql, php, phpbuilder.net and TONS of other sites, even MS. I never use the MS KB tool to search anymore because it totallty blows. Instead I use google, because it indexes MS. Also keep in mind that the third tab of google contains google groups, a 20 year archive of newsgroup posts, that contain every question you ever plan on asking, and quite possibly answers. If you ever get really bored, I suggest taking 5 minutes and skimming here: http://www.google.com/googlegroups/archive_announce_20.html It contains many many cool things, such as the first post about MS, Linus Torvalds post introducing Linux. Some dude beating on Linux and defending minix, and arguing with Linus Torvalds. Post showing Jeff Bezos hiring programmers for amazon.com(before amazon.com) and lots of other great stuff. Sorry this went OT, but perhaps we could point out to some people in this list the tremendous amount of resources available to them. PS I don't work for google, nor have anything to do with them, but I am waiting for them to set up a donation thing, because they've saved me a huge amount of time and made me a lot of money. Dan Aleksander, what does your log file say? Does the mysqld have permissions to write to the directory it's creating the DB's in? -Original Message- From: Alexander Hampel [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 9:57 AM To: [EMAIL PROTECTED] Subject: Re: problem running the mysql server! Hi Aleksander, Seems to be a problem to get MySQL started. = but no one of the advanced users/admins in this newsgroup is interested in helping other users out :-( Can't help you with your problem but probably will find it out together. Did you get error messages like mine too? Include here my problem here again (Win2000, MySQL 3.23.49): Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 17. März 2002 10:11 An: [EMAIL PROTECTED] Betreff: New to MySQL - can't start server :-( Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Do you know if there exists a document where error messages are listed? I installed 4.0.1-alpha-win and I could start the server - strange, isn't it? Try this version too - probably it helps :-) So long A:lex -Ursprüngliche Nachricht- Von: Aleksander Gziut [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 17. März 2002 18:24 An: [EMAIL PROTECTED] Betreff: problem running the mysql server! i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on an i686) and ran mysql_install_db script. then i tried to start the server: [root@localhost]# safe_mysqld enter [1] 1360 [root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql 020317 hh:mm:ss mysqld ended one question - what's that? why i can't run the server? can anybody help me? - 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
RE: Problem with using INSERT INTO [table] SQL string
Hey Don,
I read the whitepaper and it have come to the conclusion that when MS used
the words mySQL, they were not referring to MySQL, which is the list you are
on. They were referring to mySQL as my SQL just the same as myconnection and
Myemptywallet.
You see, most of us come here to get away from MS Access and MSSQL. The SQL
Server we use, MySQL, is free, and free from every licensing scheme MS uses.
It is also fast, very close to oracle, and often times pushes MSSQL off the
bottom of the chart.
The MySQL database server (a competitor to Access and MSSQL) is used in
environments that demand something more powerful that anything Microsoft,
such as
Yahoo Finance: http://www.mysql.com/articles/us/yahoo_finance.html
Nasa: http://www.mysql.com/articles/us/nasa.html
AIS: http://www.mysql.com/articles/us/ais.html
Read more:
http://www.eweek.com/article/0,3658,s=708a=23115,00.asp
If you read that article you may get a better understating of what I am
trying to relay.
Thanks
Dan
-Original Message-
From: Donald Guy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 9:55 AM
To: [EMAIL PROTECTED]
Subject: Problem with using INSERT INTO [table] SQL string
Hi all,
Please excuse any ignorance I may show with this question - as I am not a
programmer and I am trying to do something that is out of my experience. I
feel truly out of my element in this and am hoping that the list expertise
will help me. I have looked at the manual - but still am confused.
Basically, I am trying to set up forms using Microsoft FrontPage 2000 where
the results (form input) will be sent to a database (Microsoft Access 2000)
and to an email address. I am following instructions outlined in a
Microsoft white paper which has specifically been written to address this
topic (found at
http://download.microsoft.com/download/fp2000/whitep/1/NT5XP/EN-US/cdonts200
0.EXE)
My problem is that I can only get one form field value to be inserted into
my table. I think I have followed the instructions that the white paper
gives for building the mySQL string that is used to insert the form
information into the database - but I am having no success in getting all
the form information inserted into the databse.
--
The mySQL syntax given by the white paper is the following:
mySQL = INSERT INTO [your_table_name]
mySQL = mySQL ([database_field_names])
mySQL = mySQL VALUES ('[form_field_names]')
--
The example mySQL string in the white paper is:
mySQL= INSERT INTO Employees
mySQL= mySQL (FirstName,LastName,Address,City,Region,PostalCode)
mySQL= mySQL VALUES (' Request.Form(FirstName) ','
mySQL= mySQL Request.Form(LastName) '
mySQL= mySQL ,' Request.Form(Address) '
mySQL= mySQL ,' Request.Form(City) ','
mySQL= mySQL Request.Form(Region) ','
mySQL= mySQL Request.Form(PostalCode) ')
---
The white paper gives the following my SQL syntax to help with customizing
the SQL string:
INSERT INTO [table] ([DBfield1],[DBfield2]) VALUES
('[form_field1]','[form_field2]')
mySQL = INSERT INTO [table] (DBfield) VALUES ('
Request.Form(form_field) ')
--
Background:
The Microsoft Access 2000 database table I want to insert information into
is named Action
The form field names or VALUES I am trying to insert information from (from
the FrontPage 2000 form) are:
RequestDate
CommerceID
LastName
FirstName
Email
DepartmentNumber
Sector
StreetAddress
City
State
ZipCode
LocationCode
MailDrop
TelephoneNumber
FaxNumber
RequestType
Library
Request
The Microsoft Access 2000 database table field names (to which I want to
insert information into) are:
RequestDate
CommerceID
Client
FirstName
Email
DepartmentNum
Sector
StreetAddress
City
State
ZipCode
LocCode
MailDrop
TelephoneNum
FaxNum
ServiceName
InternalGroup
Request
The form field values correspond to the table colums in the following way:
RequestDate (value from form) insert RequestDate (database field name)
CommerceID (value from form) insert into CommerceID (database field name)
LastName (value from form) insert into Client (database field name)
FirstName (value from form) insert into FirstName (database field name)
Email (value from form) insert into Email (database field name)
DepartmentNumber (value from form) insert into DepartmentNum (database field
name)
Sector (value from form) insert into Sector (database Field name)
StreetAddress (value from form) insert into StreetAddress (database field
name)
City (value from form) insert into City (database field name)
State (value from form) insert into State (database field name)
ZipCode (value from form) insert into ZipCode (database field name)
RE: Delete User problem.
You would have a hard time removing the privileges using GRANT, I would suggest using revoke: http://www.mysql.com/doc/G/R/GRANT.html -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Delete User problem. So, you can see that I didn't delete him. Why? What I am doing wrong? How can I delete this user? Why do you want to delete an user by delete command from the users table?! For setting or deleteting permissions use GRANT/REVOKE commands instead. But How should I use Grant command to delete user from MySQL? -- Pozdrawiam, Marcin Pyla (o_ [ @ Marcin Pyla - Cubbi [EMAIL PROTECTED] | + NetArt ISP + @ ] (/)_ [ Nigdy nie ufaj systemowi operacyjnemu, do ktrego ] [ nie masz kodw rdowych. ] - 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
FW: IS THIS BETTER?
Is there a way to spam control caps? Like if 75% or more of the content is Capitalized, them ditch it rather then having to delete it manually? Sql , query -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 12:19 PM To: [EMAIL PROTECTED] Subject: IS THIS BETTER? - 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: sql help examining log table
I might be wrong, but this may get you going in the right direction: select count(subject) as count, subject from outgoing where auth='USER' group by subject order by timestamp desc limit 50 This would tell you each subject ever sent by the user, and how many times that subject has been sent. Such as: +---+--+ | count | subject | +---+--+ | 12| Subject 1| | 36| Subject 2| | 2| Another subject | +---+--+ And you can narrow it down if you know the subject such as: select count(subject) as count, subject from outgoing where auth='USER' and subject = 'Subject 2' group by subject order by timestamp desc limit 50 This would return +---+--+ | count | subject | +---+--+ | 36| Subject 2| +---+--+ I think this is right, if not hopefully my logic is. Regardless, hopefully something can be useful. Dan -Original Message- From: Viraj Alankar [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: sql help examining log table Hello, We use mysql to store outgoing email headers from our users and do throttling on users that appear to be spamming based on some simple queries to this table. We use the Communigate mail server and this throttling script is a PERL program implemented as a content filter. More information is here for those interested: http://www.cse.fau.edu/~valankar/ I am trying to figure out what is the best way to do a certain query. My outgoing log table looks like this: mysql desc outgoing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | rpath | varchar(80) | YES | | NULL| | | auth | varchar(80) | | MUL | | | | ip| varchar(80) | YES | | NULL| | | hfrom | varchar(80) | YES | | NULL| | | hto | varchar(80) | YES | | NULL| | | subject | varchar(80) | YES | | NULL| | | messageid | varchar(80) | YES | | NULL| | | timestamp | timestamp(14)| YES | | NULL| | | rcpts | smallint(5) unsigned | YES | | 0 | | +---+--+--+-+-+---+ What I would like to do is reject a message if the last 50 messages have the same subject. In other words, I want to look at the 50 latest entries in this table for a certain user (identified by the auth field) to find out if all of these messages have the same subject. The only way I can think of doing this is basically: select subject from outgoing where auth='USER' order by timestamp desc limit 50 And then going through each one of these rows in my program to see if they are all the same subject. Is there a way I can do this logic in the select query instead? Thanks, Viraj. - 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: sql help examining log table
Ditch the Limit 50 in those queries I wrote, they won't work, they only limit the result set, not the searched set. I don't know what I was thinking. If you need to searched set to be limited by the last 50 of the user, I cannot think of anything at this time, perhaps after a few more cups of coffee:) -Original Message- From: Dan Vande More [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:44 PM To: [EMAIL PROTECTED] Subject: RE: sql help examining log table I might be wrong, but this may get you going in the right direction: select count(subject) as count, subject from outgoing where auth='USER' group by subject order by timestamp desc limit 50 This would tell you each subject ever sent by the user, and how many times that subject has been sent. Such as: +---+--+ | count | subject | +---+--+ | 12| Subject 1| | 36| Subject 2| | 2| Another subject | +---+--+ And you can narrow it down if you know the subject such as: select count(subject) as count, subject from outgoing where auth='USER' and subject = 'Subject 2' group by subject order by timestamp desc limit 50 This would return +---+--+ | count | subject | +---+--+ | 36| Subject 2| +---+--+ I think this is right, if not hopefully my logic is. Regardless, hopefully something can be useful. Dan -Original Message- From: Viraj Alankar [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: sql help examining log table Hello, We use mysql to store outgoing email headers from our users and do throttling on users that appear to be spamming based on some simple queries to this table. We use the Communigate mail server and this throttling script is a PERL program implemented as a content filter. More information is here for those interested: http://www.cse.fau.edu/~valankar/ I am trying to figure out what is the best way to do a certain query. My outgoing log table looks like this: mysql desc outgoing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | rpath | varchar(80) | YES | | NULL| | | auth | varchar(80) | | MUL | | | | ip| varchar(80) | YES | | NULL| | | hfrom | varchar(80) | YES | | NULL| | | hto | varchar(80) | YES | | NULL| | | subject | varchar(80) | YES | | NULL| | | messageid | varchar(80) | YES | | NULL| | | timestamp | timestamp(14)| YES | | NULL| | | rcpts | smallint(5) unsigned | YES | | 0 | | +---+--+--+-+-+---+ What I would like to do is reject a message if the last 50 messages have the same subject. In other words, I want to look at the 50 latest entries in this table for a certain user (identified by the auth field) to find out if all of these messages have the same subject. The only way I can think of doing this is basically: select subject from outgoing where auth='USER' order by timestamp desc limit 50 And then going through each one of these rows in my program to see if they are all the same subject. Is there a way I can do this logic in the select query instead? Thanks, Viraj. - 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 - 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.sock
That's because you get this: '020317 16:48:10 mysqld ended.' It means there was an error, and the database server is no longer running. Check your mysql log files to find out why. Does the user, 'mysql' have permissions to write into the directory mysql is using, normally /var/lib/mysql Who is the owner, and group for that directory? And what are the permissions? Do an 'ls -la /var/lib/' You should have something like: 'drwxrwxr-x 25 mysqlroot 3072 Mar 16 23:00 mysql' or even 'drwxrwxr-x 25 rootmysql 3072 Mar 16 23:00 mysql' -Original Message- From: Art Fore [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 6:04 PM To: [EMAIL PROTECTED] Subject: RE: mysql.sock Found the file there, guess I missed it or it got created after I looked before If I run ./safe_mysqld --user=mysql I get Starting mysqld-max daemon with databases from /var/lib/mysql 020317 16:48:10 mysqld ended. I run mysqladmin u root -p piccolo 'new-password' Enter password: I then get connect to server at 'localhost failed If I run mysqld -ping, I get all kinds of info back. So guess I am completely lost. Art -Original Message- From: Mark Maunder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 4:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock Art, Do you mean, whenever you try to run the 'mysql' client you get that error? That usually happens because you are trying to connect to the mysql server using the mysql client running on the same machine i.e. localhost. It's because the mysql client uses a socket file when connecting locally and the mysqld server is not storing the file in the default location where the client expects it. Fix it by putting this entry in the file /etc/my.cnf under the [client] section. socket = /tmp/mysql.sock or whatever the location of your socket file is. If you can't find it do a find / -name mysql.sock Hope that helps, ~mark. http://www.workzoo.com/ Art Fore wrote: When I try to run the mysqld or safe_mysql, I get connot connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! This file does not exist. Where does it come from or how do you create it? I have done a search on the website, but no results. /etc/hosts file is also correct. Art - 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 - 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: Finding out whos using the database
SHOW PROCESSLIST -Original Message- From: Chip Wiegand [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 1:30 AM To: [EMAIL PROTECTED] Subject: Finding out whos using the database Is there a command that I can use to find out how many people, or more specifically, who, is using the database? I tried the mysql web site but the search result are more irrelevant than relevant. Thanks, Chip W www.wiegand.org [EMAIL PROTECTED] - 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: MySQL tables named 'column' cause problems.
Column is a mysql reserved word. Just like desc or asc or tons of others. See here: http://www.mysql.com/doc/R/e/Reserved_words.html Dan -Original Message- From: Tozz [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 16, 2002 8:58 PM To: [EMAIL PROTECTED] Subject: MySQL tables named 'column' cause problems. Hello, While reading my cron messages I found out that the mysqldump returns with an error mysqldump: Can't get CREATE TABLE for table 'column' (You have an error in your SQL syntax near 'column' at line 1) The table column is: CREATE TABLE `column` ( `id` int(11) NOT NULL default '0', `name` text NOT NULL, `user` text NOT NULL, `text` longtext NOT NULL ) TYPE=MyISAM; Anyway, I was unable to a 'DROP column;'. This returns in an error value. Then I change the above snipped into: CREATE TABLE `kolom` ( `id` int(11) NOT NULL default '0', `name` text NOT NULL, `user` text NOT NULL, `text` longtext NOT NULL ) TYPE=MyISAM; (kolom is dutch for column), there is no problem and my backup exists without errors. So, in short it comes down too: MySQL buggs when there is a table named 'column' Please mail any replies to [EMAIL PROTECTED] as I am not a member of this list. Bye, Tozz - 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: Help with selects
Kacey,
I used this, works great!
http://www.netmechanic.com/news/vol3/javascript_no12.htm
-Original Message-
From: Kacey A. Murphy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 10, 2002 1:43 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with selects
I am doing a similar thing except I don't want to use a button I want
once you select for it to auto refresh and grab the data, is this
possible.
Kacey!
-Original Message-
Subject: Re: Help with selects
Hi Alex,
Try the following:
if ($submit) {
/* process form */
if($namequery = mysql_query(SELECT * FROM rahs WHERE name='$name')
{
while($set=mysql_fetch_array($namequery)) {
printf ( Name: %sbr,$set[playername]);
printf ($stat: %s,$set[$stat]);
}
} else {
print Failed Query Error message here;
}
} else {
/* other code here */
}
Alex Behrens wrote:
Hey Guys,
I'm trying to get a form to submit to a mysql script and pull
different
variables when you select different values from the form, but I can't
get it
to work, can someone help me? Here's my code so far:
?php
if ($submit)
// process form
$namequery = mysql_query( SELECT * FROM rahs AS playername WHERE
(name =
'$name'));
$stats = mysql_query( SELECT $stat FROM rahs AS playerstat WHERE
(name =
'$name'));
while($set=mysql_fetch_array($namequery)){
printf ( Name: %sbr,$set[playername]);
}
while($stats2=mysql_fetch_array($stats)):
printf ($stat: %s,$stats2[playerstat]);
endwhile;
} else {
I know this code is only part of it, but its the only part that needs
work. I have a working model here:
http://www.3d-unlimited.com/rahslax/test6.php
Can someone help me get it to work?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
-
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
-
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: DBI installation
You should befriend a little program called webmin, available at www.webmin.com/webmin Once installed go to Other and perl modules, it does it all for you... Dan -Original Message- From: Andy Cheng [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 6:19 PM To: [EMAIL PROTECTED] Subject: DBI installation Hello all, I am new to linux. I need to connect to Mysql using perl. I downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz from http://www.mysql.com/downloads/api-dbi.html. I don't see any installation instruction. Could some one show me how to install it? Thanks for the help. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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: RH 7.2 connections problems w 16 web servers to 2 MySQL servers
If you can turn on the query log the amount of disk space it takes would be well worth troubleshooting the problem. Try and discern the last queries run on them, in order to help. Perhaps do this twice and you could check for consitency. How much disk space is in use on the drives related to it? Remember that disk space can vary immensley in seconds on some larger servers. Sometimes it may not even claim the space as taken, though it really is, if you catch my drift. Does the mysqld die or lockup? Does the entire server lockup? What day and time do you get it? Are there any cron jobs running that are doing anything? Perhaps someone has a script to pull something off your site once a week, and this is causing it? (Refer to troubleshooting explained above with query log) -Original Message- From: Sam Iam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 12:06 PM To: MySQL List Subject: RH 7.2 connections problems w 16 web servers to 2 MySQL servers We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web servers. The failover won't work now as if one MySQL goes down the cost of the 8 web servers switching over is so high the other MySQL locks up. Each Apache / PHP server takes up hundreds of connections even when they're idle so we ran into the Linux connection limit of 1000 had to recompile to get past that. Our actual MySQL CPU useage is low but the goes when with the connection overhead when starting up or failing over a bank of machines. We get a mysterious MySQL lockup once a week at the same day time. Questions : - Is our configuration of 2 sets of 8 Apache/PHP web servers 1 MySQL servers just not a good idea ? - Would we better off with FreeBSD ? - Is there anyone doing any similar setups with lots of web servers a few MySQLs ? - Is there any way to get Apache / PHP to use fewer connections ? We pay for MySQL support but haven't had much help from them. - Sam. - 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
