MYSQL :: Benchmarks Of Runtime Versions Of Mysql Or Other Sql Versions Sqlite Hsqldb

Benchmarks Mysql Vs Sql Runtime Engines (sqlite & Hsql)
I current have a mysql database of approx. 80mb.
Each day I Insert approx .5mb of new records into this table,
and I might also run mutiple Update, Delete, and Select queries as
well.
I'm trying to get an idea of how fast a sql database engine will run
given that is is inside of the JVM. I know it's going to be slower
than a db engine written in C and that's a trade off for being
portable to different operating systems.

What I want to know is how much of a trade off though - I don't want
to have to wait 10 mins or deal with screen freezing... Right
now on a windows platform using mysql things move really fast.

MySQL Versions
I am using MySQL 5 on my computer but the web-hotel I am contemplating to use only use MySQL 4.0xx. Can I use the database without modifying it? Or do I need to "convert" (downgrade) it for MySQL 4.0xx? If so, how do I do that?

Running Two MySQL Versions
Actually what I want to do is remove 4.1 because I downloaded 5.0 and installed w/o removing the previous version. I now have port 3307 for 5.0. Is this a problem and how can I change it back to 3306 so e.g. when I use Apache/PHP evrything works?

Two Versions Of Mysql On Same Unix Box
I have mysql 3.23.58 version running on my unix box. I installed a new application on it which need mysql version > 4.0 so I thought of having two mysql versions running on the same unix box. I have first installation in /usr/local/mysql and I untared the new version in /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23.

I am following instructions given in http://dev.mysql.com/doc/refman/4.1/en/multiple-servers.html I also created a empty file and named it as mysql.sock.new and stored it in /var/local. When I try to start this new version from /var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23 using ./bin/mysqld_safe --datadir=/var/local/mysql-standard-4.1.18-pc-linux-gnu-i686-glibc23/data & it says "A mysqld process already exists". Please tell me where I am going wrong and how to configure it properly?

Row Select In Old Mysql Versions
We are using MySQL version 4.0.20-standard.

Our application requires a query to do a row select. From what I have found this version does not support rownum. We are unable to update the version of MySQL. Can anyone give us some support.

Running Two MySQL Versions
It seems that my computer is running two different mysql versions. When I'm trying to login to the database it refuse my password and giving me access to the test configuration. This is what i get in the event viewer.

Do you already have another mysqld server running on port: 3306 ?
Event id 100.

The problem occur when I changed my password for the database. I have turned off Mysql in local services but i think that that's the original version. When I start the xampp i think it starts the winmysqladmin version (not sure). How do I reconfigure the hole thing and how can I see what's running on my machine.

I actually have another question to. I'm trying to run and open the shell mysqladmin which doesn't work. It's just a flash, which one of them am I supposed to run?? You have several options like mysqladmin, mysql, mysqld, mysqld-nt....etc. I opened the winmyslqadmin which i think wasn't that good.

Downgrade MySQL Versions
I need to move a MySQL database created with MySQL 4.1.22 on PHP 5.2.3 to a different server with MySQL 3.23.58 on PHP 4.3.8.
Is it possible to convert the database to do this?
Alternatively, is there a way to export from the newer version in a format that the older version will accept?

Can Run Two Versions Of MySQL In Windows 2000?
I have been running 4.0.13 for several weeks now and though I'd like to =
test 4.1.0. 4.0.13 is under c:MySQL. I downloaded 4.1.0 under c:4.1 =
AlphaMySQL. When I try to launch mysql it brings me to the old =
version, how do I access the new one without killing the old one? (I =
have also tried putting 4.1.0 on a totally different machine and linking =
to it also.)

Previous Versions Of MySQL With XAMMP
I've downloaded XAMPP for Linux 1.5.1 for use on Fedora Core 4. I notice it only has the latest version of MySQL on it. I'm working on two web sites (for different clients) and they are hosted on different shared Linux hosting servers (with PHP), each with different versions of MySQL available, i.e:

MySQL 4.0.25-standard
MySQL 3.23.52

