Note the space after the -p , alba2 will be the defaut database *after* he is
prompted and corrctly give the password for r...@whateverhishostis .
As he did not give the password, and is not connecting to an that one could get
to from the net he really has not given out particularly useful info
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
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
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
> --
> 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
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
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
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
Are you using innodb? etc...
--
Rob Wultsch
wult...@gmail.com
; --
> Eric Robinson
> Director of Information Technology
> Physician Select Management, LLC
> 775.885.2211 x 111
>
>
>
--
Rob Wultsch
wult...@gmail.com
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
before moving files around.
--
Rob Wultsch
wult...@gmail.com
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
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
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
vironment you
> are running in.
>
> be careful though!
>
> Walter
>
Not everything that gets changed is in the change log. In particular
there was a memory leak that I had (...still have...) to deal with
that got fixed without any note in the change log.
http://www.maatkit.org/doc/mk-
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
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
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
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
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
.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
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?
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/
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
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
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
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
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...@
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
nting unique
>>> >> >>>> boundaries
>>> >> >>>> i.e. rectangles and I want to search the table to find the
>>> rectangle
>>> >> >> that
>>> >> >>>> bounds a specific point.
>>> >>
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
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
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.
-
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
005 is not that long ago.
--
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
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
>>
hentication token to the OS)
>
> does this help?
> Martin Gainty
I am explicitly not setting up identity solutions or anything else.
All I want is a page from mysql which lists security issues.and what
versions are effected. I don't think that this is such an insane
thought...
-
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
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
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
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
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/
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
> 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
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
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
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
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
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
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
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
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
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
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:
#
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
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
. 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
> 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
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
gt;
> I wanted to know the possible ways in which an xml document can be stored in
> the mysql database. So the keys in an xml are the columns in the database
> and the key values in xml go as the values for columns. I dont want to use
> java if thats possible.
>
> Thanks in advance
t; same database.
>
>
>
> Are there some docs out that that could be helpful or any tips from anyone?
>
>
> D$
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECT
via CONSTRAINTs or something similar?
>
> Best Regards,
> Dav
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Rob Wultsch
(480)223-2566
[EMAIL PROTECTED]
y want
> One stop wish list for any gift,
> from anywhere, for any occasion!
> http://thewishzone.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Rob Wultsch
(48
--
Rob Wultsch
(480)223-2566
[EMAIL PROTECTED] (email/google im)
wultsch (aim)
[EMAIL PROTECTED] (msn)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
WHERE table1.col1 = table2.col1 AND table1.col2 IN ('A', 'B') AND
> table1.col3 IN ('A', 'B')
>
> Is this expected behavior? It surprised me that the second
> query would take full advantage of the index but not the
> third. We're using MySQL 4.1.20.
--
Rob Wultsch
(480)223-2566
[EMAIL PROTECTED] (email/google im)
wultsch (aim)
[EMAIL PROTECTED] (msn)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
f data. Neither was particularly inspiring, so it would
> have
> been nice if I could just use various databases through the same local
> server.
>
> Are there any solutions for this kind of problem ?
>
> Werner,-
>
> --
> Dr. Werner Van Belle
> http://werner.sigtrans.org/
>
>
--
Rob Wultsch
(480)223-2566
[EMAIL PROTECTED] (email/google im)
wultsch (aim)
[EMAIL PROTECTED] (msn)
I was previously on a list where the reply-to was setup as it is on the
mysql list, with the originator receiving a response rather than list. It
ended up that that setting was the default, and had not been changed when
the list was setup.
Is there a good reason why the reply-to is setup as it is
Perhaps I am missing something, but why not do this as an inner join?
SELECT man .name, GROUP_CONCAT( car. make ) AS 'makes'
FROM man
INNER JOIN car ON man. id = car.owner_id
GROUP BY man .id
On my box this query is about 3X faster. I think Mysql is known for not
performing well with (especially c
mungers would
have it, however the the support is not overwhelming, which it ought
to be for a change like this to be made. Oh well.
INSERT INTO `mysql_list` SET `forum`= 'RELIGION', `topic` = 'reply-to';
--
Rob Wultsch
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ing like
select concat(user,'@',domain),servername,port
from database
where
user = substring('[EMAIL PROTECTED]',0,LOCATE('@','[EMAIL PROTECTED]'))
AND
domain = substring('[EMAIL PROTECTED]',LOCATE('@','[EMAIL PROTECTED]'))
or someth
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Aaron Fischer wrote:
> > Thanks Peter and Baron, these both worked well.
> >
> > The "left join on" took .1919 seconds and the "left outer join as" took
> > .1780 seconds.
>
> They are synonymous in MySQL. The only difference is 6 extra ch
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> [EMAIL PROTECTED] wrote:
> > mos wrote:
> >>
> >> The data is quite valuable because there is a lot of competition in
> >> this particular marketplace and my competitors would like to get their
> >> hands on it. I've spent 5 years writing
On Nov 8, 2007 4:08 PM, Stut <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I've inherited a PHP app that uses a MySQL database. The following query
> is extremely slow and I've been battling for a couple of days on an off
> to try and get a combination of indexes to optimise it. Any help would
> be grea
On Nov 12, 2007 7:57 AM, Stut <[EMAIL PROTECTED]> wrote:
> Hi Rob,
>
> Thanks for your reply.
>
>
> Rob Wultsch wrote:
> > On Nov 8, 2007 4:08 PM, Stut <[EMAIL PROTECTED]> wrote:
> >> Hi all,
> >>
> >> I've inherited a PHP app th
On Nov 12, 2007 9:22 AM, Afan Pasalic <[EMAIL PROTECTED]> wrote:
> If you have to deal with it again consider using a bunch of unions
> instead of the 'IN'. Not prettiest thing, but it should fix your
> performance issue.
> Could you please give me more details about your statement that mysql dea
On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote:
> Folks
>
>
> How can one conditionally drop an index in MySQL?
>
> Googling shows that the "drop index" does not support an "if exists"
> qualifier - apparently a bug
> has been raised but as far as I know its not fixed yet.
>
> D
ame,'`
> DROP INDEX `',ndxName,'`');
> SET @SQLStmt = SQLStatement;
> PREPARE s FROM @SQLStmt;
> EXECUTE s;
> DEALLOCATE PREPARE s;
> END IF;
>
> END $$
>
> DELIMITER ;
>
> Give it a try !!!
>
>
> -
On Dec 9, 2007 10:53 AM, David Scott <[EMAIL PROTECTED]> wrote:
> I have a field in a DB that contains something like
> "lvlscore4:4493,lvlscore5:3232,lvlscore6:6128"
> I need to select all records where the "lvlscore5:" is greater than 3000.
> I think this can be done using REGEXP but I have read
On Dec 9, 2007 9:17 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>
> On Dec 9, 2007 10:53 AM, David Scott <[EMAIL PROTECTED]> wrote:
> > I have a field in a DB that contains something like
> > "lvlscore4:4493,lvlscore5:3232,lvlscore6:6128"
> > I need t
On Dec 10, 2007 1:26 AM, David Scott <[EMAIL PROTECTED]> wrote:
> I came up with a clunky solution: REGEXP
> 'lvlscore5:[6-9][0-9][0-9][0-9][0-9]';
> This gives me all scores over 6000. I then add on another [0-9] and change
> the [6-9] to [1-9] to do 10k+
> As this was a one off and only returned
On Dec 11, 2007 8:38 AM, Anders Norrbring <[EMAIL PROTECTED]> wrote:
> I'm looking at a situation I haven't run into before, and I'm a bit
> puzzled by it.
>
> I have this table structure:
>
> Table USERS: userid, class
> Table OBJECT: userid, class, result
>
> Now I want to query the database for
On Dec 11, 2007 6:30 AM, Volker Duetsch <[EMAIL PROTECTED]> wrote:
> Hi,
>
> select
> mnr,
> kw,
> sum(pzt),
> sum(uu),
> sum(u01),
> sum(u02),
> sum(u03)
> from mde
> where mnr=63210 group by kw, mnr
>
>
> results in:
>
> mnr kw sum(pzt)sum(uu) sum(
On Dec 13, 2007 12:11 PM, Al <[EMAIL PROTECTED]> wrote:
> (Sorry if this is a duplicate post, email issues w/multiple accts)
>
> I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of
> knowledge of computer systems, but haven't setup or worked with mySQL
> before. (usually use it p
On Dec 16, 2007 10:29 AM, Afan Pasalic <[EMAIL PROTECTED]> wrote:
> try REPLACE
> http://dev.mysql.com/doc/refman/5.1/en/replace.html
>
> -afan
Replace will not do an update. All previous data will be lost.
A mysql-centric alternative solution would be to use INSERT ... ON
DUPLICATE KEY UPDATE
htt
1 - 100 of 252 matches
Mail list logo
