Re: How to loop a query that is only able to handle 1 ROW at a time?

Hi Incarus, You don't need a loop just a correlated subquery on the update: UPDATE TB1 SET Ivet=PREG_REPLACE('/TeXT/', '', Ivet); Example: mysql> CREATE TABLE blah(value INTEGER, square INTEGER); Query OK, 0 rows affected (0.17 sec) mysql> INSERT INTO blah(value) VALUES (1),(2),(3),(4),(5); Q

Re: 'myisam_use_mmap' unstable like hell

11124  8:20:19 [Note] Event Scheduler: Loaded 0 events > 24  8:20:19 [Note] /usr/libexec/mysqld: ready for connections. > Version: '5.5.18-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306   > thelounge.net build > 24  8:20:19 [ERROR] /usr/libexec/mysqld: Table './afi/cms1_global_cache' > is marked as crashed and should be > repaired > 24  8:20:19 [Warning] Checking table:   './afi/cms1_global_cache' > 24  8:20:19 [ERROR] Got an error from unknown thread, > /home/builduser/rpmbuild/BUILD/mysql-5.5.18/storage/myisam/ha_myisam.cc:870 > > > > -- > > Mit besten Grüßen, Reindl Harald > the lounge interactive design GmbH > A-1060 Vienna, Hofmühlgasse 17 > CTO / software-development / cms-solutions > p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 > icq: 154546673, http://www.thelounge.net/ > > http://www.thelounge.net/signature.asc.what.htm > -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Cleaning up old files

nce I had a 40GB partition fill up over the weekend which resulted in bringing down our web server. So what are those files and can I delete all but the most recent? Thanks. Rob Tanner UNIX Services Manager Linfield College, McMinnville Oregon

Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

> Hm. > > It seems we have sort of ethernet segment saturation problem. A possible bandaid/quick fix is turning on compression for mysql replication. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Using Excel to query the database

anyone have any sample Excel .iqy files for MySQL access that they would be willing to share (with passwords removed, of course)? Thanks. Rob Tanner UNIX Services Manager Linfield College, McMinnville Oregon ITS will never ask you for your password. Please don’t share yours with anyone! [cid

Re: MySQL HA on cloud

. I strongly suggest not attempting this project. -- 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=arch...@jab.org

Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'

r says the > social network's predicament is all too common among web startups that start > small and grow to epic proportions." > Preface: I in no way speak for my employer. I suggest reading http://dom.as/2011/07/08/stonebraker-trapped/ -- Rob Wultsch wult...@gmail.co

Re: FW: [USN-1017-1] MySQL vulnerabilities

http://lists.mysql.com/ >> > On May 21 they sent out an email about MySQL Server 5.0.91 being released. I for one read release notes for each point release and had a *very* busy night. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: mysql is crashing

anks for the tip. It is a 64 bit executable so 5gb should be OK. It is >> running on a x86_64 SLES 10.3 server. >> > > Then your mysql server should also be 64 bit. Please Check. > > >> >> >> -- >> Yectli >> > Try using the file command: #

Re: mysql cluster with 3 db/data and 2 mgm nodes

ot be useful. You may want to buy another box so that do 2 replicas with 2 shards, OR just use the third node as a warm standby. -- 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=arch...@jab.org

Re: There is something wrong with bugs.mysql.com email server I think (another one)

On Sat, Aug 7, 2010 at 11:47 AM, Baron Schwartz wrote: > I consider this a bug in the bug tracking system :-) Severity: S4 (Feature request) -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Re: mysql and oom-killer

2010/8/5 Rob Wultsch : > 2010/8/5 Евгений Килимчук : >> When OOM-killer kill mysqld, I had a critical corrupted tables. My database >> is a very big. I think Apache with cgi-scripts not critical process in this >> story. And sshd is a real true. >> > > OOM is con

Re: mysql and oom-killer

elected by OOM to be killed. -- 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=arch...@jab.org

Re: Possible tricks to ALTER on huge tables?

ering using it on prod. There are some well known use cases (adding enums values, enlarging varchar columns) where altering a .frm is useful, but it should always be considered very dangerous. You could of course consider using PostgreSQL which would only need a very brief exclusive lock for adding a default null column... -- 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=arch...@jab.org

Re: Automate Install/Configuration of MySQL on Linux