Is it possible for me to use older versions of MySQL with XAMPP? Could I just turn off MySQL in XAMMP and just run and older version of MySQL independently of XAMMP? If I can then how would I install multiple versions of MySQL in Fedora Core 4?

Symlinking Between Different Serveurs And MySQL Versions
I have a hosted server where we have both web and intranet share a same database. For interne reasons we need to migrate the intranet onto one of our servers and keep the web on the hosted server.

We will thus have the database splited in two. Our intern server willl have MySQL5 and our hosted one will remain with MySQL3.23.39 at list for a while longer.

I would like your advises on the faisability of using symlinking to access the tables on the hosted server from our intern server, knowing that MySQL version are different. The tables on the hosted side are MyISAM.

The main idea is to avoiding using replication to access comon tables on remote servers.

Utility To Convert Between MySQL Versions?
My webhost downgraded from mysql 5 to 4 and I'm seeing errors in the forum I was running. All I can see that would have changed and given me this database error would have been this downgrade. Is there a conversion utility availaible that can change back and forth between MySQL versions? I've looked around for about an hour thru Google and on this forum, but I haven't found anything yet.

I was getting password errors, but we seem to have resolved that issue, and now I'm left with this database connection error.

Thanks for any assistance!

P.S. The errors I get are:

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/clanloc/public_html/forum-old/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

Selecting Correct Versions Of MySQL
I have searched this forum and google to try and get a comprehensive answer to this question but i haven't found anything yet.
I am looking to select the correct versions of MySQL, Apache and Php so that they all work together. I notice that there are alot of issues with various different versions sets being chosen and there seem to be instances where it can be very problematic if the wrong one is chosen.
I am looking to use InnoDB and would like to use the latest versions of everything as possible but it doesn't really outline anywhere what works with what best. There are lots of cases that outline what can be problematic but i'm trying to avoid this if possible and find what isn't problematic.

Trouble With NATURAL JOIN Between MySQL Versions
I have this query which works perfectly well in MySQL 5, but doesn't work in 4.1.
I know there were some changes made to join syntax between the versions but for the life of me I can't figure out exactly what I need to do to fix it:

SELECT Status, UserName, FontName, FontPath
FROM AccountInfo
NATURAL JOIN AccountPrefs, Templates.Fonts
WHERE AccountPrefs.HeaderFont = Fonts.FontID
AND UserID = '$userID'
works fine in v5, but in v4.1 I get the old "Column 'UserID' in where clause is ambiguous".
I'm trying to match the UserID in AccountInfo and AccountPrefs, I just left the font thing in there as well because I'm not sure if it's contributing to the problem.

Alternative To Group_concat For Early Versions Of Mysql
Is there an alternative to group concat, if you are using a lower version of mysql. If any one has any ideas it would be great, currently my code (thanks to some one from these forums) looks like this.

SELECT c.clientID, group_concat(ci.interestID) as interests
FROM Clients AS c
JOIN ClientInterests AS ci ON c.clientID = ci.clientID
GROUP BY c.clientID
HAVING find_in_set(1, interests)
AND find_in_set(3, interests)

Is there any way of doing this on a lower version of mysql?
Is it possible to wirte a function similar to group_concat?

How To Detect If Different Mysql Versions Are Installed/runing
from my InnoSetup setup :) I need to detect if any version of mysql is runing on my windows. Others sugested to check fo a mutex or a Class Name(dont know what are these) or Windows Names or Look for a mysql*.exe, so is there something common for mysql starting with v3 .. v5? I mean what is the thing that i have to search for, to know at least if mysql is runing.

For mysql v3 there are the posible runing files:
mysqld.exe
mysqld-max.exe
mysqld-max-nt.exe
mysqld-nt.exe
mysqld-opt.exe
or on Win98 only winmysqladmin.exe?
For mysqlv4 .. im not sure yet
For mysql 5 seems to be more simple, only
mysqld-nt.exe

Do I have to search for all these files(and others that I dont know yet :) ) to be sure that its not runing?

Migrating A MySQL Db From Plesk Over To CPanel - Possibly Differant Versions Aswell ?
Hey all. As title, i had hosting on a plesk server, but was migrating everything over to cPanel due to a better package.

Ive run into some problems though, mainly due to differant versions i think. Anyone know of a way around this as it would be alot of work redoing the whole sites again

Versions
I have MySQL 5.0.24 installed on a XP Pro SP2 PC. The latest version is 5.0.41. I looked at the change logs and they say they are bug fixes only. Have there been any security issues with 5.0.24 that I should be aware of? Do I need to move to 5.0.41 to be safe?

Run 2 Versions
Is it possible to run both
MySQL 3.23 and
MySQL 5,
at the same time on the same machine with php4.3.0 and apache 1.3.27?
What should I consider ?

Two Versions
I wanna run MySQL 3.23.54 and MySQL 5.0 in the same Redhat Linux 9 box at the same time. Is it possible?

Differences Between Versions
We have two versions of mySQL running; version 4.1.15 on a couple of local machines under Windows XP Professional and our public database running 3.23.58 under Apache.

I was populating a new field in our members table based upon a match to a table called region using the following query

UPDATE members,region set members.FPosition_Id = 19
where region.Region_Commodore_Id > 0 and
region.Region_Commodore_Id = members.member_Id

The query ran fine locally (ver 4) but gave a syntax error on version 3. Is there a list of differences/updates between these two versions? Does version 3 not support update queries using multiple tables?

I tried parenthasizing the where statement but that made no change.

Versions Of AMP On Windows?
I am somewhat concerned that i have the right versions
of AMP on my Win XP system so it will all work together...
Is there some link that (in simple terms!) tells which versions are safe
together?

I currently have MySQL version 4.0.20d, with Apache 2.0.52 and php
4.3.10. Is this the best combination?

Two Versions On Same Machine
I had MySQL 4.2 - working fine. I saw version 5 is now stable so I downloaded and installed but did not run it (I think!). Carried on with 4.2.

Then one day MySQLAdmin and Query would not log me on. I checked via the cmd line utility and when I typed in the password the window dissappeared!

I opened MySQLAdmin again and reconfigured the log-on o 3307 (I remember this was default when I installed 5.0). OK, the server must be running. So keep with 5.0 as I managed to restore one of my schemas. I wanted a later version which is only in the 4.1 directories and copied it across BUT 5.0 does not see it. But when I go to stop and restart the 5.0 server in Admin as soon as I go to the server tab to do this it stops automatically! AND will not restart.

Comparing Versions Of Sql
I'm taking up a new position and have never used sql before although use
and code in lots of other languages. When doing a bit of survey I find
many many versions of commercial and public versions of sql. Can anyone
tell me if the syntax is generally similar or are they completely
different. If I invest time learning mysql on XP or Linux will that be
useful if I end up using something like Oracle later on? The only one I
would avoid is MS.... like things that work occasionally.

Removing Old Versions
I loaded a new version of Mandrake Linux 10.0 CE and have also installed and dowloaded a new version of MySQL 4. I'm not sure but think I have several versions installed and running ...

How can I check to see what is installed, what is currently running, and then perhaps remove them all and start by installing single new copy?

Compatibility Between Versions Of SQL
Hi! Would like to enquire if different versions of SQL are compatible to one another.
I've done some code in PHP and which requires access to MySQL on my server. I have tested it on localhost and everything worked fine. Hence, i decided to upload both my code and the database i created to the server. That's when the prob started. I received this msg while trying to view my page:

Could not connect to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

what this is about? For info, my MySQL version on my personal computer is 5.0 while that of the server is 3.23. Are the database compatible?

How To Keep Trace Of The Versions From A Table
From the Code that is been written below i need to keep trace of the versions that are been read from the file(test1.lst) each time it is been changed.Does anyone know as to how i can store it in diff tables(version_0701151004 version0701151100,version_0701161000 ....versionYYMMDDHHMM) each time when this query is been called? n how to keep trace of the date and time ?

