Skip to content

Instantly share code, notes, and snippets.

View wedgemartin's full-sized avatar

Wedge Martin wedgemartin

View GitHub Profile
@wedgemartin
wedgemartin / gist:800612
Created January 28, 2011 17:38
Why is this query not hitting an index?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| activities | CREATE TABLE `activities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`ip` varchar(255) DEFAULT NULL,
`activity_type_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`publisher_id` int(11) DEFAULT NULL,
|
+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@wedgemartin
wedgemartin / gist:800652
Created January 28, 2011 17:58
innodb free buffers 0
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7,
175 inserts, 175 merged recs, 148 merges
Hash table size 1106407, node heap has 1666 buffer(s)
13281.21 hash searches/s, 46230.21 non-hash searches/s
---
LOG
---
[wedge@precious-3 bg:0 cm:512 05:02:28 /tmp/fix/badgeville]
$ git submodule sync
No submodule mapping found in .gitmodules for path 'accounts/badgeville'
[wedge@precious-3 bg:0 cm:513 05:16:25 /tmp/fix/badgeville]
$ cat .git/config
[core]
repositoryformatversion = 0
filemode = true
bare = false
logallrefupdates = true
@wedgemartin
wedgemartin / keybase.md
Created June 19, 2018 21:02
keybase.md

Keybase proof

I hereby claim:

  • I am wedgemartin on github.
  • I am wedgemartin (https://keybase.io/wedgemartin) on keybase.
  • I have a public key ASDuwQwah2Hbsc0VN5jhKTzY7DFWqJjNxGKiV5yBibGOkQo

To claim this, I am signing this object:

const App: () => React$Node = (props) => {
const [ players, setPlayers ] = useState([]);
useEffect(() => {
AsyncStorage.getItem('@maddness_user').then((userData) => {
getNearbyPlayers();
performStompConnect();
}
});