Hi Gregory,
Are you sure you'd like to do this using MySQL? What would happen if you
start using sharding?
Maybe you could consider using a stack (stored in a tool like Redis?).
Whenever some user adds some item, you add primary key of the new item
to the "network updates" stack of each frie
Hi Machiel,
Check these two links for good resources:
http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716
http://www.amazon.com/MySQL-High-Availability-Building-Centers/dp/0596807309
AFAIK there is no up-to-date (print) book about NDB (anyone?). I've used
the M
http://www.geonames.org/
http://download.geonames.org/export/dump/?C=S;O=D
On 02/02/2011 11:30 AM, viraj wrote:
dear list,
where can i find a list of map polygons for united states cities? any
open database? or tool to obtain correct coordinates?
i googled but couldn't find anything useful..
> exit mysql client and enter again.
Instead of exit client and enter again, just type \r (reconnect)
and you have a new session.
On 10/23/2010 06:44 PM, Claudio Nanni wrote:
Just a little note:
sometimes, if you are in command line session, you will not see the change
of the dynamic variabl
ALTER TABLE sometable AUTO_INCREMENT = 1000;
On 10/17/2010 07:03 AM, short cutter wrote:
Hi,
Is it possible to change this directive's value without modifition to
my.cnf and restart mysqld?
I remember there is a set @@variable syntax, but not sure.
Thanks.
2010/10/17 mos:
At 08:55 PM 1
Check whether mysql is running:
ps aux | grep mysqld
If MySQL is not running, check /var/log/mysql/error.log for errors.
Have you changed /etc/mysql/my.cnf and/or /etc/mysql/conf.d/*.cnf or are
are you still using the default config files from Ubuntu?
On 10/16/2010 06:30 PM, Dave M G wrote:
Setting this option is a trade-off between your durability requirement
and performance requirement.
http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
0 gives best performance (write + flush once every second). 1 gives best
durability (write + f
