In the last episode (Mar 26), Riccardo Michele Filippone said:
> Hello! First of all sorry for my terrible english.
>
> Well I've a big problem with ibdata1, this damn file increase its size
> constantly.
>
> I tryed to use innodb_file_per_table... but:
>
> - MySQL create a lot of ibd files fo
forgot the list, sorry :)
Walter Heck
-- Forwarded message --
From: Walter Heck - OlinData.com
Date: Thu, Mar 26, 2009 at 2:09 PM
Subject: Re: A problem relative ibdata1
To:
Cc: Riccardo Michele Filippone
Riccardo,
if you're ibdata1 file is growing fast, it means yo
Now I try to retrive a charts of queries...
>
> however do you know if there is an engine that support/manage foreign key?
>
> I use innodb for this reason.. but the size of ibdata1 is a problem :'(
>
> Thanks for ur reply
>
>
> Il giorno 26/mar/09, alle ore 12:30, Cla
You can't!
it is part of the datafiles of InnoDB storage engine!
and It contains important data like the information schema.
So I would rather ask you, is it abnormally growing or is it just your
feeling?
You should be more precise to have good answers,
for instance how much megabytes per minu
Hello! First of all sorry for my terrible english.
Well I've a big problem with ibdata1, this damn file increase its size
constantly.
I tryed to use innodb_file_per_table... but:
- MySQL create a lot of ibd files for all DB (correct)
- ibdata1 is however created and increase its size...
how
The official table's data.
++---+-+
| id | title | body|
++---+-+
| 1 | MySQL Tutorial| DBMS stands for DataBase ...
That did it, thank you all!
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 2:10 AM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: WHERE problem, or is it a problem?
Peter Lauri wrote:
> Best group member,
>
> I have t
part.memberid
HAVING count(*) >=31
ORDER BY numberofans DESC, part.memberid;
"Peter Lauri" <[EMAIL PROTECTED]>
07/26/2006 09:58 AM
To
cc
Subject
WHERE problem, or is it a problem?
Best group member,
I have this query on MySQL version 4.0.27:
SELECT part.memb
Peter Lauri wrote:
Best group member,
I have this query on MySQL version 4.0.27:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON (part.membe
Best group member,
I have this query on MySQL version 4.0.27:
SELECT part.memberid, part.prefname, part.email, COUNT(*) AS numberofans
FROM tblparticipants part
LEFT JOIN tblanswers answer ON (answer.par_num=part.memberid)
LEFT OUTER JOIN profilepdfauth pdfauth ON (part.memberid=pdfauth.memberid)
MySQL has a pluggable storage engine architecture which means that you
can use multiple storage engines within your databases. What you need
to do is investigate the different features of the engines and devide
which one best fits your system i.e. level of locking required,
InnoDB=row level My
I'm trying to find a weird performance problem in a MySQL database. I
use MySQL v5.0 but the db was migrated forward from a v4.1(?) system.
Looking at the schema in a recent backup, I was surprised to find
different engines used for different tables:
...
CREATE TABLE `comment` (
`id` int
Hi everyone,
My environment:
- Linux 2.6.7-1.7asp #1 Thu Jul 15 17:36:07 YEKST 2004 i686 i386 GNU/Linux
- server version: 4.0.13
I wrote a script-SQL like this:
#Begin of script-SQL
...
DATA_BEGIN=$1
DATA_END=$2
TIME_BEGIN=$3
TIME_END=$4
USER_NAME=$5
PRICE=$6
CUR_TABLE=acc_cur
TMP_TABLE=acc_tm
Hi everyone,
My environment:
- Linux 2.6.7-1.7asp #1 Thu Jul 15 17:36:07 YEKST 2004 i686 i386 GNU/Linux
- server version: 4.0.13
I wrote a script-SQL like this:
#Begin of script-SQL
...
DATA_BEGIN=$1
DATA_END=$2
TIME_BEGIN=$3
TIME_END=$4
USER_NAME=$5
PRICE=$6
CUR_TABLE=acc_cur
TMP_TABLE=acc_tm
Privet!
User with similar privileges successfully drops table on my MySQL 5.0.7:
mysql> drop table acc_tmp;
Query OK, 0 rows affected (0.01 sec)
mysql> show grants for current_user;
+-+
| Grants for [EMAIL PROTE
Hi everyone,
My environment:
- Linux 2.6.7-1.7asp #1 Thu Jul 15 17:36:07 YEKST 2004 i686 i386 GNU/Linux
- server version: 4.0.13
I wrote a script-SQL like this:
#Begin of script-SQL
...
DATA_BEGIN=$1
DATA_END=$2
TIME_BEGIN=$3
TIME_END=$4
USER_NAME=$5
PRICE=$6
CUR_TABLE=acc_cur
TMP_TABLE=acc_tm
José Pablo Ezequiel Fernández <[EMAIL PROTECTED]> wrote on 01/26/2005
03:49:50 PM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> After the good comments I've got on this mailing list, I think I have
the
> structure more or less complete. In some cases I follow the comments, in
some
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
After the good comments I've got on this mailing list, I think I have the
structure more or less complete. In some cases I follow the comments, in some
others, I've improvised (hehehe).
So, this is the (explained) structure, what do you think ? Anyth
Pupeno <[EMAIL PROTECTED]> wrote on 01/26/2005 11:53:06 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Je Merkredo Januaro 26 2005 18:56, [EMAIL PROTECTED] skribis:
> > For instance, when Eric Clapton did his unplugged version of "Layla",
he
> > was the same ARTIST as recorded the ori
Pupeno <[EMAIL PROTECTED]> wrote on 01/26/2005 11:48:59 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> There where two cases where I have roles:
> How an artist participated in a song (creating the lyrics, creating the
> musici, etc, etc) and how an artist participates in a group.
> D
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Je Merkredo Januaro 26 2005 18:56, [EMAIL PROTECTED] skribis:
> For instance, when Eric Clapton did his unplugged version of "Layla", he
> was the same ARTIST as recorded the original studio version but he was
> part of two different groups. The first
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
There where two cases where I have roles:
How an artist participated in a song (creating the lyrics, creating the
musici, etc, etc) and how an artist participates in a group.
Do you think that enums are good for this kind of things ? or another table
Pupeno <[EMAIL PROTECTED]> wrote on 01/26/2005 08:56:05 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello Shawn Green,
>
> Je Merkredo Januaro 26 2005 15:42, [EMAIL PROTECTED] skribis:
> > If it were me, I would have separate tables for groups, songs,
> > performances, recordings,
On Wed, Jan 26, 2005 at 01:56:05PM +, Pupeno wrote:
> Takes more room because of the extra field ? Can you tell me more about 'the
> normalized approach' ?
http://en.wikipedia.org/wiki/Database_normalization
-Jason Martin
--
If you cannot convince them, confuse them.
This message is PGP/MIME
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Shawn Green,
Je Merkredo Januaro 26 2005 15:42, [EMAIL PROTECTED] skribis:
> If it were me, I would have separate tables for groups, songs,
> performances, recordings, and artists.
Well, the thing is that I was just doing a site for holding info
Pupeno wrote:
What I don't like about that, is that half the person_id fields would
be empty
and half the group_id fields would be empty. I was thinking about:
SONG-TO-PERSON-OR-GROUP LINK TABLE
* song_id
* musician_id
* type ('person', 'group')
* role (performer, lyricist, etc.)
But this is the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Je Merkredo Januaro 26 2005 15:34, Ian Sales (DBA) skribis:
> SONG-TO-PERSON-OR-GROUP LINK TABLE
> * song_id
> * person_id
> * group_id
> * role (performer, lyricist, etc.)
What I don't like about that, is that half the person_id fields would be empty
Pupeno <[EMAIL PROTECTED]> wrote on 01/26/2005 07:00:34 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hello MySQLers,
> I'm trying to define a structure for my database and I'm experience some
> problems, any comments would be appretiated.
> This is for a (web) application to handle
Pupeno wrote:
Now that I'm thinking about a fourth solution: Have two totally separate
tables for groups and persons (this is what I really like) and then, one
table to relate songs to persons, and another table to relate songs to
groups. The problem with that is that, sometimes, I need to get a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello MySQLers,
I'm trying to define a structure for my database and I'm experience some
problems, any comments would be appretiated.
This is for a (web) application to handle information about music, lyrics and
resources for playing songs. So, the d
PROTECTED]
Sent: Thursday, October 14, 2004 12:42 PM
Subject: Hi, a problem about selecting...
I've a table and many fields. I want to search something in all fields.
-> select * from table where table.* like '%something%' did not work.
I've a table and many fields. I want to search something in all fields.
-> select * from table where table.* like '%something%' did not work.. Is there a way to do this?
Gokce AKKAYA HAZAROGLU
OptikNet Bilgisayar
[EMAIL PROTECTED]
http
If you give more details maybe someone on the list will be able to help.
Astghik Barseghian wrote:
Hello Philippe,
I am trying to use DBMail from MySQL to send and receive messages but I get an SQL
sytax error.
Could you please tell me is there any way to use the mentioned component,
or how can I
I have a webserver on Mandrake9 and Mysql3.23.56,php4.3.x,apache1.3.x is running on
it.
i wanted to transfer this server another server(FreeBSD4.9) completely.
To backup of mysql database i used mysqldump as following;
mysqldump -u user -p -all mydatabasename > mydatabasename.backup no pr
I had a bunch of problems setting up OpenCMS until I figured it out. OpenCMS
tries to connect via the network socket, so the connection to the database
may look like it's coming from the.host.name.com. You may need to add the
full host name of the machine you are installing on to the privilege
Hi,
I am trying to configure Open CMS
5.0.0 with mysql. But while Database and and table creation I am
getting
following error.
Could no connect to database via: jdbc:mysql://localhost:3306/
java.sql.SQLException: Server configuration denies access to data =
source
--
I was perusing a MySQL tutorial at
http://hotwired.lycos.com/webmonkey/99/21/index2a_page5.html?tw=programming
when I read the following:
"Save and view this script...
...through your Web server. You'll see a page filled
with useful and interesting information like this.
This info tells all
Creating library ../lib_debug/libmysqld.lib and object
../lib_debug/libmysqld.exp
set_var.obj : error LNK2001: unresolved external symbol _resize_thr_alarm
../lib_debug/libmysqld.dll : fatal error LNK1120: 1 unresolved externals
Error executing link.exe.
but i have link mysys.lib ,how to solve it
Creating library ../lib_debug/libmysqld.lib and object
../lib_debug/libmysqld.exp
set_var.obj : error LNK2001: unresolved external symbol _resize_thr_alarm
../lib_debug/libmysqld.dll : fatal error LNK1120: 1 unresolved externals
Error executing link.exe.
but i have link mysys.lib ,how to solve it
Hi!
I am trying to get access to the MySQL embedded server using the library
"libmysql.dll" through c++builder. The loading of the library goes well,
but when calls are made to start the server, the application crashes.when i
run the program ,the program crashed in mysql_server_end
my program a
Hello,
> Here is table status:
> +---+++-++-+-+--+---+-+-+-+-++-+
> | Name | Type | Row_format
Hello Stefan,
Wednesday, April 02, 2003, 2:27:40 PM, you wrote:
Here is table status:
+---+++-++-+-+--+---+-+-+-+-+-
Hello,
> When I execute this SQL:
> update table1 as a, table2 as b set a.field1=b.field1
> where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4
> I received this error "execute failed: The table 'a' is full "
> What is the meaning of this?
This means that the table is fu
Hello mysql,
When I execute this SQL:
update table1 as a, table2 as b set a.field1=b.field1
where a.field2=b.field2 and a.field3=b.field3 and a.field4=b.field4
I received this error "execute failed: The table 'a' is full "
What is the meaning of this?
My server version: 4.0.12
hi..
having a problem with a mysql query where 2 different sources use the same
query.. the only problem is that in my where clause i.e.: where
'$edit[company]'==$company
the $edit[company] is not valid for one of the sources... is there a way to
let both sources use the same query like
InnoDB seems to delaying writes for too long.
After adding or deleting records in a table, viewing
the results of a query from another application on the
same workstation and other workstations does not
reflect the changes.
It is as though another connections are still being
presented with old sn
By looking at your query and table description, I guess you can try
something like:
SELECT cus.`Code` AS `Customer Code`,
cus.`Name` AS `Customer`,SUM((1-bil.direction)*bil.Total) AS Loan,
SUM(bil.direction*bil.Total) AS Credit
FROM customer AS cus,
bill AS bil
WHERE bil.`Customer` = cus.`ID`
GRO
Hi,
I have got 2 tables one of the is "customers" the other is "bill". In the
customers table i store my customers informations. In the bill table i store
my billings. if i take a bill bill.direction=0, if i give a bill
bill.direction=1. And now i must take a report Like This..
Customer Code
Cem,
Tuesday, November 26, 2002, 1:13:45 PM, you wrote:
CY> I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
CY> working successfully on the server, and can response all request
CY> comming on Server. But, when I try to connect to the database thru
CY> any client
He all,
I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
working successfully on the server, and can response all request
comming on Server. But, when I try to connect to the database thru
any client running on a Windows 2000 (like MySQLAdmin), I can't
connect it.
Firstly,
He all,
I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
working successfully on the server, and can response all request
comming on Server. But, when I try to connect to the database thru
any client running on a Windows 2000 (like MySQLAdmin), I can't
connect it.
Firstly,
L PROTECTED]>
> Sent: Sunday, September 08, 2002 2:42 AM
> Subject: Have A problem
>
>
> > Hi,
> >
> > I got a small problem I can't seem to do a sql statement that will pick
on
> > the first letter of word in a feild. I have over 700 record in a
database
Hi,
Try :
SELECT * FROM yourtable WHERE word LIKE 'D%';
Regards,
Jocelyn
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 08, 2002 2:42 AM
Subject: Have A problem
> Hi,
&
Hi,
I got a small problem I can't seem to do a sql statement that will pick on
the first letter of word in a feild. I have over 700 record in a database,
but I like to be able only to see those that let say start with "D". How can
I do a statement that will let me do that.
Chuck Payne
Magi Desig
I compile the source code of mysql-3.23.51 on a system of solaris 8. The
following error information was produced:
make[2]: Entering directory `/user1/mals/chensong/share/mysql-3.23.51/libmysql'
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_CURSES_H
-I/user1/mals
June 10, 2002 1:11 PM
Subject: I have a problem
We are running mysql on a red hat box.
We replicate a single database twice, once on another red hat box(thank
whatever is holy), once on a winnt box.
The winnt box cares not for case sensitivity, so it created all our table
names in lower ca
We are running mysql on a red hat box.
We replicate a single database twice, once on another red hat box(thank whatever is
holy), once on a winnt box.
The winnt box cares not for case sensitivity, so it created all our table names in
lower case ( our standard is to use CAPS for tablenames )
(
I use phpBB.
When I change default character set in mysql I have a problem in phpBB so:
Warning: Supplied argument is not a valid MySQL result resource in
/../functions.php on line 230
Unable to query db!
But /../admin/index.php regularly runs.
What my problem is?
thanks
Edakom Internet
I think you misunderstood how this is going to work. The expression
ROUND(rand()*100) is not a constant, so it is going to re-evaluate it
and generate a *different* random number for each line in the table. Apart
from anything else, this is going to be slow because it will have to scan
the wh
Your problem, I _think_, is that your query works as follows:
for i = 0 to table_name.rows {
row <-- table_name.row[i]
if row.count = ROUND(rand() * 10) then result += row
}
NOTE: ROUND(rand() * 10) is performed FOR EACH ROW in your table. You
actually mean for it to b
I have database with table and 1 milions random characters. Key for
searching each character is a counter from 1 to milion.
when I execute statement:
SELECT count, character FROM table_name WHERE count=ROUND(rand()*10);
Example:
count ||character ||
1 dasarewr
2
I have a site using PHP & Mysql. About a month ago to now one of the tables
gets corrupted with the message Got Error 127... I fix it and everything
works OK, except every time I loose 1 record.
Today I could obtain mysql.err from the machine and I could see whenever an
error is produced by date,
Please help me.
I'm installing mysql-3.23.45 on Sparc 20 with Solaris 2.5 and when
i give the comand make...i have this problem.
..
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/mysql-3.23.45/libmysql'
make[1]: Leaving directory `/usr/local/mysql-
Sounds good. Thanks for the info, Heikki.
--Walt
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Benchmarking MyISAM, InnoDB, and Oracle: a problem with
InnoDB
Walt,
this is probably a
t.
The solution for me was to just rename the directory which the setup-files
was in to something short like "a", and then everything run perfectly.
Some systems info:
-Windows 2000 professional edition
-mysql-3.23.47-win
Now running perfect.
I thought i'd let you know, since this was a
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Erik Price writes:
>> Sinisa, everyone,
>>
>> That's great news! I'm excited to hear that. Which version would that
>> be... 4.0? Or perhaps another 3.x version?
>>
>> In the meantime, my boss is going to wonder w
In the last episode (Nov 16), Erik Price said:
> --- Dan Nelson <[EMAIL PROTECTED]> wrote:
> > As long as there are no active connections, killing mysql will not
> > affect the database. If you kill mysql during an update, you risk
> > corrupting any indexes on the tables being modified. If your
--- Dan Nelson <[EMAIL PROTECTED]> wrote:
> As long as there are no active connections, killing mysql will not
> affect the database. If you kill mysql during an update, you risk
> corrupting any indexes on the tables being modified. If your tables
> are BDB or InnoDB format, you should be able
In the last episode (Nov 16), Erik Price said:
> Alternatively, I am open to a workaround until the working version is
> released. I can actually use MySQL (as far as I know), it's just the
> "shutdown" that hangs. I have to use "kill -9" in order to kill the
> daemon. This makes me worry about
Erik Price writes:
> Sinisa, everyone,
>
> That's great news! I'm excited to hear that. Which version would that
> be... 4.0? Or perhaps another 3.x version?
>
> In the meantime, my boss is going to wonder why I'm not populating a
> database for him. He will make me use Access if I don't get
Sinisa, everyone,
That's great news! I'm excited to hear that. Which version would that
be... 4.0? Or perhaps another 3.x version?
In the meantime, my boss is going to wonder why I'm not populating a
database for him. He will make me use Access if I don't get cracking,
so... do you know of a
Erik Price writes:
> Hello all,
>
> Some of you may recognize this post somewhat, I've asked about this
> problem before:
>
> I am unable to execute the "shutdown" command with mysqladmin, running
> on Darwin 1.4.1 (from Mac OS X 10.1.0).
>
> Originally, I had compiled MySQL 3.23.44 from source
Hello all,
Some of you may recognize this post somewhat, I've asked about this
problem before:
I am unable to execute the "shutdown" command with mysqladmin, running
on Darwin 1.4.1 (from Mac OS X 10.1.0).
Originally, I had compiled MySQL 3.23.44 from source code, specifying
the following optio
I was having a problem with the RecordSet class in jdbc2... upon inspection,
the class file is older than the java file. I recompiled and re-jar'd. This
fixed my problem.
The version is 2.0.4
The mm.mysql-2.0.4-bin.jar just needs to be recompiled as it is out of sync
with the source code i
I have two exactly the same tables (layout, columns, data everything is the same) and
when i do a query on table 1 like :
SELECT j01.* FROM j01 WHERE j01.CAMPAGNE = 'HEYTENS' ORDER BY j01.FIN i get 7 results
(that's ok cos' there are 7 rows
in the campagne column who have the value HEYTENS, if
Hi there,
I'm trying to search a double-bytes word in my database.
If the word I search is English(single-byte word), it perfectly works.
But once I try to search a double-bytes word(such as Japanese), I don't
get any results even though the word is in the table...
I know if the word is shorter
I was trying to sign up in order to leave a comment, and your application
crashed giving this message:
---Copied From Your Web Site---
Error: query insert into
web.user(email,pass,firstname,lastname,address,city,state,zipcode,id,phone,c
ell,fax,company,show_email,created) values
('[EMAIL PROTECTE
Hi all,
I've a bit of an issue with mysqld -- errr is it?
Here's the configuration
Dell PowerEdge 6300
- 1GB ram (actually 2GB but no bigmem support at the moment - I'll get to
that)
- RH linux 6.1 running 2.2.12-smp (needs updating, I know - but hard to find
good 'down time')
- 4 10gig UW-
78 matches
Mail list logo
