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: 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: Are There Slow Queries that Don't Show in the Slow Query Logs?

> -Original Message- > From: Vikas Shukla [mailto:myfriendvi...@gmail.com] > Sent: Thursday, May 30, 2013 7:19 PM > To: Robinson, Eric; mysql@lists.mysql.com > Subject: RE: Are There Slow Queries that Don't Show in the > Slow Query Logs? > > Hi, > >

RE: [>Suspected Spam<][Characteristics] Re: NET START MYSQL QUESTION?

> why not answer the question another user made hours ago? > under which account do you try to start mysqld? > Agreed. Chances are good that if he goes into the Windows Services control panel and gets the properties of the mysql service, he will find that it is configured to start under a Windo

RE: [>Suspected Spam<][Characteristics] RE: Slow Response -- What Does This Sound Like to You?

uery_cache_size=64M max_allowed_packet = 1M sort_buffer_size = 512K read_buffer_size = 512K myisam_sort_buffer_size = 128M thread_cache_size=40 max_connections=500 max_tmp_tables=32 lower_case_table_names=1 #-turn on query logging #log=/ha01_mysql/site150/mysql/query.log log_slow_queries=/ha01_mysql

RE: Slow Response -- What Does This Sound Like to You?

> -Original Message- > From: Wm Mussatto [mailto:mussa...@csz.com] > Sent: Thursday, May 09, 2013 3:50 PM > To: Robinson, Eric > Cc: Rick James; mysql@lists.mysql.com > Subject: RE: Slow Response -- What Does This Sound Like to You? > > On Thu, May 9, 2013 15:

RE: Slow Response -- What Does This Sound Like to You?

> > > -Original Message- > > From: Robinson, Eric [mailto:eric.robin...@psmnv.com] > > Sent: Thursday, May 09, 2013 1:58 PM > > To: mysql@lists.mysql.com > > Subject: Slow Response -- What Does This Sound Like to You? > > > > We have a s

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: 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: Why configuration directives are all case sensitive?

options so things passed on the command line are at the end and override options in the config file. On Fri, Nov 23, 2012 at 10:08 PM, Tianyin Xu wrote: > Dear Eric, > > Thanks a lot for the explanation of argument directives! The concerns are > very considerate. > > Actually

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

Managing ODBC on Linux? What Happened to myodbc3i?

on Linux? -- Eric Robinson Disclaimer - April 17, 2012 This email and any files transmitted with it are confidential and intended solely for mysql@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions

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: 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: 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: InnoDB and rsync

rs ago. I'm not sure what has been implemented since then. The list thread is here: http://lists.mysql.com/internals/35527 -Eric On Fri, Jan 28, 2011 at 1:59 PM, Robinson, Eric wrote: >> * flush atbles >> * rsync while mysqld is running >> * stop mysqld >> * second

RE: InnoDB and rsync

> * flush atbles > * rsync while mysqld is running > * stop mysqld > * second rsync > Unless we can verify 100% that there is a safe way to do it without shutting down MySQL, then I'm sure the approach you described above is the one we will end up with. Thanks for your inpu

RE: InnoDB and rsync

an be used to stop only salves > for a short time and you are acting like a child "mama i will > do what i said the whole time" Our current model has been working well since 2006. We will be careful to verify the reliability of any proposed changes. Have a great day! -- Eric

RE: InnoDB and rsync

le exception of the vendor. I > would not hesitate to trust them with my data. > I will definitely look at it again. Thanks. --Eric Disclaimer - January 28, 2011 This email and any files transmitted with it are confidential and intended solely for Michael Dykman,mysql@lists.mysql.com,Shawn G

RE: InnoDB and rsync

ackground threads per Shawn's message above? -- Eric Robinson Disclaimer - January 28, 2011 This email and any files transmitted with it are confidential and intended solely for mysql@lists.mysql.com,Shawn Green (MySQL). If you are not the named addressee you should not disseminate, di

RE: InnoDB and rsync

safe (according to them) to copy the files from a running instance of MySQL. Call me persistent (or just annoyingly thick-headed) but I am not fully satisfied their explanations. --Eric Disclaimer - January 26, 2011 This email and any files transmitted with it are confidential and i

RE: InnoDB and rsync

