Re: Changing a field's data in every record

Erm. I've seen some weird responses to this. Yes, you can do this. First -- get the data into a usable format. Then, put it into a usable format (eg, timestamp for datetime field). Read up on how mysql interprets date/time data on fields. And, create a new timestamp or date field. Then, do

Re: io thread very slow copying binlogs

200kbyte/sec / 1.6Mbit/sec right now. It seems very steady too. As in, if I look at bytes, they're constantly increasing.. just, slow.. On Fri, 20 Jan 2017 10:19:57 -0500 "Morgan Tocker" <morgan.toc...@oracle.com> wrote: > Hi Brad, > > > MySQL community edition 5.6.29, run

Re: io thread very slow copying binlogs

I should add that I've turned the SQL thread off, it makes no difference from what I can see... On Fri, 20 Jan 2017 10:31:38 -0500 Brad Barnett <b...@l8r.net> wrote: > > > > On Fri, 20 Jan 2017 10:30:09 -0500 > Brad Barnett <mysql-general-l...@l8r.net> wrote:

io thread very slow copying binlogs

Hey all, I have a weird issue. MySQL community edition 5.6.29, running Linux. Binlogs never seem to get caught up on slaves. I've done all I can, to validate that this isn't network or disk related. Disk tests (using iostat and other methods) show lots of bandwidth left on the slave and

Re: MySQL 5.5.33 History list not purging?

in the list. We're currently writing about 50MB/s to that machine. Is it possible the purge thread just...can't keep up for some reason? How can I get better visibility in to how quickly the purge thread is working vs. how many undo entries are being put in the thread? Thanks, *Brad Heller

MySQL 5.5.33 History list not purging?

at to figure out how to increase bandwidth for the purge thread? Thanks, *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe http://www.twitter.com/bradhe | @cloudability http://www.twitter.com/cloudability We're hiring! https://cloudability.com/jobs

Re: MySQL 5.5.33 History list not purging?

Good point. We'll try that out. I noticed our ibdata file is gigantic now, likely due to the alter table migration we ran. What's the relationship here, do you think? *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe http://www.twitter.com

Re: SHOW CREATE TABLE suddenly slow on InnoDB?

gigantic (56GB)? *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe http://www.twitter.com/bradhe | @cloudabilityhttp://www.twitter.com/cloudability We're hiring! https://cloudability.com/jobshttp://www.cloudability.com/jobs On Mon, Mar 17, 2014

Re: SHOW CREATE TABLE suddenly slow on InnoDB?

for table_definition_cache and table_open_cache (400 each). *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe http://www.twitter.com/bradhe | @cloudabilityhttp://www.twitter.com/cloudability We're hiring! https://cloudability.com/jobshttp://www.cloudability.com/jobs

Re: SHOW CREATE TABLE suddenly slow on InnoDB?

ibdata file/data dictionary? All the contention comes out of the dictionary, but I'd expect the optimize to re-write the dictionary entries... *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe http://www.twitter.com/bradhe | @cloudabilityhttp

SHOW CREATE TABLE suddenly slow on InnoDB?

been a problem until recently. I upgraded the IO subsystem, and our statistics indicate that it's not maxing out IO (at least IOPS). This is problematic because the ORM we're using uses that to figure out the structure of our DB... *Brad Heller *| Director of Engineering | Cloudability.com | 541-231

Re: Concurrent read performance problems

| +--+-++---+++-+---+-+---+ *Brad Heller *| Engineering Lead | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe http://www.twitter.com/bradhe | @cloudabilityhttp://www.twitter.com/cloudability

Re: Concurrent read performance problems

-forward query with the subselect as well as tweaking the max_healp_table_size and tmp_table_size I saw no resource contention causing slowdowns, as well as a 12x performance boost. Thanks for your help! *Brad Heller *| Engineering Lead | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe

Concurrent read performance problems

innodb_log_files_in_group=2 innodb_log_file_size=2000M max_allowed_packet=64M Thanks in advance, Brad Heller

Error 1064

I am receiving this error: ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '16 varchar(255) NOT NULL default 'Not applicable', 17a varch I have version 4.0.16 and have a dump file that I'm