or maybe is there any other method where i can store diff versions in diff files ? would be gratefull for any advice

--DROP TABLE stocklist_values;

CREATE TABLE stocklist_values(
SAG_FREIGABE INT(1) NOT NULL,
SAG_SNR VARCHAR(50) NOT NULL,
SAG_NAME VARCHAR(40),
GSM_RELEASE_VON VARCHAR(20));

LOAD DATA INFILE '/home/user945/database/test1.txt' INTO TABLE stocklist_values FIELDS TERMINATED BY '&'

Moving A Database Between Different Versions
I'm trying to move a database on a server with MySQL 4.1.19 to another with MySQL 4.0.27. Is this possible? I'm getting errors when trying to import the database.

XAMPP And MAMP Versions
I'm running an XAMPP version of mysql on a PC and the MAMP version on a Macintosh.
I just realized that I needed to change a couple of tables.
Can I change them on the MAMP version and then copy the appropriate files to the XAMPP version, and expect them to work?

Which files should I copy over ... .MYI, .MYD or both?

The MAC version is 5.0.19
The PC version is 5.0.27

I use Navicat to modify my tables on the mac and do not have this product for the pc.

Import Export With Different Versions
I am hosting a WP site locally on my computer, to test it before putting it online,
Now I have the hosted WP site online & ready to go, but I am having trouble loading the backup data from my computer into it.
When I go to import in the myPHP section, it gives me an error message of:
Import failed, You probably tried to load too big a file.
But the file is only 350kb! The max is 8Megs!
Double checking, it looks like the 2 databases are different versions. Would this be the problem?
If so, how do I go about downgrading the version on my computer? And once done, how would I transfer my posts & info onto it?

Compatible Versions Of Software
MySQL, Apache and Php are a fairly common trio from what i gather .... but there can be alot of problems getting them to talk to each other.

Windows And Linux Versions
I would like to know what are the main differences between windows and linux versions of this DB system.

I´m using it on linux but i´m planning to migrate to windows...

Is there any performance difference? Is it as solid as linux version? It´s of free use (under GPL) ?

I made a test here in windows and it seems to work well..

MySql Benchmarks
I have been searching the web high and low for articles about MySql capabilites that are written in straight forward plain english.What I really want to know is what is the maximum number of rows you can have in a MySql table?

I am thinking about building an application that will require my MySql table to hold a hell of a lot of inserts. The rows will only contain three or four columns with very small data in them and only one or two columns indexed but there will be many rows, probably 2 million rows a month.

Although there will be a lot of inserts there won't be much quering of the db.

I use a dedicated LINUX server with dual 3.2GHZ Xeon processors and 4mb of RAM

If anyone has worked on or built an application with similar workloads can you advise on how MySql would handle such an application given the above specifications.

Sqlite Vs Mysql In Windoz Coparison
i just tried the sqlite database on my windoz machine with the odbc
driver and it seems fast. i was reading about size limitations for sqlite
databases and it seems it would run good on databases of a couple hundred
megs.

Can anyone compare the performace for a few concurrent users (20),
and the ability to recover database problems such as corruption of data in
the windoz version of mysql and sqlite?

Sqlite Vs Mysql In Windoz Coparison
i just tried the sqlite database on my windoz machine with the odbc
driver and it seems fast.

i was reading about size limitations for sqlite
databases and it seems it would run good on databases of a couple hundred
megs. Can anyone compare the performace for a few concurrent users (20),
and the ability to recover database problems such as corruption of data in
the windoz version of mysql and sqlite ?

Benchmarks
------=_NextPart_000_0401_01C35A8D.94584FD0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

At the conference a few months ago, the mysql team said that the
benchmarks they where running would be published
here
http://www.mysql.com/benchmarks but it doesn't look like this is the
link.

Basically I'm trying to figure out what a saturation level is for mysql
when it has 2 2.4Ghz Intel XEON procs, 4GB ram, RAID-10 4-6 disk system
in a Red-Hat 7.3 environment. I ran some tests in the past but I'd like
to compare my tests verses other peoples or mysql.com itself.

