Re: MySQL: Spam Free (Send/Receive) Emails. HOW?

--On September 9, 2006 12:11:15 AM -0700 deafmickey [EMAIL PROTECTED] wrote: I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query(CREATE TABLE members(

Re: MySQL: Spam Free (Send/Receive) Emails. HOW?

control of the mail server, and an understanding of how they work. There are plenty of howto's and FAQs that cover all of this elsewhere though. MTA == Mail Transfer Agentyou might know it as an SMTP server. Thanks Mel Michael Loftis wrote: --On September 9, 2006 12:11:15 AM -0700

Re: Large size of MySql binary for Power PC

--On September 5, 2006 1:41:43 PM +0530 Arvind Kumar [EMAIL PROTECTED] wrote: Hi! Any help would be appriciated. I found MySQL binaries for embedded system (Processor: Power PC, OS:Linux) There is not much space available in the hard disk. It is around 20 MB. The binary size is large

Re: Slave behind master... or not ?

--On September 5, 2006 3:18:21 PM +0200 Jocelyn Fournier [EMAIL PROTECTED] wrote: Hi, Any idea of what could be wrong here ? My guess is that the variable is based on the last update timestamp, and the last time that the slave has seen data from the master. If it had been about a

Re: solaris build mysql from source using gcc

Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. --On September 1, 2006 2:10:17 PM + [EMAIL PROTECTED] wrote: Hi, Any chance i could get

Re: solaris build mysql from source using gcc

--On September 1, 2006 8:38:21 AM -0600 Michael Loftis [EMAIL PROTECTED] wrote: Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. Sorry I

Re: The length of the sql query

--On August 23, 2006 1:55:36 PM -0400 Emi Lu [EMAIL PROTECTED] wrote: Hello, Just curious to know whether Mysql 3.23 has any length constraint about where part, such as Query = [ select col1, col2, ... coln from table 1, table2, where constraint1 + constraint2

Re: query question: most active user

select userid,count(text) from blah group by userid; --On August 20, 2006 7:22:59 PM +0100 Peter Van Dijck [EMAIL PROTECTED] wrote: I have a table with userid and text. Users write text. I want to find the top 5 users who have the most rows in this table. I can't seem to figure out the

Re: comunication between Oracle and MYSQL

--On August 14, 2006 9:11:30 PM +0530 balaraju mandala [EMAIL PROTECTED] wrote: Hi All, I need some suggestions from you. I need a comunication between Oracle database with MySQL. http://www.webmethods.com/ They sell software to do this. Or...well... ActiveSoftware/ActiveWorks did which

Re: More than 4 CPUs?

--On August 11, 2006 2:44:34 PM -0400 Ed Pauley II [EMAIL PROTECTED] wrote: It seems like I once read that you don't get any performance gains in MySQL when you go above 4 CPUs per server. Is this correct? I was considering a 4 dual-core CPU machine. Should I go with a 2 dual-core machine

Re: Can't open file: 'my_table.MYI': Could be the reason of a server reboot?

--On August 8, 2006 11:36:21 AM +0200 thomas Armstrong [EMAIL PROTECTED] wrote: Hi. My Linux server has just restarted due to memory problems. Browsing mySQL logs, I've found out 5,000 lines like these in less than one hour: -- 060808 1:27:39 [ERROR] /usr/sbin/mysqld: Can't

Re: Replicating -- sort of 2 way

--On August 6, 2006 2:01:15 PM -0700 Enrique Sanchez Vela [EMAIL PROTECTED] wrote: One thing that you could do, is to setup a replicating slave server, freeze the replication, perform backups (to tape/disks etc), then re-enable the replication activity, this way you provide a non-stop

Re: query cache about the federated engine

--On August 2, 2006 5:25:51 PM +0800 wangxu [EMAIL PROTECTED] wrote: I have a problem about the performance of federated engine. The mysql5.0 reference manual says that the FEDERATED tables do not work with the query cache, aren't they? How about the query cache used by the federated

Re: Saving Image in Database [again]

--On July 30, 2006 10:42:16 AM -0500 Chris McKeever [EMAIL PROTECTED] wrote: Starting to build a new schema, and one of the items is image storage In the past I have always used filesystem storage. Was wondering if I could get a conversation started on the pros/cons of database storage

Disable specific storage engines WITHOUT recompiling?

Hi, I know that bdb has --skip-bdb, and innodb has the ability to be disabled at startup but what about federated, csv, archive, etc? My problem is I don't want to recompile and I don't want to carry a different binary version in our local repository just for the one or two machines on which

mysql error logging

the only one complaining about this so I must be missing something, but the only logging options I've found cause full logging which can not be done. MySQL Version is 4.0.23 -- Michael Loftis Modwest Operations Manager GPG/PGP -- 0xE736BD7E 5144 6A2D 977A 6651 DFBE 1462 E351 88B9 E736 BD7E -- MySQL

RE: mysql *SERVER* error logging

--On Tuesday, March 08, 2005 15:03 -0500 Daniel Fisla [EMAIL PROTECTED] wrote: Under UNIX/linux use syslog, for me /var/log/messages shows login/auth error Mar 6 05:39:11 orion pdns[1865]: gmysql Connection failed: Unable to connect to database: Access denied for user 'root'@'localhost' (using

RE: mysql *SERVER* error logging

--On Tuesday, March 08, 2005 15:44 -0500 Daniel Fisla [EMAIL PROTECTED] wrote: I see your point, especially when not being in control of client software. You may be in a hard position. I assume your did already some research into this so I won't give you the RTFM answer. :-) Yes lots :( That's

Getting 4.0.18 to log connects, connect errors, and NOT queries...

: YES) I want a log entry, ESPECIALLY on failures like that, but I don't want nor need to log every query. This seems pretty basic so I have GOT to be overlooking something. -- Michael Loftis Modwest Operations Manager GPG/PGP -- 0xE736BD7E 5144 6A2D 977A 6651 DFBE 1462 E351 88B9 E736 BD7E

Re: Limit of 1000 rows?

--On Friday, January 14, 2005 14:39 -0700 Steve Grosz [EMAIL PROTECTED] wrote: I had tried to load a group of records from a Excel spreadsheet, and for the most part it seems to have worked. The problem is that I know there were more than 1000 rows of data to be input, and it stopped at 1000

Re: How to specify start-up options when it's running as service?

! __ Do you Yahoo!? All your favorites on one personal page ? Try My Yahoo! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Michael Loftis Modwest Operations

Re: How to Restore MySQL Database from VB?

method of Connection Object. But that doesn't seem to work. Thanks, Nawal Lodha. -- Michael Loftis Modwest Sr. Systems Administrator Powerful, Affordable Web Hosting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Rank beginnner - very basic question

and passwords? I know I can change my password with /.mysqadmin -u root password my_password - I know of few basics and that's it. And it does work fine - I just don't want to pass out the root account password to people to let them have access for a messageboard or whatever... Thanks Guy Merritt -- Michael

Re: MySQL Tables Load Slowly

! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Michael Loftis Modwest Sr. Systems Administrator Powerful, Affordable Web Hosting -- MySQL General Mailing List

Re: Can I make empty MySQL use less disk space?

), is there any way I can reduce this size somewhat? I mean like, the examples, directory isnt really necessary is it? So which files can I exclude? mvh. /m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Michael

Re: Can I make empty MySQL use less disk space?

is it? So which files can I exclude? mvh. /m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Michael Loftis Modwest Sr. Systems Administrator Powerful, Affordable Web Hosting -- MySQL General Mailing List

Re: MySQL Tables Load Slowly

enough to have a key on a table - that key also has to be cited in your query/select statements. Is that right? Thanks. -- Michael Loftis Modwest Sr. Systems Administrator Powerful, Affordable Web Hosting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: RAID or not?

--On Friday, August 22, 2003 1:21 PM -0400 Lefevre, Steven [EMAIL PROTECTED] wrote: that is not true. mirroring gives you double the read speed and half the write speed. RAID5 gives you less than half the write speed. - OK, I see how it can give you double the read speed, but how

Re: RAID or not?

--On Friday, August 22, 2003 8:37 PM -0600 Jim McAtee [EMAIL PROTECTED] wrote: I don't quite understand the need to read data before any write. Why wouldn't it just calculate the parity of whatever is being written and just write it to disk? Wouldn't there be slack space, as with any disk

Persistent annoying slave binlog corruption...

Recently, and pretty consistently our slave's relay logs have been getting garbage that is not in the master. The symptom is usually a truncated query with a few characters of garbage. The solution for now is to change master to to the errored master bin log and position and have it start

MySQL 4.0.13 Memory leakage?

to be leaking almost comparatively as much as the master so there is a common codepath somewhere. -- Michael Loftis Modwest Sr. Systems Administrator Powerful, Affordable Web Hosting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: MySQL 4.0.13 Memory leakage?

[EMAIL PROTECTED] wrote: On Mon, Jun 16, 2003 at 04:41:49PM -0600, Michael Loftis wrote: I'm noticing that our MySQL 4.0.13 system is probably leaking RAM (uptime ~10 days) ... PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 26046 mysql 9 0 548M 162M 44008 S 5.9 8.0

Re: MySQL 4.0.13 Memory leakage?

the memory leak would be in InnoDB, you can monitor its memory allocation with SHOW INNODB STATUS\G Total memory allocated 50738427; in additional pool allocated 1762432 Regards, Heikki - Original Message - From: Michael Loftis [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent