also have
a way 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! Visi
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
other accounts could also have 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 Enginee
our 8.0 server with user accounts.
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
vity
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. - I
?
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
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 to
here the
ON clause 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 st
even if a 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?
--
Shaw
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
.
*From:* shawn l.green
*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 wrote:
Good day guys,
I
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/
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 data. This how ever cannot be
rolled bac
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 &
here
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 Prin
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/certification/
at
is writeable (and accessible to the user that your mysqld 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&qu
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
Organization: Oracle Corporation
To: Chris Knipe
Hello Chris,
On 6/13/2017 5:42 PM, Chris Knipe wrote:
Hi all,
Can someone
a new 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! Vi
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
does not mean
that 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
setup, 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 Prin
.mysql.com/doc/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/
ails explaining why mysqld was unable 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
g serialized via that cache mutex.
You do 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)
aga
e session remains 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 Applicatio
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 &
tiple-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
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
ges that 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
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
and consistent update to 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 certifie
START TRANSACTION 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.
--
M
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
D NOW()
AND (
acctstoptime <= 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 Senio
looking at
non-transactional tables to make changes that are out of sequence.
It's 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
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
you compare the HEX() 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
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.
no - not
make it impossible to
read the data. It'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 c
mal (clear-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
Oracl
On 1/28/2016 6:30 PM, Larry Martell wrote:
On Thu, Jan 28, 2016 at 5:45 PM, shawn l.green wrote:
On 1/28/2016 3:32 PM, Larry Martell wrote:
On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green
wrote:
On 1/28/2016 1:14 PM, Larry Martell wrote:
On Tue, Jan 26, 2016 at 8:40 AM, Hal.sz
On 1/28/2016 3:32 PM, Larry Martell wrote:
On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green wrote:
On 1/28/2016 1:14 PM, Larry Martell wrote:
On Tue, Jan 26, 2016 at 8:40 AM, Hal.sz S.ndor wrote:
2016/01/25 19:16 ... Larry Martell:
SELECT IFNULL(f_tag_bottom
r_axis'
... repeat for the 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 Techni
hat link I 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
also reporting this as a bug.
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 detai
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
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
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/certi
ts you 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,
On 10/22/2015 11:48 AM, Don Wieland wrote:
On Oct 20, 2015, at 1:24 PM, shawn l.green 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 results. (sometimes it is a good id
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 Pr
plication in real world
situations. They are 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 cer
d 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 i
FROM fruit f
LEFT JOIN purchases 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
y query your stats for any rows where
`quarter`>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
a SHOW GRANTS command (without 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
t
d directly in a shell
session, not via the services 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
enced programmer and have trouble wrestling with the
command line. But I think I did my 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 sni
pair_tasks(
task_id int auto_increment
, task_description varchar(25)
, appliance_id int not null
, component_id int not null
)
That way you can have two tasks for the same device. For example,
A task of "attach door seal" would associate the fields (refrigerator,
door seal). So would &
ot 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 Prin
things are.
Any help greatly appreciated.
@Andy - a.sm...@ukgrid.net -
you haven't said what OS you are installing this on or how you have installed
MySQL.
Yes, he did but not directly and not completely. He is installing on
some version of Fedora using a YUM repository.
@Steve
a transfer) then a shorter -net-write-timeout
or --net-read-timeout would 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,
tbl1
LEFT 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
le using INSERT...SELECT... 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 S
fman/5.6/en/innodb-row-format-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
ng which id value you
want to keep and discard the other copy of the row.
--
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
Hello Larry,
On 2/4/2015 3:37 PM, Larry Martell wrote:
On Wed, Feb 4, 2015 at 3:25 PM, shawn l.green 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
wrote:
Hi Larry,
On 2/1/2015 4:49 PM, Larry Martell wrote:
I have 2 queries
Hi Larry,
On 2/4/2015 3:18 PM, Larry Martell wrote:
On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green 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 clause, takes 3 minutes
uot; estimates for
each phase being considered.
http://dev.mysql.com/doc/refman/5.6/en/optimizer-trace-table.html
http://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
n a
lab 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
REDO
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 Tog
ogram-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 Tog
o monitor the emails than the forum simply
because the most recent response 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 foru
'b')
WHERE WORD like 'a%' or WORD like 'b%'
Note: this last format doesn't need the second if() in the 'else'
portion of the first IF() function because the set of rows to be
operated on is already limited by the WHERE clause. The rows will ma
l.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, Engineer
LECT
hourlist.hr as theHour
, avg(login_count) as nrAgents
FROM tmpAgentCount ac
RIGHT JOIN (SELECT 0 as hr UNION ALL SELECT 1 ...) as hourlist
on hourlist.hr = ac.log_hour
GROUP BY hourlist.hr;
==
Another way to do this is to skip the totals-per-day steps by counting
up how many days each ho
like to address first?
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: Bloun
o add 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
t. 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 Tech
uction Linux box)
and executing your bash-based scripts from within that session?
Except for being able to have the great Linux tools cross compiled to
work on Windows (all sorts of goodies that Windows does not natively
have like grep, sed, awk, less, ...) that comes from installing Cygwin,
issions to use the rsh
command than MySQL. MySQL should never operate on port 554 as that is
already reserved for a different well-known service.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Bloun
-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
building 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?
--
S
t; 0 290315608 undo 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
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, whe
ur password hashes. If you don't know 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 Wor
ons.html (search
for "ANALYZE TABLE determines index cardinality...")
http://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
+-+-+--+-+-++
4 rows in set (0.20 sec)
If you can verify that I have correctly stated what you are trying to
do, we (the list) can try to help you do those steps more efficiently.
If I have misinterpreted your intentions, please describe wha
n be analyzed, possibly improved, and
potentially merged into the actual source code. For some recent
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 Softwa
page. This puts the data from both pages 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
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
have followed the mysqltuner recomendations ...
Thanks 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#sy
l.com/doc/refman/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, Enginee
igure
SSL-based connections.
If you have forgotten your actual root@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
t all data. 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
--
MyS
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
oc/refman/5.6/en/multiple-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.
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
1 - 100 of 554 matches
Mail list logo