're talkin. I'll check it out. > > I read that section but it is not at all clear (1) how one quiesces the InnoDB background threads, or (2) if there is a way to keep them quiesced while the backup is in progress. Disclaimer - January 25, 2011 This email and any files transmitted

RE: InnoDB and rsync

> > I'm starting to worry that you may be right. I know FLUSH > TABLES WITH > > READ LOCK does not work as expected with InnoDB, but is > there really > > no way to put InnoDB into a state where all changes have > been flushed > > to disk and it is safe to rsync the directory? Is stopping >

RE: InnoDB and rsync

> On 1/25/2011 10:45, Robinson, Eric wrote: > >>> There is a very good reason: it is the phenomenon of row > drift. The > >>> master and slave can appear to be in good sync, but often > it is not > >>> actually the case. > >> > >&g

RE: InnoDB and rsync

customer's database right in the middle of a production day and the other customers won't even notice! It has been great being able to do all these things. > outside mysql would ever think of backup a running db-server > Then you're just not Googling very well. :-) --Er

RE: InnoDB and rsync

> 240 mysql-servers? > why there is no consolidation? I said 240+ mysql *instances*, not servers. It's actually just 3 physical servers (not counting standby cluster nodes). > > just need a way to make the same thing work with InnoDB. > > this is simply impossible That is very unfortunate. Di

RE: InnoDB and rsync

x27;ve said so far, I still prefer my solution. I just need a way to make the same thing work with InnoDB. -- Eric Robinson Disclaimer - January 25, 2011 This email and any files transmitted with it are confidential and intended solely for Reindl Harald,mysql@lists.mysql.com. If you are not the

RE: InnoDB and rsync

> > There is a very good reason: it is the phenomenon of row drift. The > > master and slave can appear to be in good sync, but often it is not > > actually the case. > > ... sounds interesting; have you got any document explaining > this phenomenon? AFAIK, the things that (silently) break > r

RE: InnoDB and rsync

e. Warnings about data corruption and whatnot. I'll check it out again. (I was actually looking for it this morning but could not remember the name, so thanks for the reminder.) -- Eric Robinson Disclaimer - January 25, 2011 This email and any files transmitted with it are confidential and inte

RE: InnoDB and rsync

d it is safe to rsync the directory? Is stopping the service really the only way? (And even if I stop the service, is rsync totally safe with InnoDB?) -- Eric Robinson Disclaimer - January 25, 2011 This email and any files transmitted with it are confidential and intended solely for Reindl Haral

InnoDB and rsync

es to our infrastructure. Any help will be GREATLY appreciated. -- Eric Robinson Disclaimer - January 24, 2011 This email and any files transmitted with it are confidential and intended solely for mysql@lists.mysql.com. If you are not the named addressee you should not disseminate, distri

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

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: 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: 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: dynamic alias?

s context -- it didn't occur to me that it'd be relevant.) Thanks, Eric -Original Message- From: Peter Brawley [mailto:peter.braw...@earthlink.net] Sent: Friday, August 27, 2010 12:57 PM To: mysql@lists.mysql.com Subject: Re: dynamic alias? On 8/27/2010 11:16 AM, Eric Bloomquist

dynamic alias?

t; instead includes whatever tomorrow's date is when the query is run. Is it possible to do something like this in a MySQL query? Thanks, Eric -- 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

> 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: 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: 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: 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: 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: 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: 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: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

he exact circumstances under which I should be concerned about triggering them would have increased my comfort level. > I think Maatkit is by far the best solution for live master-slave sync > in most real-world situations. We'll give it another look. -- Eric Robinson Disclaimer - Decem

RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

latively painlessly. I've thought of using snapshots. Offhand, can't remember the reason that I decided they would not work for us. It'll come to me... -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it are confidential and intended solely

RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

able copy of the data.) > There are ways to resync data that don't involve all > this as well: Maatkit has some tools I've looked with great interest at Maatkit, but their tools are replete with warnings about dangers, bugs, and crashes. They certainly do not inspire confiden

RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

sql on this, but it sounds like I can just do 'flush tables with read lock;reset master;' on the master and 'change master to...;' on the slave. So cool. Thanks for the input! -- Eric Robinson Disclaimer - December 4, 2009 This email and any files transmitted with it

Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

es. We had once case where the slave SQL thread did not want to restart afterwards and we had to do the whole thing again, only we stopped the master the second time. Not yet sure what that was all about, but I think it may have been a race issue of some kind. We're still exploring it. Anyw

