I wrote:
>I apologize for asking such a basic SQL question, but I am failing in finding
>the solution...
>Consider the following table:
>id | option
>---
>1 | a
>2 | a
>2 | b
>I want to find the ids with only a specific set of options.
>For example, if I wanted to get the ids which hav
Hi Heikki,
one more question please about innodb_flush_log_at_trx_commit: if there
was some way of increasing the delay between log flushes more than 1 sec,
can you estimate will it bring any real effect in performance? I know
it'll raise the risk of losing some last transactions if something
cra
Mark,
> I notice that lots of mysql gui's all can find out the contents (tables)
> of any given database, how do they do this?
>
> Is it an sql command?
Parse the contents of "SHOW DATABASES" and then use the ouput of that to
"SHOW TABLES"...
mysql, query.
DSL
---
On Fri, 6 Sep 2002, Mark Worsdall wrote:
> Hi,
>
>
> I notice that lots of mysql gui's all can find out the contents (tables)
> of any given database, how do they do this?
>
> Is it an sql command?
>
> I hope so, I need to know what the SQL command is so I can pass it to
> perl DBI.
>
> M.
Try
The command "show tables;"
will give you what you want.
See: http://www.mysql.com/doc/en/SHOW.html
Gurhan
On Fri, 2002-09-06 at 02:42, Mark Worsdall wrote:
> Hi,
>
>
> I notice that lots of mysql gui's all can find out the contents (tables)
> of any given database, how do they do this?
>
> I
show tables from database;
- Original Message -
From: "Mark Worsdall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 2:42 PM
Subject: How to read table names within database?
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
I hope so, I need to know what the SQL command is so I can pass it to
perl DBI.
M.
--
Mark Worsdall
https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ
By binary menas.. I have downloaded the mysqlmax binary version 3.23.52 on
solaris 2.8.
I have created a user defined function and when I try to create that
function in the mysql databse I get the following error
ERROR 1126: Can't open shared library 'PosMax4SubsDll.so' (errno: 0 ld.so.1:
/us
r/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 06 September 2002 06:22, Chugh Shalini wrote:
> Can my user defined functions work well if I have installed mysql from the
> binary source??
It depends on which binary you mean. We try to link our binaries statically on
platforms that sup
Can my user defined functions work well if I have installed mysql from the
binary source??
Filter
sql, query, mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
If you want it to be as fast as possible, you might want to consider doing
the following:
1. Arrange your data so that the records are fixed length.
2. If possible, switch to something other than a relational database. A
binary search on fixed-length, sorted records is probably going to be your
I don't know anyone who's done it but I can think of no reason why it
wouldn't be possible.
Now whether it is a good idea is another idea entirely. Without a live
backup server (slave) running off hard disk and a very powerful battery
backup system, you're just begging to lose all your data. No
Hi,
Suppose there is a sql table with the following fields and values:
+-+
|username|start|stop |sessiontime|
++-+--+---+
|mehdi | 2002-08-12
I've got a question about MySQL that I've been wondering but havn't been
able to try.
Would there be a noticable performance gain if I were to put my tables on a
Linux ramdisk (disregarding any size constraints)? Would it be feasible? and
under what conditions would there be a difference?
I've g
You can't do it..
The only way i could suggest , actually kind of workaround is, set the
pager to the command you would like to execute. Say you wanna see the
output of command ls, then do
mysql>pager ls;
and then just execute a query, it will print the output on the screen.
Then just do
mysql>
Pada Thu, 5 Sep 2002 12:35:45 -0400
"Jamie Beu" <[EMAIL PROTECTED]> menulis :
> I am still having problems with the slave server being able to connect to
> the master, but a thought occured to me while we were working another topic.
>
> Please let me know what I'm missing. I can do the following
Pada Thu, 5 Sep 2002 09:39:33 -0700
"James Kelty" <[EMAIL PROTECTED]> menulis :
> mysql,query
>
>
> Hello,
>
> Maybe I'm an idiot, but I can't find any documentation on how to stop
> running queries interactively. The only thing I can come up with is to stop
> and restart the server. I don't w
Pada Thu, 5 Sep 2002 16:57:35 -0500
"Darryl Hoar" <[EMAIL PROTECTED]> menulis :
> 020904 21:41:45 mysqld started
> 020904 21:41:45 bdb:
> /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql-max-3.23.42-pc-sco3.2v5.0.6-i386
> /data/log.01: Permission denied
> 020904 21:41:45 bdb: PANIC: Permission
Hi,
Within mysql how do I call a UNIX command, e.g to list a UNIX
firectory/files.
Much thanks.
Daniel
This e-mail message (and attachments) is confidential, and / or privileged and is
intended for the use of the addressee only. If you are not the intended recipient of
this e-mail you mus
Hello, Jules,
You can use the "value in (a,b,c)" format. If necessary, implode your array
and do something like this:
SELECT emailAddress FROM subscribers_html WHERE mailingGroup value in
($toText);
Check the documentation, if necessary, for usage of implode and "value in".
HTH!
Jed
On the th
Hi all,
I have a database of names and email addresses, that I want to email.
$result = mysql_query("SELECT emailAddress FROM subscribers_html WHERE
mailingGroup='$toText'");
The select statement needs to return a row when mailingGroup='$toText', but
$toText is an array. How should I write thi
Ok,
I guess I have to re-state what I needing help with. I have a database with
three date fields. If I do a date_format for all three fields I get error.
Example
SELECT DATE_FORMAT(DATE1, '%M %D, %Y) as DATE1, DATE_FORMAT(DATE2, '%M %D,
%Y) as DATE2, DATE_FORMAT(DATE3, '%M %D, %Y) as DATE3, Gr
what is the error message you are getting?
Is the MySQL server running on the same machine you are trying to
connect to or are you connecting to a remote machine?
On Tuesday, September 3, 2002, at 09:40 PM, Al Davis wrote:
SK
> Being new to MYSQL as well as this list, I'm hoping you'll forgive
Steve,
- Original Message -
From: "Orr, Steve" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 1:23 AM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
> Heikki,
>
> > Next-key locking in InnoDB allo
Does anyone have or know of any good books that discuss or teach normal
forms in great detail. I'd like to say that
im pretty good with 2NF, i'm looking for info on more advanced
normalizations.
A specific normalization question:
if i have three tables, call them A, B, C is it ever proper to have
Heikki,
> Next-key locking in InnoDB allows you to lock the non-existence of rows
> and thus prevents phantom rows from appearing.
OK, now I understand what you're getting at with phantom rows.
But given the tradeoff between the inadvertant next-key deadlocking
challenge and a the phantom rows
Hi -
I'm using MySQL Max 4.0.1-alpha. Whenever I create or drop
an index on a table that is being queried, the query connection and
the connection used to modify the index are both lost when the index
modification is finished. If no queries are in progress, the index
modification completes wi
Greetings,
I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website.
I installed it per the INSTALL-BINARY readme file.
When I try (from /usr/local/mysql) issue:
bin/safe_mysqld --user=mysql &
It starts and immediately stops mysqld. The .err file contains
020904 21:41:45 mysql
I had the same problem with greek characters. I set
field as binary and the problem corrected.
--- National Theater of Greece <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: >
Hi.
> I have installed SuSE Linux 8.0 Proffessional and
> the MySQL that came with
> it. If anyone of you has do
If you're using MySQL 4.0.x, mysql max is included.
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 2:43 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: RE: mysql max
Mysql-Max binaries are the binaries complied with InnodB support
OK, yes and no.
The actual checkbook would be a simple database, the software to interface
it would determine things like the ability to create graphs and so forth. A
database is just that, a centralized, organized collection of data. What
you actually do with it or how you use it is completely
>Description:
I am a new user to MySQL. When i try to create the MySQL grant tables, it does
not allow me to do that.
>How-To-Repeat:
This is the error message that i get when i run mysql_install_db
*
ld.so.1:
Mysql-Max binaries are the binaries complied with InnodB support and
InnoDB tables support transactions. So if you do something that has to
be transaction-based, then you'd use mysql-max.
Gurhan
On Thu, 2002-09-05 at 16:17, Edward Peloke wrote:
>
> So is there really any benefit to using MySql
You have to do in your command shell, not mysql shell...
Go to run , type cmd
and then type mysql < batch-file ..
Gurhan
On Thu, 2002-09-05 at 16:12, Horacio Santoyo wrote:
> Hello mySQL users,
>
> I'm a new mySQL user, just installed it two days ago.
> I have a quick question... I have a .sq
When I saw this mail arrive I thought the subject read "Using mySQL in
Biatch mode", I did chuckle a little :)
> -Original Message-
> From: Horacio Santoyo [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 21:13
> To: [EMAIL PROTECTED]
> Subject: Using mySQL in Batch mode
>
>
> Hell
Hello,
I'm new to this list, and actually rather new to MySQL. I am still in the
process of learning, but I wanted an opinion on something...
I was curious what you would all think of creating a rather simple
checkbook register using mysql? From my (rather limited) knowledge, it
would seem fairl
I had a conversation with my ISP wherein I was told that using a GUI admin
tool such as MySQLGUi or MySQL Front is a security concern, but that a tool
like phpAdminSQL (??) is better becaise they can lock it down.
Is this true? Wouldn't they have the same security issues unless phpAdmin
was on a
Steve,
- Original Message -
From: "Orr, Steve" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 11:04 PM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
> Heikki,
>
> You wrote...
> > You are getting so many deadlocks tha
I suggest you to copy the database files. If you are
the administrator in a Linux system make a cron once
(for example) a week to copy this files to somwere
else.
--- Kai Vermehr <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > is there any
single MySQL script that would backup
> my co
Hi again. :-)
On Thu 2002-09-05 at 14:18:10 -0500, [EMAIL PROTECTED] wrote:
[...]
> 3) I'm somewhat at a loss for this one and perhaps the answer is more
> obvious than not. I have 257 total tables from my main DB and mysql. I
> figured this by a "ls -al var/ | grep -c MYD". How can I possibly
Hi (I tried posting this to bugs@lists, but got rejected..),
I have a brand new installation of Mac OS X 10.2 (client), with the
developer tools (including the August 2002 Dev Tools update).
Using the system's gcc 3.1, I compiled mysql 3.23.52 with:
/configure --prefix=/usr/local/mysql
And ever
Greetings,
I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website.
I installed it per the INSTALL-BINARY readme file.
When I try (from /usr/local/mysql) issue:
bin/safe_mysqld --user=mysql &
It starts and immediately stops mysqld. The .err file contains
020904 21:41:45 mysql
The html symbol for euro sign is: "€" (without
quots) if that helps.
Is it neccecery to insert it in the database?
--- Derk van der Harst <[EMAIL PROTECTED]>
&eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hello everyone,
>
> how can I insert records with the Euro sign into the
> mysql database?
> When
Hello,
In the directory you have your .sql script, run this:
mysql < myquery.sql
Remember to change the file name, though. :-)
Regards,
Iikka
On Thu, 5 Sep 2002, Horacio Santoyo wrote:
> Hello mySQL users,
>
> I'm a new mySQL user, just installed it two days ago.
> I have a quick question...
Hello mySQL users,
I'm a new mySQL user, just installed it two days ago.
I have a quick question... I have a .sql script that I want to run on
mySQL server. I have a Windows XP machine and when I read the mySQL manual,
I think they were talking about a Unix machine. This is what the manual
sa
Kevin, have you got install Apache HTTP server?
--- Kevin Walker <[EMAIL PROTECTED]>
&eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hi all
>
> I've recently downloaded and installed MySQL 3.23.52
> for Windows. I'm
> running Win95 OSR2, and Winsock2 is installed. This
> is a standalone PC with
> no web
Hello,
Yes, there might be very strong reasons to use the Max version. Most
people are using Max because it has InnoDB support.
I'm not sure about your specific needs, but see this URL for more
guidance on which version to choose:
http://www.mysql.com/doc/en/mysqld-max.html
Regards,
Iikka
On
So is there really any benefit to using MySql Max?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Iikka Meriläinen
Sent: Thursday, September 05, 2002 3:53 PM
To: Edward Peloke
Cc: [EMAIL PROTECTED]
Subject: Re: mysql max
Hello,
As of this writing, MyS
Hello,
As of this writing, MySQL doesn't support stored procedures. It will most
probably support them in 4.x versions to come.
However, there are millions of web pages that use PHP in conjunction with
MySQL without stored procs, although they would certainly benefit of them,
but those sites wor
I am new to MySql and am trying to learn PHP in conjunction with MySql. The
webpage that I want to create will benefit from stored procedures. Are
these available with MySqlMax? If so, is it setup the same way as MySql?
Thanks,
Eddie
--
Sorry,
I forgot to add the reference to that 'ACID' characterization.
It is http://openacs.org/philosophy/why-not-mysql.html :).
"
Why Not MySQL?
by Ben Adida, part of the OpenACS Project.
NOTE: This Document
Steve,
- Original Message -
From: "Orr, Steve" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 9:49 PM
Subject: RE: Performance Problems with InnoDB Row Level Locking...
> Hello again Heikki and thanks for your informa
First of all, I forgive the rather lengthy post.
Thanks for the repl(y|ies) Benjamin. Decreasing the key_buffer should
be my first step. Back to the questions:
3) I'm somewhat at a loss for this one and perhaps the answer is more
obvious than not. I have 257 total tables from my main DB and
You should be able to:
1. Shut down the server.
2. Copy all the files from your data directory (including the grant tables,
etc.) to where you would like them.
3. Change the location in your /etc/my.cnf file (Assuming a linux server.
It should be similar for other architectures.)
4. Make sure a
Benjamin Pflugmann wrote:
>OTOH, if this is a MySQL-only machine, 3GB are plenty and 100MB more
>or less used do not really matter (regarding free memory), so I would
>simply set it to use about 400MB are forget about it.
>
>
Remember to actually benchmark your differences too if possible (with
Willie Northway wrote:
>Can anyone fill me in on how to manage this *without* using a huge pile
>of symlinks:
>
>
May I highly recommend the symlink method? Its actually very
informative to do:
$ ls -l /var/mysql
and see:
---x---
mbabcock -> /home/mbabcock/mysql
gcurtis -> /home/gcurtis/mysql
Hello again Heikki and thanks for your informative reply.
Regarding...
> innodb_flush_log_at_trx_commit=2
This is not an option as we must guarantee no lost transactions. But I will
test it out of curiosity just to see what the performance difference is.
Regarding...
> InnoDB uses next-key lock
Joco Borsoi Soares ([EMAIL PROTECTED]) écrivait:
>
>Hello,
>
>I'm currently working with Macromedia Flash and MySQL. Actually I use PHP to
connect
>MySQL and
>Flash. You can use loadVariables (GET or POST) or XML to the interface between
Flash
>and PHP.
Sure ! or take a look to SwiftGenerator (Go
Hello,
I'm currently working with Macromedia Flash and MySQL. Actually I use PHP to connect
MySQL and
Flash. You can use loadVariables (GET or POST) or XML to the interface between Flash
and PHP.
Joao.
Fook Cheon Khaw wrote:
> Hi,
>
> I am thinking of using Macromedia Flash for graphical
> cha
Hmm. I'm not sure what to suggest... sorry! :(
> -Original Message-
> From: Dan Johansson [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 18:30
> To: Ben Joyce
> Cc: [EMAIL PROTECTED]
> Subject: Re: ado/mysql problem
>
>
> Yes, I have now. Do not find anything :(
>
> Ben Joyce
Yes, I have now. Do not find anything :(
Ben Joyce wrote:
>ahhh, hmm, erk...
>
>have you checked the MDAC site and MSKB for known bugs?
>
>
>
>>-Original Message-
>>From: Dan Johansson [mailto:[EMAIL PROTECTED]]
>>Sent: 05 September 2002 15:19
>>To: Ben Joyce
>>Cc: [EMAIL PROTECTED]
I'm thinking of moving databases from their standard location to
another disk. I'd like to set up a separate database for each user, so
that their storage space is reflected in their home directory quota.
Can anyone fill me in on how to manage this *without* using a huge pile
of symlinks:
Hello,
Use mysqladmin processlist command to see the thread that's eating up
resources, then use mysqladmin kill to kill that thread.
mysqladmin documentation offers much more information on this topic.
You can also use SHOW PROCESSLIST and KILL SQL commands to achieve that.
Regards,
Iikka
On
mysql,query
Hello,
Maybe I'm an idiot, but I can't find any documentation on how to stop
running queries interactively. The only thing I can come up with is to stop
and restart the server. I don't want to do that. Basically, if a user does
something stupid, and sparks off a query that is hoggin
You cna fix this problem with the "HAVING" keyword in the WHERE clause.
HAVING is like WHERE, but on group-by functions, like COUNT(*).
Change the query to:
SELECT id,name,userid,correct,count(correct) as numcorrect
FROM users,answers
WHEREid=userid AND correct='true'
GROUP BY id
HAVI
Hi.
On Thu 2002-09-05 at 09:09:07 -0500, [EMAIL PROTECTED] wrote:
> For clarity sake, assume the following:
>
> Red Hat Linux 7.1
> 2.4.8 kernel
> MySQL 3.23.42
> MyISAM databases
> 3GB RAM
> P3/700 x 4
> 15GB database spanned across ~200 tables
>
> Key_reads / Key_read_request = 0.00059875
I am still having problems with the slave server being able to connect to
the master, but a thought occured to me while we were working another topic.
Please let me know what I'm missing. I can do the following:
mysql -hctiadb1 -urepl -preplctia
and can access whatever database I wish. I jus
Hi
I was running my mysql 3.23. on redhat 6.2
I uninstall it using the rpm -e command
the went into var/lib/mysql deleted the dbase.
I then re-install mysql
mysql version,client,devel,shared
when I run: rpm -qa | grep MySql
result : I only see client,devel and shared ...I cannot see version
On Thu, 5 Sep 2002, National Theater of Greece wrote:
> Hi.
> I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
> it. If anyone of you has done the same he must have realized that many of
> the files are quite different than the files of MySQL that came with the
> standar
Hi.
On Thu 2002-09-05 at 10:13:12 -0400, [EMAIL PROTECTED] wrote:
> > On Thu 2002-09-05 at 09:29:41 -0400, [EMAIL PROTECTED] wrote:
[...]
> > > Last_error: error 'unexpected success or fatal
> > error' on query 'bslive'
> >
[...]
> > The query is then logged and send to the slave and i
Alexander,
- Original Message -
From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 6:51 PM
Subject: Re: Performance Problems with InnoDB Row Level Locking...
> Heikki, one little question -
Muzi Nkosi wrote:
> > when I run: rpm -qa | grep MySql
Wrong, the RPM is called MySQL, not MySql. Case matters. An easier solution
would be to tell grep to ignore case:
[root@serpico ~]# rpm -qa | grep -i mysql
MySQL-client-3.23.52-1
MySQL-shared-3.23.52-1
MySQL-3.23.52-1
Michael,
- Original Message -
From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 6:37 PM
Subject: Re: Bad table conversion
> Victoria Reznichenko wrote:
>
> >Michael, MySQL privilege tables MUST be MyISAM:
> > h
Heikki, one little question - is it a mistype, or can a flush log interval
duration be controlled by this option? The value should only be 0 or 1 as
the documentation says...
On Thu, 5 Sep 2002, Heikki Tuuri wrote:
> You can try setting
>
> innodb_flush_log_at_trx_commit=2
>
> if you can afford
Hello. I have a problem where TIMESTAMP comparison fails on MySQL 3.23.52 on
RedHat 7.3.
I have installed the RPMS that came with the distro as well as the ones from
the mysql.com site. The results are the same:
mysql> select TIMESTAMP from tblPositions;
++
| TIMESTAMP |
+--
I am by no means an "SQL-expert", but I'll give this a shot... :)
> -Original Message-
> From: Richard Brenner [mailto:[EMAIL PROTECTED]]
> Subject: query problem
>
> I have two tables with the following structure:
>
> Users:
> | Field| Type
> | id | int(10) unsigned
> |
Egor Egorov wrote:
> Muzi,
> Thursday, September 05, 2002, 1:15:18 PM, you wrote:
>
> >> I was running my mysql 3.23. on redhat 6.2
> >> I uninstall it using the rpm -e command
> >> then I went into var/lib/mysql deleted the dbase and all mysql directoring.
> >>
> >> I then re-install mysql
> >
Hello mysql,
MYSQLSTAT - A set of utilities to monitor, store and display Mysql
DBMS usage statistics:
http://www.mysqlstat.org/en/
Best regards,
Andrew Sitnikov
e-mail : [EMAIL PROTECTED]
GSM: (+372) 56491109
---
Hello all!
I'm looking at dumping various syslog files to a MySQL database.
The problem is that most programs I've seen only accept linux/unix default
syslog types to dump to MySQL.
I'm looking at dumping logs from a variety of different sources though my
first priority is PIX firewall logs.
A
Victoria Reznichenko wrote:
>Michael, MySQL privilege tables MUST be MyISAM:
> http://www.mysql.com/doc/en/InnoDB_restrictions.html
>
>
Yes, thank-you; I must have missed / forgotten that warning at some
point -- my next E-mail will be to the phpMyAdmin author suggesting a
patch to pr
Michael,
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 6:03 PM
Subject: Re: Bad table conversion
> Heikki Tuuri wrote:
>
> >what version you are using?
> >
> mysql Ve
Steve,
- Original Message -
From: ""Orr, Steve"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 5:52 PM
Subject: Performance Problems with InnoDB Row Level Locking...
> Background:
> I've developed a simplistic Perl program to test database per
Heikki Tuuri wrote:
>what version you are using?
>
mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686)
>It left the MyISAM user and db tables as they were.
>
>You have lost the db table? I guess that if you create the same databases in
>another server and copy the db table from there, it s
Hi,
I am thinking of using Macromedia Flash for graphical
charting. After charting, I plan to store the info
into MySQL. However, I am not sure if the Flash
Remoting in Macromedia Flash can work with MySQL. My
application is mainly JSP based but the charting is
based on Flash. What kind of driver
Michael,
Thursday, September 05, 2002, 5:09:47 PM, you wrote:
MTB> I was using phpMyAdmin to do some user management and since it was
MTB> fairly slow, decided to try upgrading my mysql.users and mysql.db tables
MTB> to InnoDB format. It seems however that this is a "bad thing" as mysql
MTB>
Muzi,
Thursday, September 05, 2002, 1:15:18 PM, you wrote:
>> I was running my mysql 3.23. on redhat 6.2
>> I uninstall it using the rpm -e command
>> then I went into var/lib/mysql deleted the dbase and all mysql directoring.
>>
>> I then re-install mysql
>>
>> mysql version,client,devel,
Well, just that thing. I'm able to search, retrieve and update Mysql tables
(server located on a Linux Box) but I cannot create tables, nor modify its
structures. Does anyone knows why. Leonardo Belen. Afip AR
PS: I tried with the last stable release of Mysql and MyODBC from MYSQL.COM.
Michael,
- Original Message -
From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 05, 2002 5:15 PM
Subject: Bad table conversion
> I was using phpMyAdmin to do some user management and since it was
> fairly slow, decided to try u
Background:
I've developed a simplistic Perl program to test database performance with
concurrent session queries. The queries involve inserts, updates, and
deletes in order to test database performance in an OLTP mult-user ACID
compliant scenario. Obviously this is not a "real world test" but it
David,
Thursday, September 05, 2002, 12:45:33 AM, you wrote:
DJ> Can the AUTO_INCREMENT feature be used to control a sequential number list
DJ> that re-uses numbers that are subsequently removed ?
You can insert another rows with the same auto_increment value as in deleted row, if
you directly
Grant,
Thursday, September 05, 2002, 1:12:23 PM, you wrote:
>> I am trying to update lot's of tables. Can I do this in one command?
>>
>> If so, what is the command. I've tried everything. Nothing works. I can
>> only update one table at a time.
Do you want to update lots of identical tables wit
I am getting error number -30996 when trying to update a MySQL BDB type
table using
transaction logging. Can anyone tell me what this number means, or where I
can get a list of BDB error numbers?
Thanks
Vivien
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
-
Vivien
Hi JC,
From http://www.mysql.com/doc/en/Table_size.html (I searched on
size)
If you need bigger tables than 4G (and your operating system supports
this), you should set the AVG_ROW_LENGTH and MAX_ROWS parameter when
you create your table. See section 6.5.3 CREATE TABLE Syntax. You can
also set
Hi all, I've been reading a bit on the innodb table type for mysql here and
on the site and some other board sites and just wanted to ask a quick
question or two in general about it, as it relates mostly to message boards
and compared to myisam. Is the only gotcha in forum code generally the
selec
ahhh, hmm, erk...
have you checked the MDAC site and MSKB for known bugs?
> -Original Message-
> From: Dan Johansson [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 15:19
> To: Ben Joyce
> Cc: [EMAIL PROTECTED]
> Subject: Re: ado/mysql problem
>
>
> I know the same issus exist on
I know the same issus exist on XP. One can't downgrade mdac on XP ??
So I really would like an other solution.
/Dan
Ben Joyce wrote:
>Yep, I had issues too... I've dropped back to MDAC2.5 and all is well.
>
> .b
>
>
>
>>-Original Message-
>>From: Dan Johansson [mailto:[EMAIL PROTECTED
> On Thu 2002-09-05 at 09:29:41 -0400,
> [EMAIL PROTECTED] wrote:
> >
> > Can anyone tell me what this means???
> >
> > Master_User: repslave2
> > Master_Port: 3306
> > Connect_retry: 60
> >Log_File: QBSLXDB1-bin.058
> > Pos: 52706154
> >
I was using phpMyAdmin to do some user management and since it was
fairly slow, decided to try upgrading my mysql.users and mysql.db tables
to InnoDB format. It seems however that this is a "bad thing" as mysql
told me when it refused to restart. I've recovered the users table from
a backup
Rummaging through some docs on performance and have come up with some
questions. Let me preface by saying, we don't have any performance
problems. I inherited this monster of a database and am running through
the configuration to make sure that it is indeed setup for optimum
performance.
For cl
Yep, I had issues too... I've dropped back to MDAC2.5 and all is well.
.b
> -Original Message-
> From: Dan Johansson [mailto:[EMAIL PROTECTED]]
> Sent: 05 September 2002 15:03
> To: [EMAIL PROTECTED]
> Subject: ado/mysql problem
>
>
> Hi
> After uppgrade mdac from 2.5 to 2.7 I get wr
1 - 100 of 157 matches
Mail list logo