tion well then Puppet or cfengine would be the way to go. As for the basic tasks that you describe, have you considered modifying the rpm/deb/whatever to distribute a data dir with whatever you want? In addition, do you really need expect? Could you get the same effect with good use of the sleep command inside bash? -- 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=arch...@jab.org

Re: migration via replication for large DB?

h is faster: dump and load or replication over the > Internet? > > Thanks for your time. > There may be significantly better options available to you. What version are you coming from and what version are you to? What engines do you use (Innodb, MyISAM,etc)? Is the data directo

Re: MMM Mysql

e using MMM. Alternatives include Linux-HA (aka heartbeat) often combined with DRBD and MySQL cluster. For the general case MMM is probably the best option. -- Rob Wultsch wult...@gmail.com

Re: Myisam advantages

No consistency. 3. Horrible isolation 4. Durable on good days. In short it can easily eat your data. If you love your data and treat it well it will love you back. There are very few valid uses for MyISAM (full text and spatial are not valid, use sphinx and PostGIS respectively) -- Rob Wultsch

Re: mysql 5.5.3 and innodb from source.

> what I'm doing wrong? Please advice. > Thanks. > Assuming that you actually built the innodb plugin (I have no experience building 5.5) the you should probably look at what you need to add to the cnf in order to use the plugin. http://www.innodb.com/doc/innodb_plugin-1.0/innodb-plugin-installation.html This is only a guess. -- 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=arch...@jab.org

Re: How to become a DBA on MySQL

trying to help people on #mysql most people will have enough knowledge that I would suggest hiring them as either junior or full DBA. In addition it is easy to make contacts that can become employment opportunities. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives

Re: Why is MySQL always linked to Php?

se of it. Both seem like they are designed for quick productivity. It seems like PostgreSQL has significant mindshare amongst Perl and C++ users... -- 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=arch...@jab.org

Re: query executes very slow in a table with 2m records

able. > > Mike > > A compound index index will not be used after the first range condition. I agree about using a single datatype (datetime or timestamp) and partitioning not being a good idea for only 2M rows. -- 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=arch...@jab.org

Re: How to become a DBA on MySQL

depends on the company. Some DBA's are glorified sys admins, some are mostly db developers and there is everything in between. I do work that would be normal for a front end developer, I also sometimes have to go digging into the C+ guts MySQL and I also deal with lots non-technical issues. I

Re: Slow disk access: 1.4m to do a select count over 23GB table.

ve 32GB of ram XD plenty to > useit into something more useful A configuration file would be helpful here. > > Thanks. > My guess is that you have a innodb table and that you have unallocated innodb buffer pool. This is nothing more than a guess What is ram XD? -- Rob Wultsch w

Re: Connection Diagnostic Tool

mark. Is there a place on the net I can look up what > it does and how to run it? > > > > Thanks! I am pretty sure Michael that meant running the command line mysql client: mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"' -- Rob Wultsch wult.

Re: Got error 139 from storage engine (InnoDB)

On Mon, Jul 5, 2010 at 9:06 AM, Rob Wultsch wrote: > On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano > wrote: >> Hi All, >> >> I have received error message "ERROR 1030 (HY000) at line 167: Got error 139 >> from storage engine" when importing dump datab

Re: How to slim MySQL?

On Mon, Jul 5, 2010 at 10:07 AM, Nima Mohammadi wrote: > On Mon, Jul 5, 2010 at 8:26 PM, Rob Wultsch wrote: > >> >> Have you considered SQLite? >> >> You probably want to compile your own version of MySQL. You probably >> want to remove debugging symbols

Re: Got error 139 from storage engine (InnoDB)

a innodb tuning issue. Please post: 1. Any relevant entries in your error log file. 2. Your my.cnf. 3. You servers specs and whether the server also runs other daemons. -- 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=arch...@jab.org

Re: How to slim MySQL?

t to remove debugging symbols* (which have been present since the mid 5.0 series, iirc), and any engines/character sets/etc you don't need. *Alternatively you can run the strip command. -- 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=arch...@jab.org

Re: Updating 4 to 5

On Sat, Jul 3, 2010 at 4:00 AM, Grant Peel wrote: > - Original Message - From: "Rob Wultsch" > To: "Grant Peel" > Cc: > Sent: Friday, July 02, 2010 3:57 AM > Subject: Re: Updating 4 to 5 > > >> On Thu, Jul 1, 2010 at 5:44 PM, Grant Peel

