Re: NOW() is stuck...

to stay in bed on Monday, rather than spending the rest of the week debugging Monday's code. - Christopher Thompson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Eric Bergen eric.ber...@gmail.com http

Re: NOW() is stuck...

-- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Which test suites are valid for --extern option in mysql-test-run?

this, I cannot judge whether a test fails is because it's not supported or real problems. Thanks a lot! Tianyin -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/ -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Why configuration directives are all case sensitive?

!! Tianyin On Fri, Nov 23, 2012 at 4:20 PM, Eric Bergen eric.ber...@gmail.com wrote: Anger and OS religious arguments the real answer is that is just how the option parsing code works. It doesn't always have to make sense. There are short and long args to programs. For example on the mysql

Re: Covering Index without the data file (myisam)

: NO -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Why configuration directives are all case sensitive?

developers do take care a lot of things (as unit and options I mentioned). T -- Tianyin XU, http://cseweb.ucsd.edu/~tixu/ -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: get a partial dump

in the java code, but I thought mysql might offer that or at least parts of it. Does anybody have an idea? Thanks, Stefan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Eric Bergen eric.ber...@gmail.com http

Re: Can I measure the use of index?

://www.twitter.com/plinux Blog: http://www.penglixun.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Replication rings/maatkit (was: HA Scalability w MySQL + SAN + VMWare)

, and Administrator University Library ITS University of California, Santa Cruz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General

Re: 4 minute slow on select count(*) from table - myisam type

)     max_heap_table_size ( 16M)     table_cache ( 1024) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=mjh2...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL

Re: Restore only one database or one table

What I am expected to hear. I will let u know after some practical implementation. Thanks best Regards, Adarsh Sharma -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: InnoDB and rsync

. This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net

Re: Is is possible to update a column based on a REGEXP on another column?

There isn't a built in way but you can try http://www.mysqludf.org/lib_mysqludf_preg/ I would go with the php/perl script if this is a one time thing. -Eric On Jan 21, 2011, at 11:31 AM, Phil pchap...@nc.rr.com wrote: I have a table which contains a username column which may be constructed

Re: Innodb table space questions

. 2. can we store table on specific tablespace like Oracle or DB2 when creating table? You can only choose to store a table in it's own tablespace or in the global one. Many thanks. -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list

Re: export result from select statement

?!? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http

Re: mysqldumpslow

To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Slow ALTER TABLE on 70M row InnoDB table

: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Recommended swap partition size

Google oom_adj and oom_score. You can control which process is most likely to be killed. On Mon, Apr 19, 2010 at 12:53 AM, Johan De Meersman vegiv...@tuxera.be wrote: On Sun, Apr 18, 2010 at 9:04 PM, Eric Bergen eric.ber...@gmail.com wrote: Usually I prefer to have linux kill processes

Re: How to corrupt a database please???

To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Recommended swap partition size

...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Recommended swap partition size

, Rob Wultsch wult...@gmail.com wrote: On Sun, Apr 18, 2010 at 12:04 PM, Eric Bergen eric.ber...@gmail.com wrote: Linux will normally swap out a few pages of rarely used memory so it's a good idea to have some swap around. 2G seems excessive though. Usually I prefer to have linux kill processes

Re: Multiple table engine

...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysqld_safe

:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Is myisam_repair_threads considered safe

? -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list

Re: Fail to change MySQL data directory on ubuntu

To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- 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 doesn't mySQL stop a query when the browser tab is closedL

? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=joh...@pixelated.net -- - Johnny Withers 601.209.4985 joh...@pixelated.net -- Eric Bergen eric.ber...@gmail.com http

Re: Why can't I kill the query cache?

/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Question on replication terminology

replication dual-master replication bidirectional replication TIA -BT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net

Re: innodb_thread_concurrency at runtime in 4.1 ?

Now surf faster and smarter ! Check out the new Firefox 3 - Yahoo! Edition * Click here! -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Sun bought by Oracle

/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@provenscaling.com http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: flush-host problem

Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@provenscaling.com http://www.provenscaling.com

Re: MySQL Closing/Opening tables

. --    Dan Nelson    dnel...@allantgroup.com -- Eric Bergen eric.ber...@provenscaling.com http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: how to disable InnoDB and MyISAM on ndb cluster

