Hi all,
Is there a rule of thumb how much internal memory you should install,
when pursuing maximum performance? A rule of thumb like: Internal
memory should be equal or more than the size of the database. Example:
total database size=3 GB; therefor internal memory should be at least 3
Gb.
Is
Hello, I'm new to the group and hoping someone can help me figure out a
problem which must be fairly common to new PHP/MySQL users. I have
PHP/MySQL/Apache installed on my Windows XP system. I'm using a supplied PHP
script for making calls from Actionscript to MySQL. The calls work great on
a
I would like to cron my backups...
I currently have the following items on my list: mysql, ldap, various
files/directories, kerberos, etc.
I'm needing the following questions answered:
1. How to 'cleanly'/securely propagate mysql backup user credentials to
mysqldump. This will be a user with
Jeremy Proffitt wrote:
Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I
Will Johnston [EMAIL PROTECTED] wrote:
Hello, I'm new to the group and hoping someone can help me figure out a
problem which must be fairly common to new PHP/MySQL users. I have
PHP/MySQL/Apache installed on my Windows XP system. I'm using a supplied PHP
script for making calls from
Hi list,
I am invoking mysql through php, so when i try to
connect,
it gives me this error messageas i connecting
mysql as
localhost to 'database' database. While I dind't
specify
user/passwd for
that.
Access denied for user: '@localhost' to database
'database'
Thanks
What happends if the master reboots, does the slave start replicating again
after the reboot?
Med venlig hilsen/Best regards
Søren Neigaard
System Architect
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45
Hi there!
I encountered a performance problem when I switched from a Win2000
machine to a WinXP machine to access MySQL via a MS Access (XP)
Front-end.
Simple queries take 20 times more time to appear on screen.
Here's a rundown of hard-/software.
Windows 2000
Windows XP
PIV processor
PIV
H?kon Nilsen \(Exinet AS\) [EMAIL PROTECTED] wrote:
I *had* the anonymous user, but I deleted it since I couldn't find the use
for it. But I figured out what the problem was. I was
using --safe-show-database, but it didn't seem to work.
My error was that I gave users privileges. I also
I have this statement that works perfectly fine in Access and MSSQL: (In
words, i first get the top 50 id values according to the where clause and
then i get the maximum of those id values)
SELECT Max(id) FROM (select top 50 id from myTable where infoId in
( 3 ) AND id 100 order by id ASC) AS
Hi,
You should do this:
$connection=mysql_connect(host, username, password);
And then when querying:
$result=mysql_db_query(database, select * from table);
From your error message it seems that your database is called simply 'database', and
that the username is empty. This doesn't work.
You
Angela Olmeijer escribió:
Hi there!
I encountered a performance problem when I switched from a Win2000
machine to a WinXP machine to access MySQL via a MS Access (XP)
Front-end.
Simple queries take 20 times more time to appear on screen.
Here's a rundown of hard-/software.
Windows 2000
Bill Leonard [EMAIL PROTECTED] wrote:
Thank you for the response Victor!
Victoria ;)
On 9/22/03 4:02 AM, Victoria Reznichenko [EMAIL PROTECTED]
wrote:
One of our users is trying to execute the LOAD DATA INFILE command (using
PHP to talk to MySQL). It is failing for some reason...
Hello there!
I have a problem with a little C program i am writing.. It uses
SSL-encrypted connections to a special server. This server needs
information from a MySQL database. The SSL-encryption is running fine.
The MySQL code runs fine, if the SSL code is not there.. Since i need
both at the
No answers?
No suggestions?
Surely, someone must have got these errors.
-Ursprungligt meddelande-
Från: Datatal AB - Gauffin, Jonas
Skickat: den 22 september 2003 14:16
Till: [EMAIL PROTECTED]
Ämne: errors
Hello
I often get these errormessages. Why?
* X clients is
Jonas,
Are you getting these messages when you run a check tables? These errors can
be caused when the database is not `cleanly` shutdown.
-Original Message-
From: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 7:22 AM
To: [EMAIL PROTECTED]
S?ren Neigaard [EMAIL PROTECTED] wrote:
What happends if the master reboots, does the slave start replicating again
after the reboot?
If master goes down, slave will try to reconnect every master-connect-retry seconds:
http://www.mysql.com/doc/en/Replication_Options.html
--
For
Im pretty sure that the server has not been rebooted inproperly.
Can there be any other reasons?
The errors occur quite often.
-Ursprungligt meddelande-
Från: Victor Pendleton [mailto:[EMAIL PROTECTED]
Skickat: den 23 september 2003 14:26
Till: Datatal AB - Gauffin, Jonas; [EMAIL
Jonas,
Can you check the mysql.err log and see if anything has been written
their?
-Original Message-
From: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 7:36 AM
To: [EMAIL PROTECTED]
Subject: RE: errors
Im pretty sure that the server
Harald,
if your server does not crash, then the database probably is not corrupt.
But having wrong log sequence numbers can make it corrupt. What is the error
message in your case?
4.0.15 contains the check, I think 4.0.14 did not.
I am wondering if there could be some bug in InnoDB which
Hi,
Could you post your definitions for 'dbase' and 'err'...
Gerald.
On Tue, 23 Sep 2003, Lars Wenderoth wrote:
Hello there!
I have a problem with a little C program i am writing.. It uses
SSL-encrypted connections to a special server. This server needs
information from a MySQL database.
Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] wrote:
I often get these errormessages. Why?
If you often get table coruption, you can make a test case. Here you can find
instruction how to do it:
http://www.mysql.com/doc/en/Reproduceable_test_case.html
* X clients is using or hasnt
Harald,
030923 15:10:14 InnoDB: Error: page 53 log sequence number 6 190415140
InnoDB: is in the future! Current system log sequence number 1
3864837242.
InnoDB: Your database may be corrupt.
what do you think is the correct log sequence number? How much do you have
data?
The pages
jihad!
My opinion is memory concerns are bound to operating system. What is
recommended for your OS?
Best,
Jerry Cornelius
Hoeven, Maarten van der wrote:
Hi all,
Is there a rule of thumb how much internal memory you should install,
when pursuing maximum performance? A rule of thumb like:
Can I do this with in pure SQL (instead of having to create logic in
programming language)?
Thanks in advance,
--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ah, of course. My apologize for being insufficient.
OS will be Linux, Redhat 7.2. Please note, I'm only looking for a very
general (and probably rough) estimate for the amount of internal memory.
That's why a rule of thumb. There are a lot of circumstances that can
make the world look completely
[Sorry for the accidental premature sending in the first post...]
CREATE TABLE `payments` (
`date` date NOT NULL,
`payee` varchar(255),
`amount` double
)
INSERT INTO payments VALUES ('2003-05-01','david',38);
INSERT INTO payments VALUES ('2003-06-02','david',13.4);
INSERT INTO payments
I haven't touched the log or the data files before or after I upgraded
mysqld...
Well, now I recreated the log files and so far that error didn't show up
again. let's pray :)
thank you very much
Heikki Tuuri wrote:
Harald,
030923 15:10:14 InnoDB: Error: page 53 log sequence number 6
it could be that err is initialized as 0 or not initialized at all
-Original Message-
From: Lars Wenderoth [mailto:[EMAIL PROTECTED]
Sent: 23 September 2003 13:02
To: [EMAIL PROTECTED]
Subject: Memory and C API...
Hello there!
I have a problem with a little C program i am writing.. It
Physical RAM = Database size is not a great rule of thumb.
What if your database has 20 gigabytes of data?
But say you have a 3 gigabyte database, and 3 gigabytes of RAM. You can't
give all that RAM to the database. The operating system needs a bunch for
itself and the processes running. If you
Sorry :)
i see that simbols i've written was converted into ASCII symbols. That is
what i need, but in MySQL :). So is there any collation where: a = a-umlaut
= a-with-any-other-fix ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Wajih-ur-Rehman [EMAIL PROTECTED] wrote:
I have this statement that works perfectly fine in Access and MSSQL: (In
words, i first get the top 50 id values according to the where clause and
then i get the maximum of those id values)
SELECT Max(id) FROM (select top 50 id from myTable where
That query will work. The note is just dosn't matter, when building your SQL
statment replace it with a varible. In PHP for instance you can do the
following
$IDValue = 100 ;
$Query = SELECT id FROM myTable WHERE infoId IN (3) AND id $IDValue ORDER
BY id ASC LIMIT 49,1 ;
Job done. No idea why
Hi,
I am just learning to use Linux and I am having some problems with
getting MySQL to load.
I have successfully installed tested both Apache PHP, so I am pretty
comfortable with the whole configure and make processes.
I followed the MySQL installation docs to the letter, however
Hi all,
i've been trying to follow the Innodb upgrade that will allow setting up
multiple separate blocks of disk for different databases, where the admin has
the ability to put databases in specific tablespaces.
There has been a bit of talk here, but whenever i go to the MySQL or Innodb
web
Can you run this query and tell me if it works on your machine?
SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records;
As per the manual, this should give something like:
+--
NumberFieldOne
1Value
2Value
3
Upgrade to MySQL 4.1 and your nested query will run with no problem.
But remember to change TOP 50 into LIMIT 50
Thanks
Emery
- Original Message -
From: Wajih-ur-Rehman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 12:40
Subject: nested select alternative??
I have a Mysql 4.0.14 standard database. A developer runs 'mysql
optimize table_name' on a small database. After running it, the SQL gui
reports that the 'MESSAGES.MYI' cannot be read.
We have to use myisamchk -o on the table to get the table back but it is
missing a lot of updates.
Any idea
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.
On Mon, 22 Sep 2003 12:25:48 +0300
Victoria Reznichenko [EMAIL PROTECTED] wrote:
Ion-Mihai Tetcu [EMAIL PROTECTED] wrote:
I had set up replication between 2 4.0.14 servers and everything
seems to work OK. Except that SHOW SLAVE HOSTS on muster returns
nothing. What am I missing ?
Hi, I am very new to MySQL.
Does anyone know if InnoDB works with the tool MySQL Control Center??
If works, what I have to do? If does not work, how I create the InnoDB tables in MySQL?
regards
I'm running 3.23.49 on a Win2k machine and wonder if anybody has some advice on how to
write queries dealing with IP addresses. Specifically, I have a table with an ip
address field. I want to be able to do queries based on subnet. Has anybody got
anyting like this?
--
Aaron Clausen
[EMAIL
Hello All,
I have come to know that mySQL FULL TEXT search has the limitation of the search
phrase to be more then 3 charators. In order to alter the default behavior one has to
alter the variable ft_min_word_len.
I am running MySQL 3.23.54 and the FULL Text search works fine , but I am
Hi,
I don't see anything wrong with that. If I was in your shoes I'd make sure
I don't have any buffer overflows anywhere between the definitions and
where you use the variable - these are notorious to only cause
segmentation faults when there's no more memory to silently consume (e.g
variable to
I am trying to find records (from the 'stamps' table) that are NOT
related to records in the 'links' table. To do this, I'm using a left
join. For example:
select s.*, l.item_id as lid from stamps as s left join links as l on ((
s.item_id=l.item_id)) WHERE (s.sold is null);
This worked great
You have to initialize @var to something first, or it's just null. So
try set @var := 0; before your query.
Also, you don't say which version of MySQL you're using, but I'm using
4.0.14 and I can't say ... as number, * from ..., but have to say
... as number, tableName.* from
HTH,
--Pete
Donald Tyler [EMAIL PROTECTED] wrote:
I am just learning to use Linux and I am having some problems with
getting MySQL to load.
I have successfully installed tested both Apache PHP, so I am pretty
comfortable with the whole configure and make processes.
I followed the MySQL
Wow! One of the fields was a primary key, but the other wasn't. When I
indexed the second field the performance went up from 2 minutes to about
2 seconds. Thanks a bunch.
-- John
Kelley Lingerfelt wrote:
Make sure stamps.item_id and links.item_id are indexed, I had a similar
problem, and when
Run explain on the query and see if indexes are being used.
John Almberg wrote:
I am trying to find records (from the 'stamps' table) that are NOT
related to records in the 'links' table. To do this, I'm using a left
join. For example:
select s.*, l.item_id as lid from stamps as s left join
Does anyone know if MySQL for windows support base 64 encoding ?
Or where this documented ?
Jeff Stout
CSG Systems, Inc.
303-200-3204
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I just loaded about 125,000 records, each containing about 30 columns
into an empty, newly created, mysql table. It took 56 minutes. Isn't
that a little long?
The table design was driven, in part, by an existing reporting
application. The data to populate the table is being exported from
Lotus
Is there any way to monitor which databases are being used the most
heavily on a MySQL server? Thanks for any info!
- John
--
---
John May : President http://www.pointinspace.com
Point In Space Internet
On 23 Sep 2003 at 17:07, Imran Aziz wrote:
I have come to know that mySQL FULL TEXT search has the limitation
of the search phrase to be more then 3 charators. In order to
alter the default behavior one has to alter the variable
ft_min_word_len. I am running MySQL 3.23.54 and
Hi,
a simple question ... I have MySQL installed on my Mandrake Linux system,
via the RPM's
MySQL-4.0.11a-5.1mdk
MySQL-common-4.0.11a-5.1mdk
MySQL-client-4.0.11a-5.1mdk
Can anyone tell me how
a) I check if InnoDB is available with this version ? (in the RPM release
notes it seems InnoDB was
Make sure stamps.item_id and links.item_id are indexed, I had a similar
problem, and when I indexed the columns, it went down to less than a half
second.
KL
John Almberg wrote:
I am trying to find records (from the 'stamps' table) that are NOT
related to records in the 'links' table. To do
Even with brand new log files, I got the messages again:
030923 13:37:10 InnoDB: Error: page 2621 log sequence number 0 758479545
InnoDB: is in the future! Current system log sequence number 0 330424282.
InnoDB: Your database may be corrupt.
030923 13:37:10 InnoDB: Error: page 2622 log sequence
Aaron Clausen wrote:
I'm running 3.23.49 on a Win2k machine and wonder if anybody has
some advice on how to write queries dealing with IP addresses.
Specifically, I have a table with an ip address field. I want to
be able to do queries based on subnet. Has anybody got anyting
like this?
Yes,
well, I have a query with 6 or 7 tables and some of them have more than
130,000 records, plus 2 inner joins and 3 left joins and a variable
condition, but still is fast!!! BUT I limit the output to about 30 records
( to fit in a screen ). make sure to have index on the link key.
- Original
At 17:07 +0100 9/23/03, Imran Aziz wrote:
Hello All,
I have come to know that mySQL FULL TEXT search has the
limitation of the search phrase to be more then 3 charators. In
order to alter the default behavior one has to alter the variable
ft_min_word_len.
I am running MySQL 3.23.54 and
The docs explicitly say that wildcards are allowed when specifying
database names in GRANT commands, but don't say anything about wildcards
being allowed in table names.
For example, in one large database I have table names that are grouped
by function:
security.ids_events
Randy Chrismon wrote:
I just loaded about 125,000 records, each containing about 30 columns
into an empty, newly created, mysql table. It took 56 minutes. Isn't
that a little long?
The table design was driven, in part, by an existing reporting
application. The data to populate the table is being
I'm having this error and am not sure what's causing it. I'm using PHP/MySQL and
Apache on Windows XP.
I've looked at my server, user, password settings and they seem to be accurate, but
the error seems to indicate this is the problem.
Any help would be appreciated.
I save as CSV (MS-DOS).
I then import into MySQL using SqlYog and the following parameters:
Line terminator \r\n
Delimiter ,
Strings Optionally surrounded by
That gives me a successful import every time. I have tried other variations
and achieved same results as you - 'jumbled'
Mytop ?
Is there any way to monitor which databases are being used the most
heavily on a MySQL server? Thanks for any info!
- John
--
---
John May : President http://www.pointinspace.com
Point In
Hi,
I have questions on string comparison:
Table: user_att
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| user_id | int(11) | | PRI | 0
Might try mytop (search google for it) .. jeremy z wrote it.. it works
well for realtime monitoring..
On Tue, 23 Sep 2003, John May wrote:
Is there any way to monitor which databases are being used the most
heavily on a MySQL server? Thanks for any info!
- John
--
On Tue, Sep 23, 2003 at 09:30:14PM -0400, John May wrote:
Is there any way to monitor which databases are being used the most
heavily on a MySQL server? Thanks for any info!
No. MySQL doesn't keep per-database statistics.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
Hey guys,
is it possible to bind some databases to a userid so u can do disk quotas
on them, or limit how big a db can be?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From the MySQL manual
A.5.1 Case-Sensitivity in Searches
By default, MySQL searches are case-insensitive (although there are
some character sets that are never case-insensitive, such as czech ).
That means that if you search with col_name LIKE 'a%' , you will get
all column values that
If you're using InnoDB, then that's not exactly true.
From the msql client, you can type show innodb status and you'll get a
bunch of stats on the database, which include:
--
ROW OPERATIONS
--
0 queries inside InnoDB, 0 queries in queue
Main thread process no. 5741, id
On Wed, Sep 24, 2003 at 01:38:43PM +1000, [EMAIL PROTECTED] wrote:
Hey guys,
is it possible to bind some databases to a userid so u can do disk quotas
on them, or limit how big a db can be?
chown the files. Just make sure they're group-wrtiable so that MySQL can
write to 'em.
--
Jeremy D.
On Tue, Sep 23, 2003 at 09:12:46PM -0700, David Griffiths wrote:
If you're using InnoDB, then that's not exactly true.
From the msql client, you can type show innodb status and you'll get a
bunch of stats on the database, which include:
--
ROW OPERATIONS
--
0
you can also convert the ip to an ip number and store it that way.
makes it easier so you don't have do deal with a octete'd number
:)
-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 1:57 PM
To: MySQL Mailing List
Subject: Re:
Your right - I created a temp database to test, and the innodb engine shows
the same stats for that new database (with no tables, no rows) that it did
for a database with tables and data.
I guess InnoDB keeps one set of stats for all databases. I guess I'm too
used to Oracle, that tracks
Yeah but when they make a nwe table, it will be owned by root.root wont it?
On Wed, Sep 24, 2003 at 01:38:43PM +1000, [EMAIL PROTECTED] wrote:
Hey guys,
is it possible to bind some databases to a userid so u can do disk
quotas on them, or limit how big a db can be?
chown the files. Just
Gustavo,
please send me the whole .err log.
I have not seen the error in my own tests. There might be some rare bug in
keeping or reading of log sequence numbers.
Regards,
Heikki
..
Gustavo A. Baratto Date: September 23 2003 3:52 pm
Subject: Re: innodb
I haven't touched
Greetings
How do I measure the exact amount of descriptors mysql is currently using, is there some formula based on SHOW status? For example open_tables + open_files * threads or something? I have a sneaky suspicioun my mysql is running out of those descriptors since mysql starts rejecting
77 matches
Mail list logo
