4.1.16-1 RPM's

l/libz.a(compress.o)(.text+0x0): In function `compress2': : multiple definition of `compress2' /usr/lib/mysql/libz.a(compress.o)(.text+0x0): first defined here ... Did something change in the 4.1.16-1 RPM's in regards to zlib? As I mentioned above, 4.1.16-0 worked fine. Thanks, Ryan --

Name-based virtual servers?

onnect to their own servers instead, and not have to remember a port number. Like: mysql -h mysql.username.domain.com -u username -p and then they'd be pointed at their appropriate instance. Anybody know how I can do that? Thanks. --Ryan -- MySQL General Mailing List For

Re: Name-based virtual servers?

heir own socket files, or ... I would settle for a single shared database in which users could create databases and drop their own databases but not other users'. They'll have to live with namespace collisions. Is that possible to do with mysql's permissions? Thanks. --Ryan On

Test mail (please ignore)

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

Timestamp woes

d $T_field2 from my "dat_an_time" timestamp(14) my records are like this: 2004022215 20040227042018 20040223015329 Any help, references to the manual or URLs will be appreciated. Thanks in advance. Ryan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie - Please help with createing database

SQL-query : CREATE DATABASE `test1` MySQL said: Can't create database 'test1'. (errno: 13) Back can ANYBODY please tell me what to do? am going totally nuts trying to figure this out. Thanks in advance, -Ryan -- MySQL General Mailing List For list archives: http://lists.mys

Re: Newbie - Please help with createing database

ble? I guess root, coz thats what I login withnot really sure what "id" is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an ex

Re: Newbie - Please help with createing database

ble? I guess root, coz thats what I login withnot really sure what "id" is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an ex

Re: Newbie - Please help with createing database

ble? I guess root, coz thats what I login withnot really sure what "id" is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an ex

Re: Newbie - Please help with createing database

ble? I guess root, coz thats what I login withnot really sure what "id" is. I do think its a permissions issue...but I dont want to touch any settings till I hear from someone who knows about this as I know squat. Cheers, -Ryan * * * * * * * * * * * * * * * * I'm not an ex

Re: Newbie - Please help with createing database