Re: Vexing permissions issue with partitioned CREATE TABLE

the community were a big help in pointing me in the right direction. Cheers, - Brad On Sat, Dec 6, 2008 at 6:48 AM, Per Jessen [EMAIL PROTECTED] wrote: Brad Heintz wrote: Thanks for responding. The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX DIRECTORY take absolute paths

Re: Vexing permissions issue with partitioned CREATE TABLE

Per - I am finding a lot of exit=-13 entries for the mysql user, but that's the same information as in the original error message. Is there anything else you're suggesting I look for? - Brad On Sat, Dec 6, 2008 at 6:48 AM, Per Jessen [EMAIL PROTECTED] wrote: Brad Heintz wrote: Thanks

Re: Vexing permissions issue with partitioned CREATE TABLE

John - I've chowned the pertinent directories to mysql:mysql and chmoded them to 700. Still no change in the result. For laughs, I tried chown and chmod with a --reference of an existing, working data directory in /var/lib/mysql, but again, no change. - Brad On Sat, Dec 6, 2008 at 10:40 AM

Re: Vexing permissions issue with partitioned CREATE TABLE

tables if I do not specify a data directory. I'll try your suggestion about making the filesystem perms more restrictive - I don't think I've tried that yet. Thanks for taking the time to respond. - Brad On Sat, Dec 6, 2008 at 3:42 AM, John Daisley [EMAIL PROTECTED] wrote: Brad, what user

Re: Vexing permissions issue with partitioned CREATE TABLE

restrictive - I don't think I've tried that yet. Thanks for taking the time to respond. - Brad On Sat, Dec 6, 2008 at 3:42 AM, John Daisley [EMAIL PROTECTED] wrote: Brad, what user are you running the mysql server as? Have you created a mysql user and group (or another user

Vexing permissions issue with partitioned CREATE TABLE

missed something in the docs? Many thanks, - Brad Heintz -- Brad Heintz [EMAIL PROTECTED]

Re: Vexing permissions issue with partitioned CREATE TABLE

and it doesn't change the error, so it has nothing to do with MySQL secretly expecting relative paths. I have created the directories by hand, and as I said in my original email, I've tried chown'ing them to the MySQL user. No change in outcome. Cheers, - Brad On Fri, Dec 5, 2008 at 4:01 PM, [EMAIL

Re: Vexing permissions issue with partitioned CREATE TABLE

Thanks, Martin, but that's not it. As I mentioned in my email, I'm running as MySQL root user with all priv bits set. I tried your suggestion anyway, but no change. Cheers, - Brad On Fri, Dec 5, 2008 at 4:34 PM, Martin Gainty [EMAIL PROTECTED] wrote: Brad- log into mysql as admin GRANT

Re: Is there a way to load non-native Date type with LOAD DATA

I have a pretty large file with a Date column in the format M/D/. Is there a way to either change the Date data type in the table or a method to indicate the date format in the LOAD DATA statement in order to handle this? If you are using MySQL 5.0.3 or greater, you should be able to

Re: Joining result sets into 1 row

I want to have the rows returned as one row Such as ROW 1 Mechanic, Carpenter, Plumber You may want to try GROUP_CONCAT(expr) ... http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: stuck on localhost authentication

insert into user (user,host) values ('jeff','localhost'); flush privileges; grant all on databaseName.* to jeff; jeff = [EMAIL PROTECTED] not [EMAIL PROTECTED] So in your statement you should have used... grant all on databaseName.* to [EMAIL PROTECTED]; select user,host from

Re: Backup questions

2) sometimes, I like to copy just a single table or so out of the backup file, and restore just that. You might want to try out MySQL Administrator which can often be used to restore backups from mysqldump. It can _selectively_ restore tables from a backup file.

Hmmm, verrry interesting on big summation

combination. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Any means to get the optimizer out of the way?

question out of all this: Is there a way to convince the optimizer that it is fine to use a range portion of the index to fulfill this query? Please let me know if there is something I've missed, Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list

Re: Indexing Questions (Problem?)

Thanks Tom and Michael, I got rid of all of the indexes except the one marked PRIMARY and a new one that I made like this: ALTER TABLE logs ADD unique (host,date,time,priority,facility,seq); I see quite an improvement from what I was seeing before. The one thing that I didn't realize is that

