 | | | MySQL General | | alright.. after some testing this afternoon I 'm beginning to wonder if this
is a memory issue.. here 's what the test was..
I did a insert select from a table that has approx 500 000 rows and the
taHello
I have a table like this
CREATE TABLE `places` (
`name` varchar(256) collate utf8_unicode_ci NOT NULL
PRIMARY KEY (`name`)
) ENGINE MyISAM DEFAULT CHARSET utf8 COLLATE utf8_unicode_ci | > dpgirago@(protected) wrote
> > We have numerous identical tables with a varchar column that holds data
> > like this "0 0 0 1 0 1 0 25 7 0 139 0 9 ". Essentially there are a
bunch
> > of integedpgirago@(protected) ha scritto
> We have numerous identical tables with a varchar column that holds data
> like this "0 0 0 1 0 1 0 25 7 0 139 0 9 ". Essentially there are a bunch
> of integersTry this
mysql > SELECT LENGTH( '0 0 0 1 0 1 0 25 7 0 139 0 9 ') - LENGTH(REPLACE( '0 0 0 1 0 1 0 25 7 0 139 0 9 ' ' ' ' ')) + 1
+dpgirago@(protected) wrote
> We have numerous identical tables with a varchar column that holds data
> like this "0 0 0 1 0 1 0 25 7 0 139 0 9 ". Essentially there are a bunch
> of integers withHi
dpgirago@(protected) wrote
> We have numerous identical tables with a varchar column that holds data
> like this "0 0 0 1 0 1 0 25 7 0 139 0 9 ". Essentially there are a bunch
> of integersWe have numerous identical tables with a varchar column that holds data
like this "0 0 0 1 0 1 0 25 7 0 139 0 9 ". Essentially there are a bunch
of integers with a single space as a separator. ThereFigure it out at 3am this morning while I was sleeping I remembered there
was an rsync on the databases every 10 mins to replicate the files across
the network.
I killed the rsync.. and all has beeOn Tue 4 Sep 2007 Lucio Chiappetti wrote
> I 'll do some experimenting and report back.
In lack of better ways of doing a tie-break I 've done the following
tests (with the linemode client) checHello
thanks. I just wonder why this isn 't actually documented in the --help
output of mysqldump.
Regards
Marten
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To Hey
This morning the default timespan of ssl certificates took my servers
down...
Everything was running fine but this morning the SSL encrypted MySQL
connections stopped working!
Then I realizedBaron
Just feedback - worked perfectly.
Thanks again!
-----Original Message-----
From Esbach Brandon
Sent 31 August 2007 14 46
To Baron Schwartz
Cc MySQL User Group
Subject RE Two/more seperOn Mon 3 Sep 2007 Shawn Green wrote
> What I hope to do is to help you to make you queries work better by
> applying hints modifiers and limits to the optimizer.
Many thanks Shawn.
> "STRAIGHello list members
Since a few days I get this error message when making a backup of my
database
mysqldump Error 2013 Lost connection to MySQL server during query when
dumping table `dbmail_meHi All
I 'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master & Slave servers have same hardware configration.
Yesterday my master server suddenly not established Justin wrote
> lockup just happened again.. here 's a innodb status.
InnoDB status will be basically useless as full-text is only applicable
to MyISAM and indeed your status output shows only one Andrew Braithwaite wrote
> Does anyone know if thread_concurrency works in linux or is it just
> limited to Solaris and Windows?
Hi! That variable only affects Solaris as the Solaris threading
liIn the last episode (Sep 03) Marten Lehmann said
> I couldn 't find an option within mysql 5.0.x to get a dump of all
> rows of a table with one line per row/record. I always get insert
> statements lockup just happened again.. here 's a innodb status.
mysql > show innodb status
|
Hello Lucio
Thank you for the excellent description of you problem. I believe I
completely understand both the data you are handling and the problems
you are facing.
I would not ask you to change yHello
I couldn 't find an option within mysql 5.0.x to get a dump of all rows
of a table with one line per row/record. I always get insert statements
with all rows at once. Has that option been remAs I 'm new on this list and can 't find a "policy statement " I assume it
is OK to reply to the list in "discussion list " fashion. If instead it is
preferred to reply to each sender privately and lat > Hello list
>
> I have doubt on TEXT data types... Checking my notes I see these ones
>
> TINYTEXT/TINYBLOB (2^8) 255 chars
> TEXT/BLOB (2^16) 64K chars
> MEDIUMTEXT/MEDIUMBLOB (2^24) 16M chars
> LOHello list
I have doubt on TEXT data types... Checking my notes I see these ones
TINYTEXT/TINYBLOB (2^8) 255 chars
TEXT/BLOB (2^16) 64K chars
MEDIUMTEXT/MEDIUMBLOB (2^24) 16M chars
LONGTEXT/LONGBLOWith assistance from a friend this issue has been rectified.
The current GRANT was not sufficient. After executing the new GRANT
with 'ALL PRIVILEGES ' (using the --init-file switch) the root user canThe grant flag is enabled on the root account
mysql > SELECT Grant_priv FROM user WHERE User 'root ' AND Host 'localhost '
+------------+
| Grant_priv |
+------------+
| Y |
+------------+
1The grant flag is enabled on the root account
mysql > SELECT Grant_priv FROM user WHERE User 'root ' AND Host 'localhost '
+------------+
| Grant_priv |
+------------+
| Y |
+------------+
1Just wanted to let everyone know that the second issue of the MySQL
magazine has been uploaded. It is available from
http //www.paragon-cs.com/mag/mysqlmag.html
Our featured articles include
MySThe application is supposed to disregard any failure to acquire the
lock. The return value isn 't even checked inside the application. There
is no loop in which we attempt the acquire the lock. The onl |
|
|
