://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
Regards
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design Web Services
Todd Smith [EMAIL PROTECTED] wrote:
Hello
I have inherited an INNODB database. I am new to MySQL and may not be
describing my problem
try something like this
select customer,max(time),name
from customers join projects on projects.parent_id=customer.id
group by customer;
regards
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design Web Services
Barry [EMAIL PROTECTED] wrote:
Gabriel PREDA wrote:
About
I dont think that it is possible to specify the engine when creating a table
this way, you could however create the table using the:
CREATE TABLE old AS SELECT * FROM request_log
and then issue an alter table command setting the engine to whatever you like.
Pure Web Solution
http
you can manipulate mysqldump using the where clause (check the man)
You might find the following usefull, but would not be so good for restoring.
from the command line
mysql --database=db_name --execute=select * from users -u username
-ppassword output.file
Pure Web Solution
http
you can add --old-password when starting MySQL manually or
try adding the following to the my.cnf file
[mysqld]
old-password
regards
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design Web Services
My /etc/my.cnf does not have this option? Is this something I can add
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design Web Services
fbsd_user [EMAIL PROTECTED] wrote:
Thank you Gabriel, more background information may result in a
better concept, so here it is.
The web based application I am writing deals with people who have an
a home
has autonumbering -
insert into table1 (field2, field3) select (field2, field3) from table1;
autonumbering will automatticaly be applied :-)
Danny
Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote:
Here is the problem that I am having. I am trying to make a copy of a
full record
Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote:
That is the effect that I am looking for, but exactly the method that
I
am trying to avoid. If I type the column names into my INSERT...
SELECT
and someone later adds a column to the table, I would have to go back
into my program
Actually, both of your solutions worked. Thanks much for the input guys.
Rob
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, September 26, 2005 12:20 AM
To: Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master)
Cc: Danny Stolle; mysql@lists.mysql.com
Here is the problem that I am having. I am trying to make a copy of a
full record in a table that has a primary key with auto-increment. The
real problem is that I want the statement to use SELECT * so that if
columns ever get added to the table the statement will still work for
the full record. I
Arcangelo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Deluxe Web
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi
Do you see any problems?
=
050303 12:51:11 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 20 seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation count 14266, signal count 14261
also help.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: Deluxe Web [EMAIL
-
From: Deluxe Web [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, February 28, 2005 11:44 AM
Subject: Re: Mysql tuning - server Crash 1
Hi
I understand.. I should switch to debian :)
but in the meantime what about the innodb buffer pull size
Have you seen my
Can you help me figure out the max connections # for a 2GB ram (2GB
swap mem) server running myslq 4.0.16-Max-log and fedora core1.
[mysqld]
max_connections= ?
innodb_buffer_pool_size=1G
The database size is approx 100 Mb with 1,700++ tables, increasing daily..
ulimit -a
core file size
Can I assume that that with a innodb_buffer_pool_size of 1G I can
accept only 500 max_connections (stack size 2M*500 connections).
Also, I noticed that I can't set a innodb_buffer_pool_size 1G. Ideas?
Max
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: Deluxe Web [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 12:05 PM
Subject: Mysql tuning - server Crash 1
Tuuri [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 2:58 PM
To: mysql@lists.mysql.com
Subject: Re: Mysql tuning - server Crash 1
Max,
- Original Message -
From: Deluxe Web [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 27, 2005 2:17
@lists.mysql.com
Subject: Re: Mysql tuning - server Crash 1
Max,
- Original Message -
From: Deluxe Web [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 27, 2005 2:17 PM
Subject: Re: Mysql tuning - server Crash 1
Hi Heikki,
http
show status (now)
+--+--+
| Variable_name| Value|
+--+--+
| Aborted_clients | 1|
| Aborted_connects | 2|
| Bytes_received | 18819744 |
| Bytes_sent | 67675629 |
Hi there,
I have a problem with mysql. I have an application basically to track
clicks to my website and last night it crashed. Can you have a look
aty my situation?
I run a server with 2GB RAM and a XEON processor!
Thank you.
- Max -
error log
-
InnoDB: Warning: a long semaphore wait:
highly possible as this is the first database ive had to use with a
large number of records. I shall look into indexing part of databasing now.
Any suggested places to start that explains it helpfully ?
Regards
Chris Aitken
The Web Hub Designer and Programmer
Phone : 02 4648 0808
Mobile : 0411 132
understanding of nice is that it
puts mysql's cpu usage priority at the lowest. But if nothing else on the
box needs the CPU, it'll still run full and bring load over 5 making
sendmail crash anyway.
Any responses would be appreciated.
Regards
Chris Aitken
The Web Hub Designer and Programmer
If you do I suggest you also include relevant table definitions and
possibly a little sample data (plus an indication of total table
sizes) and expected output, this will greatly assist anyone who my be
able to help. Oh yes, and don't forget to state the version of MySQL
you are running.
Coz
On
Hi
Counts are extremely fast and since you have no WHERE statement, it
takes the count value straight from the internals and does not look at the
tables or an index if I remember correctly. Mike
- Original Message -
From: Gabriel PREDA [EMAIL PROTECTED]
To: mysql@lists.mysql.com
On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard [EMAIL PROTECTED] wrote:
Hi
I use mysql/php on several client web sites (each client has its own
db). For development purpose, I have a local web server with
php/mysql. When a web site is still in development, this is the
master db, even
On Wed, 9 Feb 2005 15:48:12 +0200, Paul Godard [EMAIL PROTECTED] wrote:
On Wed, 9 Feb 2005 13:10:16 +0200, Paul Godard [EMAIL PROTECTED] wrote:
Hi
I use mysql/php on several client web sites (each client has its own
db). For development purpose, I have a local web server with
php
.
Thanks again
I couldn't find the thread but I manage to save the dump file on my
local server (at the same location as the php script) by running a
mysqldump on my local server to fetch a table on the web server.
mysqldump -h server_ip -u username -p password db_name table1 filename.sql
Just to confirm, is amount2 for region 1 supposed to be 1630 (id 47)
or 1955 (ids 13 47)?
Coz
snip
What I would like to have is a result like this:
++---+--+
| region | sum(amount1) if current=J | sum(amount2) |
On Tue, 8 Feb 2005 11:37:20 +, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
On Tuesday 08 February 2005 08:09, Joachim Klöfers wrote:
Hi, all
I hope somebody can help me.
bigsnip /
Many thanks in advance
Joachim
That is a very thorny problem. May I observe that you will find
On Tue, 08 Feb 2005 15:52:02 +0100, Joachim Klöfers
[EMAIL PROTECTED] wrote:
Oh, oh, Joachim,
not able to calculate, but asking questions about queries.
Coz , of course its supposed to be 1955 (id 13 47)
Joachim
Coz Web schrieb:
Just to confirm, is amount2 for region 1 supposed
Helena, have you tried this link:
http://dev.mysql.com/doc/mysql/en/upgrade.html
It starts:
2.10. Upgrading MySQL
As a general rule, we recommend that when upgrading from one release
series to another, you should go to the next series rather than
skipping a series. For example, if you
I know it's not quite the same, but I recently upgraded 2 FC2 boxes
from MySQL3.23.xx to MySQL4.0.23 simply by using (as Gleb suggested) :
rpm -U mysql*
I had downloaded the following rpm files from the MySQL site :
Linux x86 RPM downloads
---
Server
Hi Gerald
Looks like you need a username Jerry not gjw, here is the format I use
to connect. Mike
$dsn = DBI:mysql:host=$host_name;database=$db_name
return (DBI-connect ($dsn, $username,$password,
{PrintError = 0, RaiseError = 1}));
- Original Message -
From: Gerald Preston
You have not mentioned the use of a multiple column index, for that matter,
no indexes at all. I would suggest a multiple column index in the form of
hidden, touser. That index form should speed up your queries and solve the
problem. Mike
- Original Message -
From: Fagyal Csongor
Hi
When building my server I came across a similar situation. The .10 and
.14 are builds of the same library but are complied using a different C
library when building the kernel. If your kernel was built and needs .14
you should be able to find builds for your kernel. In the end, I tried
Dear Sirs,
I have mysql database on the web server. Is there any
way to see mysql actions from any log? I want to see
what my visitors did on the sql databases.
Any idea
Best Regards
__
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB
Hi
Maybe I am missing something. Why not install MySQL on a windows box
and use one of those porters. Then just copy your tables to the Linux box.
Mike
- Original Message -
From: J. Allen Crider [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: February
own learning mysql project I'm planning to build
databases for all my books and DVD's. Stephen Hawking is probably
a better typist than I am so I plan to use barcodes to get the info
,taking the information from various web sites.
People tell me that PHP is THE way to do database work with mysql
. Is there a way to
connect if I am root. thanks for your help.
-aaldrik
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi
Why would you need two servers running when you could just have
separate databases?? Is there a reason why these two cannot share?? Mike
- Original Message -
From: Ola Ogunneye [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: August 7, 2003 8:46 AM
Subject: Running two Servers?
Hi
Did you remember to flush???
- Original Message -
From: Adam Fortuno KOVICK [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: July 31, 2003 4:33 PM
Subject: ARGGH! - User password problems
All,
I've been attempting to assign a password to a user with the following
statement:
Hi
I guess I will plug Paul's books. I have his MySQL book and his MySQL
and Perl for the Web. I really enjoyed the second one but the MySQL book
was very well written. I also have read Sam's teach yourself MySQL in 21
days which seemed pretty light weight and I never look up anything
Hi
Let me take a stab at it. I don't think you need a join at all. Check
the syntax but I think you can do it like this.
SELECT *,concat(slm,item,cust,year) as result1,concat(slm,item,cust,2003) as
result2 from sales where result1!=result2 AND date2001
year would be taken from your date
Hi
Your first statement looks ok to me but the one you have below has no
space before AGAINST. Otherwise, I cannot see the problem myself. Mike
- Original Message -
From: Francis Van-Lare [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: July 12, 2003 2:42 AM
Subject: MATCH AGAINST ()
Hi
Just read this last night. Try
mysqldump databasename -u username --password=yourpassword
/to/a/directory/dump.sql
Mike
- Original Message -
From: Kalle Saarinen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: July 7, 2003 8:21 AM
Subject: mysqldump
Hello
I'm trying to
Just a guess from a raw newbie, but try using:
`traffic.trafficdb` instead of `traffic`.`trafficdb`
Ryan
Thursday, June 26, 2003, 1:13:03 PM, you wrote:
SD can someone help me with this error, with my database in MySQL 3.23.49
SD
SD SQL-query :
SD SELECT *
SD FROM
Hi
First, auto increment is a column type. You set the column to add one
to the highest value in that column. If you would like the records to start
at 10, either enter you first record with the Client_ID value explicitly
set at 10 or enter a dummy MySQL statement like INSERT INTO Clients
Hi
I really don't have an answer but would question whether MySQL will
allow zero db's with it's own grant tables. Usually there is a test db, at
least after an install. Why not try adding a database and then try to drop
clone_updater??.
Mike
- Original Message -
From: Leo
Wednesday, June 18, 2003, 2:38:53 PM, you wrote:
---Original Message-
--From: Adam Nelson [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, June 17, 2003 11:56 AM
--To: 'Bernd Jagla'; 'mysql'
--Subject: RE: RAID hardware suggestions/experience
--
--We recently bought a kick $%#%% machine for
Hello Jeff,
Monday, June 16, 2003, 1:13:27 PM, you wrote:
JS On Mon, 16 Jun 2003 12:45:53 -0400, Martin's - Web Dept. wrote:
I am quite willing to acknowledge that I'm new at this ...
But I can't find the syntax error in this query:
SELECT * FROM products WHERE MATCH (desc) AGAINST
I am quite willing to acknowledge that I'm new at this ...
But I can't find the syntax error in this query:
SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
desc is a field name, usb is the keyword I'm searching for.
MYSQL version 4.0.12
Thanks for your help.
Ryan
--
MySQL
Hi
Your problem lies in your columns. A timestamp field has the special
property of recording when a record is created or modified. However, only
the first timestamp column in a row is treated this way. I hope this helps.
Mike
- Original Message -
From: Dmitry Kosoy [EMAIL
Hi
You are not defining num so you are adding 1 to 0 to get 1 and you
already have that record. Sounds like you need an autoincrement field.
Mike
- Original Message -
From: Mark Rages [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: June 5, 2003 7:52 PM
Subject: I thought single
if something
might be done in the myisam/ftdefs.h source file to remove the dataset
weighting feature.
Thanks
Mike O'Krongli
O'K Web Design
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or hostname.
- 10 page web site -
Layouts, backgrounds, WYSIWYG (What You See Is What You Get) interface, etc.
- 100 personalized email addresses -
Create up to 100 personalized email addresses and forward them to other email
addresses.
- Web/URL forwarding -
Forward
25 February 2003 14:17, Kirill Peskov (WEB-EU) wrote:
Coud you, please, give an advice to solve following problem:
I've got two Mysql Servers:
* Master: Sparc Solaris 8, MySQL 3.23.32
* Slave: RedHat Linux 7.2, MySQL 3.23.32
Replication of data runs fine, all insert into and delete
Dear gurus,
Coud you, please, give an advice to solve following problem:
I've got two Mysql Servers:
* Master: Sparc Solaris 8, MySQL 3.23.32
* Slave: RedHat Linux 7.2, MySQL 3.23.32
Replication of data runs fine, all insert into and delete from made
on master successfully change the
Hello,
I am attempting to search a table based on information passed from a
submitted form.
The form contains details as follows:
(radio buttons)
Condition: O new O used
Type: O powerO sail
(textbox)
Make: [ ]
etc. etc. etc. ( it's a long list!)
If I
='sail'
You probably don't need to use LIKE since the form fields will always
supply you with the same values.
-bill
web-dev wrote:
Hello,
I am attempting to search a table based on information passed from a
submitted form.
The form contains details as follows:
(radio buttons)
Condition
Hi,
I'm still stuck. If anyone has time, please take a look at this session
I had and any pointers would be great. I just went to mysql.com to search
the problem, but no site there..Weird.
thanks all,
Shawn
[root /root]# mysql -u root -p
Enter password:
ERROR 1045: Access denied for user:
start the MySQL daemon with:
cd / ; /usr/bin/safe_mysqld
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; run-all-tests
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http
Hi all,
First, thanks for the patience and the help I've been getting. I'm at
this point.
I think this is where I'm getting stuck at
-p[password], --password[=...]
Password to use when connecting to server
If password is not given it's asked
Hi,
any ideas on this one
[admin admin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.37
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql UPDATE user SET Password=PASSWORD(testpassword)
- WHERE
Hi all,
anyone know why this error would come up. This is running on a Linux box
[admin admin]$ scripts/mysql_install_db
bash: scripts/mysql_install_db: No such file or directory
Shawn
-
Before posting, please check:
Hi all,
Yet another 3am night and I still can't get my MySql to work. I
installed MySql on a cobalt Raq 4 server running Linux. I can telnet into
the mysql directory, but can not seem to change the root pass. I've
searched every place except the one that as the answer to my question. What
Hi all,
I'm a newbie at this, so here's a newbie question. I have installed
MySql on a Cobalt Raq 4 running Linux via a .pkg file. All seemed to go
well, I am able to get into the MySql directory via telnet but no commands
seem to work. See session below. Can anyone help me with putting a
Hello I have a query that goes through and gets the
data out of three tables without a problems. Now the
task at hand is to compair that out put against three
identiacal tables not displaying any duplicate date.
Tables:
a
a.aocode , a.CaseNo , a.CaseName
b.
b.ao_code , b.initials
c
Is there another way as I do not have that version of
MYSQL installed on my server?
THanks-
KCK
--- Tod Harter [EMAIL PROTECTED] wrote:
On Wednesday 20 February 2002 09:20, Web boy wrote:
You want to use UNION. If I remember correctly its a
fairly new feature for
MySQL, but its a standard
I move from MDB to mySQL, I got a question concern how to create a auto digital number
field in mysql table,
create table namelist ( name char(60), ID auto, date date());
Hi, everybody here,
Anybody can help with
telnet to Linux and login to mySQL, show information about current mysql
setting,
create new DB, and table?
Since, I am using MSSQL under NT platform, it is pretty much different..
Thanks lot
Amy
- Original Message -
From: Kelsey Cummings
Hi, everybody here,
Anybody can help with
telnet to Linux and login to mySQL, show information about current mysql
setting,
create new DB, and table?
Since, I am using MSSQL under NT platform, it is pretty much different..
Thanks lot
Amy
try distinct(column name)
JCampbell wrote:
I want to know if it is possible to build a MySQL query which will only
return the unique values of a specific column. Ie if I had this table:
id | name |date___
1 | Jon | 2001-01-03
2 | Bob | 2001-01-04
3 | Jon | 2001-01-05
Is
I agree, I don't think there is a function in MySql, it will do the job.
May be you can use the following algorithm
1. fetch all rows item description.
2. Split into words and put it in a array.
3. Create a counter array of the same limit of word array.
4. in a for loop, count number of time
or you can try the following code
$result=@mysql_db_query($db_name,$query,$link);
$num=@mysql_num_rows($result);
if($num=0):
echo "No records found";
endif;
Martin Cloutier wrote:
Try this:
$RESULT_SET = mysql_query("SELECT * FROM $table where description LIKE
'%$keyword%'");
Hi Bob/ All,
I cannot get the creation of the TEMPORARY Table to
work:
The select statement works fine:
mysql SELECT table1_id, Count(date) as c FROM Table2,
Table1
- WHERE Table2.date BETWEEN "2001-02-02" AND
"2001-02-06"
- AND Table2.table1_id=Table1.id
- GROUP BY Table1.id HAVING
explain what difference between dates
2001-02-04 and 2001-02-06 for
item2 and 2001-02-04 and 2001-02-06 for item1?
- Original Message -
From: Web Depressed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 04, 2001 11:41 PM
Subject: Can anyone do this ?
Hi,
I've
Hi Bob,
Many thanks for that. I was hoping (through absolute
naiveity) not to have to go and calculate the number
of days with the specified range. Unless, of course
I could have mysql do this for me.
Can anyone tell me how I could generate such a list.
(ie something like:
SELECT BETWEEN
Hi,
Woh ! This is very strange. Any ideas ?
mysql SELECT * FROM Table2;
++-+---+
| date | no_of_items | table1_id |
++-+---+
| 2001-02-04 | 3 | 1 |
| 2001-02-05 | 2 | 1 |
| 2001-02-06 |
Hi,
I've been trying for a while now and I can't figure
out how to do the following:
In regular English, I wish to show all items for which
I have allocations greater than one for all days
encapsulated between the user input range.
User Input:
---
Date_from (ie. 2001-02-04)
Hello,
I would like to change the default date format MySql from /mm/dd to
dd/mm/. Does anyone know, how to make this change in MySql?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Thank paul. I know about Date_format, but was curious if there is some
setup parameters would allow us to define the MySql date format .
Paul DuBois wrote:
On Fri, Jan 26, 2001 at 01:40:12PM -0700, Web master wrote:
Hello,
I would like to change the default date format MySql from
select max(rating) from singlemalts will give you the highest value
or
select * from singlemalts order by rating desc
will give all the rows ordered by rating and the first row will have the
highest value
Richard Reina wrote:
I've tried the manual (and the Oreily MySQL book) and played
: wptraine
Originator:Web
Organization: Web Performance Inc. www.webperformanceinc.com
MySQL support: none
Synopsis: Unable to set mysql root password
Severity: serious
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.22.32 (Source distribution
84 matches
Mail list logo