efficiency
of how we evaluated the original query which is why your row numbering
system no longer works as you expected it to.
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountvi
ld it be best to just dump/drop/re-import the tables/databases ?
Many Thanks,
- 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 f
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
tion 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
t (always assume someone else may
steal the room, for example) and those may need 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 US
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 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
te their installation, 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
must trust 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, Engineer
ourage you to engage with Cluster sales or
any reputable consultant to get an evaluation and their recommendation,
too. (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
be an option they can use.
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
transaction isolation in InnoDB, the less 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, T
WHERE db1.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
ot;last
update on 18 Feb 2011" 1 -00-00 00:00:00 0 0 0 0
Please let me know the efficient & easiest way to remove it.
Thanks
The manual is your friend, please don't be afraid to use it. I believe
the function you are looking for is REPLACE().
http://dev.mysql.com/doc/ref
ot 'good form'. I suggest you alter
the sequence of your table definitions to use either all LEFT or all
RIGHT like this:
FROM Address
LEFT JOIN Nam
ON ...
LEFT JOIN Paid
ON ...
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Sof
ll,
easy to operate, and easy to learn. All feedback is valid.
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
thank you very much.
Humbly 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
To unsubscribe:http://lists
le.base_id
...
WHERE basetable.PKID is NULL
...
)
The first half of the UNION finds all rows in basetable plus any rows
where the jointable matches. The second half identifies only rows in
jointable that have no match with a row in basetable.
--
Shawn Green
MySQL Principal Technical Support Engineer
those patterns allow LEFT JOIN, RIGHT JOIN,
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
ase name and host name
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 Togethe
.
If you don't 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 Sup
a web page? All of this SQL coding is designed 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
Or
-
include this
f) the event starts inside the window but ends beyond the window -
include this.
g) the event starts and ends beyond the window - exclude 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 >=
e normally many ways to solve any problem. Perhaps 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
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?unsub=arch...@jab.org
the
mysql client (a command-line tool). This is where you become the SLAVE
SQL 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 int
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
r to read 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.my
hich column you 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
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 l
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 Engi
account 'root' for a new 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/rese
*!50020 */
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 Tec
ing but it is making it harder 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.
Yo
`),
KEY `NameFirst` (`NameFirst`),
KEY `NameLast` (`NameLast`)
This extremely simple join is still massively slow.
Jim
On Mar 10, 2011, at 10:00 AM, Shawn Green (MySQL) wrote:
On 3/10/2011 12:32, Jim McNeely wrote:
Rhino,
Thanks for the help and time! Actually, I thought the same thing
ULL| NULL
| 262465 | |
++-+---+---+---+--+-+--++-+
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 f
and compare how it works. If both styles are similarly
slow, collect 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
--
MySQ
.5/en/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/mys
ml
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 To
e before $now that are NOT
also listed in searching.Status
I can't seem to spot the difference. Maybe if you phrased it differently
or provided two or three sample rows for each table I could understand
your distinction?
--
Shawn Green
MySQL Principal Technical Support Engineer
Orac
tern has the added advantage of not eliminating the possibility
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: h
r 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
lts,
just the query.
--
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
instead of a scan of all
previous 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 Gene
ery() and mysql_store_result() no other thread is using
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
* 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
v.mysql.com/doc/refman/5.5/en/query-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
have 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
ation-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
Oracl
at line 1
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
Oracl
OS file and then import 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
odb-tuning.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
are saving (index 121000 rows, index
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 En
://dev.mysql.com/doc/refman/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 Gene
ny existing bugs that may 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: Blount
://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
HOW
SLAVE STATUS 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
re 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:/
clues?
Mark
SELECT MIN(column) FROM table WHERE column>0 ?
--
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?un
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
? 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
help, thanks in advance.
>
Have you tried a combined index of (startnum,endnum) instead of two
single-column indexes?
You may still run into problems, though, because ranged searches are
usually performed as
WHERE column_A BETWEEN X AND Y
and not as
WHERE X BETWEEN column_A and column_B
an
m/doc/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
l settings without 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
y, you can also
return a quality rating. Let's say you were looking for something sized
90cm and you only have 88cm pieces in stock, that may 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 no
Securing MySQL is fairly easy. Check out 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.my
definition
--
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
DB AUTO_INCREMENT=1001 DEFAULT 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 Pri
hawn 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 first level or two of time-based summary tables.
--
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
table. At the end 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 Sup
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
should also be an index on both tables where `letter` is the
leftmost element.
--
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
Why do I get this result? Thanks.
Best Regards
Xiaoming
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
--
MySQ
ds of
bugfixes 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 U
Each combination of (a,b) rows is combined with each matching row from c
So if 10 rows of A match your 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 tha
ld: ready for connections.
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 Princip
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=arch...@jab.org
p 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/mysql?unsub=arch...@jab.org
NIQUE key I violated, only that the combination already
exists and which constraint is protecting that combination.
--
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
ypes.html
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
en/view-algorithms.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
e.
If you need to expose a table from within 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
tion_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: Blountv
am) 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
"correct" version. Is is the
one on the table or the change coming in from the binary log? Maybe the
data on the slave 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
e
Prajapati <
prajapat...@gmail.com> wrote:
Hi Jitendra,
Check your error log file. Some thing might have gone wrong.
Krishna
On Wed, Aug 18, 2010 at 9:41 PM, jitendra ranjan
wrote:
Hi,
Whenever i run any commnd on mysql it gives message as below then gives
the
result successfully. What is
t how you are
sequencing your rows. 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.co
ork that's chewing up a big chunk of your CPU time.
Does it work better if you delay the index creation of your temporary
table until after the table is populated?
CREATE TABLE fp2 ... SELECT ... ;
ALTER TABLE fp2 ADD KEY p(p),KEY q(q);
--
Shawn Green
MySQL Principal Technical Support Engi
On 8/18/2010 2:22 PM, Anders Kaseorg wrote:
On Wed, 18 Aug 2010, Shawn Green (MySQL) wrote:
If the server specifies REQUIRES SSL then that client cannot connect
without going through the full SSL validation process. This means that
Mallory would need to present the same security credentials
you don't believe me. Sun made many headlines when
they bought MySQL for one billion (10) US Dollars.
I still work for MySQL (the combined products) even if there no longer
is a MySQL, Inc. (the company).
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle U
On 8/17/2010 6:02 PM, Anders Kaseorg wrote:
On Wed, 2010-08-11 at 14:23 -0400, Shawn Green (MySQL) wrote:
On 8/9/2010 5:27 PM, Yves Goergen wrote:
What's that supposed to mean? If there's no way to force the connection
into SSL, it is entirely useless. Anyone on the wire could simp
how the MySQL authentication works is available in the manual:
http://dev.mysql.com/doc/refman/5.1/en/user-account-management.html
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: ht
Third, you must always be aware of the max_allowed_packet size for the
connection you are on. If you attempt to send a command larger than that
size, the server will forcibly disconnect your session under the
impression that you are attempting to sabotage the machine by sending
queries that
for such a long time you should be
encouraged that they are under review, again.
--
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.m
table not
marked const, and usually very bad in all other cases. Normally, you can
avoid ALL by adding indexes that enable row retrieval from the table
based on constant values or column values from earlier tables.
####
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, I
I
suggest strongly that all data designs should start normalized and only
de-normalize where the physical components of performance indicate the
need to do so.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing
nt := ROW_COUNT()
Please let us know if either of those also fails.
--
Shawn Green
MySQL Principle 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
eate additional tables derived from the original
data and work with those as part of your analysis project. No
modification of the original *tables* will be required.
But this would indeed be much easier to talk about if your columns had
names.
--
Shawn Green
MySQL Principle Technical Support E
, then all of
the databases hosted there may become poorly organized resource hogs. If
you, as a DBA, are diligent, protectful, proactive, and concerned then
you will have a much better chance of achieving amazing performance out
of your servers.
Regards,
--
Shawn Green
MySQL Principle Techn
are stored
in separate tables.
When you ask about listing only the "arqueology sites" that's just a
simple query:
SELECT * from site_arqueology inner join sites on sites.id_site =
site_arqueology.id_site
I can't see where your problem is. Can you provide some additional
1 - 100 of 104 matches
Mail list logo