Re: Mysql connections not released

nd not dns / hostnames. > > > > We can’t seem to find any errors thus the reason for truggling to pinpoint > the exact cause. > > > > Machiel Richards > > MySQL DBA > > Relational Database Consulting > > > > [image: RDC_Logo] > > > > *Fr

Re: Mysql connections not released

icked up immediately eventually causes an inability to access the database > to even kill processes, etc... > > > > > > So what I know now is that the problem is caused by a > connection / transaction not completing. However what I need to find out now > is w

Re: Updating 4 to 5

he changes. 2. mysqlupgrade runs REPAIR TABLE which acts differently in different versions of MySQL See http://www.mysqlperformanceblog.com/2010/05/14/mysql_upgrade-and-innodb-tables/. -- 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=arch...@jab.org

Re: Mysql connections not released

e: RDC_Logo] > > > My first guess would be a networking problem. If you run ifconfig repeatedly do you notice the number of errors increasing? It would be good to look at both the database server and the web server. Also, until you figure the issue out you should be able to mitigate it by setting the connect timeout to a more aggressive value. -- Rob Wultsch wult...@gmail.com

Re: Reserving threads for root user

worth note that the facebook patch set has a new variable "reserved_super_connections" which defaults to 10. It would be very useful to have this feature in mainline MySQL. -- 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=arch...@jab.org

Re: MySQL Upgrading

to run both versions of mysql (the 5.0.32 > and the 5.1.47)?    granted, this is not the debian mailing list, just > thought I would ask that last part ;) > > > Steven Staples > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/

Re: how to setup replication - MySQL 5.0.x - Migration and new databases

using the mysqlbinlog command on the log files or the SHOW EVENT (http://dev.mysql.com/doc/refman/5.1/en/show-events.html) syntax. -- 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=arch...@jab.org

Re: Temporary tables created on disk: 99%

be able to help you more. Also, you might want to consider creating a ram disk so that filesorts that must be done on disk might be done inexpensively. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: Anyone can help resolve this problem?

rmal working) extension, phpbb will > return error message like 'Access Denied for r...@localhost (using > password:NO), why display NO and why phpbb use root to connect to database? > > > THX. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For lis

Re: source backup.sql - troubleshoot

T". Note that the command output will be truncated if it is long at all. If you need to see the entire query run "SHOW FULL PROCESSLIST". Alternatively start up the mysql client with the --verbose flag. I don't recall in what version that became available. You will probably

Re: Security issues

On Mon, May 24, 2010 at 1:42 PM, Martin Gainty wrote: > Good Afternoon Rob- > > if you're implementing either glassfish or weblogic webserver > your "best fit solution" would be Oracle Identity Manager > > there are 'other' identity solutions such a

Re: Security issues

On Mon, May 24, 2010 at 12:07 PM, Jerry Schwartz wrote: >>-Original Message- >>From: Rob Wultsch [mailto:wult...@gmail.com] >>Sent: Saturday, May 22, 2010 11:52 AM >>To: Martin Gainty >>Cc: mysql@lists.mysql.com >>Subject: Re: Security issues >>

Re: Security issues

On Sat, May 22, 2010 at 5:44 AM, Martin Gainty wrote: > Good Morning Rob- > > one vulnerability (with UDFs) > http://dev.mysql.com/tech-resources/articles/security_alert.html > > a manager considering a enterprise-wide security solution may want > to consider Oracle I

Security issues

Given the rather serious recent bug fixes I have been thinking a good bit about security. Does MySQL AB/Sun/Oracle maintain a page similar to http://www.postgresql.org/support/security.html which lists security issues and what releases they effected? -- Rob Wultsch wult...@gmail.com -- MySQL

Re: Where to index - over 15m records and growing

py) gut thinks your best bet is a a composite index on the table IVAOData on the columns TrackerTime and FlightID. This will make all access to the table in this query hit a covering index. Fourth thing: What do you intend to ask the database with this query. This query smells overly broad. -

Re: capacity planning.

on.com/Art-Capacity-Planning-Scaling-Resources/dp/0596518579 will get you started. -- 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=arch...@jab.org

Re: 4- Question

a time I have found to be often ideal. > 4- InnoDB have a optimize table ? For re-index or something to make a > better performance http://tinyurl.com/32ysu4s I have lots of boxes and darn near never run optimize table on a innodb table. Exceptions are made for massive bloat when fil

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

nting unique >>> >> >>>> boundaries >>> >> >>>> i.e. rectangles and I want to search the table to find the >>> rectangle >>> >> >> that >>> >> >>>> bounds a specific point. >>> >>

Re: Join syntax problem

t; > > > __ Information from ESET Smart Security, version of virus signature > database 5063 (20100426) __ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > > -- > MySQL General Mailing List > For list archi

Re: Slow query, unknown why

luded in the results > or not. > Please post create table statements, show indexes and explain for any queries with which you want help. Please then post each of your attempted queries coupled with a written description of what you think you are asking the database for. -- Rob Wultsch wult...@

Re: MySQL Community Server 5.1.46 has been released

es, the name is now rewritten as Name_exp_pos, >       where pos is the position of the column. To avoid this >       conversion scheme, define explicit, valid names for view >       columns using the column_list clause of the CREATE VIEW >       statement. >       As part of this f

Re: Loading 4.1.12 dump to 5.0.18 server

stination to something 5.0.67 (min) or later. -- 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=arch...@jab.org

Re: better way to backup 50 Gig db?

u will be surprised how often you find them. -- 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=arch...@jab.org

Re: mysql-bin log file

On Mon, Apr 19, 2010 at 1:07 AM, Johan De Meersman wrote: > On Mon, Apr 19, 2010 at 6:48 AM, Rob Wultsch wrote: >> >> And if your slave's IO lags badly enough this will hose you. Further > > True, but if you remove logs that haven't been transferred, yet, you los

Re: mysql-bin log file

next bin-log swittch. > And if your slave's IO lags badly enough this will hose you. Further it might well come in handy to an arbitrary number of bin logs for pirt purposes. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: InnoDB Default Storage Engine

ore from backup or failover to a slave. The answer you probably want is http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html > why I am getting a message "*Error*: *No query specified*"  when I run a show > engines\g commands -version (5.0.45) Exactly what are you running?

Re: mysql-bin log file

.1/en/purge-master-logs.html -- 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=arch...@jab.org

Re: Recommended swap partition size

Note that innodb_flush_method can implact this... -- 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=arch...@jab.org

Re: How to corrupt a database please???

s. I would assume: 1. Possible, perhaps even probably hardware issues if there is Innodb corruptions. 2. A failover takes a set amount of time. Repairing corruptions will usually take longer, perhaps much much longer. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives

Re: How to corrupt a database please???

ut repairing a db. How the hell do you repair from not having data files? For that matter the recovery from lacking log files (and assuming a crashed state) is imho ugly as hell. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

Re: How to corrupt a database please???

