-Original Message-
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thu, 1 Mar 2007 10:00 AM
Subject: Re: Breaking Up Tables
It's nothing to do with mysqldump - it's part of the SELECT syntax for regular
queries.
Then I'm confused as to what you're suggesting I do. I
Hi,
I have an interesting (a.k.a. frustrating) problem on MySQL 4.1.11.
I try to connect to the database via DBD::mysql. Everything works - except in a
few cases (once in every 1 occasions, approximately) I get:
DBI connect('database=test:host=192.168.0.200','test',...) failed: Can't
Nils Meyer wrote:
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight
Hi all,
Just wondering how people are dealing with tables that are used for
logging, ie: insert only tables supporting occasional queries used for
audit or event logs.
These tables will keep growing and there is no need to keep them that
large so what is the best strategy in managing the
Hi list,
This night my slave stopped replicating the master (I am using 4.1.11 to
replicate 4.1.9). Whenever I say start slave, The error log of the
slave says:
050430 10:27:12 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'www-bin.03'
HI,
I am using MySQL 4.1.11 on FC3, and I have trouble reading back latin2
characters. No wonder, as character_set_client, character_set_connection
and character_set_results are all set to latin1. The problem is that I
cannot set them to latin2 _permanently_, I mean every time I connect to
the
Mathias,
[...]
I changed my.ini (.my.cnf) like this :
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
log-bin = C:/Program Files/MySQL/MySQL Server 4.1/Data/binlog
#Path to installation directory. All paths are usually resolved relative
to this.
basedir=C:/Program
Mathias,
And you can add all those variables to the ini file :
character_set_client=latin2
character_set_connection=latin2
character_set_database=latin2
character_set_results=latin2
character_set_server=latin2
No, I can not. MySQL won't start.
More precisely, character_set_results is not
Mathias,
2 other things :
1. what is your character set when you install the mysql server ?
I used the binaries from mysql.com. I think that has latin1/swedish as a
default. But anyways, I really don't like the idea to recompile MySQL
just to get my character sets work all right.
2. what
Hmmm, strange...
From the mysql client I see:
mysql show variables like %char%;
+--+-+
| Variable_name|
Value |
Hi,
I am new to replication so excuse me if my question is stupid.
The manual recommends that a nice scenario to take advantage of
replication in MySQL is to send all updating queries to the master
server, and reading from the slave. I would like to use this setup (as
usual, I have many more
Harald,
Perhaps the following excerpt from perldoc DBD::mysql is relevant
for you:
mysql_read_default_file
mysql_read_default_group
These options can be used to read a config file
like /etc/my.cnf or ~/.my.cnf. By default MySQL's
C client library doesn't use any config files
Paul,
DBI doesn't read the config file, DBD::mysql does.
Erm, yep, I meant that, too :-)
It's not expensive at all. Why do you think it's expensive?
As the file must be read and parsed at each -connect(...) invocation.
It would be nicer if DBD could read the config file during the use
phase (for
Hi,
I am running an instance of MySQL 4.0.16, mostly using MyISAM tables on
a 18G 10kRPM SCSI drive w/ ext3, the server having 2G RAM and a 2.8G HT
P4, on a RedHat 9 install.
Would some of you experts be so kind to take a look at the variables I
have, and tell me if anything is wrong? I think
Hi List,
I am putting in a separate disk for our MySQL (4.1.7) server. I have
some MyISAM, some InnoDB tables. Lots of reads, lots of writes (mostly
atomic ones, insert/update one row), a few million rows per table,
approx. 100-400 queries per second.
What would you say is better (with respect
Scott,
I've read the article about 'prepared statement' found in MySQL 4.1, and am
not sure if I understood what 'prepared statement' does and how can it
benefit us. Can anyone elaborate on what 'prepared statement' could do with
examples where possible?
In the simplest case, consider this:
Hi,
Hi Stuart,
Getting your brains warped by logical statements, eh?
If I remember correctly AND has precedence over OR. That means that the
statement A or B and C evaluates to A or (B and C) which means that
the statement will be true if A is true or if both B and C are true.
When in
Dirk,
Hello,
For several years I am hosting a popular website using PHP and MySQL.
As the site is growing and evolving, speed is becoming more and more
important.
With my latest inventions on the website, I notice that the website is
becoming slow and I want to find out what's causing this.
And
Hi Heikki,
Csongor,
in InnoDB, it is better to use
SELECT ... FOR UPDATE
to lock the result set of a SELECT.
Thank you, I think I will go with this one.
A plain SELECT in InnoDB is a consistent, non-locking read that reads a
snapshot of the database at an earlier time. It does not lock
;-)
However, I still need InnoDB, though, as I am doing deletes on multiple
tables, of which I am scared :-)
Reagards,
- Csongor
ps: Obviously this was a dumb question, not a dump one :-)
Ed
-Original Message-
From: Fagyal Csongor [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 4
Hi Marten,
Hello,
4.1 offers some interesting new features like more secure passwords
and subqueries. However, this release is still labeled a-gamma; on
the other hand it shall be used for future development. What's that
a for (usually for alpha) if it's also stated gamma? Is gamme the
last
Hi,
I think I have some problems understanding how transactions work, and
how they relate to locking. Can someone please explain?
The question is this:
I have a table where I have a column into which I insert numbers in
sequencial order - it is not set to auto_increment, though, because the
Dan Nelson wrote:
In the last episode (Sep 09), leegold said:
Could anyone link me or explain the purposes of backquotes in an SQL
statement. I tried searching the manual and googling it but couldn't
find a simple explaination. ``` vs. regular single quotes'''.
Thanks, Lee G.
Backquotes
Hi,
I have a table that looks like this:
table events:
id : INT
remoteid: INT
type : enum ('a','b','c')
value: INT
when: DATE
For each 'remoteid' and 'when', there are 3 rows with type=a,b,c
respectively. (Bad table design that is...) I would like to shorten this
table so it will look like this:
Hi,
Thank you Laercio.
Hy Csongor,
You can write this in pure Mysql.
1. First you create a temporary table from your original table events with
group by remoteid and when;
2. Create your new table with the fields value_a, value_b and value_c;
3. Populate your new table from your temporary table
Richard F. Rebel wrote:
Next time you come over, maybe you can help hold him or take the shot.
He's such a pain to take pictures of, he walks right up to the camera.
Yeah, I also have problems taking snapshots of my cat... use FEL to
pre-flash so he won't blink when you take the actual
Hi,
I have a table that has a few short text fields [text(4000), text(1000)]
I would like to index. Do you think it is a good idea to index them
simply, or is it better if I create auxilary fields which hold the MD5
for the text fields and index those? Would that be faster?
Thank you,
-
Hi,
1. The timeout is set to 5 min, because of the number of queries, there
are a lot of unused http processes that linger with connections, and the
only way to seeminly keep MySQL connections available is to keep
timeouts short.
What about using a connection-pool?
Like Apache::DBI.
It should
Hi,
I am using DBI from mod_perl, and sometimes get the following error:
You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '-63, 20' at line 1
This is given me right at:
eval {
$dbh =
Egor Egorov wrote:
Andy B [EMAIL PROTECTED] wrote:
hi...
what would be the best field type and length for an md5 encrypted password sort of thing??
You can store it in the CHAR(32) column (or VARCHAR(32)).
Or for binary MD5 (and not the hex version) a TINYBLOB(16) should also
be OK.
[EMAIL PROTECTED] wrote:
No they don'tyour machine may be infected...I'd run a scan. or
download some malware fixers (adaware/spybot)
Yes, they do :-) Check the second link under Publisher's site :
http://www.customfittech.com/
- Cs.
--
MySQL General Mailing List
For list archives:
[EMAIL PROTECTED] wrote:
Arithmetic results in a value of zero but mysql is
treating the value as 0. This is reproducible in a
lot of different ways. Below is a pretty clear
example.
mysql select version();
+---+
| version() |
+---+
| 4.0.17-max-nt |
+---+
Todd Cary wrote:
Is there a way to export/import MySQL tables in XML format?
trying_to_be what=funny
Yep. It's called perl :-))
/trying_to_be
Sorry 'bout that... ;-)
- Csongor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Thomas,
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB and presto - views the 'private' data !!!
Well, someone should not have access rights to the DB files on the
first
You have to use bind_param() to identify the parameter as an integer.
Rudy Lippan, the author of DBD::mysql, had a message about it on the
dbi-users list:
Thanks Keith, that explains it... I do not like this new behaviour of
DBD, though. I think it should be the other way around: let those
not upgraded my DBI
DBD packages properly? Or are LIMIT placeholders no longer supported in
DBI with MySQL 4?
Thanx,
- Fagyal Csongor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a P4 server with RedHat 8.0 running on the lates stable kernel. I
also have MySQL 3.23.54 installed.
My problem is that when I do a 'ps aux', I only see one mysql process:
mysql 916 0.0 0.3 38616 3936 ?S17:39 0:02
/usr/sbin/mysqld --defaults-file=/etc/my.cnf
All right, you can disregard this :-) I was too quick to post it to the
list... those _are_ threads, the kernel upgrade must have introduced
them :-). Sorry for the bandwidth!
But other than that, something off-topic: on the very same server I have
found that I cannot issue the 'su' command,
gerald_clark wrote:
Unless, of course, you have quotes in your data.
With perl you can use the quote() function to ensure the whole line
gets in.
Or placeholders.
- Cs.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Jeremy Zawodny wrote:
On Mon, Mar 31, 2003 at 06:00:12PM +0100, Ben Edwards wrote:
Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk) are
still using V3 and don't have any timescales for upgrading?
No idea. Ask them, maybe?
This is probably a don't fix what's not
40 matches
Mail list logo