Fluid Hosting Forums  
HomeWeb HostingSupportContact UsAbout UsForums |

Go Back   Fluid Hosting Forums > General Forums > News, New Features, and Improvements

Reply
 
Thread Tools Display Modes
Old 03-22-2004, 08:11 AM   #1
allera
Registered User
 
Join Date: Nov 2003
Location: Palm Beach, FL
Posts: 685
Mysql Upgrade to 4.0.17

Mysql will be upgraded over the next week to the new 4.0.x line. This will bring the following improvements:

- The InnoDB storage engine is now included in the standard binaries, adding transactions, row-level locking, and foreign keys.
- A query cache, offering vastly increased performance for many applications. By caching complete result sets, later identical queries can return instantly.
- Improved full-text indexing with boolean mode, truncation, and phrase searching.
- Enhanced MERGE tables, now supporting INSERT statements and AUTO_INCREMENT.
- UNION syntax in SELECT.
- Multiple-table DELETE statements.
- libmysqld, the embedded server library.
- Additional GRANT privilege options for even tighter control and security.
- Management of user resources in the GRANT system, particularly useful for ISPs and other hosting providers.
- Dynamic server variables, allowing configuration changes to be made without having to stop and restart the server.
- Improved replication code and features.
- Numerous new functions and options.
- Changes to existing code for enhanced performance and reliability.

We're excited about this upgrade and we hope you take advantage of its benefits.
__________________
Alex Llera
Certified Server Reboot Monkey
allera is offline   Reply With Quote
Old 03-23-2004, 03:29 AM   #2
AlexanderT
Registered User
 
Join Date: Jun 2003
Posts: 402
Quote:
We're excited about this upgrade and we hope you take advantage of its benefits.
Definitely cool!
AlexanderT is offline   Reply With Quote
Old 03-23-2004, 08:09 PM   #3
nvphone
Events May Change
 
nvphone's Avatar
 
Join Date: Apr 2003
Location: America
Posts: 269
You guys keep fixing the place up and I will have to start wiping my feet before I log on!
__________________
Have a Nice Day!
nvphone is offline   Reply With Quote
Old 04-05-2004, 03:27 AM   #4
AlexanderT
Registered User
 
Join Date: Jun 2003
Posts: 402
It's installed, and appears to be running "fluidly"...

Seriously, I think the MySQL Upgrade is a huge improvement in speed.

Last edited by AlexanderT; 04-05-2004 at 05:05 AM.
AlexanderT is offline   Reply With Quote
Old 04-13-2004, 10:13 AM   #5
theOG
I love M$, Apple, & Palm
 
theOG's Avatar
 
Join Date: Apr 2003
Location: In the Fluid Hosting Servers
Posts: 766
Mysql Upgrade to 4.0.17

LOL... and what can this do for me IN PLAIN English....

Sounds French....
theOG is offline   Reply With Quote
Old 04-13-2004, 06:01 PM   #6
masoud
Registered User
 
Join Date: Feb 2003
Posts: 13
Wink

Quote:
Originally posted by theOG
Mysql Upgrade to 4.0.17

LOL... and what can this do for me IN PLAIN English....

Sounds French....
Well then OG, if you want to do some serious web development you should go and learn french then. Should'nt you??
masoud is offline   Reply With Quote
Old 04-13-2004, 06:13 PM   #7
theOG
I love M$, Apple, & Palm
 
theOG's Avatar
 
Join Date: Apr 2003
Location: In the Fluid Hosting Servers
Posts: 766
Always got to be on in the group...

theOG is offline   Reply With Quote
Old 04-13-2004, 06:46 PM   #8
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
Quote:
Originally posted by theOG
Mysql Upgrade to 4.0.17

LOL... and what can this do for me IN PLAIN English....

Sounds French....
Basically, it introduces a few new items to the SQL syntax.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 04-13-2004, 07:16 PM   #9
theOG
I love M$, Apple, & Palm
 
theOG's Avatar
 
Join Date: Apr 2003
Location: In the Fluid Hosting Servers
Posts: 766
LOL... anything plug-in-play? What can it do for the "FrontPage" developer who does not do SQL? I do like to use the database capabilities on the web.

Do I need to hire a web developer to take advantages of the new tools?



thanks,
theOG is offline   Reply With Quote
Old 04-13-2004, 10:45 PM   #10
FH-John
Fluid Hosting Tech
 
FH-John's Avatar
 
Join Date: Feb 2003
Location: Washington
Posts: 4,177
Cool

As for Frontpage, it wouldn't effect that. If you wanted to use it, you'd need to develope something for it, or download something.

It really depends on what you want to do.
__________________
John T. Yocum
"An empty stomach is not a good political adviser." -- Albert Einstein
"There never was a good war or a bad peace." -- Benjamin Franklin
FH-John is offline   Reply With Quote
Old 04-14-2004, 05:39 AM   #11
allera
Registered User
 
Join Date: Nov 2003
Location: Palm Beach, FL
Posts: 685
The mysql servers have all been moved to one beefy machine. I'm pretty sure most if not all of the kinks have been worked out, but let me know if you guys see any problems with your websites.

I'm using this thread because I'm sure a bunch of you die-hard mysql users are registered to it, so I'd like you guys to check out your sites before I dub it successful and alert everyone else.

If you have any problems, just send them over to support@fluidhosting.com.

In case you have connection problems, make sure you're connecting to mysql1.fluidhosting.com (66.150.201.91). This is affecting Shared Hosting customers only.
__________________
Alex Llera
Certified Server Reboot Monkey
allera is offline   Reply With Quote
Old 04-14-2004, 09:29 AM   #12
brian
Registered User
 
Join Date: Aug 2003
Location: Tennessee
Posts: 88
Quote:
Originally posted by allera
I'm using this thread because I'm sure a bunch of you die-hard mysql users are registered to it, so I'd like you guys to check out your sites before I dub it successful and alert everyone else.
Not exactly a heavy user, but I do have 3 different mySql databases and they all seem to be performing just fine.

brian
brian is offline   Reply With Quote
Old 04-14-2004, 02:49 PM   #13
relworg
Registered User
 
Join Date: Feb 2004
Posts: 150
Everything was working fine yesterday. Today I can still login and use mysql through my websites (php), but the webbased administration seems to be down.

Today I am unable to login to myphp.fluidhosting.com to administrate my mysql database. Everything was working fine last night (was using it at 10:30 pm PST Tuesday). I am trying to login with users that have full permissions to the database, on two separate FH accounts with multiple databases. I get the same error:

Server mysql1
Error

MySQL said:


#1045 - Access denied for user: **deleted**
(Using password: YES)
relworg is offline   Reply With Quote
Old 04-14-2004, 03:36 PM   #14
FH-Dave
Fluid Hosting Staff
 
Join Date: Feb 2003
Posts: 3,302
phpmyadmin access should be fixed now. Let us know if you still have any problem with phpmyadmin.
__________________
Do to others what you would want others do to you.
FH-Dave is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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 Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 04:49 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright© Fluid Hosting WebHosting Services