Re: Sun and mysql

On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay

condense mulitple tables....

I am using 3 different systems... Each have a registration system... I believe they all use md5 to encrypt the password. Is it possible to just put as the value of the password record something like this: dbname.dbtablename So that it will be that value, instead of one that is inserted into the

Show Master Status php

I am having a heck of a time ... I would like to use php to do a SHOW MASTER STATUS and print the output but for the life of me can't figure it out. I can get it to SHOW DATABASES and SHOW TABLES in a database but now SHOW MASTER STATUS or SHOW SLAVE STATUS. David Rodgers -- MySQL General

Huge Server configuration

Hello all, I have a server like 8way Intel Pentium 4 Xeon processor with 12GB RAM and 1TB harddisk space. All the tables size are over 10GB and they have over 100mm records. Could some one help me get an appropriate mysql configuration(my.conf) file for the machine. I understand ther are

Re: Huge Server configuration

Christopher Knight wrote: what table types? Innodb.etc... It is mainly innodb. about how many tables? there are around 200 tables do you do alot of sorting? Lots of sorting and fltering is done are the exact same queries repeated alot? Not likely is the machine doing anything else or is

Re: Huge Server configuration

= record_buffer=512M set-variable = record_rnd_buffer=512M set-variable = myisam_sort_buffer_size=512M set-variable = max_allowed_packet=16M ---Original Message- --From: Mysql List [mailto:[EMAIL PROTECTED] --Sent: Thursday, July 24, 2003 9:38 AM --To: [EMAIL PROTECTED] --Subject: Huge

Re: Huge Server configuration

Dathan Vance Pattishall wrote: RAID-5 is cool, RAID-1+0 (10) is better for writes. Your defiantly are going to be IO bound. I would go with many smaller disks = 20 disk, in multiple RAID-1+0 configurations on different channels or better yet different RAID controllers. Well I do not have the

Re: select part of a field into another field

Jason Joines wrote: I have a table with an email field that contains values of the form [EMAIL PROTECTED] I need to populate a new field called uid with just the uid part of the email address. Is there any way of using select to just retrieve the part before the @ and insert it into the uid

Re: Just a doubt.....

Hi, I made a table with a primary key,and all the columns i declared char got converted into varchar. plz someone throw a light on it as i had seen somewhere that using primary key increase search speed and using varchars decrease so im in confusion. :(

Insert using placeholders....

I'm using placeholders like this: (using Perl) $stmt .= , if $stmt; $stmt .= $f-{t_name} . = ?; my $temp_value_holder = $f-{value}; $temp_value_holder =~ s/\,/\;/g; push (@placeholder, $temp_value_holder); The reason I'm using a temp value then switching the commas with ; is

How should I... [store data for later]

I am making my own shopping cart, and I'm trying to figure out, how to store previous orders, so they can view them later. If they have multiple products(tangible to be shipped), and they have the possibility of having colors, sizes, and or styles, each of them their own attribute, plus qty,

Help With Default Value

I am trying to do one of two things. First I'd rather do this, but if not possible, then the other way that I'll describe will suffice. 1) I need to have a default value of a column named invoice_id be this: Column names of importance: idinvoice_id id is auto_increment and BIGINT unsigned.

Re: Help With Default Value

Nevermind I got it $next_number = $dbh-selectrow_array(qq{ SELECT MAX(id) FROM whatever_table }); Richard. - Original Message - From: MySQL List [EMAIL PROTECTED] To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 30, 2003 9:44 PM Subject: Re: Help With Default

[ADMIN] Mailing lists back in service.

Hello again, MySQL list subscriber! We have completed the first phase of maintenance on the mailing lists, and mail should now start flowing on the lists again. Along with upgrading the hardware serving the lists, we have put in place new systems to help combat spam. One part of this system

[ADMIN] Mailing list maintenance this weekend.

Hello, MySQL list subscriber! We will be performing maintenance on the servers hosting the MySQL mailing lists this weekend, which will result in some periods of unavailability, and possible delays in mail delivery. Sorry about the interruption and inconvenience, and thanks for your patience

Locating Duplicate records always results in Error 127

I am locating 'duplicate entries in a table and updating a status field accordingly. The idea is to locate rows which have a matching 'Name' field, and mark them for subsequent processing. However, my update query *ALWAYS* returns Error 127, even on a newly created table if the matching name field

Re: Test

Adam Randall [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Which_version.html * http://www.mysql.com/doc/en/MySQL_test_suite.html * http://www.mysql.com/doc/en/running_mysqltest.html *

Re: BUG: InnoDB ORDER BY DESC may hang in 4.0.10

Heikki Tuuri [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/DESCRIBE.html * http://www.mysql.com/doc/en/ALTER_TABLE.html * http://www.mysql.com/doc/en/Group_by_functions.html *

Re: [BUG] Seg fault on REPLACE into large table

Chris Wilson [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Packet_too_large.html * http://www.mysql.com/doc/en/Creating_many_tables.html * http://www.mysql.com/doc/en/REPLACE.html *

Re: MySQL and Windows XP (Pro)

Dan Cumpian [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/ODBC.html * http://www.mysql.com/doc/en/Contrib.html * http://www.mysql.com/doc/en/Windows_client_compiling.html * http://www.mysql.com/doc/en/Windows.html

Re: Reading fixed column format file

[EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Static_format.html * http://www.mysql.com/doc/en/Miscellaneous_functions.html * http://www.mysql.com/doc/en/Compressed_format.html *

Re: How to Archive and restore the data in MySQL database.

Prasad Budim Ram [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Asking_questions.html * http://www.mysql.com/doc/en/RESTORE_TABLE.html * http://www.mysql.com/doc/en/Miscellaneous_functions.html *

Re: support question (win98_se) (auto)

Hi [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Business_Services_Support.html * http://www.mysql.com/doc/en/Which_OS.html *

Re: converting MS SQL to MySQL

Hi Hawk [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Using_mSQL_tools.html * http://www.mysql.com/doc/en/Using_InnoDB_tables.html This was an automated response to

Re: replication

Hi [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Replication.html * http://www.mysql.com/doc/en/Replication_FAQ.html *

Re: Replication is out of sync? (auto)

Hi goth [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Commands_out_of_sync.html * http://www.mysql.com/doc/en/Replication.html *

Re: natural left join (auto)

Hi Varshavchick Alexander [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/JOIN.html * http://www.mysql.com/doc/en/LEFT_JOIN_optimisation.html *

Re: CREATE TABLE, NOT NULL fields, and empty strings (auto)

Hi Doug Beyer [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Problems_with_NULL.html * http://www.mysql.com/doc/en/CREATE_TABLE.html *

Re: SQLyog 3.02 Released (auto)

Hi Insanely Great [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Many_versions.html This was an automated response to your email 'SQLyog 3.02 Released'. Final search keyword

Re: Replication error (auto)

Hi Oliver Schlag [EMAIL PROTECTED], I'm not sure if you have checked the manual yet, but following links seem to be somewhat related to your query: * http://www.mysql.com/doc/en/Replication_FAQ.html * http://www.mysql.com/doc/en/Replication.html *

Re: converting MS SQL to MySQL

Hawk [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/Using_mSQL_tools.html * http://www.mysql.com/doc/en/Using_InnoDB_tables.html This was an automated response to your email 'converting MS SQL to MySQL'. Final search keyword used to

Re: InnoDB foreign keys bug

Scott Wong [EMAIL PROTECTED], Do you think the following links may help? * http://www.mysql.com/doc/en/example-Foreign_keys.html * http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html * http://www.mysql.com/doc/en/ALTER_TABLE.html *

MySQL on large server

Hi, I was wondering if anybody has built MySQL 3.23 from source that can handle a high number of connections threads. I've have tried MySQL binaries in the past (not RPMs), but these have had stability/load problems. When building from source I don't have those issues, but I am limited by the

RE: Date()

Look at the DATE_FORMAT function. http://www.mysql.com/doc/en/Date_and_time_functions.html -Original Message- From: hotel [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 6:07 PM To: mySQL Subject: Date() Is it possible for mySQL to recognize and compare dates written in this

FULLTEXT search against a query result

Okay, here we go ... I would like to do a FULLTEXT search against a query result. There are multiple columns that have a FULLTEXT index. Hopefully I break this down in a manner that can be understood. The fields of interest: Table events: event_id [int(11)] event [varchar(255)] description

Replication Relay Fails.

We are trying to setup the following MySQL replication MSSQL Server - Push replication to Server 1 Server 1 - (Receives push replication from MSSQL and is Master MySQL for Server 2) Server 2 - (Slave to Server 1, Master for Server 3) Server 3 - (Slave to Server 2) Okay to make a long story

Rand slowness.

Hi, Is there a quicker way to get a selection of random rows than RAND()? I basically use: SELECT * FROM table ORDER BY RAND() LIMIT 3; But I find that as the # of rows increases in table, it keeps taking longer and longer to get a result back. And I am talking a large increase, basically 50

RAND slowness?

Hi, Can someone tell me which query would be faster with say 1000 rows: SELECT * FROM table ORDER BY RAND() LIMIT 3; or SELECT * FROM table; then use php to get 3 random rows from the returned data? - Before posting, please

A LEFT OUTER JOIN question.

I have two tables, 'items' and 'stuff'. Items has a primary key of itemid. and looksmlike this ItemID other fields... 1 ... 2 3 4 5 6 Stuff contains something like this: ItemID type info 1 0blah blah 2 0something 2 1... 3 1... I want a query

RE: A LEFT OUTER JOIN question.

Hi Peter, Thanks a lot - that does the trick! Incredibly quick response :) Ian -Original Message- From: Peter Normann [mailto:[EMAIL PROTECTED]] Sent: 16 June 2002 17:06 To: 'mySQL list'; [EMAIL PROTECTED] Subject: RE: A LEFT OUTER JOIN question. Try SELECT Items.ItemID

MyODBC DSN Configuration Dialog Hidden

Hi, I have a vb application which connects to mysql via ado/myodbc 3.51.03. In it, users can choose to connect to databases on different machines. I construct a connection string from the hostname, database etc. So far so good. The problem I have only occurs (as far as I can tell) on Windows

RE: MyODBC DSN Configuration Dialog Hidden

Hi Venu, The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname'

UPDATE-ing a table with keys to a related table?

Hi, hope somebody can help me - what I want to do is simple I'm sure, but I can't work out how to do it: I want to replace a column in a table, containing text, with a key to another new table which holds the text. Example: Given a table, 'people', which contains two columns, name, and town,

Help with Auto Increment

Hi, How do I start an autoincrement field at a certain value, say 1000? I have a field as: ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID) How do I modify it to start at 1000? These all generate errors: modify mytable ID AUTO_INCREMENT = 1000; modify mytable ID = 1000; modify mytable ID

Re: User issues in installation. New beginner

In General Terms: Most default linux installs do not allow root user to telnet in to the machine, this is good as a default. You need to add the user that you do logon as to the MySQL permissions. This can be found in the manual. To access your MySQL db from Access, all you need to do is install

How many OR, AND in a query?

Hi, How many OR or AND can I put in a select query statement? ex: WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . . A thousand? How would that affect the database execution time? - Before posting, please

Re: How many OR, AND in a query?

in() is usefull for OR ing, but is there a way to do this AND ing? You might want to try: WHERE mycolumn in (1, 3, 23, ...) Or even better, put your thousand records into a temporary table and then just do a join. --jfarr - Original Message - From: Mysql List [EMAIL PROTECTED

Question

Hi, Why is mysql(ver 3.23.41) complaining about this: CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY (ID), I know it is not the entire statement, but mysql does not like the AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable? Thanks, Chris

Re: Question

That didn't work either. The documentation seems to show that you have to use = 1000, but I can't get it to work. Try putting it like this :: AUTO_INCREMENT(1000), . Not sure but that should work - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Mysql

Re: Question

, . - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Mysql List [EMAIL PROTECTED] To: Deryck Henson [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Friday, September 07, 2001 4:26 PM Subject: Re: Question That didn't work either. The documentation

Query Question

Hi, Can any of you query experts tell me if this is possible in a query? I have 3 tables, categories, products, groups. Groups table consists of categoryid and productid, it just keeps track of which categories have which products. I need a query(if possible) that would basically say: Select

DuBois's book's scripts - where to get them?

I have the book, are the little scripts in the book available online? I went to the book's site at http://newriders.com/books/title.cfm?isbn=0735709211 which sent me to the author site at http://www.mysql.com/Contrib/Examples/ but gets the no permission error You don't have permission to access

What is the for in ' safe_mysqld --log '

I lost track of the tutorial where I saw the command safe_mysqld --log What is the for? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

Where to get a list of explanations for Errcodes?

When I attempt to get into this database this error comes up, but other databases work ok. I cannot find a reference to 'Errcode: 13' or any 'Errorcode' in the manual or mailing list archives. mysql use vhosts; Can't read dir of './vhosts/' (Errcode: 13) There is instruction on how to perform

How to start mysql server as user mysql

In my UNIX (FreeBSD) system the database directories shows up as below. drwx-- 2 mysql mysql512 May 11 11:51 mysql drwx-- 2 mysql mysql512 May 11 22:40 test I guess this means I should only start mysql server by being the user mysql. But how can I become the user mysql? The