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

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 ve

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 eng

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 serv

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: 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: 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: 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 que

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: 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

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 enou

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: 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( membe

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

do requires 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 1

mysql error logging

ng to have a hard time believing I'm 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 6A

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' (usin

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'

MySQL 4.0.13 Memory leakage?

eems 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

Re: MySQL 4.0.13 Memory leakage?

wodny <[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

Re: MySQL 4.0.13 Memory leakage?

Michael, in the case 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 PR

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 re

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

g password: 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 E

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 e

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

is running as an NT Service? Thanks! __ 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 PR

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, bu

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 s

Re: Rank beginnner - very basic question

have access for a messageboard or whatever... Thanks Guy Merritt -- 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 PROTECTED]

Re: MySQL Tables Load Slowly

Friends. Fun. Try the all-new Yahoo! 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 --

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

.com/[EMAIL PROTECTED] -- 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 PROTECTED]

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

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 Loftis Modwest Sr. Systems Administrator Powerful, Affordable Web Hosting -- MySQL

Re: MySQL Tables Load Slowly

ances. Anyway, I added a primary key, but the table still loads slowly. However, I'm guessing that it isn't 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 Po

Re: How to Restore MySQL Database from VB?

ot;\. sql_file" using Execute/Open 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 unsubs