Re: innodb_read_only issues

On Thu, Sep 7, 2017, at 02:04 PM, shawn l.green wrote: > Hello Josh, > > > What appears to be missing on that page is a discussion what to do with > the "temporary tablespace" used to hold intrinsic (internal) temporary > tables created by different types

innodb_read_only issues

hitting or am I holding it wrong? -- Thanks, Josh Paetzel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: backup from a slave

as that is the value which determines where in the binary logs you're slave is currently at. -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider Website: http://itsecureadmin.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: backup from a slave

you're slave is currently at. These values are accessible via 'show slave status\G'; -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider Website: http://itsecureadmin.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: backup from a slave

taking the backup, but also after you obtain the master log file and position. HTH, -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider Website: http://itsecureadmin.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL not running on fresh LAMP install

mysqld. Also, mysqld safe is a daemon which provides some safety features to mysql and is the recommended method of starting mysql, AFAIK. http://dev.mysql.com/doc/refman/5.0/en/mysqld-safe.html HTH, -- Josh Miller, RHCE/VCP Seattle, WA Linux Solutions Provider http://itsecureadmin.com

Re: innodb/myisam performance issues

= O_DIRECT +#skip-innodb-doublewrite +#innodb_support_xa = 1 +innodb_autoextend_increment = 4 innodb_data_file_path = ibdata1:40G:autoextend [mysqldump] So, we're going to take a break from the InnoDB stuff while I recover the slave and try again next week or so. Thanks! Josh Miller, RHCE

innodb/myisam performance issues

back to MyISAM. Thanks! Josh Miller, RHCE -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb/myisam performance issues

Tom Horstmann wrote: Hello Josh, why you moved your table to InnoDB? Your description doesn't sound like the tables rows are accessed concurrently and need to be locked? Are you sure you need InnoDB for this table? If you need InnoDB you probably need to redesign your queries and table

Re: innodb/myisam performance issues

innodb_log_buffer_size. Try something between 16-32MB if you have many transactions. Ok, we've increased the innodb_log_file_size to 500M, and that has not changed the IO wait at all so far (after 1 hour). Thanks! Josh Miller, RHCE -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: innodb/myisam performance issues

-designing the queries and indexes. We have a less than 50% index usage rate which is disastrous. We'd like to prove InnoDB and move onto that storage engine for the transaction support, MVCC, etc.. but we're finding that performance is poor. Thanks! Josh Miller, RHCE -- MySQL General Mailing

Configuration and improvement advice.

? Should I simply take an outage and alter table to set the engine type to InnoDB, or should I rename the table, and select into a new table? What are the upper limits of MySQL performance in terms of data set size using MyISAM vs InnoDB? TIA, -- Josh Miller, RHCE -- MySQL General Mailing List

Re: Table Size

and could potentially have many null values... I'm trying to get an idea of whether or not those null values are taking up much space. Thanks. - Original Message From: Baron Schwartz [EMAIL PROTECTED] To: Dan Nelson [EMAIL PROTECTED] Cc: Josh [EMAIL PROTECTED]; mysql@lists.mysql.com Sent

Table Size

Hello, I have a database that is growing at a rate of 4-5 MB per day (that number is getting larger as well). Not too bad but I'm trying to clean up the tables to minimize the amount of space they take up. I have one particular table that has 2 columns: rolID int(10) unsigned repID int(10)

Re: Table Size

