Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
need surrogate keys for US states also but if you speak about
"states" in general you may need key (many countries over the world have
"states")
The same is about cities: city name is too big to be used as primary key,
and there may be many cities with similar names.
Ilya.
igured Max Memory Limit : 3.91 G
Physical Memory : 5.82 G
I am not sure if it works correctly with 5.6
Ilya
>-Original Message-
>From: Denis Jedig [mailto:d...@syneticon.net]
>Sent: Saturday, April 20, 2013 1:17 AM
>To: mysql@lists.mysql.com
>Subject: Troubleshoot excessive mem
Hello Richard,
>the count(*) for each week of 2013 so that I end up with:
http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html
Ilya.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
_pool should be set to about 70% of
available
>RAM.
I will increase it now.
But I will need to disable swapping also to prevent my OS from swapping out
InnoDB pages.
Ilya.
>
>> -Original Message-
>> From: Ananda Kumar [mailto:anan...@gmail.com]
>> Sent: Tuesday, Apri
several ideas:
* Count 'Innodb_rows_read' or 'Innodb_pages_read' instead of actual time
* Set pool as small as possible to reduce its effect on query speed
* Set pool larger than my db and run query to load all data into pool and
measure speed then
How do you measure your queries'
if files are stored externally.
If somebody knows more reasons to store files in DB -- post it here, please.
It would be interesting. Thanks.
Ilya.
-Original Message-
From: John G. Heim [mailto:jh...@math.wisc.edu]
Sent: Wednesday, February 10, 2010 10:09 PM
To: mysql@lists.mysql.co
Which MySQL server do you use?
What is your storage engine?
-Original Message-
From: Ken D'Ambrosio [mailto:k...@jots.org]
Sent: Friday, February 05, 2010 5:26 PM
To: mysql@lists.mysql.com
Subject: Help optimizing settings?
I've got a fairly large -- 100+ GB -- MySQL database. It isn't
") );
ERROR 1074: Too big column length for column 'test' (max = 255).
Use BLOB instead
>Fix:
N/A
>Submitter-Id:
>Originator:Ilya Martynov
>Organization:
Ilya Martynov (http://martynov.org/)
>
>MySQL support: none
>Synopsis:
db_login (dbh=0x8132808, imp_dbh=0x8131130,
dbname=0x8135210 "test;mysql_read_default_file=/home/ilya/my.cnf",
user=0x8136b48 "", password=0x8134eb0 "") at dbdimp.c:830
#6 0x401b5a34 in XS_DBD__mysql__db__login (cv=0x817ed3c) at mysql.xsi:63
#7 0x808a11b in Perl_pp_en
ter.
There is a number of CPAN modules which provide OO access for SQL database.
Take a look at http://poop.sourceforge.net.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/
#I
DO> nnoDB
I would go directly to http://www.innobase.fi/
DO> Have a good reading.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4A
t = 'center'
l> first and then all the rest of the depart records in
l> alphabetical order.
l> Any ideas?
Use two queries: one to get records where depart = 'center' and second
for rest of the depart records.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
perfomance is good only if databases fit RAM.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software
ll be served from proxy cache. Such approach removes
unnecessary load from database and gives speed of static data
requests.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BD
oo,
ES> but I have never seen the computer use more than 32k of the swap space.
ES> So could I force mysql to load the indexes into memory when you start the
ES> computer?
Run your queries manually on startup?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
hed to a database and that tables exist
M> but 'show tables;' doesn't seem to work. I am sure it is user error
M> but could you please show me my error.
IMHO sounds like a bug. I think you should submit bugreport.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
no way of doing so.
mysqldump
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http:
M> How would I select all the tables _names_ in a particular database? Is it possible?
M> i.e. Select table_names from tables;
SHOW TABLES FROM database_name;
or
SHOW TABLES;
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martyn
ta but once he rewrote code
with placeholders problem disappeared.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6
Use $dbh->quote() or placeholders to insert the BLOB value into
PD> the query string. See the DBI docs.
Only use placeholders. $dbh->quote() is unreliable (and this fact is
documented in DBI documentation).
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
e-level locking. Thus it
can be a limitation for some applications.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DE
SG> MySQL
SG> Will not do transactions till V4...
Wrong. InnoDB table type supports transactions.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F
second mysqld and second mysqld pushes changes
in another set of tables on first mysqld.
So my question: Will it work?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7
nly one single scalar. Check man DBI chapter (Placeholders
and Bind Values) for info on placeholders usage. It has some examples.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)
g = "string";
r> Note that variables inside of strings enclosed by '' will not be translated,
r> only strings enclosed by "" (or qq{} =) ).
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)
27;right' to something else. They are reserved words.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 3
amed TABLENAME
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http:/
WW> Can you use a raw partition with MySQL much like you can with Oracle or
WW> Sybase?
Probably tables with InnoDB type can work on raw devices.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martyn
uot;Transaction aborted because $@";
$dbh->rollback; # undo the incomplete changes
# add other application on-error-clean-up code here
}
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)
-MySQL is experimental driver.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software
ck()?
>> (ex. MySQL server will become slower, MySQL server will crash, etc).
TEG> Well, you've just lost the effects of your operation...
Only if AutoCommit is off and table type support transactions.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| I
rom 'perldoc DBI'. Read section
'Transaction' there for more info.
P.S. Be sure that you have latest version of Msql-Mysql-modules
(version 1.2216). Previous versions does not support transactions.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
. Output of 'show proceslist' shows that MySQL server is much
less loaded (because it handles requests faster) than before. Also
people who tested it on test server before deploying on production
said that it worked faster.
This is real experience.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-
CPUs because it'd never
JZ> spread the threads from each server across the CPUs the way you'd
JZ> like.
AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have
been ported on FreeBSD). In this case threads will spread across the
CPUs as on Linux.
--
-=-=-=-=-=-=-=-
Thanks for idea again :)
HT> Ilya,
HT> actually, it may be safest that you use CREATE TABLE to create
HT> an identical InnoDB table, and then do
HT> INSERT INTO newtable SELECT * FROM oldtable WHERE yourkey > something
HT>
re quite small except one which has
about 1,800,000 records (size of MyISAM files about 70Mb).
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80
't handle it well. It doesn't means that you
cannot get your data. It just means that mysql client cannot show it.
You can use perl script to get your data.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)
A> }
WA> $dbh->quote($string);
WA> $sql_statement = "insert into table(tars) values('$string')";
WA> $sth = $dbh->do($sql_statement);
Change these two lines to
$sql_statement = "insert into table(tars) values(?)";
$sth
above query so it SELECTS everything EXCEPT myuen
KAZ> (that
KAZ> is, I want my result to be puffy and jlo).
"SELECT * FROM activities WHERE month='$month' AND year='$year' AND
username!='myuen'"
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Does somebody try to build MySQL-3.2.36 on Slackware 7.1?
I have an error trying to make test.
configuration:
[30-Mar-01][15:55]{ilya@odin} ~/Sources/mysql-3.23.36>./configure
--prefix=/usr/local/mysql --enable-assembler --with-berkeley-db
--with-charset=koi8_ru --with-extra-charsets=lat
41 matches
Mail list logo