Hi Nipuna, InnoDB can be disabled with the skip-innodb option. MyISAM can't really be disabled because it's required to read the grant tables. -Eric On Sat, Dec 27, 2008 at 4:21 AM, Nipuna Perera nipu...@gmail.com wrote: Hi All, I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our

Re: Where should I download mysql 4.0.12?

If you still want it you can download it from the Proven Scaling mirror. http://mirror.provenscaling.com/mysql/community/source/4.0/ -Eric On Thu, Nov 6, 2008 at 1:58 AM, Joerg Bruehe [EMAIL PROTECTED] wrote: Hi! Moon's Father wrote: Hi. Where can I download a mysql 4.0.12? I found

Re: How Can I Auto Delete my Binary Files?

Shaun, Purge master logs is available in 4.0 it just doesn't have the before key word. It should be trivial to write a script that decides which log file to purge based on the mtime. -Eric On Thu, Jul 10, 2008 at 12:15 PM, Shaun Adams [EMAIL PROTECTED] wrote: I'm running a RHEL 4.1 and MySQL

Re: Why open-files-limit smaller than table_cache?

Hi, It's true that MyISAM keeps two files descriptors open per open table but this is MyISAM specific. An open table in MySQL isn't a one to one mapping to file descriptors, it's simply a c++ object. It's up to the storage engine how it manages file descriptors. Engines can use worker threads

Re: Database cache corrupted

Can you send us the exact zabbix error? On Sun, Apr 27, 2008 at 6:18 PM, Sergio Belkin [EMAIL PROTECTED] wrote: So anyone had ever had any problem with database cache? :) 2008/4/25 Sergio Belkin [EMAIL PROTECTED]: Hi, I am using zabbix (monitoring software) with mysql. zabbix goes

Re: problems w/ Replication over the Internet

TCP checksums aren't as strong as encryption. It's rare but corruption can happen. Where are you reading the positions from and how are you taking the snapshot to restore the slave? On Mon, Apr 21, 2008 at 12:30 AM, Jan Kirchhoff [EMAIL PROTECTED] wrote: Eric Bergen schrieb: Hi Jan

Re: Working with Images

Victor, Please give us an example with the python removed and include the actual syntax error. -Eric On Fri, Apr 18, 2008 at 8:41 AM, Victor Subervi [EMAIL PROTECTED] wrote: Hi; The python code works properly, so I assume this is a strictly MySQL question now :) If I grab an image in

Re: problems w/ Replication over the Internet

Hi Jan, You have two separate issues here. First the issue with the link between the external slave and the master. Running mysql through something like stunnel may help with the connection and data loss issues. The second problem is that your slave is corrupt. Duplicate key errors are sometimes

Re: Does version 4 mysqlcheck close MyISAM tables left open?

Nicole, The tables left open warning is from the tables that were left open when the server was rebooted. Internally mysql keeps a counter per table of the number of clients that have a table open. When a table is closed this counter is decremented. If mysql is improperly shutdown this counter

Re: Innodb vs myisam

I don't see what the issue is. As Jay said the row counts in explain outputs are estimates. When running an explain query MySQL asks the storage engine how many rows it thinks are between a set of values for an index. Different storage engines use different methods to calculate row count. Both

Re: only myisam storage engine

You can set the skip-innodb option in my.cnf -Eric On Tue, Apr 1, 2008 at 9:28 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, We have a linux box running debain, with 8 cpu and 8 GB RAM, we want only myisam engine to be running on this. So, should i not setup any innodb parameters or

Re: Connections on Database

You probably only want max_connections and not max_user_connections. Max_user_connections is the number of times a user can connect per hour.. -Eric 2008/3/31 Vidal Garza [EMAIL PROTECTED]: Velen escribió: Hi, How can i limit connections to my database? Regards, Velen

Re: Connections on Database

Oops. I was wrong on that one. max_user_connections is different from global max_connections and max_connections per user. 2008/3/31 Eric Bergen [EMAIL PROTECTED]: You probably only want max_connections and not max_user_connections. Max_user_connections is the number of times a user can

Re: The Use database command is too slow