my very best to keep MyISAM out of production. In my opinion MyISAM should be treated as something one step higher than the blackhole engine. Put data in and you might be able to pull it out later. (don't get me wrong, packed myisam has its place...) -- 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=arch...@jab.org

Re: InnoDB - 16GB Data

oblem? Anyways... here are some reactions: innodb_flush_log_at_trx_commit=0 ... THIS MEANS YOU CAN LOSE COMMITTED TRANSACTIONS. Read up on this. "innodb_flush_method=O_DSYNC" Any particular reason you aren't using O_DIRECT ? Read up on this. Why do you not have skip-name-resol

Re: upgrade from version 5.0.45

On Sun, Apr 4, 2010 at 9:29 PM, Walter Heck - OlinData.com wrote: > Depending on the "seriousness" of your environment you can read the > changelogs and upgrade if you don't see any showstoppers. I have > hardly ever seen any problems with minor version upgrades of mys

Re: upgrade from version 5.0.45

gy is 5.0.67. I suggest that this is worth the upgrade. In theory there are not significant differences between 5.0 versions after GA other that bug fixes. I *do not* trust this. -- 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=arch...@jab.org

Re: MySQLTuner

able and thread cache to sane levels. 4. Having well indexed and well written queries will probably help you far more than any server tunning. 5. How are you going to test any changes to configuration? -- 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=arch...@jab.org

Re: Mysql Certification exams

the guide. -- 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=arch...@jab.org

Re: Rename Database - Why Would This Not Work?

before moving files around. -- Rob Wultsch wult...@gmail.com

Re: Rename Database - Why Would This Not Work?

risks associated with my simple approach? > > (Also there are no stored procedures because this is MySQL 4.1.22.) > > --Eric > Within your specific circumstances what you suggest should be safe. -- Rob Wultsch wult...@gmail.com

Re: Rename Database - Why Would This Not Work?

; -- > Eric Robinson > Director of Information Technology > Physician Select Management, LLC > 775.885.2211 x 111 > > > -- Rob Wultsch wult...@gmail.com

Re: Optimizing my.cnf

Are you using innodb? etc... -- Rob Wultsch wult...@gmail.com

Re: Is myisam_repair_threads considered safe

ta-ever-myisamchk-parallel-recover/ > > On Thursday, September 10, 2009, Rob Wultsch wrote: > > myisam_repair_threads > > > > "If this value is greater than 1, MyISAM table indexes are created in > > parallel (each index in its own thread) during the Repair by s

Is myisam_repair_threads considered safe

ir_threads Can anyone comment about whether 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=arch...@jab.org

Re: Are equi-joins faster than left joins?

rt of the result then you must use left. -- 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=arch...@jab.org

Re: Replica questions

> -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:    http://lists.mysql.com/mysql?unsub=wult...@gmail.com > > -- Rob Wultsch wult...@gmail.com wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replica questions

ore. It is subject to removal in a future version of MySQL." #2. Replication info should be being recorded on the master.info in your data dir. -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysqlimport remote host problem

On Tue, Mar 10, 2009 at 7:16 PM, René Fournier wrote: > OK, I've managed to do the same thing with just the mysql command line > program: > >mysql -h 192.168.0.224 -u root -p alba2 < > /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql > > Works great. However, the sql file is normally gz

Re: WHERE vs. ON

n by rand! The on clause is just something evaluated for each row that if it returns an expression that evaluates to true will allow the row to be joined. -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: moving from 3.23.58 to 5.0.45

On Thu, Oct 30, 2008 at 5:16 AM, Obantec Support <[EMAIL PROTECTED]>wrote: > Hi > > are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45 > moving from a Fedora Core3 to Centos5.2 server. > > Mark > > http://www.justfuckinggoogleit.com/?q=my

Re: deleted user...lost access to appointment data

store2/ > > > > 3. /sbin/service mysqld stop > > > > 4. restored pbcs7 database files to the working mysql directory > > cp -a /var/lib/restore/var/lib/mysql/pbcs7/* /var/lib/mysql/pbcs7/ > > > > 5. /sbin/service mysqld start > > > > Any help would be great > > > > Michael > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim)

Re: MySQL Sort by Array

. > >> > >> Keith > >> > > >> > >> > >> No virus found in this incoming message. > >> Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: > >> 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM > >> > >> > >> > > > > > -- > Jim Lyons > Web developer / Database administrator > http://www.weblyons.com > -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim)

Re: Error Code 28

? I'd really appreciate some help. I'm > running MySQL 5 on a Debian based system. > > > > If you need any more information what so ever, please let me know. > > > > Cheers in advance, > > > > Heston > > 1. Just because your data set is small does not mean that mysql will not create a larger temporary file to store a temporary table. 2. If I had to guess I would say some sort of quota is in effect, also possibly for /tmp/ in particular. -- Rob Wultsch

Re: mysql is dead slow

On Mon, Oct 20, 2008 at 9:31 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Mon, Oct 20, 2008 at 8:30 PM, Perrin Harkins <[EMAIL PROTECTED]> wrote: > >> On Mon, Oct 20, 2008 at 10:15 PM, Sangeetha <[EMAIL PROTECTED]> wrote: >> > Gosh I wonder >> >

Re: mysql is dead slow

ty sure 5.2 became 6.0 6.0 is two major versions out The last major release happened 3 years ago -- Rob Wultsch

Re: mysql is dead slow

here Username IN (SELECT > DISTINCT commentname from comments where id=35037 ORDER BY > commentname)Group > by Username) > It is dead slow... almost doesnt work.. is it the query or is my DB set up > wrong? When i had records of around 500 rows it worked fine.. now i have > around 6 rows its dead slowPlease help me... > -- Rob Wultsch

Re: FLOOR(DATE_ADD(CURDATE(), INTERVAL 4 MONTH)) -- ?

On Fri, Oct 17, 2008 at 2:19 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > On Fri, Oct 17, 2008 at 2:15 PM, Ian Christian <[EMAIL PROTECTED]>wrote: > >> 2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>: >> > On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <

Re: FLOOR(DATE_ADD(CURDATE(), INTERVAL 4 MONTH)) -- ?

On Fri, Oct 17, 2008 at 2:15 PM, Ian Christian <[EMAIL PROTECTED]> wrote: > 2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>: > > On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]> > wrote: > > > >> Okay, I realize that query won't wor

Re: FLOOR(DATE_ADD(CURDATE(), INTERVAL 4 MONTH)) -- ?

floor ( 2008-10-16 + 4 months ) = 2009-02-1 > > Is there a nice SQL way of achieving this? > > ...Rene > SELECT date(now() + INTERVAL 4 MONTH - INTERVAL day(now())-1 DAY); -- Rob Wultsch

Re: Confusion over query stratergy

On Fri, Oct 17, 2008 at 10:31 AM, Ian Christian <[EMAIL PROTECTED]> wrote: > 2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>: > > > *How long does the second query actually take to run compared to first? > > Actually, really quickly - so quickly that I also suspected th

Re: Confusion over query stratergy

On Fri, Oct 17, 2008 at 9:56 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Fri, Oct 17, 2008 at 2:12 AM, Ian Christian <[EMAIL PROTECTED]>wrote: > >> Hi all, >> >> I'm trying to work out the difference in a field between the last 2 >> updates in an

Re: Confusion over query stratergy

l 29 million records. > Whilst this query appears to run fast still, surly it's not right that > a full table scan is needed? > > Thanks, > > Ian > Hi, In my experience derived table performance often sucks. This does not feel like a place where it should suck, though. My guess is that the limit is messing with EXPLAIN's head. I have experienced LIMIT causing EXPLAIN output to show full table scans while the query performance did not act that way, and the servers stats did not show it either. How long does the second query actually take to run? -- Rob Wultsch

Re: Stored proc - dynamic sql in cursor

// A couple of thoughts, and please bear in mind that you probably know more about stored than I do. 1. Would this be better dealt with by BASH? You could look at the results and act accordingly much more easily with BASH/Perl/whatever. 2. Why not fetch the prepared statement into a udv? would become SET @stmt_text=CONCAT("select count(*) INTO resadi from ",tablename," a join individual i on a.ident=i.ident where fid=",agpfid); ... you could then test resadi as shown. I hope I am not adding to the confusion, Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does MySQL have RETURNING in the language?

On Wed, Oct 15, 2008 at 2:09 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote: >> Rob Wultsch wrote: >>> >>> On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED

Re: Does MySQL have RETURNING in the language?

On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote: > Rob Wultsch wrote: >> >> On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> >> wrote: >>> >>> There's an awesome feature that was added to Post

Re: Does MySQL have RETURNING in the language?

qs-stored-procs.html#qandaitem-22-4-14 "22.4.14: Can MySQL 5.0 stored routines return result sets? Stored procedures can, but stored functions cannot. If you perform an ordinary SELECT inside a stored procedure, the result set is returned directly to the client. You need to use the MySQL 4.1 (o

Re: How to build sub-sequence ... AUTO_INCREMENT on a sub-key starting with a specific offset?

er. Why? Both of these fields are ints, so the key length would rather small. > I don't think the 'MAX' is optimized, though and maybe there is a better, > more robust way to do this which is already built into MySQL that I don't > know about. MAX should be fast, assu

Re: Permissions

//ronaldbradford.com/blog/why-you-do-not-use-grant-all-on-2008-09-23/ -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication question -different db name on slave server

s and then run the sql thread. In fact I bet there is some way for awk to sit between the relay logs and sql threads in real time... -- Rob Wultsch

Re: Global search and replace utility

ion schema to make a list of all tables and columns, and then run updates on all of them. OR Dump to a text file and run a find and replace in your editor of choice. -- Rob Wultsch [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Copying" tables between databases

> > Is there a way to set up real-time "replication" of that table? > Assuming that both databases are on the same mysqld instance setting triggers to keep the table up to date should do what you want... -- Rob Wultsch [EMAIL PROTECTED] -- MySQL General Mailing List For list a

Re: simple design choice

e size of db, depending on column choice. A decent choice I think. #2 Yuck. #3 A compact and clean solution. -- Rob Wultsch [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   5   6   >