Yeh Thanks BUT EVERYTHING LOOKS CORRECT
can I give you super admin to fix the problem? see attached
I need this fixed....
Thanks

I have been a member of joomlapolis for about 10 years
I just paid my membership for CBuilder and CB subs again so I can get support from this forum
My Host is Hostgator this is what my conversation with them said.

As I keep asking you and you keep telling me a story about things that don't answer my questions look.

In phpmyadmin I have file see attached says DYNAMIC

OK SEE. SO MY QUESTION IS You are saying It is important to know that the changing to ROW_FORMAT: DYNAMIC is custom, and something you will have to contact a third party to perform for you.

In phpmyadmin I didn't change anything and it says
ROW_FORMAT DYNAMIC


see attached says DYNAMIC are you saying there is another setting somewhere to change?
ROW_FORMAT: DYNAMIC

Hello,

Thank you for contacting HostGator.

If you are seeing that it is enabled for phpMyAdmin, then I would assume there is nothing else to do. The entire situation with ROW_FORMAT is not with in our scope of support. We are not able to answer question you ask if they are not with in our scope of support. The reason we have said that you would need to update the ROW_FORMAT on your own, does not mean that it is not already setup. It just means that we will not be able to assist with that settting at all. Since you have provided a partial screenshot showing the ROW_FORMAT being set to dynamic. Then there does not seem to be anything else for us to assist with going forward. All of the settings you were asking about that we can look into are already set.


????????????????????????????Please let me know if you have any further questions or concerns.
???????

Sincerely,

Kyle B.
Tier 4 Web Administrator
HostGator.com

I've spent a lot of money on this project which the team has helped me.
I have this problem that looks like it should work . But it doesn't..I need support for this It looks like it should work.

I can't even edit or add new CBuilder members.

Thanks

HostGator said this,
Hello,

Thank you for contacting HostGator.

Per the linked MySQL information:
innodb_page_size can only be configured prior to initializing the MySQL instance and cannot be changed afterward. If no value is specified, the instance is initialized using the default page size. See Section 15.8.1, “InnoDB Startup Configuration”.

and

The default 16KB page size or larger is appropriate for a wide range of workloads, particularly for queries involving table scans and DML operations involving bulk updates. Smaller page sizes might be more efficient for OLTP workloads involving many small writes, where contention can be an issue when single pages contain many rows. Smaller pages might also be efficient with SSD storage devices, which typically use small block sizes. Keeping the InnoDB page size close to the storage device block size minimizes the amount of unchanged data that is rewritten to disk.

The value is set to 16k, which is the default:

mysql> show variables like 'innodb_page_size';
+

---

+

---

+
| Variable_name | Value |
+

---

+

---

+
| innodb_page_size | 16384 |
+

---

+

---

+

ROW_FORMAT is set on a per table basis. Querying your server it is showing:

mysql> show variables like 'innodb_default_row_format';
+

---

+

---

+
| Variable_name | Value |
+

---

+

---

+
| innodb_default_row_format | dynamic |
+

---

+

---

+
1 row in set (0.01 sec)

As we have stated previously setting a particular row format is beyond the scope of our support, but that doesn't mean that the server is not already configured the way that you are wanting by default. The values are set as this forum is recommending already. If the table is showing that the row format is "dymanic" in phpMyAdmin then that is the format that the table is in in MySQL.

If you are seeing errors that these changes are supposed to fix then it could be helpful if you upload the dump that you are attempting to restore and provide us with the path and filename for the dump, or if you can provide us with the query we can investigate further, but we are VERY limited in what we can do when an issue is out of scope. Genuinely your best bet is probably to get a professional database administrator to make any further massive changes required for your site to the database engine.

Please let us know if you have any further questions and if you have a couple of extra seconds, there is a quick three question survey at the bottom of this email.

Best Wishes
Jon T
Senior Linux Administrator
HostGator.com


I don't know what to do?
They said this above..... it could be helpful if you upload the dump that you are attempting to restore and provide us with the path and filename for the dump,.... I'm not doing a dump or restore?????

Thanks