I think a better question is why do you have one database per user? -Eric On 2/2/08, imad [EMAIL PROTECTED] wrote: I am not connecting through MySQL. I am connecting through PHP. How can I speed it up? On Feb 3, 2008 12:20 AM, Saravanan [EMAIL PROTECTED] wrote: Hi, when you connect

Re: MySQL Ends Enterprise Server Source Tarballs

://www.linux.com/feature/118489 ÐÆ5ÏÐ -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What's up with 5.1x beta

release? -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: slave backups master data

server? -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: hang up mysql shell

-Grundgebühr! http://www.arcor.de/rd/emf-dsl-2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives

Re: Limitation of DRBD For MySQL

mounted disk 7. Does not address scaling or performance 8. OS Limitations – Some only run on Linux May someone elaborate or disprove those points? Thanks. -- Regards, Mohd Irwan Jamaluddin Web: http://www.irwan.name/ Blog: http://blog.irwan.name/ -- Eric Bergen [EMAIL PROTECTED] http

Re: speedup mysql restore

] -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com

Re: max mysql under windows

, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- Eric

Re: INSERT IGNORE BUG?

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

Re: bug

://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Sequence ID generation transaction-safe?

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

Re: Why innodb can give the same X gap lock to two transactions?

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

Re: Help understanding the whole password issue

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

Re: InnoDB Crash RECOVERY HELP (Urgent)

in my.cnf, it startsup but my innodb tables could not be accessed. How can I start MySQL server again? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. a href= http://www.spreadfirefox.com/?q=affiliatesamp;id=0amp;t=1; Get Firefox! /a -- Eric Bergen

Re: Who's locking ?

investigate, who's blocking the line ? -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Looking For How test database performans on different hardware

forms of data corruption may not be present and we do not take any responsibility in any occurrence. -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com

Re: udf configuration resources

to it everytime it is run. I know I could read a file in the _init function, but this seems very wasteful to read a file every time the function is being used. Any thoughts on this would be appreciated. thanks, Yong. -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL

Re: key_buffer_size vs innodb_buffer_pool_size

in your hands ASAP. -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can you tell if a table is corrupted?

to tell if a table has been corrupted? We're having some weird things happening and the only thing I can think of is possible corruption of a table, but is there anything you can do to find out? Jenifer -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List

Re: recursive queries

I believe that some time in the future mysql will support oracle style connect by prior syntax but it's not implemented yet. Gleb Paharenko wrote: Hello. Though I haven't read this article, but its title looks promicing: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

Re: Optimize: 14 hours and still running!

Is the box swapping? Gleb Paharenko wrote: Hello. As was mentioned by other members without seeing your configuration settings it is difficult to say about InnoDB performance. You can indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW INNODB STATUS. For InnoDB it maps to

Re: IP Resolution

MySQL 4.1.14 is the current version. You should always upgrade to the lastest release and test your problem before trying to report bugs. Ben Clewett wrote: Dear MySQL, My MySQL 4.1.9 has lost the ability to work out what IP address clients are connecting from. Eg: $ mysqladmin

Re: Drop Table Problem

Try running a flush tables in mysql to make sure that mysqld knows about all the tables on disk. xtcsuk wrote: Running the command: Drop table if exists table1 complaints of table1 does not exist (Error: 1051). However, if table1 is swapped with another table, irrespective of its existence it

Re: Optimizing query WHERE date0

When you add that index are more than 30% of the rows in the table DateTimeNext1126215680? Dan Baker wrote: I have lots of tables that are similar in nature: id int(11) PRI NULL auto_increment Name varchar(30) DateTimeNext int(11) The DateTimeNext field represents when this records needs

Re: Anyone knows what happens at mysqladmin startup time?

It appears that mysqld is not listening on /tmp/mysql.sock. Log into mysql and run show variables like 'socket'; This will tell you where mysqld is actually listening for socket connections. Then update your my.cnf files so they all have the same sock file location as the one that mysqld is

Re: log event entry exceeded max_allowed_packet

packet too big errors in replication are often a sign of corrupt binary logs. If it's on a slave reading the relay log often times flushing it will temporarily solve the problem. The easiest way to flush the relay logs is to do a slave stop; change master to back to the current file name and

