MySQL table size 4.7MiB – emember_country_lookup

[coabirder]

I was perusing my WordPress MySQL database and noticed that the emember_country_lookup table size is 4.7MiB. This seems ginormous compared to other eMember/eStore tables. Upon browsing it there are 184 pages of 500 entries so something doesn’t seem right with that table.

Thanks for your help.

Steve

[admin]

Our main plugin never creates any table like that. So that’s not from our main WP emember plugin. Are you using any addon or a customization on this site that probably uses that table?

[admin]

I just double checked all our emember addons and I think you are using the Stats/Analytics addon which will use that table.

Stats work by saving all the data on each visit of your members. So it can grow to be a large size as it keeps storing more and more data for the stats. You can’t have stats and analytics without storing data for it. So if you don’t want to use the stats addon, simply deactivate that addon then you can delete that Database Table.

[coabirder]

Thank you for your reply. I’m thinking this data from the emember_country_lookup table might not be the “Stats” table you’re thinking of. Below is a sample from the beginning of the table (please excuse the formating) and another from the end. Note that there are >91K entries to this 4.7MiB file!! I have yet to take any action as I’d like to understand exactly what is generating this table before removing it as I’m sure you’d understand.

There is another table called emember_stats_tbl where I do see data related to members.

[Beginning of country_code_lookup table]
Full texts
id
ip_from
ip_to
country_code2
country_code3
country_name

Edit Edit
Copy Copy
Delete Delete
1
33996344
33996351
GB
GBR
UNITED KINGDOM

Edit Edit
Copy Copy
Delete Delete
2
50331648
69956103
US
USA
UNITED STATES

Edit Edit
Copy Copy
Delete Delete
3
69956104
69956111
BM
BMU
BERMUDA

Edit Edit
Copy Copy
Delete Delete
4
69956112
72349055
US
USA
UNITED STATES

————————

[from near the end of the table]

Full texts
id
ip_from
ip_to
country_code2
country_code3
country_name

Edit Edit
Copy Copy
Delete Delete
91701
3716537472
3716537535
AU
AUS
AUSTRALIA

Edit Edit
Copy Copy
Delete Delete
91702
3716537536
3716537567
HK
HKG
HONG KONG

Edit Edit
Copy Copy
Delete Delete
91703
3716537568
3716537599
JP
JPN
JAPAN

Edit Edit
Copy Copy
Delete Delete
91704
3716537600
3716538367
AU
AUS
AUSTRALIA

————————

Also, note that our site is pretty local to CT USA and it certainly puzzles me to see HUGE numbers of entries from other countries hence my question about this table and eMember.

Your support form isn’t very kind with cut/paste or attachments or I’d share more of what I’m seeing in phpMyAdmin.

Thanks for your continued assistance.

Steve

[admin]

The stats table needs to create multiple tables. The country one ALSO comes from the stats table (I have double checked the code of the stats addon). Bottom line is, you can’t have stats without a lot of data in various tables. Then the plugin connects those data to show the stats when you are viewing it. That’s how stats and analytics work in general. Please deactivate the emember stats addon and delete the DB tables.

[coabirder]

Thank you for the detailed explanation. So I did try deactivating the eMember Stats plugin; then deleting just the emember_country_lookup table; then activating the plugin again. The emember_country_lookup table came back 20% larger just to spite me 🙂

I’ll be leaving it alone now. I’ve decided that analytics is more important than a smaller WP database so I’m keeping the plugin installed after all.

Thanks very much for your help.

Steve

[admin]

The database size is actually not an issue (unless your are running out of space on your database). The tables created by this addon is only used by the addon so the data just sits there. It won’t cause any issue in terms of front-end performance since it is not loaded on the front-end. This particular data is only loaded by the addon when you go to the stats menu.

[Author]

Posts