 | | | MySQL General | | Hi guys
I 'm new to MySQL it 's been just few days since I 've installed it and started playing with it.
I 'm migrating web application from another database which gives us too many problems. So farLook it through
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.com/mysql?unsub mysql@(protected)VBMySQL.com is pleased to announce the launch of a new projects page at
http //projects.vbmysql.com.
The first (and flagship) project is VBMySQLDirect. VBMySQLDirect is a
new MySQL C API wrappeMy best guess is somewhere around summer 2005
On Wed 2004-03-17 at 09 41 Garg Piyush (EM GECIS) wrote
> Hi Everyone
>
> Can you please tell what is the expected date for the Production r-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Randall Cayford wrote
> JDBC driver mysql-connector-java-3.0.11-stable-bin.jar
>
>
> Randall Cayford wrote
>
> > > > I am new to mysql so thi
Gabriel Alessandria wrote
> I am a user of Microsoft Sql Server and use very much the function Datediff
> (interval fecha1 fecha2) to extract differences between two dates in
> years days I am new to mysql and am converting an existing program. I have
encountered what appears to be a problem with bigints
I have a large integer number (milliseconds since 1970) which is 13
digits-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Eric B. wrote
> Hi
>
> I 've recently upgraded from 4.0.8a to 4.0.18 and am running into a
strange
> error in the JDBC connector. If the DB If it was me writing the code I 'd use two different update statements
a) an UPDATE to initialize the DateTime to Now() and set the counter to 1
when the page is first hit
b) another UPDATE to i-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
The docs aren 't clear on this. Is mysql_close needed on a MYSQL struct
previously initilized with mysql_init after a failed mysql_real_connectHello
I 'm trying to determine the best way to optimize the query below. Right now
it is taking around 9mins and we need it to take no more than 30 seconds (we
can get it under 30s on MS SQL)
"van der Scheun Willem (GXS) " <Willem.vanderScheun@(protected) > wrote
> I 'm new to mysql and I just installed 4.1.1 and ran into trouble combining a
> subquery and 'order by '. I guess the 3 queries beThe short answer is no not using MySQL built in transaction system. What I
do for things like this is add a field to the table that indicates whether or
not the record is locked. It is usually a "Austin Hastings " <Austin_Hastings@(protected) > wrote
> I 'm not sure if this is a bug or a user failure so I 'm going to ask here
> before doing anything rash.
>
> I 'm trying to classify a single filter select mysql
Solaris 3.23.40 connections using perl jdbc odbc.
Yesterday we experienced a rare mysqld failure where all connections
where in the state "Opening table ". Normally ourHello
I only have one server available to be set up to handle a lot of data. I
have looked through some documentation and am a little confused. So I
thought I would get the opinion of someone whi listers
how would i determine the association between the id from mysqladmin processlist to a pid?
what i 'm after is that i notice some of the mysql threads have a high cpu utilization. i see > correctly on my web page. Querying the database with the mysql client I
see
> that the character ?in the word Supervisi?n is ok but when my web app
> queries the database the web page displays SIn order to get the max performance from our servers we 're reading every bit
we can lay our hands on about performance tuning.
In this document
http //www.phpconference.de/2003/slides/business_traOn Tue 9 Mar 2004 10 52 38 +0100
"Martijn Tonies " <m.tonies@(protected) > wrote
> > I 'm running
> > mysql Ver 12.21 Distrib 4.0.15 for suse-linux (i686)
> > ps says I 'm running mysql-max
> * Franz Edler
> I have a perhaps simple problem but it 's a problem for me
>
> I have made the following GRANT statement
> mysql > GRANT ALL ON ser.* TO root@(protected)
> Query OK 0 rowsI 've been reading this thread but I can 't see the advantages of storing
files in a database.
I 've always had the impression that a *file* system was the appropriate
place to store files.
AccessIvan Sergio Borgonovo <mail@(protected) > wrote
> On Tue 9 Mar 2004 10 52 38 +0100
> "Martijn Tonies " <m.tonies@(protected) > wrote
>
> > > I 'm running
> > > mysql Ver 12.21 Distrib 4.0.15 Hello All!
After we converted our tables from MyISAM to InnoDB the database
became very slow!
The same database on another machine on MySQL 3.23.58 works very good.
The machines are identical mAnyone any idea how I could rewrite this as a join - all the indexes are in
place and each of the components of this work fine - its only when the
combined subqueries are passed to the root query doLorenzo Rossi <lrossi@(protected) > wrote
> Hi.
> My system is Slackware 9.1.
> MySQL is the default version installed on Slackware cdrom while system
> installation so I hope all the path are ok I 'd like to modify the email send I presently get
from the Perl script when a new record is
submitted from the form to contain an email link
which if I click on it will update MySQL.
Anybody knowOn Mon 2004-03-08 at 15 52 David Scott wrote
> OK here is a problem that has been bugging me for some time.
>
> If I have a table like this showing 3 visitors to a website and the pages they Lianghwa Jou <ljou1@(protected) > wrote
>
> Mysql seems to insists that all tables must be locked if one table is
> locked in a select statement. Why ?
>
> For example-
>
> lock tables A WRITDid anyone refer you to the following page in the manual?
<http //www.mysql.com/doc/en/example-Maximum-column-group-row.html >
Your proposed solution seems equivalent to the 2nd of the 3 solution |
|
|