Message From: Baron Schwartz [EMAIL PROTECTED] To: Josh [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, October 27, 2007 10:17:32 AM Subject: Re: Table Size Josh wrote: Hello, I have a database that is growing at a rate of 4-5 MB per day (that number is getting larger

Re: Table Size

Create_time: 2007-05-19 21:17:58 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL - Original Message From: Baron Schwartz [EMAIL PROTECTED] To: Josh [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, October 27, 2007 10:17

resources for tuning

horribly out-dated. (The my-large.cnf assumes you have a whopping 512 mb of memory). I was thinking of modelling my.cnf after the provided my-innodb-heavy.cnf file, but I am worried these files might be out-dated so I figured I'd ping the mailing list for other resources for tuning? Thanks, Josh

logging

Hello, I realize that this is a silly question, but I cannot figure it out. I don't know why. Id really appreciate your help. I cannot get mysql to do general logging. My my.ini reads like this: -- #This File was made using the WinMySQLAdmin 1.4 Tool

silly trigger question

Hi, Would something like this make it so that every time there was a new row inserted on TEST, a row with the new values was inserted on LOG_TABLE? I am not sure if you can reference NEW.id and all the NEW values directly and send them in a trigger... Thanks... CREATE TRIGGER test.data_table_au

query logging is making me mental!

Hello Everyone, I am hoping that someone can help me. Before I jump off the roof! I installed MYSQL 5 along with PHP and apache 2 as part of the XAMPP stack put out by ApacheFriends. I am putting together a few CMS sites and think the product is great. But I am having a simple problem

RE: query logging is making me mental!

I figured it out. Thanks for listening. I maybe just needed to vent. -Original Message- From: Josh Milane [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 12:46 PM To: mysql@lists.mysql.com Subject: query logging is making me mental! Hello Everyone, I am hoping

Re: SQL Plus (oracle) and SQL (mysql)

AUTO_INCREMENT columns, but they are not as robust as sequences. 4.) MySQL does not support CHECK constraints inside CREATE TABLE clauses. I'm sure there are others, but as long as your application uses pretty generic SQL and you are not getting into Oracle-specific stuff you should be ok. Josh -- MySQL

Sum and Total Query

What's the proper way to query for a total for a value and also the total for all values for a particular set of parameters? For example, I have a table of orders that customer service reps make. The reps place multiple orders per day for various products. I'm trying to pull a report that

Re: Sum and Total Query

Sorry... The dates were incorrect in my previous post. They are corrected below. --- Josh [EMAIL PROTECTED] wrote: What's the proper way to query for a total for a value and also the total for all values for a particular set of parameters? For example, I have a table of orders

Re: Compare lists Query?

SELECT statements. --- Yesmin Patwary [EMAIL PROTECTED] wrote: Dear All, I had some issues in past with timestamp fields as a result I am unable to upgrade to mysql 4.1 version. I am sure below the query recommended by Josh works with 4.1 or above. Would it be possible to rewrite

Re: Problems with timestamp field after upgrading MySQL Server.

Sure is... SELECT DATE_FORMAT(dateField,'%Y%m%d') as dateField Take a look at: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html -Josh --- Yesmin Patwary [EMAIL PROTECTED] wrote: Dear All, First of all, I would like to thank to Josh and Peter Brawley for their kind

Re: Stored Procedure Problem

Peter, nice catch. Changing the parameter names did the trick. Thanks. --- Peter Brawley [EMAIL PROTECTED] wrote: Josh wrote: I posted this same item on the mysql forum but the only place that looked remotely appropriate was under the Newbie section... I'm not sure

Re: Compare lists Query?

Here's one method: SELECT cl1.list_name, count(*) as count FROM customerList cl1 WHERE cl1.id IN (SELECT cl2.id FROM customerList cl2 WHERE cl2.list_name='CA10') and cl1.list_name != 'CA10' GROUP BY cl1.list_name --- Yesmin Patwary [EMAIL PROTECTED] wrote: Good morning all, We

Stored Procedure Problem

I posted this same item on the mysql forum but the only place that looked remotely appropriate was under the Newbie section... I'm not sure if it will be answer there so I thought I might toss it out here to see if there were any takers. I'm baffled as to why this stored procedure is acting this

MySQL query question

I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams,

Status of OUTER JOIN bug 1591?

and 3765. But bug 1591 is still listed as To be fixed later. Is that correct? If it is is there a different bug against how MySQL 4 handled OUTER JOINS which was fixed in MySQL 5 that I can reference in my justification letter? Thanks, Josh Trutwin FWIW - here is an off-list conversation

Re: Reason for Auto-increment primary keys?

of the INT column parent_id. In my mind it's always good to use UNIQUE in these cases so your real primary keys are in your table structure to prevent getting bad data. My $0.02 Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Next alpha release?

I don't think I remember a time when MySQL only had stable production releases available for download (at least not off the website) since v3. Any idea if the next alpha is on the way? Thanks, 5.0 looks great, I've been using it for over a year with very few problems. Josh -- MySQL General

Re: Foreign key support in MyISAM

candidate I wonder how soon it will be before 5.1 alpha is released? Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Differences Between ORACLE SQL PLus and MYSQL SQL

ADOBD (http://adodb.sourceforge.net) or PDO/MDB/Metabase, etc. Good luck, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL db size using show table status

using a command line tool should do this. Usually, .frm table definition files are negligible to the size of the actual database. Qus 2. Is there any other way to compute the db size (other than disk quota). du -s mysql_data_directory Regards, Josh -- Josh Chamas Director, Professional Services

Re: Locks acquired with get_lock() persisting, even after MySQL thread has exited

() reports that the lock is held by a particular thread ID. This does not seem like expected behavior. I would either file this as a bug at http://bugs.mysql.com/ with a nice reproducible test case, or file a ticket with MySQL Support at https://support.mysql.com/ Regards, Josh -- Josh Chamas

Re: MySQL Users

. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb thread concurrency size [mysql performance tuning]

at these packages: http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting #use this line mfor mysql 4.1

Re: Too Many Queries Have Writing To Net Status [mysql performance tuning]

, and if you want expert help, I would recommend you engage with our professional services team with either of these packaged consulting solutions: http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director

Re: 45 minutes to check table to complete

the extra memory the next step is tuning MySQL to take advantage of it depending on the storage engine you are using. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list

Re: The Intel MySQL compiled Server

, then revert back to the normal binaries. Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Intelligent Converters product: MSSQL-to-MySQL

with it and it seemed fine. I would also stay tuned for our MySQL Migration Toolkit to support MSSQL migrations. You can find it here: http://www.mysql.com/products/tools/migration-toolkit/ Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL

Re: MySQLHotCopy Error

/not-enough-file-handles.html If this does not help, and you need further support, you could work this up with MySQL Support at: https://support.mysql.com Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting

Re: Behaviour of like expression

for pattern matching, and = for equivalency. I don't know what the ANSI SQL spec says here, and whether our behavior is correct there, but this behavior makes sense to me at least. I would expect similar behavior from perl, for example: $ perl -e 'my $a = qw(a); print $a =~ //;' 1 Regards, Josh

Re: URGENT --- OSX 10.4 ODBC driver error

. If you need urgent help, please contact MySQL Support at: https://support.mysql.com Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL! www.mysql.com/consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL vs Plone/Zope/Python

starting to like Python more and more. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORACLE and Mysql: Create tables, constraints, swquences, storage. ..?

-toolkit/ One of the ways I like to use it is to reverse engineer the Oracle schema, and then have the MySQL schema definition script created for further modification. Note we do not have support for sequences, and its typical to just use AUTO_INCREMENT columns for these. Regards, Josh -- Josh

Re: very slow inserts on InnoDB [InnoDB Performance Tuning]

help via our commercial offerings: http://www.mysql.com/network/ - OR - http://www.mysql.com/consulting/packaged/performance.html http://www.mysql.com/consulting/packaged/rapidresponse.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More

Re: query on a very big table [MySQL partitioning of large tables]

partition your tables. If you continue to need help, then you might want to enlist our on-site consulting for your project needs: http://www.mysql.com/consulting/packaged/performance.html Regards, Josh -- Josh Chamas Director, Professional Services MySQL Inc., www.mysql.com Get More with MySQL

Re: Seriously.. When are we going to get subqueries?!

control over this. If this is something you cannot live with then choose a different RDBMS. I have to say, MySQL still looks like a tinker-toy to me. ignoring troll bait Good luck, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Seriously.. When are we going to get subqueries?!

in table row automatically is updated to the current timestamp when the value of any other column in the row is changed, unless the TIMESTAMP column explicitly is assigned a value other than NULL. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: MySQL 5.0.6-beta has been released

beta I had was 5.0.4 unless I missed a release announcement... Thanks, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Nevermind!] MySQL 5.0.6-beta has been released

On Wed, 1 Jun 2005 10:40:10 -0500 Josh Trutwin [EMAIL PROTECTED] wrote: On Tue, 31 May 2005 18:01:48 -0500 Matt Wagner [EMAIL PROTECTED] wrote: snip This is the third published Beta release in the 5.0 series. All attention will now be focused on fixing bugs and stabilizing 5.0

Re: Export from Access

and just use ODBC - check out MyODBC on mysql.com. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql_fix_privilege_tables error

On Fri, 22 Apr 2005 22:44:44 +0300 Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Make a bug or feature report at http://bugs.mysql.com. Already did - 10098 - it was recently closed, guess it was already fixed in 5.0.5. Josh -- MySQL General Mailing List For list archives: http

mysql_fix_privilege_tables error

') COLLATE utf8_general_ci DEFAULT 'N' NOT NULL thd-thread_id=6 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 Josh -- MySQL General Mailing List For list archives

Re: MySQL 5.0.4-beta has been released

Something amiss or am I losing it? Thanks, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 5.0.4-beta has been released

different mirrors. I'll keep at it and see if I get a better download. Thx, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL vs PostgreSQL

for yourself. Have fun, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL and PHP

systemroot directory you use) before the PhP MySQL extension will work. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [OT] MySQL and PHP

=maincslot_1=2 Anyway, this is now OT for a MySQL list Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql-4.1.8 library name bug

Yes, this has been reported on this list a couple times already. Really baffling how this one made it out of QA. Josh On Thu, 23 Dec 2004 21:43:27 +0200 (EET) Andrey Kotrekhov [EMAIL PROTECTED] wrote: SQL Hello, All! IMHO this the bug in 4.1.8 to create library shared libraries

Re: libmysqlclient name library wrong

rebuilding everything that links against mysql (php, perl dbd, courier imap, etc) because of this. I thought maybe the library version number just bumped up one. Erg, now I'll have to do that all again when 4.1.9 fixes this... Josh -- MySQL General Mailing List For list archives: http

Re: FOREIGN_KEY CHECKS

*/; Great, thanks for the info! Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FOREIGN_KEY CHECKS

this as an option to mysqldump as I can never remember the syntax to this command when I do an import with InnoDB tables. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: mysqldump

Thanks Spenser, but I'd already tried something similar. What I get when I try this is: mysqldump: Can't get CREATE TABLE for table `z_*` (Table 'sinu_com.z_*' doesn't exist) -Original Message- From: Spenser [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 6:30 PM To: Josh

RE: mysqldump

, 2004 1:44 PM To: 'Josh Howe'; [EMAIL PROTECTED] Subject: RE: mysqldump Did you try this one? I simplified it for you. You just need to put this in a file and chmod +x the file. Then you can execute it from a crontab or with the shell. ~~~ Copy/paste after this ~~~ #!/bin/bash # Modify

mysqldump

Hi, Can anybody help me with a linux newbie question. I want to use mysqldump to backup all of the tables in a database that start with z_. Can I do this in linux with a single line? Thanks.

RE: what is wrong woth this statement?

exists]) then Do some sql End If How can I do this? Thanks. -Original Message- From: Leo [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 19, 2004 11:38 PM To: Josh Howe Cc: [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? i didnt fully catch you

RE: what is wrong woth this statement?

, 2004 3:25 PM To: Josh Howe Subject: Re: what is wrong woth this statement? How can I do this? By using the CASE staement? On Wed, 27 Oct 2004 15:15:11 -0400, Josh Howe [EMAIL PROTECTED] wrote: Sorry, I don't think I was very clear. I'm asking a more generic question about control flow

RE: what is wrong woth this statement?

. That's more complex though. Any ideas would be greatly appreciated. Thanks! From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 3:30 PM To: Josh Howe Cc: Leo; [EMAIL PROTECTED] Subject: RE: what is wrong woth

RE: what is wrong woth this statement?

, October 27, 2004 4:51 PM To: Josh Howe; [EMAIL PROTECTED] Cc: Leo; [EMAIL PROTECTED] Subject: Re: what is wrong woth this statement? Have you considered doing what you want to do in Ant? I haven't done exactly what you want to do but Ant supports properties and conditions. I could imagine an Ant task

RE: user defined table constraint

Thanks, but I don't think a unique index is what I want. I need to allow any number of records with the same user_id and a value of 'N' in is_primary. -Original Message- From: Gary Richardson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 11:18 PM To: Josh Howe Cc: [EMAIL

what is wrong woth this statement?

if (select count(*) from z_mail_systems 0) then [insert statement] endif; How do I do this kind of conditional insert? Thanks.

user defined table constraint

Hi all, I have a table with these fields: user_id dept_id is_primary ('Y' or 'N') I want to make sure that there are never two rows in this table with the same user_id and is_primary='Y'. For any user_id, there can only be one primary record. In MS SQL I would define a user

compare schemas

Does anybody know of any free tools to compare two mysql schemas? Thanks.

Re: OUTER JOIN bug in 5.0.1?

the outer row for class id = 2 to show. This was so much easier with the bug! :) Thanks for your help, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OUTER JOIN bug in 5.0.1?

use it in this query because the withdrawl date might come into play. So what I'm trying to do is display which classes (meetings/whatever) a student has attended and which they have not been at for my ICS311 course. Here's what kind of results I'd like: Student Id: 123123 Name: Josh class_id

Re: OUTER JOIN bug in 5.0.1?

results that resembled an outer join. Unfortunately I cannot test this out at the moment due to other issues. Thanks for your help though, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OUTER JOIN bug in 5.0.1?

in the WHERE clause, I usually define my JOIN condition solely on the column(s) being joined together and any additional filtering gets done in the WHERE clause. Man, I thought I had a good handle on OUTER JOINs. Erg. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

OUTER JOIN bug in 5.0.1?

guess I could try to download and install again. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: html in a text field - good practice?

problems with if you blindly store submitted HTML from the Internet such as on in a bulletin board app. http://www.php.net/htmlentities http://www.php.net/html_entity_decode Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Difference between PostgreSQL and MySQL

(memory only, ISAM, full-relational) and both transacted and non-transacted execution models. That's just about everything you could want a database to do. No, not really: http://sql-info.de/mysql/gotchas.html Good link - thanks. Josh -- MySQL General Mailing List For list archives: http

Re: Difference between PostgreSQL and MySQL

On Tue, 10 Aug 2004 23:34:49 +0200 Jochem van Dieten [EMAIL PROTECTED] wrote: On Tue, 10 Aug 2004 16:00:12 -0500, Josh Trutwin wrote: One area where MySQL beat Postgres is in Windows installation. Installing postgres on Windohs is like pulling your fingernails off slowly. It is more

Re: [OT] PostgreSQL / MySQL Data Dictionary

://dev.mysql.com/doc/mysql/en/Roadmap.html Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Data Dictionary (INFORMATION_SCHEMA)

it? Will it be in the next 5.0 alpha release? I'm very curious to try it out. Thx, Josh -- 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

pg and mysql in a couple years... Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Multiple Foreign Keys

setting up my tables as INNODB types. Good. All my create tables should have had the ENGINE=InnoDB but I'm lazy. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: When is mysql 4.1.x , production?

by testing it in your enviornment. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Concurrency Question

this carefully under load to make sure that your code does not result in any dead locks. Regards, Josh Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Enterprises Inc. | NodeWorks Directory - http://dir.nodeworks.com

Re: iptables and mysql...

by your firewall on ports you have closed, turn on logging, etc. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error 1005 when adding a Foreign Key

explanation of the latest InnoDB foreign key error in the server. So, you should check show innodb status for some more about this error it seems. Also, one of the more common errors is a lack of an index on testplans.PlanName, so make sure you have one of those too. Regards, Josh

InnoDB tablespace fragmentation bug in MySQL 4.0.20

by adding/dropping indexes, one will eventually run out of disk space regardless of whether one is actually using that disk space! Also, I have a linux 2.4 kernel that this is running on, with mysql compiled with gcc 3.2.2. Thanks, Josh

InnoDB, odd insert error shared row locking behavior

from show innodb status regarding one such deadlock. Regards, Josh Josh Chamas, Founder| NodeWorks - http://www.nodeworks.com Chamas Enterprises Inc. | NodeWorks Directory - http://dir.nodeworks.com http://www.chamas.com

Re: triggers or stored procedures

the characteristics that make MySQL so appealing, great, otherwise forget it. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UNION with INTO OUTFILE and ORDER BY

BY a; Is this normal/intentional? MySQL 4.0.20 on Debian Linux. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Views Syntax for MySQL 5

/en/ANSI_diff_Views.html Sounds like it will make it into the 5.0 branch, but has not yet. Another good link: http://dev.mysql.com/doc/mysql/en/Roadmap.html Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: DBD or InnoDB or not?

handler which does not have Transactions and Foreign Keys, but would provide more speed for this type of database usage. You should probably read or at least glance through all of Chapter 15 on the online manual: http://dev.mysql.com/doc/mysql/en/Table_types.html Josh -- MySQL General Mailing

Re: Binary logfiles eating all my disk space

your perl script? Perhaps offlist if you are concerned about everyone seeing it? Thanks, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   >