# [EMAIL PROTECTED] / 2004-01-08 13:26:26 +0200:
> Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > # [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200:
> > > From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > > > My first question is: wha
# [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > My first question is: what is the interaction between MySQL's
> > *_buffer_size and InnoDB's innodb_buffer_pool_size?
> > IOW, are *_buffer_size
This'll probably show my ignorance, but can someone explain why this
select uses index on ob_vl_parametry.info_cs when that column is not
used anywhere in the query?
mysql> EXPLAIN SELECT vp.id
-> FROM ob_vl_parametry_zbozi zp, ob_vl_parametry vp,
-> ob_vl_parametry_kategorie vpk
-
# [EMAIL PROTECTED] / 2004-01-05 13:49:17 +0200:
> I'm running MySQL 4.0.17 on FreeBSD machine. i have one process which rarely
> uses Mysql DB, and few postfix processes which uses db for authorizaton. In
> `top` i see that mysql process usually eats 40-50% +/-20. `mytop` show ~5
> sleeping proces
I've been trying to tune a MySQL installation a bit, and have a few
questions regarding relations/interactions between InnoDB and MySQL
when it comes to the various buffers... I wanted this mail to be more
specific, but given the lack of info in the manual, I basically don't
have much cannon fodder
# [EMAIL PROTECTED] / 2003-09-26 15:12:03 -0700:
> --- Harald Fuchs <[EMAIL PROTECTED]> wrote:
> > Ed Smith <[EMAIL PROTECTED]> writes:
> > > Greetings. When I execute the SQL script below in
> > > mySQL 4.1, I get
> >
> > > ERROR 1216: Cannot add or update a child row: a foreign key
> > > constr
# [EMAIL PROTECTED] / 2003-09-25 14:59:33 +0100:
> CREATE TABLE `pheno` (
> `id` smallint(5) unsigned NOT NULL auto_increment,
> `relevant` enum('y','n') default NULL,
> `phenotype` varchar(50) NOT NULL default '',
> PRIMARY KEY (`id`,`phenotype`),
> KEY `id` (`id`),
> CONSTRAINT `0_12
# [EMAIL PROTECTED] / 2003-09-25 08:58:09 +0300:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > > > Also, is there a way to *measure* the fragmentation of a table?
> > > > If there is, how should the info be interpreted?
>
> Sorry, no. But addin
# [EMAIL PROTECTED] / 2003-09-24 17:41:29 +0300:
> the row count in SHOW TABLE STATUS is only an estimate based on 8
> dives into the index tree.
ok.
> You had a typical symptom of a fragmented table: space usage much bigger
> than you would expect.
that doesn't answer my questions :) n
# [EMAIL PROTECTED] / 2003-09-23 21:56:55 +0300:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > A simple question regarding storage allocated / reported by MySQL/InnoDB.
> > If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns,
> > why is t
# [EMAIL PROTECTED] / 2003-09-24 02:32:10 -0600:
> According to documentation, in MySQL version 4.0, it is possible to use
> sub-selects
According to what documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.see http://www.eyrie.org./~eagl
A simple question regarding storage allocated / reported by MySQL/InnoDB.
If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns,
why is the reported avg. row length 148 bytes?
mysql> show table status from pmsystem2 like 'editor_competence_product'\G
*** 1. r
# [EMAIL PROTECTED] / 2003-06-29 23:24:58 -0500:
>
> > # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500:
> > > CREATE TABLE extraFieldOptions (
> > > fieldID tinyint(3) unsigned NOT NULL default '0',
> > > fieldOption varchar(16) NOT NULL default '',
> > > fieldValue varchar(16) NOT NULL defa
# [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500:
> CREATE TABLE extraFieldOptions (
> fieldID tinyint(3) unsigned NOT NULL default '0',
> fieldOption varchar(16) NOT NULL default '',
> fieldValue varchar(16) NOT NULL default '',
> PRIMARY KEY (fieldID,fieldOption)
> ) TYPE=MyISAM;
> mysq
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200:
> I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the
> used version. What is the command to do that? (according to mysql.info
> it is Version 3.23.42. )
SELECT VERSION();
--
If you cc me or remove the list(s) completely I'll
# [EMAIL PROTECTED] / 2003-06-29 08:14:28 +0100:
> The table customer_basket contains the products_id which is no good
> for my routine. What I need to check is the categories_id but there
> is no reference in the customers_basket.
>
> Presumably I need to do a join on the table that holds the ca
# [EMAIL PROTECTED] / 2003-06-17 11:44:46 -0400:
> At 05:14 PM 6/16/2003, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400:
> >> I can use:
> >>
> >> SELECT sum(if(voidreason>0,0,amt)) as sales FROM sdtik where acctno=1234
> &
please don't top-post.
# [EMAIL PROTECTED] / 2003-06-27 14:01:58 -0400:
> On Fri, 27 Jun 2003, Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
> > > I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
> > > pthre
# [EMAIL PROTECTED] / 2003-06-27 14:44:55 +0200:
> I have a question regarding mysqlhotcopy's use.
> I'd like to use the --flushlog option in order to have a nice backup &
> synchronized log for my replication slave in case of recover need
> (without stopping the master).
> But the lock used by m
# [EMAIL PROTECTED] / 2003-06-20 11:07:09 -0400:
> Hello,
> I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
> pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to
> mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and
> everything went fine.
# [EMAIL PROTECTED] / 2003-06-27 09:45:06 +0200:
> how can i delete an foreign key between two tables? Is there a drop foreign
> key - command available?
yes, read:
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
--
If you cc me or remove the list(s) completely I'll most likely ign
your MUA doesn't properly represent quotation marks, breaking them
in other MUAs.
# [EMAIL PROTECTED] / 2003-06-25 04:51:49 -0700:
> This follows on a previous mail from me:
>
> When using
> GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
> ?password?
>
> I could not get the passwor
# [EMAIL PROTECTED] / 2003-06-25 14:03:17 +0100:
> Im altering a number of table from MyISAM to innoDb and adding foreign
> keys.
>
> The alteration of the table type works.
> Adding the row as an index works.
> Adding the foreign key fails, generating the error:
>
> alter table project add FORE
# [EMAIL PROTECTED] / 2003-06-24 20:32:48 -0700:
> insert into table1 select * from table2;
>
> Table2 has some 10,000 records while table1 has around
> 11,00,000 records. The time reqd. to execute the above
> query is round about 80- 90 secs.
>
> The table1 has 7 columns out of which 5 are comp
# [EMAIL PROTECTED] / 2003-06-25 02:11:05 -0400:
> I needed to add a new, autoincrementing, primary key column
> to a table and have been struggling to figure out how to
> assign an initial, unique value to each row.
>
> I finally accomplished my task, but feel sure there's an
> easier way.
>
# [EMAIL PROTECTED] / 2003-06-25 07:10:46 +0100:
> Sometime recently Roman Neuhauser said:
> > # [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
> > > alter table p_asset add mydate datetime default 'now()';
> > >
> > > - you need the '' ar
# [EMAIL PROTECTED] / 2003-06-25 06:18:04 +0100:
> Sometime recently MaFai said:
> > A table contains a column named "mydate".
> >
> > //Wrong sql statement
> > alter table p_asset add mydate datetime default now();
> > alter table p_asset add mydate datetime default time();
>
# [EMAIL PROTECTED] / 2003-06-25 15:18:09 +1000:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > please don't piggyback on other people's threads. you can start your
> > own for free.
>
> Although it was the first time for me to send the
# [EMAIL PROTECTED] / 2003-06-25 12:05:49 +0800:
> //Wrong sql statement
> alter table p_asset add mydate datetime default now();
> alter table p_asset add mydate datetime default time();
> alter table p_asset add mydate datetime default now;
> alter table p_asset add myda
# [EMAIL PROTECTED] / 2003-06-23 11:11:28 -0400:
> I have updated mySQL to the 4.0.13-standard and had no problems UNTIL I
> attempted to run mysql_fix_privileges. This is the error I get:
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> /tmp is
# [EMAIL PROTECTED] / 2003-06-23 16:16:50 -0400:
> I installed MySQL (mysql-standard-4.0.13-apple-darwin6.4-powerpc) ...
> but now I get this error in the log file and I am unable to still start
> the MySQL Server.
> 030623 15:59:05 Fatal error: Can't open privilege tables: Can't find file:
# [EMAIL PROTECTED] / 2003-06-24 01:02:17 -0600:
> But, I need to know which rows were modified, not simply how many. So
> far this is the best that I have come up with
>
> LOCK TABLES MyTable WRITE
> SELECT * FROM MyTable WHERE SomeRecord = OldValue
> UPDATE MyTable SET SomeRecord = NewValue WHER
OTECTED] / 2003-06-24 04:00:02 -0700:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
> >> Does MYSQL support transaction concept, which includes issues
> >>like commiting data , rollbacking etc???
> >
> > Did you know
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
> Does MYSQL support transaction concept, which includes issues
> like commiting data , rollbacking etc???
Did you know MySQL has documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.s
# [EMAIL PROTECTED] / 2003-06-24 16:48:24 +0800:
> After I create this table,and add foreign key tno to this table.
> If I delete "tno" in "p_program_type" table,it would alarm that some
> data still in "p_schedule".
> How can I define the "p_schedule" or "p_program_type" table to make
> sure that
please don't piggyback on other people's threads. you can start your
own for free.
# [EMAIL PROTECTED] / 2003-06-24 09:46:24 +1000:
> I am using LOAD DATA INFILE to import some data to MySQL. I would like to
> leave some fields blank and use the default value set in the tables. I have
>
don't piggyback on other people's threads. you can start your own
for free.
# [EMAIL PROTECTED] / 2003-06-19 13:23:04 -0700:
> I ran a command which was part of the installation process for some php
> accounting software.
>
> update user set host='%' where host='localhost' and user='roo
# [EMAIL PROTECTED] / 2003-06-21 12:35:04 -0700:
> I'm trying to load a couple tons of data into a shopping cart system
> and for some reason it keeps kicking back with an error. I'm too dumb
> to figure out why. Can anyone tell me what's wrong with this code and
> why it doesn't work?
I can
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400:
> [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe &
> [5] 703
> [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases
> from /usr/local/mysql/data
> 030618 11:50:09 mysqld ended
>
>
> [5]Done
# [EMAIL PROTECTED] / 2003-06-17 21:28:12 +0300:
> From: "Kerry Colligan" <[EMAIL PROTECTED]>
> > I see that 5.x will support triggers. Does anyone have any advice for
> > implementation of triggers on the DB? I will need to be able to utilize
> > them from web applications AND from command-line ty
# [EMAIL PROTECTED] / 2003-06-17 10:59:13 +0200:
> On Mon, Jun 16, 2003 at 11:56:59PM +0200, Roman Neuhauser wrote:
> > # [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
> > > mysql> select * from unitest WHERE t LIKE 'A%';
> > > ERROR 1210: Wrong ar
# [EMAIL PROTECTED] / 2003-06-17 11:25:36 +0900:
> Hi Roman,
>
> just saw this by chance.
>
> >sockstat -4l | grep 3306.
>
> I never heard of such a tool , also I did not find any info on the
> internet. I assume you dont mean sock, of course.
>
> Could you let me know where I can find the tool
# [EMAIL PROTECTED] / 2003-06-16 15:27:21 +0200:
>
> I'm trying to use 4.1.0-alpha's "extensive unicode support".
[...]
> Now I try to read the data, this time from the commandline client:
>
> mysql> select * from unitest WHERE ID=72;
> ++---+---+
> | ID | vc
# [EMAIL PROTECTED] / 2003-06-16 12:01:57 +:
> I installed the mysql 4.0 pkg on Mac OS 10.2, then I followed the
> installation instruction. It works fine. I then tried to create
> database, but is says"Access denied". I checked "Show database" ,
> there is only one database in, which is 't
# [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400:
> I have two tables...
> Table 1 newdata contains a lot of statistical data on our customers,
> including last 12months sales amt.
> table 2 sdtik contains all ticket information for all customers.
> Both tables have acctno as primary key.
>
> I ca
# [EMAIL PROTECTED] / 2003-06-16 21:09:14 +0200:
> In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
> sequence number.
>
> Is it possible to turn off this behaviour?
I doubt that.
> (without messing with the code, of course)
I doubt that some more.
> Using NULL to
# [EMAIL PROTECTED] / 2003-06-16 15:23:21 -0500:
> I thought it was written in EnglishIt wasn't?
It was written in English, but your MUA labeled it as being encoded
with ks_c_5601-1987. Is that a Korean charset? Non-broken MUA will
obey the header, and display it as though it was e
# [EMAIL PROTECTED] / 2003-06-16 14:47:19 -0500:
> Content-Type: text/plain; charset="ks_c_5601-1987"
>
> ?...
posting in english would yield more replies.
--
If you cc me or remove the list(s) com
lines as long as 380 characters are hard to read.
hit enter every now and then, please.
# [EMAIL PROTECTED] / 2003-06-15 17:47:39 -0700:
> I created the following function to move a record from one table to
> another. The only difference in the table structures are the
> auto-incremented
# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100:
> (...) lack of commercial support company means you are unlikely to get
> the same level of support.
unlikely? perhaps. but...
how many OS programs do you use, how many of them have commercial
support, and how do those that have co
# [EMAIL PROTECTED] / 2003-06-10 14:38:49 +0300:
> I am fairly new to databases, but my boss has assigned me to choose a
> database system for our company. I know of Oracle databases but they are
> way too expensive so it's not an option for us. I did some research and
> came up with two free da
# [EMAIL PROTECTED] / 2003-06-06 09:21:32 -0400:
> Heikki Tuuri wrote:
>
> >InnoDB is totally C, MySQL half C++ and half C, with a few hundred lines of
> >x86 Assembler.
> Oh? I thought that MySQL ran on Mac OSX as well as various Intel platforms.
the parts that are written in assembler are
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300:
> Roman,
>
> looks like your application fails to commit this transaction:
>
> "
> 030604 13:52:21 INNODB MONITOR OUTPUT
> ...
> LIST OF TRANSACTIONS FOR EACH SESSION:
> ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251
> 10 lock struct(
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300:
> Roman,
>
> looks like your application fails to commit this transaction:
>
> "
> 030604 13:52:21 INNODB MONITOR OUTPUT
> ...
> LIST OF TRANSACTIONS FOR EACH SESSION:
> ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251
> 10 lock struct(
# [EMAIL PROTECTED] / 2003-06-04 16:37:08 +0300:
> I have a program that runs a loop,in every loop I execute a query.
> the query itself is very efficient, the result of the query is 4 rows at
> most but...
> after a while I get the following error:
> Out of memory!
> Bus error (core dumped)
>
>
# [EMAIL PROTECTED] / 2003-06-04 09:17:01 -0400:
> acc.name, acc.phone, acc.acctno, sales1.amt as mo1sales, sales2.amt as
> mo2sales, (sales1.amt - sales2.amt) as diff SORT by diff
>
> I need all data in sales1 and sales2, but only for records from acc that
> are in either/both sales1, sales2.
>
# [EMAIL PROTECTED] / 2003-06-03 22:59:47 +0300:
> you can use SHOW INNODB STATUS to look what active transactions you have and
> how many lock structs they have.
>
> Also innodb_lock_monitor helps.
Hi Heikki,
thanks for the reply. I have dropped the database, recreated it,
stopped t
keep the lines at or under 72 characters, please.
# [EMAIL PROTECTED] / 2003-06-03 19:20:17 +0100:
> To display in my web page im using:
>
>
>
> This displays the above images in my html page
>
> The problem i have is where the field in my table is left blank
> (null), a web browser shows
# [EMAIL PROTECTED] / 2003-06-03 18:45:31 +0200:
> Executing gcc.exe...
> gcc.exe "U:\mep\Dev\abr.c" -o "U:\mep\Dev\abr.exe"
> -I"C:\Dev-Cpp\include" -I"C:\mysql\include" -L"C:\Dev-Cpp\lib"
> C:\DOCUME~1\badier1\LOCALS~1\Temp/ccW8.o(.text+0x1d2):abr.c: undefined
> reference to [EMAIL PROTEC
Hi there,
I have a problem with LOCKs. I use InnoDB tables and transactions.
[EMAIL PROTECTED] ~ 1001:0 > /usr/local/libexec/mysqld --version
/usr/local/libexec/mysqld Ver 4.0.13 for portbld-freebsd4.8 on i386
[EMAIL PROTECTED] ~ 1002:0 > uname -sr
FreeBSD 4.8-RC
[EMAIL PROTECTED] ~ 1003:0 > htt
I don't enjoy being a PITA but could you teach your MUA to create
proper attributions? This makes it really hard to tell who said
what, leads to confusion, and may piss of quite a few people if a
debate gets somewhat heated...
# [EMAIL PROTECTED] / 2003-04-02 18:18:17 +0200:
> > #
# [EMAIL PROTECTED] / 2003-04-02 17:37:26 +0200:
> And from this page:
> http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
> I understand it is rather recommended NOT to use foreign keys, at least
> until mysql integrates it more fully.
which part of that page makes you say that?
--
Fr
X-Mailer: Microsoft Outlook, Build 10.0.2616
your MUA wrap-mutilates quoted text.
# [EMAIL PROTECTED] / 2003-04-02 02:34:01 +0200:
> > 1. If a column is a primary key, there is no need to declare it a
> > unique.
>
> Thank you, I was doing that for every table sinc
# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500:
> Uttam wrote:
>
> >u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
> >date in desired format.
> >
> Thanks for the detailed information.
>
> >For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
> >funct
forgot to cc the list...
# [EMAIL PROTECTED] / 2003-03-18 08:06:37 -0700:
> On Sunday, March 16, 2003, at 03:33 AM, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-03-15 08:29:51 -0700:
> >>On Thursday, March 13, 2003, at 12:46 PM, Roman Neuhauser wrote:
> >>
# [EMAIL PROTECTED] / 2003-03-30 17:49:27 +0200:
> Hello, I was starting a php/mysql project in december and seeked for help on
> this mailing list, it has been a great help for solving problems.
> My application is a website where you can order meals from restaurants that
> are within your postcod
# [EMAIL PROTECTED] / 2003-03-29 21:52:18 -0500:
> I just downloaded and installed the "mysql-max-4.0.12.pkg", ran
>
> cd /usr/local/mysql
> sudo ./bin/mysqld_safe
> (Enter your password)
> (Press CTRL+Z)
> (Press CTRL+D to exit the shell)
> bg
>
> as specified in the readme. When attem
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500:
> I'm experienced with SQL, but new to MySql and PHP, which I'm using
> together to create a dynamic web site. Right now, I'm having minor
> difficulties with date formatting. It seems that when I retrieve a date
> from MySQL into PHP, it shows
# [EMAIL PROTECTED] / 2003-03-24 21:15:46 +0100:
> i've got MySQL installed from RPM.
> when i try to run the MySQL server, this happens:
> [EMAIL PROTECTED] root]# /usr/bin/safe_mysqld
> Starting mysqld daemon with databases from /var/lib/mysql
> 030324 21:09:10 mysqld ended
>
> why does it sto
# [EMAIL PROTECTED] / 2003-03-24 23:49:59 +0100:
> this is what Mysql Reference Manual tells me about creating foreign
> keys.
> I understood how to use them, except for the restrict here ---\
> |
> [CONSTRAINT symbol] FOREIGN KE
# [EMAIL PROTECTED] / 2003-03-24 16:51:25 +0800:
> I have a mysql+php+apache server,It must have some program to call
> another informix database,I don't know how to configure my php,anyone
> have good resource help me??
yes. http://www.php.net/manual/, and if that fails,
http://www.php.ne
# [EMAIL PROTECTED] / 2003-03-13 11:51:52 -0700:
> This is not proper syntax, but I would think it is close...
> select replace(contact_phone, REGEXP "^[1234567890]",'') from
> individual;
I don't use REs in MySQL, but inverse classes are written [^spec],
not ^[spec].
--
If you cc me or
72 matches
Mail list logo