Indexing Questions (Problem?)

Please be gentle, I have nearly no experience with SQL databases. I am not subscribed to the list so please cc me on replies. Because my email client probably did horrable things to this post you can find the text here also: http://nolab.org/scratch/mysql-index-oddness.html I use syslog-ng

Re: simple but frustrating query

| cc | biotech | +-++-+ 3 rows in set (0.01 sec) Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Difference between PostgreSQL and MySQL

EWAGW wrote: Hi all, mr.super newbie here, what is the best for cold fusion development? I know that NASA uses MySQL but I have also been told that more 'professionals'(???) use PostgreSQL. Let the flaming begin!! No need for flames. I think the two are converging. PostgreSQL started out with a

Re: InnoDB TableSpace Question

nM' command. But the resize will choke on a datafile with active extents in that datafile. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my MySql is DEAD!!!!!!!!

to get rid of this problem, i have even tried re-installing the entire database server, but no use plz. help me. regards mahesh - Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. -- Brad Tilley VT Athletics Coordinator

stress test

hi does anyone have a stress test for mysql? i want to give my box a workout before deploying on the web. Maybe a PHP page which runs forever, creating, finding and deleting thousands of records? Maybe I can run it in several browsers at the same time? thanks! brad -- MySQL General Mailing

Re: Slow querys When ADSL is down on W2K

I'd suggest you add a static route to the W2k clients just to see if that corrects the problem... try this command: route ADD ddd.ddd.ddd.ddd MASK mmm.mmm.mmm.mmm ggg.ggg.ggg.ggg d = destination (the mysql DB server) m = subnet mask (255.255.255.0 or whatever your route happens to be) g =

Re: mysqldump under cron

Here's a simple python script that I use to do mysql backups. I wrote it myself. It works great. Cron it to run however you like: def db_backup(): import os, time # Change db_list contents to reflect the names of your databases. db_list =

Re: Upgrade 4.1.1 to 4.1.2

Man rpm and read a bit about the *upgrade* option... rpm -Uvh name-of-package Larry Lowry wrote: I'm running 4.1.1 on RH 9. I want to upgrade this to 4.1.2. I'm using the rpm from the MySQL site. If I just try to install it with rpm -i then I get a bunch of errors about conflicting files from

Search for relationships that aren't present

Three tables: computers (Describes computers) users (Describes users) comp-user-link (Links users to computers in a 1 user to many computers relationship) Could someone offer advice on how to construct a select statement to show which users aren't in the comp-user-link table? Sort of the

Re: Search for relationships that aren't present

,the solution depends on your primary keys. SELECT u.* FROM users u LEFT OUTER JOIN comp-user-link c ON u.userID = c.userID WHERE c.userID IS NULL -Original Message- From: Brad Tilley To: [EMAIL PROTECTED] Sent: 5/25/04 1:39 PM Subject: Search for relationships that aren't present Three tables

Re: Search for relationships that aren't present

joining them. Yes, it's a bit more complex, but it works well for us... especially with the amount of transfers that we do between users. Thanks again, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Search for relationships that aren't present

Ah yes, thank you Gerald. I didn't understand this until now. I guess I should say that 'by design' the linking table will never contain a null, but the left join changes that. Thank you for pointing that out. gerald_clark wrote: Brad Tilley wrote: I should better describe the tables

Re: questions about bind_param and mysql trace data included

