MYIsam vs. BDB

In a high activity OLTP environment with "heavy" UPDATE activity, which table type is better? I have one table which has many readers & a decent amount of UPDATE activity. Will BDB or MYIsam result in better performance & by how much better (please quantify?

Re: Consenus on best column type for Latitude / Longitude?

I worked on a system years ago that used "binary encoded" integer for latitude & longitude. The Most Significant Bit (MSB) was a sign bit ( + or -). The next bit was 180 degrees The next bit was 090 degrees The next bit was 045 degrees. etc Functions were written to transform these into human read

Re: How do you think about PostgreSQL and mysql?

As previously posted to this list. http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf On 6/24/05, stone.wang <[EMAIL PROTECTED]> wrote: > How do you think about PostgreSQL and mysql? want to know which is good? How > to choose database for the web? -- MySQL General Ma

Re: libmySQL.so location

I suspect a case problem ln -s /usr/lib/dbd/libmysql.so libmySQL.so # perhaps? /opt/lampp/lib/mysql/libmysqlclient.14.0.0 /opt/lampp/lib/mysql/libmysqlclient.14 /opt/lampp/lib/mysql/libmysqlclient.so.14 /opt/lampp/lib/mysql/libmysqlclient.so.14.0.0 /opt/lampp/lib/mysql/libmysqlclient.so /opt/lamp

What is MYSQL equivalent to Oracle's NVL function?

The subject says it all!

How to login to MYSQL as "root" without knowing the passward

I've been asked to assist the folks who own the data in the database, but folks who used to maintain it are no longer with the company. This installation resides on a Windows 2003 server to which I have local admin rights. What is the most painless way to get "root" access to this database? I am mo

Re: How to login to MYSQL as "root" without knowing the passward

Sounds reasonable, but how do I shutdown down MYSQL so I can restart with --skip-grant-tables option? On 1/30/06, Dan Trainor <[EMAIL PROTECTED]> wrote: > > sol beach wrote: > > I've been asked to assist the folks who own the data in the database, > but > > folk

What is MYSQL's equivalent to Oracle's DBMS_OUTPUT

Oracle provides a stored procedure called DBMS_OUTPUT which primarily is used to write/print/display text string to StandardOut (a.k.a. the terminal). In V5 MYSQL is there a functional equivalent? If so, what is it called. I am willing to RTFM if somebody provides me a clue as to which manual conta

V6.0.3 & XML files

LOAD XML LOCAL INFILE 'test.xml' INTO TABLE bids ROWS IDENTIFIED BY ''; Above command is now valid in V6.0.3 & cleanly ingests properly formatted XML files. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 6.0.3 package has broken mysqld_safe

It exists on my system. ls -l /usr/local/mysql-6.0.3-alpha-linux-i686-glibc23 /share/english/errmsg.sys -rw-r--r-- 1 root mysql 36766 Nov 20 10:47 /usr/local/mysql- 6.0.3-alpha-linux-i686-glibc23/share/english/errmsg.sys On Feb 3, 2008 6:47 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > I just

MYSQL data replication

I have limited experience with MYSQL replication; which is why I am hoping others with more experience can answer a question or two. Let's say I have a MASTER MYSQL database. Let's say there are 50 - 60 other systems where I'd like to have MYSQL running on these "slave" systems. These slave system

Re: looking for a good book for learning mysql

MYSQL Third Edition by Paul DuBios (a frequent list contributor) On 8/2/07, Richard <[EMAIL PROTECTED]> wrote: > > Hello, I've got a good book for learning php, very complete and goes > through almost everything. However I'm now looking for a good mysql > book. I don't want ebooks, only paper vers

Re: Open Source Application Server

Spamming for maximum exposure? http://www.dbforums.com/showthread.php?t=1622017 http://www.orafaq.com/forum/t/88505/74940/ On 9/1/07, john_sm <[EMAIL PROTECTED]> wrote: > > > > Hey Guys, can you suggest any Open Source Application Server for SOA > deployments. Also, wondering, if our needs are s

ERROR 2013: Lost connection to MySQL server during query

I've tried looking up this error code on www.mysql.org & via Google. I'm not sure it matters but if you look closely at the SQL below, you can see it is working on file "page_path.tab4". It has already successfully loaded files page_path.tab1 thru page_path.tab3 I seriously could use a CLUE on

Re: newbie: delete row xy

> I want to delete e.g row 1433 There is NO row "1433"! "1433" would depend upon which column(s) specified in ORDER BY clause. A table is a collection and a collection has NO inherent order. On 5/2/05, Christoph Lehmann <[EMAIL PROTECTED]> wrote: > Hi > I now how to use delete together with a

Re: mysql and php

Gil, THREE elements need to be match what is stored inside MYSQL DB. 1) username 2) password 3) hostname You need to enable MYSQL logging, restart the DB, & try to login from PHP. Then, take a look at what MYSQL shows in its logfile & post the results here! YMMV On 5/29/05, Peter <[EMAIL PROTEC

mysql Ver 11.16 Distrib 3.23.49

Yes, I know it is old & obsolete. How do I query mysql to determine which hosts would benefit from a FLUSH HOSTS command? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What's MYSQL equivalent to Oracle's TRUNC(date_time_var)?

In Oracle TRUNC(data_time_var) returns only the date portion of a date_time data type. What's the easiest way in MYSQL to accomplish the same thing? I tried to RTFM (Paul DuBios' MYSQL tome; 2nd Ed.), but no clean solution lept out at me. It is a GREAT book, but it did not help me in this case. T

Re: Install problems with phpMyAdmin

You might want to consider the following site and collection of s/w http://www.apachefriends.org I have successfully installed XAMPP on both Windoze & Linux from their downloads. On Wed, 01 Dec 2004 08:44:49 -0500, Jason McKnight <[EMAIL PROTECTED]> wrote: > This may be a bit off-topic for

table types

How do I find out what table type is associated with each of the tables in MYSQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to enable BDB support?

I have two systems running mysql which I have inherited. On a good day I can spell "MYSQL", but I am required to support these DBs. mysql Ver 11.18 Distrib 3.23.51, for pc-solaris2.7 (i386) ; without BDB support +---+---+ | Variable_name | Value | +---+---+ | have_b

Re: big table corruption

Random hardware failures will NOT only impact a single file. The only thing that I know that will consistantly fail at the same spot is s/w. On Mon, 03 Jan 2005 16:32:31 -0800, Mark Maggelet <[EMAIL PROTECTED]> wrote: > Thanks Mike, > It's hardware raid, but I don't know the manufacturer. I could

Listing all connected users?

How do I see who is currently connected to MYSQL & from where they originate? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

show table types

SHOW TABLE TYPES became available in MYSQL 4.1. What is the equivalent for MYSQL 3.23.49? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

"missing" my.cnf file?

I have inhertited this old Solaris x86 system with MYSQL installed on it. mdb:/tmp 15:38:08 [539]# uname -a SunOS mdb.hitbox.com 5.7 Generic_106542-24 i86pc i386 i86pc I would rate myself as an advanced novice WRT MYSQL To a large deree this system is running OK. However, it does seem to be smac