Re: Doubt about query optimization

Can you send us the actual show indexes from table and explain output that isn't shortend? Ronan Lucio wrote: Hello, I´m using MySQL-4.1.7, and I have a query that seems, even using where clause, an specific table isn´t being optimized properly: I have four tables: real_state: cod, name,

Re: Insert with prefix

Try this: concat('UP', lpad(category_id, 6, '0')); Scott Purcell wrote: Hello, I have the following dilemma, that I do not know how to handle. I have the need for a table where I create a identifier. The identifier consists of a two character string, eg: UP + the next AUTO_INCREMENT Here is

Re: Hour counts

This does make his code fall under the limitations of unix timestamps. In 30 years or so when we are all retired millionaires ;) some poor intern is going to have to figure out why the hour diff calculation is failing. [EMAIL PROTECTED] wrote: Gyurasits Zoltán [EMAIL PROTECTED] wrote on

Re: table export problem

Which version of mysql are you exporting from and inserting into? [EMAIL PROTECTED] wrote: Hi all, I am trying to create a table on the remote server from a table I created on my local sever but it never seems to work CREATE TABLE `sheet1` ( `id` int(10) NOT NULL auto_increment, `title`

Re: Mysql crash due to page corruptions

Please upgrade to the newest 4.0 mysql binaries. Anil wrote: Hi, We are using mysql 4.0.20 on RHEL3.0 with circular replication setup A -B -C -A . A is the master and all operations will be happening on A. We are facing frequent mysql crash on Master with page corruption errors. How to

Re: Subselect in an Update query

Could you accomplish this with an update and self join? Ed Reed wrote: Sorry, I thought it was easy to understand. I wanna update a field in a table with a value from the same field but from a different record of the same table. For example, using the query in my original message,

Re: INSERT DELAYED and NOW()

More queries yes but not more disk i/o. The first query will never touch a disk. [EMAIL PROTECTED] wrote: Eric Bergen [EMAIL PROTECTED] wrote on 06/09/2005 12:56:59 PM: How about something like this: mysql select @t := now(); +-+ | @t := now

Re: INSERT DELAYED and NOW()

How about something like this: mysql select @t := now(); +-+ | @t := now() | +-+ | 2005-06-09 09:55:49 | +-+ 1 row in set (0.00 sec) mysql insert delayed into t set t = @t; Query OK, 1 row affected (0.00 sec) mysql select *

Re: ORDER BY and ENUM -- not alphabetical

It's not a bug at all. You just hit one of the features of enum :) If you want to order alphabetically as you describe cast the enum name to a string like this select col from t order by concat(my_enum); -Eric Daevid Vincent wrote: Please tell me there is a way to fix this bug in mysql

Re: MySQL Slave Read Only

There is an option starting in 4.0.14 called read-only that will allow only the slave i/o thread and users with the super priv to execute write queries. Jeremiah Gowdy wrote: Is there a way to make MySQL Slaves read only in regards to all UPDATE, INSERT, DELETE, DROP, TRUNCATE, etc, except

Re: maximum size of mysql server-id field

It's 32 bit. I'm not sure if it's signed or not but chances are you don't need more than 2 billion ids :) Richard Lynch wrote: On Wed, May 25, 2005 11:59 pm, David said: Does anyone know what the range for server-id can be? Is it a 16 bit number? 32 bit? I can't seem to find it in the

Re: ERROR 1030 (HY000): Got error 127 from storage engine

Did you shut down mysqld or read lock before copying the table? Qunfeng wrote: Hi, I am running MySQL 4.1.8-Max-log on two Linux machine (machine A and machine B). In the past, I do a simple scp to transfer all the database table file from one machine (A) to the other (B). After the

Re: MySQL preg_split functionality?

I'm working on a set of UDFs for preg functions. [EMAIL PROTECTED] wrote: I have a hard time figuring out when you would use such a function. I do not believe you will be able to duplicate this behavior without constructing your own UDF or by writing a stored procedure. BTW, why *do* you

Re: ERROR 1030 (HY000): Got error 127 from storage engine