Dump To SQLite
I am trying to dump the data to import in SQLite.
I used --compatible=ansi option.
What is the correct syntax / options to be used with mysqldump for this purpose?

Navicat For SQL Runtime
Does anyone know if there is a runtime for Navicat 7? The organization
I work for is interested in buying this product but we only need about
3 or 4 people to create reports, however, we want everyone to be able
to view the reports. So, I am trying to find (with little success) if
we will have to purchase a liscence for every computer even if the
users are only viewing data, or if we only have to purchase a liscence
for the people who develop reports, and the rest can use some sort of
runtime in order to access the reports.

Runtime Error
Microsoft Visual C++ Debug Library

Program C:mysqlinmysqld.exe

This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information.

(Press Retry to debug the application)

Abort Retry Ignore

When I pressed Ignore and restarted the server it solved the problem until the next morning the server had the same error. Do you have any idea how I can permanently fix this?

Runtime 3251
I'm someone be able to tell me why I am getting a runtime 3251 (recordset does not support updating?) error? I'm trying to put a field into a text box on an excel worksheet. I am able to use the same query and put the results in a row, but not in a text box...

' Create a recordset object.
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

'--->>>Create the SQL string
sqlString = "SELECT * FROM movie WHERE movie_name like ""Anchorman"""
With rs
' Assign the Connection object.
.ActiveConnection = cnnt
.Open sqlString
.Fields("movie_name").Value = TextBox1.Text '--->>>ERRORING OUT HERE<<<---
' Tidy up
.Close
End With

cnnt.Close
Set rs = Nothing
Set cnnt = Nothing
End Sub

Microsoft VBScript Runtime (0x800A01A8) Object Required: 'oConn'
I'm kind of stuck on a few changes I'm making to my coding. I'm putting connection strings into a sub in a file called functions.asp. however, when I try to send a query, the object does not seem to exist. strange thing is it works when I comment out Call ConnectDB("Members") in test.asp and uncomment

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=Users;OPTION=3"

please take a look at my code...

ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem.

I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:

Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root,
then type "mysql", I am able to connect to the server and run my
queries.

If I exit out of su so that I am my own id (baisley) and type "mysql",
I get this error: Can't connect to local MySQL server through socket
'/home/data/mysql/mysql.sock' (13)

Any idea why? mysql.sock has full permissions (read/write/execute), so
it should be accessable by user baisley. If I am baisley and I run
"mysql -u mysql" (as mysql is the user that the RPM set up), it will
connect.

What I would like to be able to do is run this without having to be
user mysql all the time. How do I go about setting that up, or is it
better to run all my queries/make tables as 1 user?

ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment:
ASP.NET ver 2
MySQL 5.0
FP Extensions 2003

Progression:
Developed Website Outline
Developed Database in Access2003
Migrated AccessDB to MySQL @ Hosting Service using Migration Tool.
Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there.

PROBLEM: (The heart of the matter)
Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get:

"Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.

ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away"

Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.

Warning: Mysql() [function.mysql]: Access Denied For User 'apache'@'localhost' (using
my script is not connecting to my database, i get this error

Warning: mysql() [function.mysql]: Access denied for user 'apache'@'localhost' (using password: NO)

Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean

Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6
Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6

Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6
here4
Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13

I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:

MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it.

So ... I get the following error when I try to connect:

MySQL Error Number 2003
Can't connnect to MySQL server on 'hostname'(10065)

Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:

How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states
and other countries on the other side of my router. But when I use the
MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN,
the driver tells me it cannot make the connection. Here are the ODBC
driver connection parms:

Data Source Name: (free field - name my "my linux box" will do nicely)
Host/Server Name (or IP) - something like MSQLUserName@ServerName.net
has worked fine for me in the past. Now I'm trying 192.168.1.106
Database Name - whatever, mysqldb works fine, any valid db

User - root
Password - myrootpass

Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now
SQL Command On Connect - haven't ever put anything here

Perhaps there is some configuration in mysql user privilege for the
mysqluser "root" that would prevent him from logging from a remote PC
to the mysql server?