RE: Rename Database - Why Would This Not Work?

ervice mysql stop mv olddb newdb service mysql start mysqlcheck -o newdb -- Eric Robinson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Rename Database - Why Would This Not Work?

edures because this is MySQL 4.1.22.) --Eric

Rename Database - Why Would This Not Work?

ause when I Google it, I see people talking about lots of different ways to do a database rename, and people are making it sound like a complicated, dangerous procedure. Why would my simple approach not work? Should I be watching for potential problems down the road because I did it this way? -- Er

Re: Distinct max() and separate unique value

On Tue, 20 Oct 2009, DaWiz wrote: I would try: select max(object_id), term_taxonomy_id group by term_taxonomy_id order by term_taxonomy_id; max(column) returns a single value so distinct is not needed. The group by and order by should only have columns thaqt are displayed and that are not agg

Distinct max() and separate unique value

I'm trying to formulate a query on a Wordpress database that will give me the highest 'object_id' with the highest 'term_taxonomy_id', something like: +-+--+ | max(distinct object_id) | term_taxonomy_id | +-+--+ |

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: 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: 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: 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: Question on replication terminology

n if you handle the failover correctly. -Eric On Tue, Apr 28, 2009 at 3:43 PM, Claudio Nanni wrote: > Hi there, > I would only like to stress that the only supported (and recommended) > replication solution in MySQL is > Master--->Slave  replication. > In this scenario you ca

Re: innodb_thread_concurrency at runtime in 4.1 ?

Hi, I checked the 4.1.24 source and I don't see innodb_thread_concurrency in the list of variables that can be set at runtime. I only see: innodb_max_dirty_pages_pct, innodb_max_purge_lag, innodb_table_locks, innodb_max_purge_lag, innodb_autoextend_increment, -Eric On Sun, Apr 26, 2009

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: flush-host problem

You can set max_connect_errors=9 to "disable" the host blocking. It's common to do this with load balancers because tcp/ip health checks count as connection errors. -Eric On Sat, Apr 11, 2009 at 1:01 PM, Shawn Green wrote: > > Hello Gary, > > Gary Smith wrote

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

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. >>Whe

RE: Question about Averaging IF() function results

Hello Peter, Thanks for your suggestion, I think I have found another way to get the average that I need. If the formula I have come up with does not work I will try your formula. Thank you Eric H. Lommatsch Programmer 360 Business 2087 South Grant Street Denver, CO 80210 Tel 303-777

Question about Averaging IF() function results

6.000 | 6.000 |6.000 | 6.000 I tried using the if function without a false answer and I am getting a syntax error when I do this. If it is possible for me to get this correct result in MySQL, can someone provide me with the correct query syntax to get these r

"Copying" tables between databases

night via cron and feeding it back into Bar via cron. Is there a way to set up real-time "replication" of that table? -- WANT TO MODEL FOR MAC & BUMBLE? APPLY AT http://casting.macandbumble.com - Eric And

Re: Speed up slow SQL statement.

f the reason it's slowing down. Any ideas how I can optimize this? Eric On Sep 26, 2008, at 11:47 AM, Martin Gainty wrote: Hi Eric- the immediate challenge is to fic the join statement so make sure products.id is indexed make sure browse_nodes_to_produ

Speed up slow SQL statement.

What I'm trying to accomplish with this is to get an ordered list of unique products found under a category. Any ideas on how I could speed this up? Thanks in advance, Eric Stewart [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Lock Issue

Hello, I'm having issues where once every 24-36 hours a replication slave locks up and I have to kill -9 the process and restart it. I'm using mysql 5.1.26 and centos 5 (kernel 2.6.18-92.el5) but it's been occurring since I simultaneously upgraded to 5x and started using the slave in production (i

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&

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

n use worker threads with their own descriptors or like the heap engine use none at all. it's possible to have many more open tables than file descriptors. -Eric On Mon, Jun 2, 2008 at 9:54 AM, Jean-Paul Bauer <[EMAIL PROTECTED]> wrote: > Hi all, > I'm a bit confused about the al

Re: Looking for a Mysql Guru/DBA

ant to talk to someone about getting the right schema in place, however. Kevin [1] http://www.sqlite.org/ Hey Kevin, One thought on that, there are a lot of existing WAMP installs out there. :) But overall I think you are probably right. This might be worth a look http://www.freebyte.

Re: very simple but slow query

Don't use cross joins. Just do some googling as to why. Thanks, Eric Ananda Kumar wrote: in mysql sub queries dont perform well. You can could try this SELECT a.ID FROM ven_tes a, ven_tes b where a.id=b.id and b.id_ven=6573 . On 5/20/08, Wakan <[EMAIL PROTECTED]> wro

Re: Query execution time - MySQL

---+---+ | Status | Duration | ++---+ | (initialization) | 0.192 | | checking query cache for query | 0.42 | | Opening tables | 0.24 | | System lock| 0.0

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

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: Does version 4 mysqlcheck close MyISAM tables left open?

doesn't get decremented. A mysqlcheck (repair table query) will reset the counter. -Eric On Tue, Apr 15, 2008 at 1:12 PM, Garris, Nicole <[EMAIL PROTECTED]> wrote: > Unable to find this in the manual ... > > Yesterday morning we rebooted the server by accident, which crashed an

Re: problems w/ Replication over the Internet

caused by a corrupt table but more often by restarting replication from an incorrect binlog location. Try recloning the slave and starting replication again through stunnel. -Eric On Tue, Apr 15, 2008 at 1:11 AM, Jan Kirchhoff <[EMAIL PROTECTED]> wrote: > I have a setup with a master an

Re: History of changed rows

C K wrote: Hi all. How can we manage the history of changed rows in the database. I have some idea but not yet implemented. By using triggers to make a copy of the row being changed to the another table in the same db. Is there any way to only save the changed fields data and field name? Any othe

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

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

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 <[E

RE: Performance problem - MySQL at 99.9% CPU

-Original Message- From: Per Jessen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 02, 2008 7:51 AM To: mysql@lists.mysql.com Subject: Re: Performance problem - MySQL at 99.9% CPU Gunnar R. wrote: > I am thinking about buying a new dual core box (with IDE disks?), but > I have to ma

Cross database joins

I actually opens another connection or not. I saw one mention of a worry about that, but as I understand it, you can refer to any table in any database from any mysql connection that has permission to access that DB and table, so you should be able to access any DB from any initial connection. Tha

RE: Unusual sort

Hi, One thought, it might a good idea to make a trigger/procedure that inserts the seprate index field, so you can forget about it from here on. -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Saturday, November 24, 2007 11:18 AM To: Jim; mysql@lists.mysql.com Su

Re: Giant database vs unlimited databases

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

Re: Giant database vs unlimited databases

Mohammad wrk wrote: Hi Eric, In the case of a "yes" answer to the second question below, can't we still use something like VPD (Virtual Private Database) in MySQL? Thanks, Mohammad Hi, I don't know much about Oracle, but I looked this up. MySQL can't do it,

Re: Giant database vs unlimited databases

to, or expect for any of these things to happen, you will just be creating headaches for yourself. Backup, replication, and the need for cross DB queries, will all be a pain in comparison to a single DB. I am sure there is more to consider, but these are the points that come to my mind ri

Re: Replication and AUTO_INCREMENT; is it safe?

On 10/24/07, Eric Frazier <[EMAIL PROTECTED]> wrote: js wrote: Hi list, Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me wonder how is it possible to replicate AUTO_INCREMENTed value to slaves. According to the doc, "If you specify an AUTO_INCREMENT column fo

Re: Saving space disk (innodb)

. http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html So the only other question is what is the cost if any? It is a good idea because often there are just a few tables that get really big and this is a nice way to deal with them separately like you would with MyISAM. Eric On 10/10

Re: Saving space disk (innodb)

ce in the clustered index" But that just means he has empty space in his tablespace :) At least that is how I read it, so Baron's suggestion makes the most sense. Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DB Schema Comparison Utility ?

I found this yesterday: http://sourceforge.net/projects/mysqltoolkit I think the guy has done a lot of really good work. Thanks, Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Slave Bin Log Question

Boyd Hemphill wrote: I have executed a strategy for backup where I stop a slave and do a mysqldump with --master-data. Both master and slave are 4.1.20 My assumption was that the log coordinates in the dump file would provide me with the place to replay the log for a point in time recovery.

  1   2   3   4   5   6   7   8   9   >