Edit - Database Administrators Stack Exchange

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

Rev

1

You are correct about 48 bits but it is a CPU limit deliberately. See en.wikipedia.org/wiki/64-bit#Limitations and en.wikipedia.org/wiki/X86-64#Virtual_address_space_details

gbn
– gbn

2011-09-26 16:55:37 +00:00
Commented Sep 26, 2011 at 16:55
Although your answer is not MySQL-specific, I can relate to your bird's eye view of the OS, so +1 for that. Just to keep things in perspective, please remember the "guys at MySQL" are Oracle.

RolandoMySQLDBA
– RolandoMySQLDBA

2011-09-26 16:55:45 +00:00
Commented Sep 26, 2011 at 16:55
@gbn I was only pointing out that that's the limit everyone refers to for Linux, and I don't think that's accurate, but I can't speak to the Linux internals. But you're correct, everyone refers to the hardware limits.

jcolebrand
– jcolebrand ♦

2011-09-26 17:04:18 +00:00
Commented Sep 26, 2011 at 17:04
1

@RolandoMySQLDBA true, but without an OS to guide us, the answer has to be about the OS. And while it's true today that "the guys at MySQL are at Oracle", that doesn't mean that those guys have the experience per-se of the long-standing Oracle systems-dev gurus, nor does it mean that the team for MySQL has any desire to provide this construct (whereas the Oracle team may have the desire to provide the construct as asked above) .. tl;dr: meh, two different teams.

jcolebrand
– jcolebrand ♦

2011-09-26 17:06:07 +00:00
Commented Sep 26, 2011 at 17:06
@jcolebrand : I believe Oracle has the expertise (they exercise it within Oracle10g/11g). However, it's the desire part towards MySQL that strikes the biggest chord. +1 on your last comment.

RolandoMySQLDBA
– RolandoMySQLDBA

2011-09-26 17:22:53 +00:00
Commented Sep 26, 2011 at 17:22

| Show 5 more comments

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)

<https://example.com>

[example](https://example.com)

<a href="https://example.com">example</a>

formatting help »
answering help »