2025年4月

mysql 5.6 导入sql时提示【MySql】Specified key was too long; max key length is 767 bytes

关闭此限制后，索引前缀的大小将可以达到3072字节。

SHOW variables like 'innodb_large_prefix';
1.如果查询的值是OFF的话 执行下面命令

SET GLOBAL INNODB_LARGE_PREFIX = ON;
1.另外，innodb_large_prefix这个属性在5.6上是默认关闭的，而在5.7上是默认开启的。

执行完了 之后 还得查看当前的innodb_file_format引擎格式类型是不是BARRACUDA

执行SHOW variables like 'innodb_file_format';

1.如果不是的话则需要修改

SET GLOBAL innodb_file_format = BARRACUDA;

docker 启动数据库 ：service mysql start

docker 启动ssh服务：service ssh start

飞牛docker 安装显卡，https://club.fnnas.com/forum.php?mod=viewthread&tid=14106&highlight=

飞牛docker 显卡启动报错无权限，参考：https://club.fnnas.com/forum.php?mod=viewthread&tid=19860

cmake -D CMAKE_TOOLCHAIN_FILE=$ANDROID_NDK/build/cmake/android.toolchain.cmake \

  -D CMAKE_BUILD_TYPE=Release \
  -D CMAKE_INSTALL_PREFIX=install \
  -D ANDROID_ABI=armeabi-v7a \
  -D ANDROID_PLATFORM=android-21 \
  -D BUILD_SHARED_LIBS=ON \
  -D BUILD_opencv_core=ON \
  -D BUILD_opencv_imgproc=ON \
  -D BUILD_opencv_features2d=ON \
  -D BUILD_opencv_world=OFF \
  -D BUILD_TESTS=OFF \
  -D BUILD_PERF_TESTS=OFF \
  -D BUILD_EXAMPLES=OFF \
  -D BUILD_opencv_calib3d=OFF \
  -D BUILD_opencv_dnn=OFF \
  -D BUILD_opencv_ml=OFF \
  -D BUILD_opencv_objdetect=OFF \
  -D BUILD_opencv_photo=OFF \
  -D BUILD_opencv_video=OFF \
  -D BUILD_opencv_videoio=OFF \
  -D BUILD_opencv_highgui=OFF \
  -D BUILD_opencv_imgcodecs=OFF \
  -D BUILD_opencv_shape=OFF \
  -D BUILD_opencv_stitching=OFF \
  -D BUILD_opencv_superres=OFF \
  -D BUILD_opencv_ts=OFF \
  -D BUILD_opencv_flann=OFF \
  -D BUILD_opencv_gapi=OFF \
  -D BUILD_opencv_java=OFF \
  -D OPENCV_ENABLE_NONFREE=OFF \
  -D BUILD_ANDROID_PROJECTS=OFF \
  ..