ith tables seems to indicate that you are > communicating properly. Sounds goodbut still not working :-( Any other ideas? Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

taking out 3.23 and installing 4.0

after speaking with our host, this is the file: mysql-standard-4.0.18-pc-linux-i686.tar.gz Is there a step by step guide to do this? (remove 3.23 and install 4.0 OR keep 3.23 and run 4.0 side by side) Advise, URLs and any other kind of help appreciated. Thanks in advance, Ryan A -- MySQL General

Newly installed mysql 4.0

I do? Please explain in steps coz am just trying to get the hang of this. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newly installed mysql 4.0

Do you already have another mysqld server running on port: 3306 ? 040317 21:30:50 Aborting 040317 21:30:50 /usr/sbin/mysqld: Shutdown Complete Now what do I do? Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newly installed mysql 4.0.

essage from the server start-slave Start slave stop-slaveStop slave variables Prints variables available version Get version info from server So the above does not make too much sense to me being a newbie...but hopefully guys can hel

(simple select) bug? version problem? or just bad SQL?

James middle name Jacob etc but it does not display them...if i try with just first name then it displays the people whose first names start with "ja" whats wrong? is this a bug or not supported in 3.23 or I have written bad SQL? How can I do the above? Thanks, -Ryan A

Quick mysql question

Hi, A quick question, which is the most stable version of mysql to run on a very busy and commercial website(s)? 4.0 or is 4.1 stable enough? Thanks, -R.A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE

sysdate() query and note to Mysql admin

Hi, I my name is ryan and I own a small site which has a mysql database and servlet support. I have a simple query to all you mysql gurus... my table is very simple, i created a table with the following create table datee(int today); now,what statement do I use to put the sysdate into the

Small Java Problem and msg to MySql Admin

ks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on

Small Java Problem and msg to MySql Admin

ks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on

Small Java Problem and msg to MySql Admin

ks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on

Small Java Problem and msg to MySql Admin

ks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on

Small Java Problem and msg to MySql Admin

ks in advance, -Ryan NOTE TO MySql admins: Dear Sir/Madam, After trying to subscribe to the list I get a email asking me to confirm and when I confirm by sending a blank email with the necessary string in the subject line I get an email saying that there was an error and that you have given up on

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:ryan reynolds >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority:

Syntax error

Hi, here is public void String myQuery = "SELECT password from customerinfo where username="; myQuery.concat(myQuery, - Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices

Syntax error

hi everyone in this group, i am getting lately mysql syntax error when i run query from JSP page. here is sample code: public selectMyPass (String userid) { String myQuery = "select pass from datainfo where id="; myQuery.concate(myQuery,userid); myResultSet = stmt.executeQuery(myQuery)

possible to store raw data (like image data)?

Is it possible to store raw data (like image data) in mysql? If so, how can i accomplish it? (Should i need to make user-defined type?) Otherewise, what other databases support storing raw data? - Do You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got s

Re: See how far the slave has replicated from master

slave(s) is/are doing. The master only writes stuff to the binary log and leaves it at that. Anyway, that's my understanding. Cheers, Ryan -- Ryan Tracey Citizen: The World -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Questions about backups, InnoDB tables, etc.

ord in the database. The mysqldump is still running. How is this record getting inserted into the database? I thought it was locked while the dump was happening? I thought it would get queued up and inserted when the mysqldump is finished. The record was NOT in the dump, this part made sense. T

Backups on high-availability servers

about it! Thanks for any input, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysqldump Problem

sing "--skip-extended-insert". -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Intelligent Converters product: MSSQL-to-MySQL

Has anyone ever used this MSSQL-to-MySQL converter? It's pretty reasonable at $40, and the demo output I got looked pretty good. But I wanted to see if there is anything I should be weary about. http://www.convert-in.com/mss2sql.htm Thanks, -Ryan -- MySQL General Mailing List For

Connecting using MyODBC

error: ODBC Error Code = IM003 (Specified driver could not be loaded) Thanks for any help. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Questions about last_insert_id() instead of @@IDENTITY

your MySQL server version for the right syntax to use near 'INSERT INTO rps_names (nameid, name) VALUES (NULL, "Ryan Smithland") SELECT LA' at line 2 With MSSQL the trick was the NO COUNT. That told the database server not to return a count of the rows affected. Is there som

RE: Questions about last_insert_id() instead of @@IDENTITY

and I've tried setting autocommit = 0 at the beginning also. I will ask on a CF list, because they may have run into this issue. But really I think it's a MySQL question. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Intelligent Converters product: MSSQL-to-MySQL

Josh Chamas wrote: > Ryan Stille wrote: >> Has anyone ever used this MSSQL-to-MySQL converter? It's pretty >> reasonable at $40, and the demo output I got looked pretty good. But >> I wanted to see if there is anything I should be weary about. >> http://www.conve

RE: Intelligent Converters product: MSSQL-to-MySQL

a field will contain. > How can TEXT(16) hold more data than VARCHAR(16) ? I'm not sure how the (16) is used on a TEXT field. MS SQL has TEXT fields and VARCHAR fields. A VARCHAR(16) in MSSQL would be the same as a VARCHAR(16) in MySQL. But in my MSSQL database I have data with t

Detect if table exists from within MySQL?

S NOT NULL SELECT notifyto FROM cfgbiz ELSE SELECT '' as notifyto Is there something similar in MySQL? I am running version 4.1.x. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Detect if table exists from within MySQL?

in that list. But I was hoping for a more elegant way to do it, within the single query. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Detect if table exists from within MySQL?

-and- select IF((SHOW TABLES LIKE 'cfgbiz'),notifyto,'') FROM cfgbiz; But it looks like the SHOW TABLES statement just doesn't return like a regular SELECT statement does, because the above works if I use it like this: select IF(1,notifyto,'') FROM cfgbiz; -Ryan -

Problem compiling MyODBC - looking for sql.h file

lude/sql.h file on that system. I don't know how it got there. By looking inside the file it appears to be related to MyODBC 3.5.11. Just for kicks I copied this file to the second system, but got the same error when trying to run ./configure. Any ideas? -Ryan -- MySQL General M

Re: Terrible MySQL Administrator

? i suggest you post the email header here, so anyone can help you further. hth -- Ryan Escarez CEBB F1E4 1E39 EC48 F05D 6B72 9C11 DD88 5E39 E471 $ gpg --keyserver pgp.mit.edu --recv-keys 0x5E39E471 main(k){float i,j,r,x,y=-16;while(puts(""),y++<15) for(x=0;x++<84;putchar(" .:-;!

UNIX timestamp with microseconds

is possible to get UNIX timestamp with microseconds when i try the following it just give 10 digits mysql>SELECT unix_timestamp('20051114095641'+ INTERVAL 0 HOUR) as ts; output : 1131933401 <--- 10 digits any tips? tia! -- MySQL General Mailing List For list archives: http://lists.mysql.com/

timestamp

is it possible to get the the given (unix)timestamp in milliseconds since the epoch? tia! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql compile error

re command: ./configure --without-server \ --prefix=/usr/local/mysql \ --exec-prefix=/usr/local/mysql \ --with-named-curses-libs=/usr/lib/libncurses.so.4 \ --enable-thread-safe-client \ --with-extra-character-sets=complex Any ideas on what's wrong?

RE: Mysql compile error - more info

there's no obvious break between my comments and my pasted error messages. I hate Outlook with a passion but am forced to use it. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql compile error - fixed

I fixed the whole problem by typing this one line: `ln -s libz.so.1.1.3 /usr/lib/libz.so` Linux is such a pain sometimes. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Unable to reference right join table in left join statement under windows...but works under linux

I am using MySQL 5.0.15 on windows and cannot run this query: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25 I re

RE: Backups

> Furthermore, would it make more sense to have the data dump locally, > and then use a script to move the contents of the dump to a machine > on the network, perhaps even to a machine located on an alternate > network accessed via a second ethernet card? This would be the simplest approach. That

Converting a date/time field to UTC

then add that to the field value. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: data entry GUI

You can also install MyODBC and then hook an Excel spreadsheet into your database. Editing the spreadsheet will update data in your database. This isn't a good solution if you are going to be creating new tables often. But for manipulating data in a known set of tables it's gre

User is rejected because of IP, but hostname is allowed

nc.com'. The machine I'm trying to connect from is named dbdev.willcomminc.com. I did a reverse lookup from the database server and the IP 192.168.2.56 does indeed lookup to dbdev.willcomminc.com. Why is MySQL ignoring the hostname and using the IP? I did google for this first but d

RE: User is rejected because of IP, but hostname is allowed

Nope. _ From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 4:32 PM To: Ryan Stille Cc: mysql@lists.mysql.com Subject: Re: User is rejected because of IP, but hostname is allowed did u start

RE: User is rejected because of IP, but hostname is allowed

>>> did u start mysql with --skip-name-resolve ??? >>> Kishore Jalleda Kim Christensen wrote: > On 2/16/06, Ryan Stille <[EMAIL PROTECTED]> wrote: >> Nope. > > Well, have you tried it? Did it solve your problem? Sorry, I misunderstood. I t

Want mysql to return tablename.fieldname format

turned, so they show up as ads.id, track.id, etc? -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: create/restore database without binary logging

Put "SET SQL_LOG_BIN=0" at the top of your dump file. That will turn off logging just for your session. -Ryan > -Original Message- > From: sheeri kritzer [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 02, 2006 11:56 AM > To: Rithish Saralaya > Cc: M

RE: Want mysql to return tablename.fieldname format

specific names (ads.id as adid). Thanks, -Ryan Rhino wrote: > I don't understand what you want. If you have the original > query, it should be apparent from it where each 'id' column > originated. If you're not sure how to read the query, post it > and we can he

RE: manual deletion of binary log files

Yes, look at the PURGE LOGS command. Rithish Saralaya wrote: > Hello. > > Can I delete off the binary log files manually? I do not want > to 'RESET MASTER', as it will clear all the binary logs, and > that's not what I want to do. The database is backed up every > midnight, and I wouldn't want to

RE: Deleted sock file, how can I recover

from the local machine, depending on what address you use to connect to. (local IP, local host, actual hostname, etc). -Ryan Scott Haneda wrote: > ERROR 2002: Can't connect to local MySQL server through > socket '/tmp/mysql.sock' > > I accidentally deleted the above

Charset questions

some ColdFusion functions. I am wondering if my database charset has anything to do with it. What do other people usually do as far as the collation setting? We are in the US, but do have a few sites that make use of German and Spanish characters. Thanks, -Ryan -- MySQL General Mailing List

RE: How can I observe mysqld?

> What else can I do to observe myslqd? mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/ -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Charset questions

I'm still hoping someone can else can share their input on this. What do other people usually do as far as the collation setting? Thanks, -Ryan Ryan Stille wrote: > When we migrated to MySQL from MS SQL, I left everything set > to the default as far as collations - latin1_swedish_ci.

RE: Charset questions

Are my emails not coming through? Or is this question way too 'newbie' and no one wants to touch it? -Ryan Ryan Stille wrote: > I'm still hoping someone can else can share their input on this. > > What do other people usually do as far as the collation setting? >

How to Log Warnings and Errors from queries

does not work on my server with mysqld-4.0.25 binary version. Any inputs are appreciated. Thanks, Ryan.

Re: How to Log Warnings and Errors from queries

Hi Dan, Noted with thanks. As such, is there a workaround to log problematic sql queries ran against the mysqld server ? Do I need to write separate script to do this ? Regards, Ryan. On 3/10/06, Dan Nelson <[EMAIL PROTECTED]> wrote: > > In the last episode (Mar 08), ryan lwf

Re: How to Log Warnings and Errors from queries

Hi Rithish, Thank you all for your suggestion, I would definitely give it a shot. Regards, Ryan. On 3/13/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote: > > Hello Ryan. I am more of a developer than a MySQL administrator. Hence, I > would always favour applications logging quer

RE: Very large from

e time, I think you even said most of your traffic would be browsing and reading the listings. So I don't think it would be a problem to build up all the data in a session and then write it all at once at the end. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Table size vs Memory requirements?

Hello, Is it common heard from people that if you have large table (assume MyISAM in my case), you need large memory in order to have the key/index in memory for performance, otherwise, table scan on disk is slow. But how to estimate how much memory I need? Consider a simple case, a MyISAM table

Re: Help saving MySQL

On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman wrote: > I hope the only reason this thread  is so quiet is because we are all > busy notifying our friends.  There are a hell of a lot more users > invested in MySQL than those who read this list.  Spread the word! > Let's stand up today to face t

Table level locking when inserting auto-increment PK to InnoDB

Hey. Back to few years ago, InnoDB require table level locking when inserting auto-increment PK to the table, and Heikki said there will be a fix. Is this problem still exist now? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

Why UTF8 need 24bit in MySQL?

http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html Since MySQL only support BMP, so in fact 16 bit is needed actually? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Why UTF8 need 24bit in MySQL?

Hi, On Tue, Jun 8, 2010 at 12:44 AM, Warren Young wrote: >  The Unicode consortium has stated that Unicode will > never require more than 21 bits per character[*], and 24 bits is the next > even multiple of 8 up from that. Maybe off topic, but just curious...If 3 bytes is enough for all Unicode

int(10) va int(11)

Assume MySQL int range (unsigned) is from 0 to 4294967295 There are total 10 digits. Why a lot of tutorial in the web tell you to declare, e.g. CREATE TABLE t1 (f INT(11) UNSIGNED); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Storage of UTF-8 char in MySQL

According to this document: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html It said MySQL support UTF-8 using one to three bytes per character. But I have created a test table: -- create table test ( c char(5) ) default charset =utf8; >From the table status, the data length is alway

Parameter(s) need to take care when setting replication over WAN

Hello, I am setting MySQL (5.0) replication over WAN for backup purpose (with SSL enabled). I have read the document: http://dev.mysql.com/doc/refman/5.0/en/replication.html, and wonder if any special tunning needed for using replication over WAN. Are there any configuration parameter(s) need s

how to generate a data set then join with in on fly?

` = d ? Thanks, Ryan

One database per server architecture

Architecture question I'm having trouble finding an answer to: I run four WordPress websites. I have mysql setup in a write master/read replica slave configuration on Amazon. There is one master that all the WordPress instances write to. I'm trying to figure out how to setup the read replicas.

Re: One database per server architecture

s not like to share an app server) and added memcache. So I think we're ripe for another try. Thanks again, Ryan On Oct 18, 2011, at 5:39 PM, Lydia Rowe wrote: > You have answered your own question, good sir. Or so I have come to believe. > Is your primary concern $? Is your organiz

mysql_secure_installation

Hi, Does anyone know why what's done in 'mysql_secure_installation' [0] isnot part of the default mysql installation? [0] http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html Thank you,Ryan Dewhurst P.S. I also asked this question on the forums:http://forums.mys

Re: mysql_secure_installation

opinion, additional steps shouldn't be taken to make MySQL more secure, instead additional steps should be taken to make it insecure if that is what is needed in certain environments. Thank you for the reply. Ryan On Tue, Dec 27, 2011 at 4:08 PM, Shawn Green (MySQL) wrote: > Hello Ryan

Slow Subquery

Y `index_tags_on_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `projects_tags` ( `project_id` int(11) default NULL, `tag_id` int(11) default NULL, KEY `tag_id` (`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; I'm using MySQL 5.0.37. Thanks in advance.

Problem with master/slave replication

)?Eod> #master-connect-retry = 60 #replicate-do-db= mydns # -- Regards, Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Why is this delete so slow? ( 90 seconds per 100 records)

I'm trying to delete some orphaned records from a table that has about 150K records. Here is my delete: |CREATE TEMPORARY TABLE deleteids AS ( SELECT subTable.ID from subTable LEFT OUTER JOIN parentTable ON subTable.ID = parentTable.ID WHERE parentTable.ID IS NULL ); DELETE FROM subTable WH

Re: Why is this delete so slow? ( 90 seconds per 100 records)

gone. Thinking about it now... its probably the IN clause, isn't it? I've heard those are slow. Hopefully someone will have a better idea. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why is this delete so slow? ( 90 seconds per 100 records)

Thanks for the help, I rewrote it as a subselect and it deleted all 10K records in two seconds. DELETE subTable FROM subTable LEFT OUTER JOIN parentTable ON subTable.parentID = parentTable.ID WHERE parentTable.ID IS NULL -Ryan -- MySQL General Mailing List For list archives: http

Re: Why is this delete so slow? ( 90 seconds per 100 records)

Ryan Stille wrote: Thanks for the help, I rewrote it as a subselect and it deleted all 10K records in two seconds. DELETE subTable FROM subTable LEFT OUTER JOIN parentTable ON subTable.parentID = parentTable.ID WHERE parentTable.ID IS NULL -Ryan Whoops, I meant that I rewrote it as a JOIN

my.cnf optimization

t follows my sig below... My devs are adding indexes where the slow query log is pointing them, but any suggestions on how better to tune things up would be much appreciated. I'm not sure what else to tune here but we're getting bursts of 1200+ queries per second regularly and s

Re: my.cnf optimization

Variable_name: sort_buffer_size Value: 67108856 12 rows in set (0.00 sec) I'll bump innodb_buffer_pool_size to 2G and see how that goes. Thanks for the tips, if there's additional innodb tuning parameters folks tend to hit first I'd be glad to try them as well. -- Ryan S

Re: my.cnf optimization

On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote: Hi ryan. As pointed by Johnny, it is difficult to give optimization advise without exactly knowing the performance of your machine. I'm assuming you are using the machine as Database Server and not running application (Web/other) o

Selecting a column with a regular expression applied to it?

e regex in the where clause. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Selecting a column with a regular expression applied to it?

h all the non-ascii characters removed, for example. -Ryan Darryle Steplight wrote: Hi Ryan, MySql does have regular expressions. See Link http://dev.mysql.com/doc/refman/5.0/en/regexp.html On Thu, Sep 11, 2008 at 9:52 AM, Ryan Stille <[EMAIL PROTECTED]> wrote: From looking at the M

MySQL on a ram disk?

running on MSSQL, and we are wondering if we could find any speed improvements by moving to MySQL, possibly running on a ram disk. Any input appreciated. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: MySQL on a ram disk?

Maybe I should just be looking at using a HEAP table? -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB does not preserve AUTO_INCREMENT -- WTF!?

omething for setting the next auto increment id. Hope this helps. -Ryan Daevid Vincent wrote: http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html We have recently switched several database tables from MYISM to INNODB, only to find out this colossal design flaw in InnoDB tab

Re: question on create_tmp_table_priv

docs about this the other day. It said temp tables are always created in memory, but can be moved to disk if they get too large, or will be created on disk initially if the table contains a certain type of field (maybe text or binary, can't remember). -Ryan -- MySQL General Mailin

Re: making graphs with MySQL data

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

Re: select on multiple fields in several tables?

er. When would every column in your table have the same value? (john smith in your example). You can programmatically get a list of columns in a table, then when you are using Perl or PHP or whatever to build your query string, you can loop through the columns to list them. -Ryan -- MySQ

Re: MySQL Daylight Savings Time Patch

Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Paul DuBois wrote: At 4:17 PM -0600 2/20/07, Paul DuBois wrote: At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks

Re: MySQL Daylight Savings Time Patch

Paul DuBois wrote: At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! ... My timezone tables appear to be empty. At least the time_zone_nam

Re: MySQL Daylight Savings Time Patch

Ryan Stille wrote: Paul DuBois wrote: At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! ... My timezone tables appear to be empty. At leas

  1   2   3   4   >