access to any other user that cannot login
directly from the host machine.
Hopefully, this clarifies why your localhost account was unable to login.
Additional reading:
http://dev.mysql.com/doc/refman/5.5/en/connection-access.html
--
Shawn Green
MySQL Principal Technical Support Engineer
On 3/16/2012 2:41 PM, Clemens Eisserer wrote:
Hi Shawn,
I understand the logic behind seperating local and remote users,
postgresql does the same thing in its pg_hba.conf file.
However, what I don't understand is the way this turned out to be such
a huge problem (for me), as it worked already
quotes)
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
as you expected it to.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
,
- bobb
The simple solution is to rename your tables to
a) use shorter names
and b) not use any illegal characters
Are those odd characters and long names really a requirement to your
design or are they there just for developer's convenience?
--
Shawn Green
MySQL Principal Technical Support
instructions for Macs and other non-Windows systems in the
manual?
http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-installation.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
credentials.
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_user
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http
to be resolved through a
different process.
* Keep the business logic in your application, leave the data integrity
rules to the database.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
(or something similar based on some unique
combination of identifiers in your original data instead of just 'name'
) so that each of your child rows can be assigned their proper parent id
values.
http://dev.mysql.com/doc/refman/5.5/en/information-functions.html#function_last-insert-id
--
Shawn Green
MySQL
, there is the script.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
you, the DBA, to do that properly.
http://dev.mysql.com/doc/refman/5.5/en/replication-sbr-rbr.html
http://dev.mysql.com/doc/refman/5.5/en/replication-rbr-safe-unsafe.html
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work
. (disclaimer: I am not a cluster guru). I also encourage you to seek
multiple recommendations. Many different solutions to the same problems
you describe have been created by many different people. What works in
my mind may not work in all situations.
Regards,
--
Shawn Green
MySQL Principal
.
So the default remains at 0 until the support for it becomes much more
common among Linux user accounts.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing
isolation you
require, the more likely you are to generate a shared lock vs an
exclusive lock.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
.field1 IS NULL;
How many rows do you get back from that?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
be afraid to use it. I believe
the function you are looking for is REPLACE().
http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_replace
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office
On 10/19/2011 20:03, Dotan Cohen wrote:
...
Thank you Shawn. I very much appreciate your help, and I also
appreciate your employer's initiative to have such a position
monitoring the mailing list. Is that an Oracle-created position, or
did it exist at Sun as well?
MySQL has always encouraged
this:
FROM Address
LEFT JOIN Nam
ON ...
LEFT JOIN Paid
ON ...
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http
,
LEFT OUTER JOIN, or RIGHT OUTER JOIN but not just OUTER JOIN.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
On 10/19/2011 13:19, Dotan Cohen wrote:
...
Thank you Shawn! I see that I am getting support right from the top!
So far as I understand, an outer join should return all matched and
unmatched rows (essentially all rows) from both tables. So it is not
clear to me what is the difference between
On 10/19/2011 13:29, Michael Dykman wrote:
While we have him online, I think we could all take a moment and be grateful
for the contributions of Shawn Green.
When I see the Oracle-bashing on this list, I am often reminded that we
still have a hard-core MySQL developer who has survived the ride
arguments may be given to specify the default database or the host where
the server is running. If omitted, the current values are used.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
like the font on the web site, tell us. This is your chance
to completely rip us a new one and to brag about your favorite service
offerings at the same time.
All opinions about any support providers are welcome.
Thank you kindly,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle
to be a single
step in some larger process. If you share that larger purpose with us,
we may be able to suggest a more efficient approach than arrays to solve
your larger problem.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered
this.
In order to get every event in the range of c-f, here is what you need
for a WHERE clause
WHERE start = (ending time) and end = (starting time)
Try that and let us know the results.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered
if you shared
the problem you are trying to solve, you can see how many different ways
the members of the list can solve it without resorting to an array?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office
On Sat, Aug 27, 2011 at 17:33, Arthur Fuller fuller.art...@gmail.com wrote:
I agree 110%. It is completely pointless to index a column with that amount
of NULLs. In practical fact I would go further: what is the point of a
NULLable column? I try to design my tables such that every column is NOT
that never closes, then those objects will continue to take up resources
as well (user variables, prepared statements, temporary tables) .
Basically, you need to get your connections under control in order to
solve your problem. Raising the limit was probably a temporary fix, at
best.
--
Shawn
thread.
Beyond that, all you really need to keep up with is the binary log
position you replicated last (again, pretending to be the SLAVE IO thread).
Best of luck! what you are doing is definitely labor intensive.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA
content is also available here:
http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html
It may be an easier address to reach.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
On Aug 3, 2011 9:24 AM, David Lerer dle...@us.univision.com wrote:
I rarely use aliases (unless rarely required in self-join queries).
When I have that option, I create unique columns by prefixing every
table (and its objects) with a number.
Something like:
Create table T1234_Employee
the smaller table first.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
want to base your time comparison on, and
someone will show you an example.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http
mysql select day(now())-5;
+--+
| day(now())-5 |
+--+
| 26 |
+--+
2011/7/31 yavuz maslak mas...@ihlas.net.tr:
I don't want all records during 5 days ( 24*5days ) . Only I need records
at 5 days ago ( for instance 24 hours on 26 th July 2011) ?
On 7/22/2011 18:48, Tim Thorburn wrote:
On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote:
On 7/21/2011 22:45, Tim Thorburn wrote:
Hello,
For those keeping score, this will be the second time in the past few
months I've come upon this problem. To recap, this is happening on a
development laptop
Look into select into or just insert. The mysql doc covering this might even
have a suitable example.
On Jul 23, 2011 8:42 AM, Velen Vydelingum ve...@biz-mu.com wrote:
Hi,
I have 2 tables and need to create a 3rd one as follows:
Table Sales:
Code Price sQty sDate
123 12.00 2 2011-03-12
190
installation is
not created without a password. If you had restored a very old copy of
that table, that might have been your situation.
* are you aware of the lost password reset instructions in the manual?
http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html
--
Shawn Green
MySQL
On 7/22/2011 17:02, Shawn Green (MySQL) wrote:
... quick correction ...
* ...the account 'root' for a new installation is*
created without a password. ...
I originally said 'is not'. Sorry for the confusion
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc
On Thu, Jul 14, 2011 at 10:50, Jerry Schwartz je...@gii.co.jp wrote:
There are a couple of problems with using any database for doing this.
you're probably right. that said
- Rows in a table are inherently in no particular order. That means they are
neither sorted nor random.
-
On Jul 13, 2011 2:26 PM, Elim Qiu elim@gmail.com wrote:
I have a prime table
+-+--+-+
| oid | pv | descipt |
+-+--+-+
| 1 |2 | NULL|
| 2 |3 | NULL|
| 3 |5 | NULL|
| 4 |7 | NULL|
| 5 | 11 | NULL|
|
On Jul 13, 2011 6:41 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote:
Dear all,
I have million of sites stored in url column of a mysql table.
I need to shuffle the . words . Is there any in built function in mysql to
achieve this.
Why would you want to do this in mysql? What's your
I'm actually enjoying this discussion because I have the same type of issue.
However, I have done away with trying to do a full text search in favor of
making a table with unique fields where all fields should uniquely identify
the group. If I get a dupe, I can clean it up.
However, like you,
i'm just looking for rough ideas here...
i've got a table that has 31 fields. most of them need to be there
(entry time, exit time, entry lat, etc). however, i've got 4 fields
that i query this db with that should generally be unique... well,
really 3 fields that should be unique, because the
*/
Unfortunately, I have no way at this time to separate the
version-specific comments from the rest of the dump. Perhaps someone
better than I at using grep, sed, or awk could produce a script to strip
those comments and share with the list?
Yours,
--
Shawn Green
MySQL Principal Technical Support
| |
++-+---+---+---+--+-+--++-+
But, very good try. I thought this might be it as well.
... snip ...
According to this report, there are no indexes on the `patient_` table
that include the column `IdPatient` as the first column. Fix that and
this query should be much faster.
--
Shawn Green
On 3/10/2011 13:12, Jim McNeely wrote:
Shawn,
This is the first thing that I though as well, but here is a portion from the
show create table for patient_:
PRIMARY KEY (`zzk`),
KEY `IdPatient` (`IdPatient`),
KEY `SSN` (`SSN`),
KEY `IdLastword` (`IdLastword`),
KEY `DOB` (`DateOfBirth
for
random successes. If they fail to randomly find a valid value enough
times, you lock out that IP address.
However this really isn't a great topic for a database list as most of
solution to your problems reside in how you design your application.
Yours,
--
Shawn Green
MySQL Principal
the EXPLAIN plan for this query and share with the list.
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
/replication-options-master.html#sysvar_auto_increment_increment
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
for correct foreign key definition.
To rephrase, a little: Columns must be indexed before they can
participate in Foreign Keys.
See the link you provided for more details.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together
or three sample rows for each table I could understand
your distinction?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
The Customer Support Center Will Retire February 11, 2011
Find out what
of using an INDEX on the dtcolumn column by wrapping it inside a function.
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
for the section talking about clean backups.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
unique values.
Please let us all know if this is faster enough. (and don't forget to
drop the temp table once you are through using it)
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http
the same connection.
###
This same rule applies to attempting to process more than one query on
the same connection. You must complete the first query before starting
the second or you must open a separate connection to handle the second
query.
Yours,
--
Shawn Green
MySQL Principal Technical
* FROM table1 INNER JOIN table2;
Again, this is a perfectly legal statement, even if it may not make
logical sense in the context of your application or data to leave out
the joining criteria.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
-log.html
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
you checked?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Is there a better way to generate incremented sequence IDs?
Can this be done in a stored function?
Is there a particular reason why you cannot use an auto_increment column
to atomically create your sequence number?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc
-functions.html#function_last-insert-id
Have you also explored the use of auto_increment columns as part of a
multiple-column index on MyISAM tables as described here?
http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
that into the other server using
another mysql command line client command. I'd like to find something
cleaner than that.
I'm using 5.5.8.
thanks,
-Hank
Have you looked at the FEDERATED storage engine?
http://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html
--
Shawn Green
MySQL
121001 rows, index 121002 rows,...) then you can see a big improvement
by waiting to put the indexes on the table at the very end of the process.
http://dev.mysql.com/doc/refman/5.0/en/insert-speed.html
Yours,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office
will cause a reload of the
configuration?
It won't reload the configuration.
http://dev.mysql.com/doc/refman/5.1/en/server-signal-response.html
Are you sure you aren't seeing the results of a dirty shutdown and
auto-recovery?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc
/5.1/en/create-trigger.html
I know it's a workaround but it will keep the default value management
out of your application and inside the database.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives
already match your description. The team
that manages that tool may ask for additional information so please do
respond or we will close the bug as No Feedback.
Warmly,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
://dev.mysql.com/doc/refman/5.1/en/csv-storage-engine.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
to ensure that they are both catching up to the master.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the current version after you
restore your old-version tables but if you want to try to avoid that
step, you can use my techniques.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
?
Mark
SELECT MIN(column) FROM table WHERE column0 ?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
. There is always the
possibility that someone never had a score above zero. This should
handle it.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
? It is on Redhat if that makes a difference.
I suggest you also look at the syntax for SELECT INTO OUTFILE, too.
Dumps are usually scripts of SQL statements that Oracle may not read
appropriately.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
column_A BETWEEN X AND Y
and not as
WHERE X BETWEEN column_A and column_B
and the optimizer has been designed to evaluate the first pattern but
not the second.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list
/refman/5.1/en/group-by-modifiers.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
affecting the global defaults.
Please read this if you are still confused:
http://dev.mysql.com/doc/refman/5.1/en/using-system-variables.html
http://dev.mysql.com/doc/refman/5.1/en/show-variables.html
http://dev.mysql.com/doc/refman/5.1/en/set-option.html
--
Shawn Green
MySQL Principal Technical
return a match
quality code of
1-(abs(90-88)/90)
You can combine that in the query against tmp_relevance to generate
scores for near matches and not just exact partial matches.
Does this give you some ideas to build on?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc
this guide in the manual for
details:
http://dev.mysql.com/doc/refman/5.1/en/security.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-in-time-recovery (PITR). Which combination of backup techniques
(and there are multiple techniques) you use depends on your hardware,
software, and operational requirements.
Please read the fine manual for more details:
http://dev.mysql.com/doc/refman/5.1/en/backup-and-recovery.html
--
Shawn
CHARSET=utf8
COLLATE=utf8_unicode_ci
I'm confused, I thought primary keys were always unique ?
Cheers
Neil
I see no reason why this won't work. Show us some duplicate data and I
may be able to explain how to fix your definition.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle
On 10/13/2010 11:37 AM, Tompkins Neil wrote:
Shawn, sorry my error, I didn't realise I had two fields as the primary key
That's misinformation. You can have multiple fields as a primary key.
Show us what you think is duplicate data and I may be able to help you
fix your definition
On 10/8/2010 3:31 PM, Neil Tompkins wrote:
Hi Shawn
Thanks for your response. In your experience do you think I should still
retain the data used to generate the computed totals ? Or just compute
the totals and disregard the data used ?
In my experience, the details matter. Also in my
of the day, you take
the previous 24 entries from stats_hour and compute a stats_day entry.
Each level up aggregates the data from the level below.
Does that give you an idea about how other people may have solved a
similar problem?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle
or greater ?
Regards
Neil Tompkins
If you are an official MySQL customer, log in your request to the
support system at
https://support.mysql.com/
If you need help with your account, email our administrative staff at
support-feedb...@mysql.com
Warmest regards,
--
Shawn Green
MySQL Principal
!
This should work -
SELECT ic.letter_codename, lo.greek greek, lo.french french, lo.german
german from intl_codes ic LEFT JOIN letter_otherlanguages lo on
lo.letter = ic.letter WHERE ic.letter='A';
There should also be an index on both tables where `letter` is the
leftmost element.
--
Shawn
You forgot to use -- before the option version. Try this instead
mysqladmin --version
Let us know your results.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
above and beyond your current 5.1.14. I suggest you upgrade and
try again. Even if this does not fix the behavior to act as you want,
the upgrade will at least remove your exposure to hundreds of identified
bugs.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office
conditions, 1 row from B match your
conditions, and 10 rows from C match your conditions, then this query
produces 10*1*10 total row combinations.
That should explain why your numbers are higher than expected.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office
them as a
load test.
Do you have any techniques you can share?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub
.
Version: '5.1.48-enterprise-gpl-advanced' socket: '' port: 3306 MySQL
Enterprise Server - Advanced Edition (GPL)
For more information on how to locate the error log:
http://dev.mysql.com/doc/refman/5.1/en/error-log.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc
the top 11 in your client code from the
query that includes all players totals?
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
That explains why there is no length to this index.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
).
...
Hank,
I think mysql is selecting ALL the records from both tables then
applying the where clause to all the data from table 1 and table 2 (I
think - guys correct me if I'm wrong)
...
Jangita is correct. Read the bottom of
http://dev.mysql.com/doc/refman/5.1/en/view-algorithms.html
--
Shawn
#option_mysqld_tmpdir
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_heap_table_size
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_tmp_table_size
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
a different database, you must
use a view.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
) and not just one or the other.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is correct but it has been offset by a few rows
inserted a long time ago.
It's your responsibility to understand and appropriately respond to the
errors not just repeat scripted actions until the problems disappear
temporarily.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA
. Only then do the concepts of before and after
have any meaning.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub
201 - 300 of 549 matches
Mail list logo