-- Brad Lhotsky [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL Website

ms 85.178 ms 87.600 ms Thanks, Brad Teale Universal Weather and Aviation, Inc. mailto:[EMAIL PROTECTED] -Original Message- From: Peter Burden [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 7:35 AM To: Lehman, Jason (Registrar's Office) Cc: [EMAIL PROTECTED]; [EMAIL

Converting tables to innoDB

... everything works great right now. I'm just hearing how InnoDB is the only way to go today, any tips on whether or not to switch? Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sql bench problems

properly. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best practice on table design

an int is usually 4 bytes at worst while a city name is definitely more than 4 bytes. Yes it does generate a second table that only has the mappings from cityID to cityName, but you will likely find it well worth the effort to use the mapping. Brad Eacker ([EMAIL PROTECTED

Re: free software and open source

On Sunday 11 April 2004 10:58 am, Saurabh Data wrote: Dear Users Can anyone in your own words clarify the difference between open source and free software. Many Thanks Saurabh Data This is off topic for this list, but I'll provide a quick answer. Free software is software that's free to

Re: privileges

them up again while trying to 'secure' my db), I can rerun the script that sets up the mysql table and things are back to normal. Best of luck, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql scripting

of which are all caps some of which are not. Also the vendor name may be DELL for one entry and dell on another. We're standardizing the input to avoid this mess in the future, but I'd like to clean up what's current present. All tips are appreciated. Thanks, Brad -- MySQL General Mailing List

unique field problem

could be inserted into the field that's acting as the unique index. Is this possible? Is it a good idea? Any tips on a better approach to handle this? Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

unique varchar in field

this field to be unique, but I don't want it to be a part of the primary key, or any key for that matter. I just want it to be unique. How do I achieve this? Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: MySQL on Linux

On Tuesday 06 April 2004 16:31, dan wrote: Uhm, what are you talking about?!? Linux has no such limitation. you can grow files as large as you like. right now I have an InnoDB dbase with Mysql on a linux system and the file is over 60 GIGS in size! maybe you meant 2 Tb? and if you did,

Re: MySQL on Linux

On Tuesday 06 April 2004 17:28, dan wrote: nice flame! :) btw- Doesnt exist in out-of-the-box Linux distros, or any distro you can currently download. or any distro you could download (or buy) over the last few years. it doesnt occur in vanilla distributions or any other retail,

two questions on starting and stopping mysld

the best way to stop the server? Currently, I'm doing a killall mysqld, is there a more graceful way? Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

two tables with same field names into one table

have the same names. I tried this: create table computers select * from desktops, laptops where desktops.field_1 = laptops.field_1 ... ... ... But I got an error about duplicate field names. Any suggestions on how to do this? Thanks, Brad -- MySQL General Mailing List For list archives: http

Re: two tables with same field names into one table

* FROM laptops If you create the computers table before hand (you can see how you would create either of the others with SHOW CREATE tablename), then you can just do one INSERT into the new table, using a select similar to the one above. Thanks, Matt -Original Message- From: Brad

Re: newbie: increment an existing record

development experience. You may want to take a look at Teach Yourself SQL in 21 Days by Stephens and Plew, Sams Publishing ISBN 0-672-31674-9 for the copy that I have in front of me. It does a good job of explaining these kinds of questions. Brad Eacker ([EMAIL PROTECTED

Re: Newbie question

21 years, and perl for 20 years. Yet these don't appear to be enough to get a position in Silicon Valley. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

ft_boolean_default

Is this a legitimate variable? It seems like it'd be useful, but when I tried it (on 4.0.12-nt and 4.0.17-nt) it didn't work. Anybody know what's going on? Brad [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: C API

There is a C++ package called OTL (http://otl.sourceforge.net/home.htm). It supports both MySQL through MyODBC, and Oracle. It works great with Oracle applications, but we have not used it with MySQL. Thanks, Brad Teale Universal Weather and Aviation, Inc. mailto:[EMAIL PROTECTED] 713-944-1440

RE: Ancestry program

that exports the data, it should probably export in the GEDCOM format because that is what most software packages will import. http://www.ngsgenealogy.org/ http://www.gentech.org/ngsgentech/main/Home.asp GEDCOM seems to be the standard file format: http://www.gendex.com/gedcom55/55gctoc.htm Brad

RE: C API

There is a C++ package called OTL (http://otl.sourceforge.net/home.htm). It supports both MySQL through MyODBC, and Oracle. It works great with Oracle applications, but we have not used it with MySQL. Thanks, Brad Teale Universal Weather and Aviation, Inc. mailto:[EMAIL PROTECTED] 713-944-1440

RE: Adding indexes on large tables

to another drive like Dan, said. Brad -Original Message- From: Brendan J Sherar [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 6:27 AM To: [EMAIL PROTECTED] Subject: Adding indexes on large tables Greetings to all, and thanks for the excellent resource! I have a question regarding

RE: grant by option on querys

Thank you very much Paul. The order by NULL clause sped the query up from 1.5 minutes to 10 seconds! This is what we were looking for. Thanks, Brad -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 9:59 PM To: Brad Teale; '[EMAIL PROTECTED

Query speed issue

', PRIMARY KEY (stn,yearmoda,hr,min), KEY interp_hr (yearmoda,hr,stn) ) TYPE=MyISAM; Table Stats: foo - 38G - Data/18G - Index (326K rows) bar - 24G - Data/14G - Index (35K rows) Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

grant by option on querys

temporary; Using filesort | +---+--+---+--+-+--+--+- -+ 1 row in set (0.05 sec) Thanks, Brad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

help with table design/performance

. How have other people handled this sort of thing? TIA. -=-=-=-=-=-=-=- Brad LaJeunesse, PINES System Administrator Georgia Public Library Service www.georgialibraries.org Scotty, I need warp speed in three minutes or we're all dead! --Admiral James T. Kirk, Star Trek II: The Wrath of Khan

Recomended RAM for production server. 3Gb overboard?

guys think 3-4Gb is fair or excessive for this workload? Of course i wouldn't mind some headspace to grow. Unfortunatly i don't expect 6x increase any time soon though :) Thanks :) Brad. _ Få gode tilbud direkte i din mailbox http

HELP : SQL command parser broken

I compiled and installed mysql-max-3.23.51. Installation process seems to go fine. When I go to run mysql_install_db however, I get the following error : ERROR : 1064 use mysql; syntax error I try starting mysqld without grant tables - and I can. However, when I connect via a client, none of

Re: Using PHP to do a MySql Dump

Upon initial search, does not appear to be. except: exec(mysqldump) or system(), or shell_exec() Maybe the PHP list would render better results? HTH -Brad Todd Cary wrote: Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software

Replication Question

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

Field type conversion question

name is stored in fields FirstName and LastName. I would like to have a field in Events that will store multiple names with both fields from EmpTable concatenated into one string (i.e. FirstName LastName) What is the most efficient way to do this in MySQL? Thanks, Brad This e-mail and any

Access replacement...

that development has to be done in the opensource equivalent of VB which may shut out the advanced users from making changes? Regards, Brad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Access replacement...

that development has to be done in the opensource equivalent of VB which may shut out the advanced users from making changes? Regards, Brad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: [PHP] Encrypted MySQL passwords

it is the same every time it is like doing string compares on the same encrypted value so it authenticates, of course this is also the vulnerability of md5. I suppose that with cracking software and time, someone could get it, but it also might be better then sending it in the clear. -Brad Adam Voigt

External files w/ MySQL ???

to get this to work w/ Cold Fusion and Access, but I'm trying to do it with PHP and MySQL and I'm coming up short. Thank you for any info you have. Brad DISCLAIMER: The information contained in this transmission may be legally privileged and/or confidential information. Any dissemination

4 table join

, T.StartDate FROM Work W LEFT JOIN ZoneZip Z ON (W.zone=Z.zone) LEFT JOIN Customer C ON (C.Zip=Z.zip) LEFT OUTER JOIN Task T ON (C.CustNo=T.CustNo) WHERE W.day = 'Thr' AND (TO_DAYS(T.StartDate) = TO_DAYS('2002-10-03') OR TO_DAYS(T.StartDate) IS NULL); thanks -- K. Brad Simmons Secure

\T command in 4.0 broken?

is this tee or \T command supposed to still work in mysql 4.x? the manual says * For logging, you can use the `tee' option. The `tee' can be started with option `--tee=...', or from the command-line interactively with command `tee'. of course there isn't a single example of the

RE: processors

A load of 2? Heck we have systems that run a load of 20 or more without issues. If you are doing a lot of connections you might look at optimizing your code. Also using indexes can increase the speed as well. --- Brad Dameron

How to optimize/index merged tables

are already indexed? Common sense says I should be indexing once over ALL tables, since the searches people perform are always going to span multiple tables. Any experiences you can throw out at me regarding 'merge' would be greatly appreciated. Thanks. Brad

Easy Auto-Increment

to continue incrementing even if the record holding the greatest AUTO_INCREMENT value is deleted? Thank you in advance for your support! Regards, Brad Galiette - Before posting, please check: http://www.mysql.com/manual.php

Array-Like Columns...

the original question: is an array-like data type possible in MySQL, and if so, how? Thank you in advance for your support! Regards, Brad Galiette - Before posting, please check: http://www.mysql.com/manual.php

Real-time data warehousing

can handle it, would we be better off using InnoDB or MyISAM tables? Thanks, Brad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: Real-time data warehousing

much of a performance hit would we take with MySQL if we connected through MyODBC? Thanks again, Brad -Original Message- From: walt [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 11:47 AM To: Brad Teale Cc: '[EMAIL PROTECTED]' Subject: Re: Real-time data warehousing Brad, We're

RE: Real-time data warehousing

web servers on Linux, but the big iron will always be Sun here (Company policy). There has been talk of getting Oracle 9i? because Oracle has told us it is much faster, but we are not holding our breath. Thanks, Brad Teale -Original Message- From: walt [mailto:[EMAIL PROTECTED]] Sent

Re: Adding a Column to an existing table

Run the following for each table: ALTER TABLE tableName ADD COLUMN Company_ID INT UNSIGNED NULL; Hope this helps. Ulrik Witschass wrote: Hi, I'm new to this list, hopefully, I can contribute some wisdom :) At the moment, I have to update a large database to be multi-company-ready, so I

MySQL, FreeBSD problem

Hello all. I have an application that does a lot of table creation and writing for a FreeBSD 4.4 SMP machine. Over time, I begin to see the following errors. DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, FILE

Re: mysql.sock problem

I should have mentioned that I did a 'find / -name my.cnf' and there is only one such file--/etc/my.cnf Perhaps I should try creating a local version of my.cnf, but I really want to know why it's getting the wrong .sock file in the first place. Brad Gerald Clark wrote: check for a .my.cnf

mysql.sock problem

--socket=/var/tmp/mysql.sock it works. I hesitate to consider it a longtem solution. Brad Emerson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: BSD and MySQL : Major Problems

to be no pattern to the occurrence of the error. No trigger. It just happens out of the blue. It also happens to any of the Databases, not just the one listed above. Any ideas - any help would be much appreciated. Brad, - Before

Compiling on Solaris

a good ingest machine. So I would like to compile MySQL and MySQL++ with the Sun compilers to take full advantage of everything the platform has to offer. Any help would be great. Thanks, Brad Teale Universal Weather and Aviation, Inc. mailto:[EMAIL PROTECTED

RE: Compiling on Solaris

-calc_hashnr)(key,length); 191: } To fix the problem I poked around, and ended up commenting out lines 183-185. After this it compiles fine. Will this lead to any problems? Computer Config: SunOS 5.8 sun4u sparc SUNW, Ultra-80 Sun Workshop 6 update 2 5.3 2001/05/15 Thanks, Brad Teale Universal

Re: Need Help bad!.. today.. of all days!

of data where it currently stops, does it stop there again? Does the code stop in the same place with different data? Brad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

ALTER Syntax Question

Is it legal to change a field name to the same name as in the following? ALTER TABLE t1 CHANGE a a INTEGER; Thanks, Brad This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed

Duplicate column names

How does MySQL handle duplicate column names? This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by legal privileges or statutory

Re: LOAD DATA into multiple tables?

the two tables key columns dont get out of sync with each other. Is there a way to load multiple tables with a single LOAD DATA statement? Thanks, Brad - Before posting, please check: http://www.mysql.com/manual.php

Re: LOAD DATA into multiple tables?

the two tables key columns dont get out of sync with each other. Is there a way to load multiple tables with a single LOAD DATA statement? Thanks, Brad - Before posting, please check: http://www.mysql.com/manual.php

Re: Unix passwd file and mysql authentication table

Don Read wrote: On 26-Jul-2001 sachin shetty wrote: Hi Is it possible to authenticate a logged on user by comparing the unix passwd file entry with the mysql user table entry(after copying passwords from the password file to the table). The password_crypt routine used in MySQL is

  1   2   >