Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #16  
Old 25 Jun 2014, 10:27
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Is it a varchar? Max value of a varchar can be 65535, but maybe you should use `text` instead.

Edit: refer to http://stackoverflow.com/a/18459732/1961685 if you want to make the values to be truncated instead of showing the error.

Last edited by Dave; 25 Jun 2014 at 10:33.
Reply With Quote
  #17  
Old 04 Dec 2014, 06:47
kemraj kemraj is offline
 
Join Date: Aug 2014
How to convert my current vbulletin database to MariaDB? Should all the tables be converted or just some.
Reply With Quote
  #18  
Old 04 Dec 2014, 06:49
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Do the whole database

https://mariadb.com/kb/en/mariadb/do...ql-to-mariadb/
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #19  
Old 04 Dec 2014, 08:44
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
You don't have to change anything in the database yourself, all you're changing is the software. Everything else will be the same.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #20  
Old 04 Dec 2014, 17:45
kemraj kemraj is offline
 
Join Date: Aug 2014
but do the tables need to be changed to aria engine to utilize MariaDB?
Reply With Quote
  #21  
Old 04 Dec 2014, 18:01
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by kemraj View Post
but do the tables need to be changed to aria engine to utilize MariaDB?
Not sure about vB 3.*, but on vB 4.* I only changed the software and didn't alter the tables or database at all.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #22  
Old 04 Dec 2014, 18:18
kemraj kemraj is offline
 
Join Date: Aug 2014
my host currently has MariaDB installed, And i did alter some of the Tables to the engine aria and it did made a huge improvement. So i was thinking about doing all the tables.
If you look at this

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MYISAM
[--] Data in Aria tables: 8M (Tables: 24)
[--] Data in MyISAM tables: 303M (Tables: 379)
[--] Data in InnoDB tables: 1M (Tables: 78)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1020K (Tables: 2)

you will see how much tables are in aria, myisam and innodb, what i was thinking about since my transition from phpbb to vbulletin some of my tables was automatically converted from myisam =to innodb.
So i was thinking the situation will apply here as well to convert the tables to aria to utilize MariaDB.
So i don't know if i'm wrong but i did notice a huge increase in speed when doing so.

"MariaDB uses by default the Aria storage engine for internal temporary files, instead of MyISAM. If you have a lot of temporary files, you should add and set aria-pagecache-buffer-size to the same value as you have for key-buffer-size. "
https://mariadb.com/kb/en/mariadb/do...mysql_upgrade/
Reply With Quote
  #23  
Old 24 Feb 2015, 22:47
thetechgenius's Avatar
thetechgenius thetechgenius is offline
 
Join Date: Jun 2014
Why would you want to switch Databases if they both have just about the same features? MySQL has just been around for a lot longer (I think so anyway), so its a lot older and more mature.
__________________
TheTechGenius.Net Official IRC Network (ONLINE)
Host: irc.thetechgenius.net
Port: 6667
TTG IRC Web Client - http://thetechgenius.net/irc.html
Reply With Quote
  #24  
Old 25 Feb 2015, 02:55
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Originally Posted by thetechgenius View Post
Why would you want to switch Databases if they both have just about the same features? MySQL has just been around for a lot longer (I think so anyway), so its a lot older and more mature.
Oh dear... MariaDB is superior for many reasons; MySQL is dying (kind of).

MariaDB is a fork of MySQL thus has everything that MySQL has plus more plus decent support and bug fixes.

See this for all the good reasons to switch:
http://www.vbulletin.org/forum/showthread.php?t=317249
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #25  
Old 04 Mar 2015, 01:57
thetechgenius's Avatar
thetechgenius thetechgenius is offline
 
Join Date: Jun 2014
Originally Posted by AusPhotography View Post
Oh dear... MariaDB is superior for many reasons; MySQL is dying (kind of).

MariaDB is a fork of MySQL thus has everything that MySQL has plus more plus decent support and bug fixes.

See this for all the good reasons to switch:
http://www.vbulletin.org/forum/showthread.php?t=317249
Oh wow, really? I didn't know that. I will have to look into it, maybe I will switch also. Thanks for the info!
__________________
TheTechGenius.Net Official IRC Network (ONLINE)
Host: irc.thetechgenius.net
Port: 6667
TTG IRC Web Client - http://thetechgenius.net/irc.html
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:09.

Layout Options | Width: Wide Color: