Re: udf configuration resources

UDF able to refer back 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:/

Re: Who's locking ?

somebody try to explain, how I can 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

nt that virus or other 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: InnoDB Crash RECOVERY HELP (Urgent)

I add skip-innodb 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. http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";> Get Firefox!

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: 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: 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` v

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, ci

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

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 0

Re: Optimizing query "WHERE date>0"

When you add that index are more than 30% of the rows in the table DateTimeNext>1126215680? 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 li

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 p

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: 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 processl

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 A

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

y, is there a way 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]

Re: key_buffer_size vs innodb_buffer_pool_size

> > > - > Yahoo! Photos > Got holiday prints? See all the ways to get quality prints 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 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 wrote: > Hi All, > > I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our server > machi

Re: MySQL Closing/Opening tables

es to a transaction log immediately, then trickle out the actual >  key block updates over time.  If you want to try out mysql 6.0, the maria >  engine is basically MyISAM with logging. > > -- >    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: flush-host problem

allow the server to reallocate those resources to handling the > commands for the live (and not idle) connections. > > For additional reasons for these errors, please peruse: > http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html > > Warmest regards, > > -- > Shawn Green, MySQL Senior 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Sun bought by Oracle

ely by replying to this message and deleting it and all > copies and backups thereof.  Thank you. > > > > -- > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: innodb_thread_concurrency at runtime in 4.1 ?

tion for me now .. i have to go with 4.1 > at this point .. > > > A.Alagarsamy > > > 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

Re: Question on replication terminology

>> someone please tell me if the following terms mean the same thing or, if >> not, what is the difference: >> >> master-master replication >> dual-master replication >> bidirectional replication >> >> TIA >> -BT >> >> > > > -

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

).  That should flush your OS cache.  The guaranteed > way would be to dismount then remount your filesystem, but that could be > difficult depending on how many other processes are using it.. > > -- >        Dan Nelson >        dnel...@allantgroup.com > > -- > MySQL Gene

Re: Why doesn't mySQL stop a query when the browser tab is closedL

stop. I'm >> > pretty sure you could >> > > create a "tired of waiting" button for the user, but I >> > haven't done it >> > > myself. >> > > >> > > Regards, >> > > >> > > Jerry Schwartz

Re: Fail to change MySQL data directory on ubuntu

think I have done everything needed to change MySQL data directory. >> >>    Why am I still getting this error?  Where can I start to look for >>    the causes? >> >>    Thanks. >> >>    Jia >> >>    -- >>    MySQL General Mailing List >&

Re: Is myisam_repair_threads considered safe

her this setting is safe, and if so on > what major versions? > > -- > 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 &

Re: How to corrupt a database please???

r 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Recommended swap partition size

overcommit off. > > > > > > -- > 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Recommended swap partition size

010 at 12:13 PM, Rob Wultsch wrote: > On Sun, Apr 18, 2010 at 12:04 PM, Eric Bergen 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 proc

Re: Multiple table engine

ists.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?unsub=arch...@jab.org

Re: mysqld_safe

knows five or six more things > than someone who hasn't. >                -- Mark Twain > > -- > 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

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 wrote: > > > On Sun, Apr 18, 2010 at 9:04 PM, Eric Bergen wrote: >> >> Usually I prefer to have linux kill processes rather than ex

Re: Slow ALTER TABLE on 70M row InnoDB table

> Check the data before creating the indexes to make sure the same number of >> rows have been copied over and the data is in the correct columns. >> >> >> >>> # Add back indices in one command (for max speed) >>> >>> ALTER TABLE the_table_clone \ >>>  ADD INDEX IX_the_table_on_col2_col3 (col2,col3),\ >>>  ADD INDEX IX_the_table_on_col4_col6 (col4,col6),\ >>>  ADD INDEX IX_the_table_on_col5_col2 (col5,col2),\ >>>  MODIFY id INT SIGNED AUTO_INCREMENT,\ >>>  ADD PRIMARY KEY(col1); >> >> Correct. >> >> Mike >> >> >> > > -- > 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysqldumpslow

://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?unsub=arch...@jab.org

Re: export result from select statement

27;; > Though, it doesn't work?!? > > 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.co

Re: Innodb table space questions

e. > 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 -- MyS

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 wrote: > I have a table which contains a username column which may be constructed > something like >

Re: InnoDB and rsync

t > in this email, the company cannot accept responsibility for any loss or > damage arising from the use of this email or attachments. > This disclaimer was added by Policy Patrol: http://www.policypatrol.com/ > > -- > MySQL General Mailing List > For list archives: http://list

Re: Restore only one database or one table

ll probably compress that a factor 10 or better. Simply use bzcat to > pipe the file back into the MySQL client to restore. > > > > > That's pretty nice & What I am expected to hear. > > I will let u know after some practical implementation. > > Thanks &

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

> hours.   You can reset the timeouts interactivly by entering at the >>> > mysql prompt: >>> > >>> > set global wait_timeout= >>> > >>> > You can do the same for the interactive_timeout. >>> > >>> > Setting these

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

m's reliability and robustness?  Do the tools > help to deal with fail over? > > W. > > -- > Wes Modes > Systems Designer, Developer, and Administrator > University Library ITS > University of California, Santa Cruz > > > -- > MySQL General Mailing List &

Re: Can I measure the use of index?

be:http://lists.mysql.com/mysql >> >> > > > -- > Senior MySQL Developer @ Taobao.com > > Mobile Phone: +86 18658156856 (Hangzhou) > Gtalk: penglixun(at)gmail.com > Twitter: http://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: get a partial dump

Of course I could build the > statements 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:h

Re: Why configuration directives are all case sensitive?

e to figure > it out. Maybe simply because all the other servers I used like PostgreSQL, > httpd, etc are case insensitive. That's the whole story, and that's why I > ask on the forum, being curious about the reason. > > It's fine that you told me it's simply beca

Re: Why configuration directives are all case sensitive?

lain about the directives in the configuration file? > > Thanks a lot! > > Happy Thanksgiving!! > Tianyin > > > > On Fri, Nov 23, 2012 at 4:20 PM, Eric Bergen wrote: >> >> Anger and OS religious arguments the real answer is that is just how >> the option par

Re: Covering Index without the data file (myisam)

to also store >> a MYD file > > simple answer: 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: Which test suites are valid for --extern option in mysql-test-run?

ow which test suites in "t" directory are valid for > --extern option? Without knowing this, I cannot judge whether a test fails > is because it's not supported or "real" problems. > > Thanks a lot! > Tianyin > > -- > Tianyin XU, > http://csew

Re: NOW() is stuck...

estarting the MySQL engine? I'm willing to do that, >> but would much >> rather wait and not do it in the middle of the day. >> >> Thanks, >> Andy >> >> > > > -- > 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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: NOW() is stuck...

al Mailing List >>>>> For list archives: http://lists.mysql.com/mysql >>>>> To unsubscribe:http://lists.mysql.com/mysql >>>>> >>>> >>>> >>>> >>>> >>>> Notice: This communication may contain privileged and/or confidential >>>> information. If you are not the intended recipient, please notify the >>>> sender by email, and immediately delete the message and any attachments >>>> without copying or disclosing them. LBI may, for any reason, intercept, >>>> access, use, and disclose any information that is communicated by or >>>> through, or which is stored on, its networks, applications, services, >>>> and devices. >>>> >>> >>> -- >>> Andy Wallace >>> iHOUSEweb, Inc. >>> awall...@ihouseweb.com >>> (866) 645-7700 ext 219 >>> -- >>> "Sometimes it pays 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 >>> >> >> >> >> >> Notice: This communication may contain privileged and/or confidential >> information. If you are not the intended recipient, please notify the sender >> by email, and immediately delete the message and any attachments without >> copying or disclosing them. LBI may, for any reason, intercept, access, use, >> and disclose any information that is communicated by or through, or which is >> stored on, its networks, applications, services, and devices. >> > > -- > Andy Wallace > iHOUSEweb, Inc. > awall...@ihouseweb.com > (866) 645-7700 ext 219 > -- > "Sometimes it pays 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://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

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, > > > > w

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, >

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 time

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 paramete

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 inno

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 doe

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 sc

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

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 go

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 with

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 MyS

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

Re: Help understanding the whole password issue

gt; 3. For remote access if I setup % in the host as I have done in the past > that should allow me to login both remotely & to localhost right? > ( again this works perfectly on my older box) > > > Hope this makes sense. > > Thanks, > > Joey > > > > -- MySQL G

Re: Sequence ID generation transaction-safe?

be: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://lists.mysql.com/[EMAIL PROTECTED]

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

the same X lock? Any comment will be welcomed? Best regards, Leo Huang -- 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 Gener

Re: bug

d http://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/my

Re: max mysql under windows

nk you. -- 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: INSERT IGNORE BUG?

TECTED] -- 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: speedup mysql restore

: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com

Re: Limitation of DRBD For MySQL

ng that requires 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

Re: slave backups & master data

ump of a replication slave and have that dumpfile contain the master data for the master 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] ht

Re: hang up mysql shell

für clevere Doppel-Sparer, nur 39,85 € inkl. DSL- und ISDN-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.prove

Re: MySQL Ends Enterprise Server Source Tarballs

rom=rss> > &from=rss > > <http://www.linux.com/feature/118489> > http://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

a real date available for an official > 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: "show table status" extremely slow

advance. > > Regards, > Zhe > > -- > 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.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Two versions of MySQL on same machine

details above and > > > > then > > > >>delete this e-mail. > >>Please note that e-mail may be susceptible to data corruption, > >>interception > >>and unauthorised amendment. Alchemetrics does not accept any > > > > liability > > > >>for > >>any such corruption, interception, amendment or the conseq

Re: queries slower on InnoDB

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

Re: Empty 'Relay_Master_Log_File'?

ve got a copy of the > replicated DB + master.info from an existing slave. > > Thanks, > > Atle > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Eric

Re: Empty 'Relay_Master_Log_File'?

4 Feb 2005 15:55:49 -0800 (PST), Atle Veka <[EMAIL PROTECTED]> wrote: > > On Mon, 14 Feb 2005, Eric Bergen wrote: > > > Did you copy the relay-log.info and relay logs from the seed slave? > > > > Relay_Master_Log_file is line 3 in the relay-log.info file. This file

Re: queries slower on InnoDB

14 Feb 2005 15:52:21 -0600, Eric Bergen <[EMAIL PROTECTED]> wrote: > > Total row count is cached in the header for MyISAM tables. InnoDB has > > no such mechanism for this because transactions make it impossible to > > keep an exact row count. In order for InnoDB to get

Re: Configuring two mysql servers on one linux server

List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- 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: Difficulty starting mysql

ld > > ./usr/libexec/mysqld > > ./usr/local/libexec/mysqld > > ./home/webcollab/mysql-4.1.10/sql/mysqld > > > > What do I need to do to make it start properly? Thanks in advance! > > > > Kelly S. Brace > > Information Technology Exchange Center > &

Re: Speed of Inserts into MyIsam tables from mysqlbinlog

MyIsam table as the bin_logs are played back on > the system? This is also used to help gauge performance, so this method > of inserting data is important to the process as a whole. > > Regards, > > Thomas. > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net

Re: Exporting Data via Command Line

> > > > > > Thanks > > > > Try reading up on these commands: > > (from a command shell prompt) mysqldump > http://dev.mysql.com/doc/mysql/en/mysqldump.html > > (from within a MySQL client) SELECT ... INTO OUTFILE > http://dev.mysql.com/doc/mysql/en/select.h

Re: Join Limits

-mail. > Please note that e-mail may be susceptible to data corruption, interception > and unauthorised amendment. Alchemetrics does not accept any liability for > any such corruption, interception, amendment or the consequences thereof. > **

Re: Sum() unequal number of rows

ble structures (SHOW CREATE TABLE xxx\G) and your > sample data (SELECT * FROM xxx;), then show us what you think your queries > SHOULD have given you (your expected results) and we can start to help. > The xxx in the sample commands was just a placeholder for the actual table > name

Re: database pooling problem

dozens, > > you know...), HOW you initialize your pool (again many methods > > available), HOW you take and return connections from your pool > > (ditto), and which languages are in use in this entire process > > (again dozens of options). Just telling us that you use a web

Re: php - mysql connection

ost", "test", "test"))){ > echo mysql_error() . "\n"; > exit(); > } > > It will give you a more descriptive error if there is one > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql >

Re: Replication only DB

; > > > > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 3/11/2005 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > T

Re: Adding fields to db table (primary key and other type)

r fields at the moment. How can I add more fields? I want to > add a primary key column which autoincrements, how can I do that? Thanks a > lot > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Wait for data to change

communicate a > change in data than a "passive detect" like you are doing? How much > control do you have over what can and cannot change your data > (specifically the field you keep polling)? What other application-based > options are open to you? > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > -- 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: Help restoring

50418 > > I'm getting > ERROR at line 84: > > Line 84 is all garbled text... > > Working with 3.23.58 ... Any thoughts? > > -- > Patrick Campbell > OurVacationStore.com > Website Administrator > Tel. 602.896.4729 > > -- Eric Bergen [EMA

Re: Mysqladmin bug

and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of comp

Re: mysql import or write my own Perl parser

into a hash? > > Also, if I decide to use mysqlimport is there anything I should watch out for? > > thanks! > > > ----- > Post your free ad now! Yahoo! Canada Personals > > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.ne

Re: optimal number of connections?

hot topic, I'm wondering if we're missing out > somehow. > > Thanks > > Jeff > -- 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: Warning (reformulated)

; GAT/O/CM d- s:+ a- C UL P+ L+++ E--- W+++ N++ o+ K w--- O+++ M- V > PS+ PE++ Y+ PGP+++ t+ 5-- X R !tv b DI+++ D++ G e-- h+ r--- y+ > -- ---END GEEK CODE BLOCK-- > > Check out these few php utilities that I released > under the GPL2 and that are meant for use with a > php cli binary: > > http://www.vlaamse-kern.com/sas/ > -- > > -- > > > -- 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: 4==4something: equal vs identical

number > and a numeric comparison is done. '4aef' converts to 4. > > I suppose you could convert the integer to string instead: > > WHERE CONCAT(`id`) = "4aef" > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL

  1   2   >