ay of showing you some kind of trace or log that serves as a
fingerprint for that happening.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/c
Hello Jim,
On 2/25/2019 7:29 PM, Jim wrote:
On 2/25/2019 5:46 PM, shawn l.green wrote:
Hello Jim,
On 2/25/2019 5:04 PM, Jim wrote:
I have a question about mysql replication. I believe I understand most
of it, but have a question about user privileges.
I understand on the master
the REPL_SLAVE_PRIV privilege and
any of those could be used by a slave to do the same job. However losing
control over one of those more privileged accounts could pose a higher
risk to your data.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrate
s.
Once you reach that stage, you are ready to start testing copies of your
applications against 8.0 to see what else will need to be updated (such
as the library you use to connect to MySQL). Moving from 5.1 to 8.0 is
a big shift, you potentially have a lot of work ahead of you.
Yours,
--
to resume so that replication could continue.
A safer plan is to stop both threads at the same time. Just use the
basic STOP SLAVE command instead of the more specific STOP SLAVE IO_THREAD.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integr
?
Have you checked these resources to see what the InnoDB main or
background threads are doing when your CPU starts to spike? (you could
be in a massive rollback)
SHOW ENGINE INNODB STATUS
SELECT * FROM information_schema.INNODB_TRX;
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support
, and Shawn is the authority on this.
Your request for a lock would have waited until all existing readers or
writers (depending on the type of lock you asked for) had finished using
the tables you wanted to lock. By extension, that means that any
transactions active against the tables you wanted
could look like
a.pigId = b.pigID AND a.seq-1 = b.seq
But at that point, counting the length of sequences (and remembering
when each trend became positive) needs a loop. That's where even
complicated set-wise SQL fails you and you need to shift into using the
SQL of stored programs.
Regards
later step had needed you to issue a ROLLBACK
command.
Note, even if you are not in a multi-statement transaction that any
stored programs called by or executed within the scope of your user
command are part of that little mini (auto-committed) transaction.
Does that help?
--
Shawn Green
My
s into individual glyphs based on their
individual byte values.
The next time you are in mysql and have a chance to look at some utf8
data, please collect and share these two reports:
status
SHOW GLOBAL VARIABLES like '%haracter%';
(you can obfuscate any sensitive details like server names or
.
*From:* shawn l.green <shawn.l.gr...@oracle.com>
*Sent:* 13 February 2018 09:51:33 PM
*To:* mysql@lists.mysql.com
*Subject:* Re: Optimize fails due to duplicate rows error but no
duplicates found
Hello Machiel,
On 2/13/2018 3:02 AM, Machiel Richards
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/
nuary, 2018 23:19:29
Subject: Re: Examples of savepoints and transactions
Den 22-01-2018 kl. 22:01 skrev shawn l.green:
Hello Lars,
On 1/21/2018 3:37 PM, Lars Nielsen wrote:
Hi,
I have a system that uses begin and commit transactions. It works
like a dream! ;)
Now I want to test it by creating test da
are calling "test data" ? I think
that the term "test data" is too general to make much sense to most of
us in the context you described.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications &
, there
will be a NULL value in s.ident.
Finally, filter the combination of the s and d tables (I'm referring to
their aliases) to find all the rows where s.ident was not given a value
because it did not satisfy the ON condition of your outer join.
#
Yours,
--
Shawn Green
MySQL Senior Principal Technical
very much for helping MySQL to become a better product!
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certifica
is running
as), does that get you past this problem?
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_temp_data_file_path
Think of it as allocating "scratch space" for this mysqld to "think"
while it processes your queries against the data.
Your
ryone else.
Humbly embarrassed,
Shawn
Forwarded Message
Subject: Re: Something strange here...
Date: Wed, 14 Jun 2017 14:04:02 -0400
From: shawn l.green <shawn.l.gr...@oracle.com>
Organization: Oracle Corporation
To: Chris Knipe <sav...@savage.za.org>
Hello Chris,
instance as there are things it cannot do (like create
folders in your file system).
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit h
table (more selective indexes, querying for fewer columns,
sharding tables, sharding data to different instances, partitioning
data, ... ).
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville
our end users cannot download one for their operating system from
other reputable sources (like the Google devs for tcmalloc, for example)
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountvil
, right after the error occurs execute ...
show engine innodb_status;
and search the result for LATEST FOREIGN KEY ERROR.
PB
Typo warning: "innodb status" is two words (no underscore)
https://dev.mysql.com/doc/refman/5.6/en/show-engine.html
--
Shawn Green
MySQL Senior Principal
refman/5.6/en/storage-requirements.html
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
for details.
le to stay running. The
angel process mysqld_safe would try to restart the server automatically
which could explain why Moodle was only unresponsive for a short while.
Additional resources:
https://dev.mysql.com/doc/refman/5.6/en/problems.html (in particular,
review B.5.2)
--
Shawn Green
M
this by setting --query-cache-type=0 (or OFF) not just by
allocating no space to the buffer. This is particularly true if you
* have a low reuse rate
* have a high churn rate
* do not have a large population of queries that are repeated (exactly)
against sets of tables that change rarely.
--
Shawn
ns active. The reason it is in Sleep state is
because the server is waiting for the client to send its next command.
http://dev.mysql.com/doc/refman/5.7/en/kill.html
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platfo
On 5/14/2016 2:57 PM, Peter Brawley wrote:
On 5/14/2016 11:16, shawn l.green wrote:
Hello Sukhjinder,
On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote:
Hello,
i have a question regarding the GREATEST function of mysql.
I would like to add the values returned by GREATEST function is
mysql
total from t1;
+---+
| total |
+---+
| 5 |
+---+
1 row in set (0.00 sec)
Can you provide a more complete test case?
Can you tell us which version of MySQL you are using?
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications &
-servers.html
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
for details.
--
MySQL General Mailing List
For list arch
appen. (This is also one of the dangers if someone changes
autocommit=0 and forgets to change it back.)
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certifi
hat contain the rows that are physically required
by the individual transaction. This is a much smaller locking footprint
and is much easier to manage.
Bernd
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Serv
On 4/1/2016 9:12 AM, Lentes, Bernd wrote:
- On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
"Unsafe" in that sense replies to the fact that certain commands can
have a different effect when processed from the Binary Log than they did
when they wer
your
data, then use a transaction. If not, operating in autocommit mode is
ideal.
Bernd
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https:/
NSACTION and
COMMIT.
Bernd
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
for details.
--
MySQL Gener
On 3/26/2016 4:36 PM, shawn l.green wrote:
On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote:
I have Freeradius 2.x with MySQL 5.5 in Ubuntu.
I want to query user quota for current date. I am using following code
SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM
radacct where
NOW()
OR acctstoptime IS NULL
)
But in reality, can you have an acctstarttime that is >= NOW()? If not,
then you can also simplify that term to just
AND AND acctstarttime >= CURDATE()
and lose the BETWEEN comparison.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
O
possible for the two storage engines to co-exist but you need to be
careful or you will create the database equivalent to the "grandfather
paradox". This kind of self-protection needs to happen in your
application logic.
Only using one type of storage engine per transaction is the ot
On 3/3/2016 10:40 AM, lejeczek wrote:
On 02/03/16 00:51, shawn l.green wrote:
On 3/1/2016 6:26 PM, lejeczek wrote:
On 29/02/16 21:35, shawn l.green wrote:
On 2/29/2016 3:13 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote
() of both fields on both systems, do they match?
If so then it's a client-side translation error. If they do not match,
then you introduced the extra characters during the dump/restore
process. The "é" is what the "é" would look like if you were reading it
in latin1.
Yours,
On 3/1/2016 6:26 PM, lejeczek wrote:
On 29/02/16 21:35, shawn l.green wrote:
On 2/29/2016 3:13 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way better
Only to a degree
s purpose is to make it impractically hard for any
unauthorized parties to read it.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/cer
-content) indexes on it. It would only
be able to index the encrypted (opaque) data. The clients would need to
code their queries with WHERE clauses looking for the exact encrypted
values they wanted to find.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc
On 1/28/2016 6:30 PM, Larry Martell wrote:
On Thu, Jan 28, 2016 at 5:45 PM, shawn l.green <shawn.l.gr...@oracle.com> wrote:
On 1/28/2016 3:32 PM, Larry Martell wrote:
On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green <shawn.l.gr...@oracle.com>
wrote:
On 1/28/2016 1:14 PM, L
e rest of the fields to test ...
ELSE 'none'
END as match_flag
FROM ...
Technically, the term in the WHERE clause should prevent a 'none' result
but I put it there to help future-proof the code.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated
On 1/28/2016 3:32 PM, Larry Martell wrote:
On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green <shawn.l.gr...@oracle.com> wrote:
On 1/28/2016 1:14 PM, Larry Martell wrote:
On Tue, Jan 26, 2016 at 8:40 AM, Hal.sz S.ndor <h...@tbbs.net> wrote:
2016/01/25 19:16 ... Larry Martel
just provided for "orphaned"
tablespaces)
Then, when you can, schedule a full hardware check to look for
potentially failing memory or disk media. That's the most common cause
for a fault like this.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracl
http://bugs.mysql.com/bug.php?id=79873
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com/certification/
for details.
--
MySQL General Mai
the file and not be blocked while one of the other two operations are in
progress.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysql.com
On 12/9/2015 12:06 PM, Artem Kuchin wrote:
09.12.2015 19:35, shawn l.green пишет:
INSERT operations are special as you can enable a mode to allow
INSERTs to happen only at the end of the file and not be blocked while
one of the other two operations are in progress.
Cannot find anything
On 12/9/2015 11:59 AM, Artem Kuchin wrote:
09.12.2015 19:35, shawn l.green пишет:
On 12/9/2015 9:59 AM, Artem Kuchin wrote:
Hello!
|THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE
TABLE_SCHEMATABLE_NAME
268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock
270022
u to this other very
important page:
http://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Does this help?
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
B
On 10/22/2015 11:48 AM, Don Wieland wrote:
On Oct 20, 2015, at 1:24 PM, shawn l.green <shawn.l.gr...@oracle.com> wrote:
Which release of MySQL are you using?
Version 5.5.45-cll
How many rows do you get if you remove the GROUP_CONCAT operator? We don't need
to see the r
o you get if you remove the GROUP_CONCAT operator? We
don't need to see the results. (sometimes it is a good idea to look at
the raw, unprocessed results)
Is it possible that you are attempting to concat more values than
allowed by --group-concat-max-len ?
Yours,
--
Shawn Green
MySQL Senior Princip
just not using the MySQL BOOLEAN data type to store
the value for comparison.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! Visit https://www.mysq
set of tables. What is meant by
"logic" in that previous sentence varies widely between each situation.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Cloud Applications & Platform Services
Office: Blountville, TN
Become certified in MySQL! V
ses p
on f.id = p.fruit_id
LEFT JOIN customer c
on p.cust_id = c.id
From here, look at when the columns are NULL and when they aren't. Then
experiment with different conditions. You are almost there. This should
push you right to the top of the learning curve.
--
Shawn Green
MySQL Senior Pri
r`>4 to see which games, if any, experienced any OT play at all.
You could do the same with ENUMS but then you would need a longer list
of ENUMS (OT, OT2, OT3, ... ) to cover all the possibilities.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Integrated Clo
thout any
user name or FOR keyword) to see their own privileges.
Additional reading:
http://dev.mysql.com/doc/refman/5.6/en/account-names.html
http://dev.mysql.com/doc/refman/5.6/en/show-grants.html
Does that give you the details you need to create a second account with
the appropriate host patte
or mysqld_safe scripts) at least once to
ensure that you have the problem corrected. After that, and a normal
shutdown, you should be able to resume starting the database daemon
using the angel script mysqld_safe again.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA
due diligence and didn't find any open
doors.
The door is there, you just just need to be able to see it as a door.
Just a little more experience working on the command line will help.
... remainder snipped ...
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc
. So would order door seal
from warehouse.
I would not use ENUMS, you would run out of options too quickly. My
examples are extremely simplified but hopefully you can see the storage
pattern I am suggesting.
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA
of disk-level intermediate storage which
is much slower than buffering that same information in memory. However,
that may be all the RAM you can spare for MySQL. If that is so, then
there is little you can do about this particular part of the problem.
Yours,
--
Shawn Green
MySQL Senior Principal
) How many my.cnf files (or .my.cnf) do you have currently on your
system? Where are they located?
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Become certified in MySQL! Visit https
expire and the session would die then. But I
think you were not observing one of those failures.
Does that help?
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Become certified
JOIN tbl2 AS two
ON tbl1.id = tbl2.id
The other thing that springs to mind is that you lack a GROUP BY in your
query. It isn't required but they can often help get you to the correct
answer.
Best regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc
... instead.
CREATE TEMPORARY TABLE name_goes_here (
a int
, b varchar(50
, c datetime
...
) ENGINE=... (pick which engine you want to use or let it chose the
default for that database by not using any ENGINE= as part of the
definition)
Yours,
--
Shawn Green
MySQL Senior Principal
-dynamic.html
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
You or someone you know could be a presenter at Oracle Open World! The
call for proposals is open until April 29.
https
.
--
Shawn Green
MySQL Senior 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
://dev.mysql.com/doc/internals/en/optimizer-tracing.html
Yours,
--
Shawn Green
MySQL Senior 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
Hi Larry,
On 2/4/2015 3:18 PM, Larry Martell wrote:
On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
Hi Larry,
On 2/1/2015 4:49 PM, Larry Martell wrote:
I have 2 queries. One takes 4 hours to run and returns 21 rows, and
the other, which has 1 additional where
Hello Larry,
On 2/4/2015 3:37 PM, Larry Martell wrote:
On Wed, Feb 4, 2015 at 3:25 PM, shawn l.green shawn.l.gr...@oracle.com wrote:
Hi Larry,
On 2/4/2015 3:18 PM, Larry Martell wrote:
On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green shawn.l.gr...@oracle.com
wrote:
Hi Larry,
On 2/1/2015 4
box long before you push it into production. This will give you the
chance to find any of those new 5.6 changes that your clients may not be
ready to handle.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work
-restrictions.html
The gist of all of these restrictions is that a FUNCTION shall create
the least side effects possible while generating the result value.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together
log files.
http://dev.mysql.com/doc/refman/5.6/en/innodb-data-log-reconfiguration.html
Please let us know if you have any other questions about MySQL.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together
on is already limited by the WHERE clause. The rows will match
one condition or the other but not neither.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General
to a list topic does not automatically
reposition the topic to the top of the list. It's harder to lose a
question in the noise when I can see what I have tagged as read/unread.
I can't do that in the forums.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc
?
http://forums.mysql.com/
My problem is a lack of time. I can monitor the mailing lists or the
forums but rarely both while still doing my regular job of handling the
official service requests.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software
up to you.
Please let us know which technique works better for you.
Yours,
--
Shawn Green
MySQL Senior 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
?
I have a feeling it's more about how FLUSH TABLES WITH READ LOCK works
but I want to be certain before answering.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL
a new command (MERGE) to the
parser, here.
http://bugs.mysql.com/
But the odds are low that we will add the predicate MERGE to our
syntaxes simply because we already have a storage engine called MERGE.
http://dev.mysql.com/doc/refman/5.6/en/merge-storage-engine.html
--
Shawn Green
MySQL
. No, the sizes of the columns cannot be
changed. Sorry.
To see how to set a comment, check out the appropriate ALTER or CREATE
command for the object you want to annotate.
http://dev.mysql.com/doc/refman/5.6/en/sql-syntax-data-definition.html
Yours,
--
Shawn Green
MySQL Senior Principal Technical
n:o 0 17
What is the current transaction compared what is the oldest transaction
that still has aged copies of data left in the data area of the
tablespace. The difference between those two values is the purge backlog
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
a table ensure that the index pages are made contiguous?
No.
Do these same answers apply to the actual data stored on a table? Yes.
http://dev.mysql.com/doc/refman/5.6/en/innodb-file-defragmenting.html
http://dev.mysql.com/doc/refman/5.6/en/innodb-file-space.html
Does that help?
--
Shawn Green
-locks.html
See also:
http://dev.mysql.com/doc/refman/5.6/en/innodb-next-key-locking.html
http://dev.mysql.com/doc/refman/5.6/en/innodb-locks-set.html
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Specialist
Yours,
--
Shawn Green
MySQL Senior
://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_stats_sample_pages
http://dev.mysql.com/doc/refman/5.1/en/optimizer-issues.html
Feel free to ask the list any questions that may arise in your research.
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
if you
have a matching host pattern, post the list of host patterns you got
from the query to the list. We can tell you.
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
phpMysqlAdmin. When I do that, the only host that appears is localhost.
However, when I browse
.
If I have misinterpreted your intentions, please describe what it is you
are looking for and we can work from there.
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL
examples, see:
http://www.tocker.ca/2014/06/09/mysql-5-6-19-community-release-notes.html
--
Shawn Green
MySQL Senior 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
onto one of them (page
A, for example). However page B remains empty and becomes available for
any other purpose.
Is that what you are calling 'fragmentation' ?
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together
in advance.
Regards,
Antonio.
It makes a huge difference if the tables you are trying to optimize have
their own tablespace files or if they live inside the common tablespace.
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_file_per_table
--
Shawn Green
MySQL Senior
Hello Reindl,
On 6/24/2014 3:29 PM, Reindl Harald wrote:
Am 24.06.2014 21:07, schrieb shawn l.green:
It makes a huge difference if the tables you are trying to optimize have their
own tablespace files or if they live
inside the common tablespace.
http://dev.mysql.com/doc/refman/5.5/en
@localhost password, you can reset
it following one of the procedures provided here.
http://dev.mysql.com/doc/refman/5.6/en/resetting-permissions.html
Yours,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office
/5.6/en/connecting.html
)
./mysql -h 127.0.01 --port=3306 --protocol=TCP -u root -p mysql-admin
See also:
http://dev.mysql.com/doc/refman/5.6/en/access-denied.html
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work
. Another solution is increase the server resources.
Any ideas?
See above.
Thanks in advance.
Regards,
Antonio.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General
-servers.html
Really. I mean it. Don't do it.
--
Shawn Green
MySQL Senior 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
On 5/14/2014 3:45 PM, shawn l.green wrote:
Hello Bruce,
On 5/14/2014 2:11 PM, Bruce Ferrell wrote:
OK, put away the flamethrowers, I KNOW it's dumb.
I've been asked for the upteenth time is this possible and if so under
what conditions?
So I pose the question to the community, is it? Under
can also review the bug reports to see if this is something we
already fixed and in which release we fixed it
http://bugs.mysql.com/
Regards,
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville
with data and look into improving your skills immediately.
Regards,
--
Shawn Green
MySQL Senior 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
-database, object type per database (routines,
triggers), or global objects (events). What level of detail you want to
copy from your old instance into your new instance is completely up to you.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware
1 - 100 of 549 matches
Mail list logo