elaborate it a little more on why? Thanks a lot! Qunfeng At 01:05 PM 5/27/2005, Eric Bergen wrote: Did you shut down mysqld or read lock before copying the table? Qunfeng wrote: Hi, I am running MySQL 4.1.8-Max-log on two Linux machine (machine A and machine B). In the past, I do a simple scp

Re: slow DELETE query

Also try running the delete more frequently. It won't cause much of a lock if there is an index on accountcode and mysql doesn't find any rows to delete. gerald_clark wrote: Matthew Simpson wrote: I use Mysql to store call detail records from telephone calls. I have around 20 voice switches

Re: Upgrading from 4.0 to 4.1

When mysql had trouble starting up what error messages did it give in the .err file in the datadir? -Eric James Tu wrote: I had to migrate from 4.0.11 to 4.1.12. I saved the data directory from the older version. I also exported all the information using phpMyAdmin's export tool. I have one

Re: select count(*) table

select count(*) table; gives me a syntax error in 4.0 and 4.1 so I'm not sure how that worked. Something similar would be select count(*) t; which uses the shortcut alias syntax. It's the same as doing select count(*) as t; Simon Garner wrote: [EMAIL PROTECTED] wrote: I have a curious

Re: mysqldump question

Is there a reason you can't run mysqldump on the server? You could then gzip it and use any transport method with throttling you want (like wget) -Eric Aaron Wohl wrote: http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do what you want... I havent tried it yet, but noted the

Re: Read past Equivalent in MySQL

I agree. It sounds like you could use plain repeatable read isolation transactions. If someone else is modifying those rows you get an older version from when your transaction was started. No need for skipping anything. Martijn Tonies wrote: I am using InnoDB only. But, it's not skipping

Re: Seeking Syntax Assistance

Sorry, mysql doesn't support sub queries until version 4.1 -Eric Scott Purcell wrote: Hello, I am accustomed to Oracle query syntax, and I am having trouble with this following query which uses the IN. I am running mysql ( Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32) ) which does not support

Re: Efficiently finding a random record

Even better is if you have an integer primary key (think auto_increment) and use in() So if you want 10 random rows in your app generate 20 or so random numbers and do something like select col1, from t where x in (1, 5, 3, 2...) limit 10 check num rows and if you don't get enough generate

Re: Fastest way to get the record count?

select count(*) from table is the fastest for myisam because it caches row count. This will also include any rows that have null values. select count(col) from table will not count rows where that column is null and will also be forced to access the index or data file. -Eric Brian Dunning

Re: Efficiently finding a random record

in() can take millions of arguments. Up to max packet size. Try it :) Dan Bolser wrote: On Fri, 13 May 2005, Eric Bergen wrote: Even better is if you have an integer primary key (think auto_increment) and use in() So if you want 10 random rows in your app generate 20 or so random numbers

Re: Maximum number of user variables

It sounds like you should be doing the link preservation and number update part in php or perl. Neculai Macarie wrote: Not that I'm aware of. What type of conversions are you doing that you need 30,000 use vars? An easy solution would be to try it and find out :) I need to move

Re: Very UIrgent....How can i start with mysql in c language?

- Yahoo! Mail Stay connected, organized, and protected. Take the tour -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Maximum number of user variables

Not that I'm aware of. What type of conversions are you doing that you need 30,000 use vars? An easy solution would be to try it and find out :) -Eric Neculai Macarie wrote: Hi! What is the maximum number of user variables that I can have in MySQL ? (I need to transfer a application from one

Re: Dates after version upgrade

The default timestamp display format changed between mysql 4.0 and 4.1 The easy fix is to add + 0 to all timestamp fields in selects. Like this: select my_ts + 0 from t; You should always read the upgrade notes in the manual. This is very well documented:

Re: Union Performance Question

Use one big table. A merge table will run the same query over all 10 tables. The key buffer is filled from the top down so if you have a key buffer that looks like this: a / \ /\ b c / \/ \ de fg

Re: missing library

you need to install your distro's ncurses and ncurses-devel packages. -Eric ganesan malairaja wrote: ok i found the source file .. tarball mysql-4.1.11.tar.gz after executing the ./configure command i does some checking the it gives this error checking for termcap functions library ... configure :

  1   2   >